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
mssql back with MS Management Studio
- Tribble
- Registered User
- Posts: 88465
- Joined: 08 Feb 2007, 02:00
- Processor: Intel Core i7-4770K CPU@3.50GHz
- Motherboard: ACPI x64-based PC
- Graphics card: GeForce GTX 780 Ti
- Memory: 16GB
- Location: Not here
- Contact:
Re: mssql back with MS Management Studio
Yes you can - chose a different location and name when you do the backup.
Oh yes - and remove the current backup from the list.
Oh yes - and remove the current backup from the list.
- hamin_aus
- Forum Moderator
- Posts: 18363
- Joined: 28 Aug 2003, 02:00
- Processor: Intel i7 3770K
- Motherboard: GA-Z77X-UP4 TH
- Graphics card: Galax GTX1080
- Memory: 32GB G.Skill Ripjaws
- Location: Where beer does flow and men chunder
- Contact:
Re: mssql back with MS Management Studio
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
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