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.
6/10/2013 11:36:00 pm
Sarkari Job




0 comments:
Post a Comment