Viewing 4 posts - 31 through 34 (of 34 total)
It's possible that antivirus programm on your machine may accessing it.
Also make sure that you have detached the database properly. Check for the same using sp_helpdb.
March 23, 2009 at 6:24 am
#964353
Jeff,
That's why you are champion !!! 🙂
But I think one can use Truncate_only with proper planning...
March 23, 2009 at 6:19 am
#964348
If your database is not configured for Replication or Logshipping you can use following command to shrink your databse log file to death:
backup log with truncate_only
dbcc shrinkfile...
March 23, 2009 at 5:57 am
#964337
You can also use SSIS for transferring Jobs and Logins from your primary server to secondary server.
March 19, 2009 at 2:26 am
#962523