Following is the one of the Backup method on MSSQL server 2005/2008
Open Microsoft SQL Server Management Studio and login with admin privileges.
Expand database server name -- > databases -- > under databases select database and right click in the selected DB for which you want to take backup -- > then Tasks --> Backup,
then it will redirect to the backup wizard. as shown below.as shown below. then under source select backup type as FULL.
Under backup set give proper backup name
under destinaton click on Add button then select database destination wizard will open.
then click on broese button it will open locate database file where we can give detinaton of (.bak)back file with name as shown below.
Once backup process complete you can success message as following window .
Open Microsoft SQL Server Management Studio and login with admin privileges.
Expand database server name -- > databases -- > under databases select database and right click in the selected DB for which you want to take backup -- > then Tasks --> Backup,
then it will redirect to the backup wizard. as shown below.as shown below. then under source select backup type as FULL.
Under backup set give proper backup name
under destinaton click on Add button then select database destination wizard will open.
then click on broese button it will open locate database file where we can give detinaton of (.bak)back file with name as shown below.
No comments:
Post a Comment