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 |
|
Mazdak
Yak Posting Veteran
63 Posts |
 Posted - 2002-12-02 : 08:47:38
|
| I want to restore data from backup in enterprise manamger at specific point,but in restore database dialog box this option is disable,also if I exwcute this command in query analyzer the STOPAT does not work and it always restore the last data. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-12-02 : 08:52:22
|
| Are you restoring a full backup or transaction logs?==========================================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. |
 |
|
|
Mazdak
Yak Posting Veteran
63 Posts |
Posted - 2002-12-02 : 10:24:56
|
quote:
Are you restoring a full backup or transaction logs?
I choose "Database-Complete" option. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-12-02 : 10:38:20
|
| You can't restore a full database backup to a point in time. You can only do it if you have transaction log backups.Look in Books Online under RESTORE, and also check the entries under STOPAT, they describe the process necessary to allow point-in-time restorations. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-12-02 : 10:54:19
|
Maybe I shouldn't try to be subtle  .==========================================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. |
|
|
|
|
|
|
Restore Data (2)