Ad:

MS SQL Discussion Thread
Marked Solved
Views: 6688

Mar 7th, 2008

How do I Backup the MS SQL server 2000 database file (mdf) to my local PC ?

Expand Post »

Hi, currently I have a shared web hosting with MS SQL server 2000 database.

I have already implemented the database, with all the data inside the database, on the server.

Now I wish to copy the whole database (.mdf) down to my PC, in case I wanna change hosting or in case the server broke down, and keep it as a safe backup.

I already created a backup of it, the .bak file, but it is all stored in the web hosting database server.

How can I actually copy the whole thing down to my pc ?

I am using Microsoft SQL Server Management Studio Express.

Thanks alot..

Last edited by -mk-; Mar 7th, 2008 at 7:04 pm.

-mk-

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

10 posts
since Mar 2008

Permalink

Mar 8th, 2008

Re: How do I Backup the MS SQL server 2000 database file (mdf) to my local PC ?

Manually you can stop the server copy the data files and then restart the server..

Ramy Mahrous

Featured Poster

Reputation Points: 480

Solved Threads: 276

Postaholic

Offline

2,189 posts
since Aug 2006

Permalink

Mar 8th, 2008

Re: How do I Backup the MS SQL server 2000 database file (mdf) to my local PC ?

Click to Expand / Collapse Quote originally posted by RamyMahrous ...

Manually you can stop the server copy the data files and then restart the server..

yeah, i do this way if i want to backup my database. i think this is a simple way.

Jx_Man

Reputation Points: 1182

Solved Threads: 392

Posting Sensei

Offline

3,145 posts
since Nov 2007

Permalink

Mar 8th, 2008

Re: How do I Backup the MS SQL server 2000 database file (mdf) to my local PC ?

and don't forget to stop a server for a while when you want to backup data cause it will give you an error.

Jx_Man

Reputation Points: 1182

Solved Threads: 392

Posting Sensei

Offline

3,145 posts
since Nov 2007

Permalink

Mar 9th, 2008

Re: How do I Backup the MS SQL server 2000 database file (mdf) to my local PC ?

sorry but it is a shared-hosting service. I don't have the access to the server files and such.
Only able to connect to their SQL Server.

FTP accounts only able to access db and wwwroot folders.

Last edited by -mk-; Mar 9th, 2008 at 9:21 am.

-mk-

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

10 posts
since Mar 2008

Permalink

Mar 9th, 2008

Re: How do I Backup the MS SQL server 2000 database file (mdf) to my local PC ?

Give this a shot from within sqlcmd or osql....

MS SQL Syntax (Toggle Plain Text)
EXEC sp_addumpdevice 'DISK', 'MyBackupToFTPland', 'DirectoryYouCanFTPFrom\backup.bak'
 
BACKUP DATABASE yourdatabase
TO MyBackupToFTPLand
EXEC sp_addumpdevice 'DISK', 'MyBackupToFTPland', 'DirectoryYouCanFTPFrom\backup.bak'

BACKUP DATABASE yourdatabase
TO MyBackupToFTPLand

Then you should be able to FTP it...assuming of course that SQL Server has write access to someplace that you have FTP read access too.... could get complicated. Check the BOL for more options. the DISK keyword is necessary but you should be able to get away without the other wacky names i've chosen. hope that helps

AaronASterling

Reputation Points: 10

Solved Threads: 5

Light Poster

Offline

31 posts
since Dec 2007

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: Inquiry on finding if a fields data is unique for the recordset

Next Thread in MS SQL Forum Timeline: deleteting multiple rows and related table entries

DaniWeb Message

Cancel Changes

User Name
Password