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 |
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
 Posted - 2001-11-22 : 09:21:04
|
| How to restore increament back up?I tried, but got error,saying that Norecovery option is not set for previous restore.Thanx in advance.---------------------------Sandesh - The Messanger |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2001-11-25 : 20:40:15
|
| It is left as loading because the datbase has not complete recovery.If you want to view the data you can restore with standby. This will create a file enabling it to reverse the database recovery for the next incremental or tran log.Were any other full backups taken before the incremental?Have you restored any other incrementals?As you say it happens when the backup is scheduled it sounds like something is happenning that you don't know about - like a full backup being taken from somewhere. Has someone installed backup exec to take a backup direct to tape or something?==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Restoring Increamental Backup