Monday, June 10, 2013


How do a quick back up for SQL Server 2005


Here is the syntax to quickly backup a database in SQL Server 2005.
Backup database [database name] to disk=’path where you want the file.bak’
Eg:-

backup database CRM_MSCRM to disk=’c:\crmbackup_rakesh.bak’
You can make the backup command to a completely different level but this is a quick tip on just getting a backup to perform some quick maintenance.

No comments:

Post a Comment