I want to create a one off backup of a database that I can then restore on my local machine. I do not want to have any impact on the current media set. I see an option "Back up to new media set, and erase all existing backup sets". What I really want is "Bak up to new media set".
views:
358answers:
1
+5
A:
See this article. It explains how to make a backup without breaking the existing backup chain.
NYSystemsAnalyst
2009-02-04 13:20:43
Thanks NY. So The below would do it (sorry - very new to this and don't want to cause any problems..)BACKUP DATABASE MyDataBase TO DISK='C:\Dev\BackUpTest\BackUpTest.bak'WITH FORMAT, MEDIANAME = 'Tester', MEDIADESCRIPTION = 'My testing of backups', COPY_ONLYGO
MT
2009-02-04 13:32:09
Looks OK. I would advise testing this first before running it against a production DB.
NYSystemsAnalyst
2009-02-04 13:57:06
Naturally... seems to be working. Thanks again.
MT
2009-02-04 14:22:42