Viewing 2 posts - 31 through 32 (of 32 total)
So r u saying that you cant free your log file after running :
Backup log DBNAME with truncate_only
DBCC Shrinkfile ('Log')
You can try restaring your SQL service before you restart machine.
March 12, 2008 at 11:20 pm
#788890
1.To bring back your database from Norecovery to recovery
RESTORE DATABASE databasename WITH RECOVERY
In above statement change 'databasename' to your orignal database name.
2. Does both of your DB's are on...
March 12, 2008 at 12:49 am
#788403