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 |
|
missinglct
Yak Posting Veteran
75 Posts |
 Posted - 2004-03-29 : 14:04:03
|
| Dear experts,I am very pleased to see this Forum. I am new to SQL Server.I want to do backup / restore db but I got stuck.Someone told me to read stuff at BOL (book on line) which I did.However, my question is still unresolved.I created a new DB called, 'TestDB'I created a new table call, 'Contacts' that has 1 row.I created a FULL Backup db.I then deleted 'Contacts' table so this table is gone.Then I created a RESTORE db and the 'Contacts' table was restored. Next, I added a second row to 'Contacts' table. So this table has 2 rows.Then I deleted 'Contacts' table.Then I did a RESTORE db and the 'Contacts' table was restored. BUT the second row is not restored. In other words, it only restored up to the point where I did a FULL BACKUP. Anything after that is gone.So, my question is: If I make more changes to my tables AFTER I create my FULL Backup, how do I save these new changes if something goes wrong (disaster or other incidents)Thanks so much in advance.Lisa |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-29 : 14:05:49
|
| You'll need to schedule transaction log backups. Look up BACKUP LOG in BOL. Make sure your database recovery model is set to FULL.Tara |
 |
|
|
|
|
|
Back up and restore db