Back up your MS SQL 2008 database using Studio Express
Backing up your Microsoft SQL Server 2008 database is easier than ever using SQL Server Management Studio Express
2008.
This article is split into two sections, backing up your database content, and backing up stored procedures and functions.
Back up your database content
Step 1: Open SQL Server Management Studio Express 2008 and
connect to your database.
Step 2: Right-click on your database and select Tasks, then Export Data from the drop down
menus.
Important: You will not be able to use the Back up option from this menu.
Step 3: The Import/Export wizard will open, click Next.
Step 4: In the form provided, enter the following details:
* Data source: Select SQL Server Native Client 10.0 from the drop down menu.
* Server Name: Enter the IP address of your database server. This is shown within your Control
Panel.
* Authentication: Select Use SQL Server Authentication, then enter your database username and
password. This is the username and password you chose when you created your database.
* Database: Enter the name of your database from the drop down menu.
Step 5: Click Next.
Step 6: You will be asked where to export the database contents to. Select Flat File Destination from the
drop down menu and choose a filename and location for your backup.
In the example below we have also changed the Locale to English (United Kingdom) and selected the option
marked Column names in the first data row.
Quick Tip: This example shows you how to back up your content to a .txt file. If you would like to back up your
data to a separate database, select SQL Server Native Client 10.0 from the drop down menu and enter your
database details in the text boxes provided.
Step 7: Click Next.
Step 8: Select Copy data from one or more tables or views and click Next.
Step 9: Finally, choose which tables or views you want to export and select how you would like the file to be
formatted. Once done click Next.
Step 10: Click Next, then Finish to export your file. You will receive confirmation that your
database content has been backed up.
Backing up stored procedures and functions
Step 1: Open SQL Server Management Studio Express 2008 and connect to your database.
Step 2: Navigate to your stored procedures, and then highlight any stored procedures that you want to back up.
Quick Tip: The information below shows you how to back up stored procedures, but the principle is exactly the
same if you want to back up any functions.
Step 3: Right-click on Stored Procedures and select Script Stored Procedure as > CREATE To > File
from the expanded menu.
border="0">
Step 4: Choose a location to save your stored procedure and a file name for this backup. Then click
Save.
The selected stored procedures will now be saved on your computer.
Related Articles
There are no related articles
No viewers have posted comments
|
|
