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 |
|
shep5709
Starting Member
1 Post |
 Posted - 2006-02-10 : 13:56:25
|
| I have a ms sql 2000 database. Its a couple of months old. It has never had a backup. It has a transaction log.I ran DTS to copy objects from another ms sql server to this target. By mistake I checked copy dependent objects. Some objects got overwritten.DTS started and I realized it was doing more then I expected and I stopped the session.Can I rollback or recover this database to say 8:00AM today?Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-10 : 13:58:32
|
| Not without purchasing a 3rd party tool, such as Lumigent's Log Explorer to read the transaction log. In order to restore your transaction log, you would need a full backup taken prior to the backup of the transaction log. You don't have either. You have the active transaction log only.Tara Kizeraka tduggan |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-02-11 : 01:37:50
|
| Hi shep5709, Welcome to SQL Team!"It has never had a backup"The Maintenance Wizard has anOption to back up ALL databases (or all USER databases). That means any new database which is added in the future will be include in the backup.I'd recommend that, or something equally robust - even though its closing the stable door after the horse has bolted!Kristen |
|
|
|
|
|
|
Recover without backup