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 |
|
ganeshkumar08
Posting Yak Master
187 Posts |
 Posted - 2010-09-23 : 02:15:18
|
| Hi All,I have a full backup which was done at 1.00 AM, and for every 1 Hr i do differential backup. i.e, at 2 AM,3Am,4Am....Now how to i restore the full backup and differential backup in sql 2000.Please give me a script to do that.ThanksGaneshSolutions are easy. Understanding the problem, now, that's the hard part |
|
|
vna_mhars
Starting Member
37 Posts |
Posted - 2010-09-23 : 02:26:01
|
| Hi, Is your backup also a SQL2000 db? if that so, you need to restore first your last full backup follow by the differential backup. Your differential back up should be restored accordingly from old to new after the fullbackup. Regards, Vamodentevamodente |
 |
|
|
vna_mhars
Starting Member
37 Posts |
|
|
ganeshkumar08
Posting Yak Master
187 Posts |
Posted - 2010-09-23 : 02:31:26
|
| Yes, my backup file is Sql2000 and restoring database also sql 2000Solutions are easy. Understanding the problem, now, that's the hard part |
|
|
|
|
|
|
|
|
Restoring Full backup and Differential backup