You began the transaction 600 times (GO 600), hence you need 600 commits to actually commit that transaction. Or one rollback to undo it.

May I suggest...

BEGIN TRANSACTION

GO

INSERT INTO t1 DEFAULT...

https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/

Have you considered backing up to disk and moving the backup to tape later?

dr.blowfin (8/19/2013)

---

I've seen 17 seconds of SOS_SCHEDULER_YIELD waits reported for a 15 second period, correct me if I'm wrong but this basically equates to at least an entire core being...

What's in the SQL Server error log?

From Object Explorer, Management -> SQL Server logs. You can't turn off error logging.

You need to restore the full backup, all the log backups taken after the full backup ending with the one that contains the deletion (that's why the STOPAT clause)

You're trying...

RESTORE LOG <database name> FROM DISK = <log backup location> WITH STANDBY = <standby file...

Unless you're in full recovery model and haven't taken a log backup since the delete, the log records describing that change will likey have been removed from the log (marked...

It depends.

Do you need to read the secondary? For example, offloading reports. If so, standby. If not, no recovery.

It's got nothing to do with what other people do. It's just...

Chapter 6: https://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

Please don't cross post. It just wastes people's time and fragments replies.

No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1485549-391-1.aspx

If you have some form of auditing set up, then it depends on exactly what you're using to audit and how it's configured. If you don't have any auditing set...

Why are you shrinking a file that's already too small for the workload? Surely if the file's getting full all the time you'd want to make it larger, not smaller?