Get help detecting problems in SQL Server by viewing the current error log, or backups of previous logs, to check whether processes have finished successfully.

EXEC sp_readerrorlog 0 --log file you want to read: 0 = Current, 1 = Archive #1, 2 = Archive #2, etc , Null --log file type. 1 or Null = error log. 2 = SQL Agent log ...

Sometimes, you may be unable to perform a sync on the server. Maybe you’re trying to sync a resource that doesn’t exist, or maybe you’ve got too much data and ...

All the information in SQL Server database is stored in 8 KB-sized pages. If any page gets corrupted, server fails to read the data in the database and displays different errors. Some common errors ...

Have you ever started SQL Server only to discover your database labeled “In Recovery,” you know how upsetting it can be—especially when the process appears to ...

I also posted this in the other MS centric forum, because I wasn't sure which one it fit in.<BR><BR>I have been at this for two days, and it has completely killed all my productivity. Microsoft has ...

I have been at this for two days, and it has completely killed all my productivity. Microsoft has been less than helpful, despite having spent non-trivial cash on a support incident.<BR><BR>Here's the ...