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 |
|
guyver
Starting Member
7 Posts |
 Posted - 2006-07-14 : 01:51:11
|
| hi everybody, im lynard and i'm a developer but i'm also working as a dba in our company. i just want to ask to all experts how to restore correctly your backup files. i have a complete backup every midnight and differential backup hourly from 6 am to 9 pm and transactional backup every 15 mins. i read some articles that do this scenario but when i test for restore it didnt work. can anybody explain to me what seems to be a problem. thanks in advance |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-14 : 05:26:25
|
| Restore the full backup (without recovery).Restore the last diff backup(without recovery)Restore all the tr log backups taken after the diff in sequence (without recovery).Restore with recovery.You can restore using any full backup and any corresponding diff (i.e. taken before the next full) and the complete sequence of tr log backups taken after that.Here's an SP that will do it given the correct naming convention (there's a backup sp to produce them on the same site).http://www.nigelrivett.net/SQLAdmin/s_RestoreDatabase.html==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
guyver
Starting Member
7 Posts |
Posted - 2006-07-17 : 00:10:56
|
| thanks nr, i got to try this sp. i will post later if it succeed |
|
|
|
|
|
|
how to restore your backup in sql server 2k