CODEWITHSUNDEEP
sqlsql-serversql-server-expressdatabase-backups
Greg McNulty
Greg McNulty

Reputation: 1466

How do I backup a local SQL Server database in XP?

I have developed an ASP.NET 3.5 website on my PC

To deploy the database on the host I use, they require I "restore" it, using a backup of the database.

How do I create this back up of my the database on my PC running XP?

Is there any way to do this in Visual Web Developer? I also downloaded the SQL Server Configuration Manager but I see no option for a backup.

Any help is appreciated!

(Visual Web Developer Express with SQL Server Express 2005)

Thank You.

EDIT
My solution thanks to the answers below:
Right in Visual Web Developer Express SQL pane I executed the statement - 

BACKUP DATABASE [C:\Mysite\App_Data\ASPNETDB.MDF] TO DISK = N'C:\Backup.bak' WITH NOFORMAT, NOINIT, NAME = N'YourDB-Full Database Backup', 
SKIP, NOREWIND, NOUNLOAD, STATS = 10;

This created the back up, with some warnings, not really sure what they meant as it mentioned "missing columns" that I am not familiar with. After uploading the database on the host it looked like everything was there, I will be able to test it soon an will update if there is anything I did wrong or missed.

Upvotes: 2

Views: 961

Answers (2)

RichardTheKiwi
RichardTheKiwi

Reputation: 107816

Get SQL Server Management Studio 2008 R2 (choose Management Tools only) if you don't have it. It will help you manage your database. The UI is easy to drive - expand the tree on the left to the database required, and right-click -> Backup Database

Upvotes: 2

Martin Smith
Martin Smith

Reputation: 453887

You should be able to do it through the GUI in management studio or adust the following script and run.

BACKUP DATABASE [YourDB] TO  DISK = N'C:\Backup.bak' WITH NOFORMAT, NOINIT,  
NAME = N'YourDB-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10

It is particularly likely that you will need to adjust the file path to somewhere that the service account has permissions to write to (The Backup folder in your MSSQL directory is a good bet).

Upvotes: 4

Related Questions