Page 1 of 1

mssql back with MS Management Studio

Posted: 19 May 2011, 15:14
by geraldhum
HI All

Is there a way to backup the DB through Microsoft SQL Management Studio, so instead of appending or over writing the current backup it creates a new Backup. I am busy doing this through sqlcmd but only can over write or append to the current backup and my client wants to keep each backup.

Regards
Gerald

Re: mssql back with MS Management Studio

Posted: 19 May 2011, 19:13
by Tribble
Yes you can - chose a different location and name when you do the backup.

Oh yes - and remove the current backup from the list.

Re: mssql back with MS Management Studio

Posted: 20 May 2011, 02:52
by hamin_aus
The only time you should be manually backing up a DB is the rare occasion you need to do an ad-hoc backup or restore.
With SQL maintenance plans and the SQL agent this is childsplay to automate!

Google "MSSQL Maintenance Plans"
MSSQL has one of the most comprehensive backup engines of any DBMS.
Just go to the Management tree in the object explorer in SSMS drill into it and right-click on the Maintenance Plans folder to start creating a custom backup plan that can do exactly what you want.
IE not overwrite your previous backups every time, but keep them all for a user-defined period.

Shout if you need help