Hot answers tagged


Maybe mere mortals can't view the log files, but a DBA can glean all kinds of information. Here are a couple queries to get you started. -- Run this query to get the transaction ID USE YourDatabase GO SELECT [Transaction ID], Operation, Context, AllocUnitName FROM fn_dblog(NULL, NULL) WHERE Operation = 'LOP_DELETE_ROWS' ...


The method I prefer: Method 1: Back up and restore the user databases Back up the user databases on the source server, and then restore the user databases to the destination server. The database can be used when the backup is in process. If users perform INSERT, UPDATE, or DELETE statements on the database after the backup is complete, the backup will ...


To remove all entries for new SQL 2014, you need to delete file: C:\Users\(USER)\AppData\Roaming\Microsoft\SQL Server Management Studio\12.0\SqlStudio.bin

Only top voted, non community-wiki answers of a minimum length are eligible