Geeks With Blogs
Fórmulas e Cenas Object Reference Not Set to an Instance of an Object
Restoring a database can be a pain in the ass, specially when you need to find some point in time where the data went wrong.

This is the best way i know how:

RESTORE DATABASE MY_TARGET_DATABASE FROM DISK = 'path_to_backup.bak' 
WITH NORECOVERY, replace
GO
RESTORE LOG MY_TARGET_DATABASE FROM DISK = 'mytransaction_log1.trn' WITH NORECOVERY
GO
RESTORE LOG MY_TARGET_DATABASE FROM DISK = 'mytransaction_log2.trn' WITH NORECOVERY
go
RESTORE LOG MY_TARGET_DATABASE FROM DISK = 'mytransaction_log3.trn' WITH NORECOVERY
go
RESTORE LOG MY_TARGET_DATABASE FROM DISK = 'mytransaction_log4.trn' WITH RECOVERY,
STOPAT = '2012-08-31 14:10:00' 
go

Posted on Monday, October 22, 2012 11:18 AM Geral , Database | Back to top


Comments on this post: How to restore a database using multiple transation log files (sql server 2000)

# re: How to restore a database using multiple transation log files (sql server 2000)
Requesting Gravatar...
I've tried the process and it worked well. Thanks for sharing the idea here. - Paradise Home Improvement Charlotte
Left by Ashton on Nov 12, 2016 1:47 AM

Your comment:
 (will show your gravatar)


Copyright © Sglima | Powered by: GeeksWithBlogs.net