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 |
|
jlking22
Starting Member
2 Posts |
 Posted - 2006-03-14 : 12:47:13
|
| I restored a complete backup with STANDBY. I attempted to restore the differential and it failed without showing an error. Do you have to use the NORECOVERY option after the full restore? I assumed that I could use the STANDBY option in the same manner so that my users could still access the database.Jess |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-03-14 : 18:39:28
|
| Either option will work when performing restores. But you need to make sure to kick everyone out when doing the restores or it will fail. STANDBY allows for read-only access and has the ability to apply additional backups. NORECOVERY is in a loading state, meaning users can not access it, and has the ability to apply additional backups. I've never restored differential backups, but I assume it's the same process as applying tlogs.Tara Kizeraka tduggan |
 |
|
|
Kristen
Test
22859 Posts |
|
|
jlking22
Starting Member
2 Posts |
Posted - 2006-03-15 : 10:34:25
|
| The reason the Differential Restore did not work with the Full Restore in STANDBY mode was because I had spaces in the USE file path. I moved the USE file and have tested it with the Northwind database with success.Thanks!Jess |
|
|
|
|
|
|
Differential Restore - STANDBY vs. NORECOVERY