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.

About Rakesh

Programmer (CSE Development)

Your email address will not be published. Required fields are marked *

Name*
Email *
Comment*