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 |
|
shaik.zakeer
Posting Yak Master
117 Posts |
 Posted - 2008-04-23 : 01:35:35
|
| I am new to administrationI know how to take backups and restoring full database backup.can you plz help me how can i restore differential , transaction log backups. |
|
|
Nitin Doshi
Starting Member
1 Post |
Posted - 2008-04-23 : 04:03:15
|
| To restore differential & transaction log...First restore your full backup with norecovery. Then restore your differential backup with norecovery (syntax is same). Then restore your transaction log backup with norecovery using restore log except last transaction log. Restore last tranaction log with recovery. |
 |
|
|
shaik.zakeer
Posting Yak Master
117 Posts |
Posted - 2008-04-28 : 02:42:52
|
| HI FRIENDI WAS TRYING TO DO THIS ... BUT I M NOT GETTING. WHENEVER I M TRYING TO RESTORE WITH NO RECOVERY IT IS NOT GETTING RESTORED.ITS SHOWING 'DATABASE NAME (RESTORING.............).BUT IT IS NOT .HELP ME OUT FRIEND.Thanks |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-28 : 17:08:40
|
| You are in right track. You have to choose Recovery option to completely restore. |
|
|
|
|
|
|
Help me