backup and restore -- sql server new users

tonyr
6/2/2005 6:59:39 AM

ok I screwed up the recovery settings on a database, originally it was set
to simple and created a backup that did a complete backup every night no
transaction logs being backed up (obviously). I then must have switched it
to full and kept the same backup job anyway when I do a restore and pick the
date that I want restored it does the restore but the data shows no changes.
What am I doing wrong or is this even recoverable?
thanks
tr
ps I've read the books on line backup and restore stuff but I'm not getting

Hari Prasad
6/3/2005 1:31:45 AM

Hi,

Are you appending backup sets into a single backup file? It is always
recommended to keep seperate backup files for each full database backup.
Best method for backup is to use the Maintenance plan. There you can set a
archival period to house keep old backup files.

Since currently the database is set to FULL recovery do a transaction log
backup as well using maintenance plan.

Thanks
Hari
SQL Server MVP

[quoted text, click to view]

sql server new users : backup and restore