hello everyone first of all thank you so much for the post comment and share my post with everyone,here i come with the new post Create a Database Backup in Sql Server 2008 R2, in this post i briefly explain the description of the creating backup and store in particular location.
Create a Database Backup in Sql Server
Starting with open the sql server management studio and login with the specific you user you want to use and the expand the database and select the database and right click on the database and navigate the "Task" and select the option "Back up..."
after completion this step the open the new window for backup configuration see like this..
- General configuration
in this window you can first select the file name radio button options and then click on browse button to right side of the file name text box tor browse the local path of your system see on the next step, also second option is Backup Drive you have any Backup drive so you can select via drop down list text box.
select the check box left side of the path and then click on the OK button to view the progress of database backup on the window right bottom corner and display the message back up..created successfully.
Using Sql Query to create database Backup file
Open a new query window
Syntax
BACKUP DATABASE [Database file Path] TO disk = 'Path to store backup file'
Example
BACKUP DATABASE [E:\krunal\data\EMPDB.mdf] TO disk = 'E:\Krunal\data\backup\empdb.bak'
check the path you select the folder open file is create with extension of ".bak" here is i haver create backup file called "empdb.bak" is stored in ms sql server default Backup folder.
Also you can crate the Auto backup Schedule for your database, this facility provide in sql server 2008 R2 , i explain it on my up coming post.
here now i complete this post,i wish this post is help to learn everyone, any query or confusion regarding my post please send me mail or comment.
Thanks
Kruna Patel
(Software Developer)
:-) :-)
My Popular post click on Link to view
Create a Database Backup in Sql Server
Starting with open the sql server management studio and login with the specific you user you want to use and the expand the database and select the database and right click on the database and navigate the "Task" and select the option "Back up..."
after completion this step the open the new window for backup configuration see like this..
- General configuration
- Options Configuration
in this window here you can create or configure the backup for your database name "EMPDB" all the by default configuration is set,to see on above picture, you can configure all the option as per your needs, after configure all the option you can select or click on "Add" button to add the location you want to store the database backup file.
- add the location you want to store database backup file
in this window you can first select the file name radio button options and then click on browse button to right side of the file name text box tor browse the local path of your system see on the next step, also second option is Backup Drive you have any Backup drive so you can select via drop down list text box.
in this step you can specify the selected folder path bottom of the window and files type and last name of file you want to create backup then click on ok button to return on the select file name window here is the display the whole path with file name and file extension.click on ok button to return the main configuration window with display the path and file name.
select the check box left side of the path and then click on the OK button to view the progress of database backup on the window right bottom corner and display the message back up..created successfully.
Using Sql Query to create database Backup file
Open a new query window
Syntax
BACKUP DATABASE [Database file Path] TO disk = 'Path to store backup file'
Example
BACKUP DATABASE [E:\krunal\data\EMPDB.mdf] TO disk = 'E:\Krunal\data\backup\empdb.bak'
check the path you select the folder open file is create with extension of ".bak" here is i haver create backup file called "empdb.bak" is stored in ms sql server default Backup folder.
Also you can crate the Auto backup Schedule for your database, this facility provide in sql server 2008 R2 , i explain it on my up coming post.
here now i complete this post,i wish this post is help to learn everyone, any query or confusion regarding my post please send me mail or comment.
Thanks
Kruna Patel
(Software Developer)
:-) :-)
My Popular post click on Link to view
No comments:
Post a Comment