Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
satishvsh
Starting Member
41 Posts |
 Posted - 2008-08-06 : 12:14:28
|
| Team -Please advise me on this.1. Is it possible to restore SQL Server 2005 Database using SQL Server 2000 Database transaction logs.Please advise me which method is good restore with full backup or restore with T-logs.Please provide step by step for restore database using T-logs.Cheers :)satish |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-06 : 22:59:41
|
| restore database db_name from disk = 'path\full_backup_file' with norecovery ...restore log db_name from disk = 'path\log_backup_file1' with norecovery .......restore log db_name from disk = 'path\log_backup_filen' with recovery |
 |
|
|
|
|
|
Restore SQL Server 2005 databases using T-Logs