April 19, 2007 at 2:55 pm
I am trying to restore backup and the system gives me error for LSN. No error no. is displayed but it seems that the system doesnot accept trn log restore.
My bkp strategy is:
Full Backup: weekly
Diff bkp: daily
T Log Bkp : every 2 hours.
But sometime I need to shrink Log file due to heavy growth. Hope that is not creating problem. The following is what i do for shrinking TLog file.
BACKUP LOG ABC TO ABC_BackUp
DBCC SHRINKFILE(ABC_Log, 500)
pL. guide why my restore fails. When i try to exclude TLog bkp, the system gives me another error;
System.Data.SqlClient.SqlError: Invalid column name 'lightweight'. (Microsoft.SqlServer.Smo)
April 19, 2007 at 3:37 pm
Are you running this thru the GUI or with a script.....and if a script..can you post the script that your running to restore the database and log?
April 19, 2007 at 6:07 pm
I am restoring this thru GUI interface.
April 19, 2007 at 9:53 pm
try going the manual approach
RESTORE
DATABASE Ten
FROM DISK = 'C:\Backup\Ten_data.bak'
WITH
NORECOVERY,
MOVE
'Ten_Data' TO 'D:\SQLData\Ten_data.mdf',
MOVE
'Ten_log' TO 'E:\SQLData\Ten_log.ldf
Then see what message comes up. if successfull, then apply your log or diff backups.
--Eric
April 20, 2007 at 9:35 pm
Just shrinking the log file using DBCC SHRINKFILE should not cuase log sequence to break...
There might be something else cuasing to break...mostly truncating the log.
MohammedU
Microsoft SQL Server MVP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply