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 |
|
edtraviles
Starting Member
7 Posts |
 Posted - 2009-12-29 : 11:56:32
|
| Hi. I'm no SQL Server expert, and I'd be grateful if someone could clarify something for me.I've been asked to do a one-off backup to disk (for archiving) of a SQL Server 2005 user database, but am uncertain which overwrite options to select, and what the implications are of 'Backup to a new media set, and erase all existing backup sets'.The DB in question gets backed up daily (scheduled) to a specific directory. Only the most recent backup is retained. A substantial number of other databases on the same server are backed up in the same way, each to its own directory. When I right-click the DB and choose 'Backup', the path and file displayed in the 'Destination' box are those of the daily scheduled backup. I want to place the one-off backup in a separate folder, and don't want to erase the existing backups of this or any other DB.I presume I use 'Add...' to specify a new path and filename for the one-off backup, highlight it when I run the backup, and leave the existing alone(?), but I don't know what effect the various selections on the Options tab will have and therefore which to choose.Alternatively, can I just use Explorer to copy and rename a scheduled backup file? Any advice much appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
edtraviles
Starting Member
7 Posts |
Posted - 2009-12-29 : 12:20:42
|
| Thanks for the reply. In that case, I presume I should:On the General tab- Enter a new backup set name.- Enter a new backup destination, and have it highlighted when I hit OK to start the backup.On the Options tab- Select 'Backup to a new media set, and erase all existing backup sets'.- Enter a new 'New media set description'.Run the backup, confident that no existing backups will be affected?Sorry if I seem paranoid about losing data - it's because I am... |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
edtraviles
Starting Member
7 Posts |
Posted - 2009-12-29 : 12:43:10
|
| Thanks. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Database backup: erase all existing backup sets...