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