•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 422,389 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,745 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser: Programming Forums
Views: 1513 | Replies: 5
 |
•
•
Join Date: Mar 2008
Posts: 2
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
How do I Backup the MS SQL server 2000 database file (mdf) to my local PC ? 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..
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 6:04 pm.
•
•
Join Date: Aug 2006
Location: Egypt
Posts: 762
Reputation:
Rep Power: 4
Solved Threads: 59
Master Poster
Manually you can stop the server copy the data files and then restart the server..
B.Sc Computer Science, Helwan University
Microsoft Student Partner
Personal blog http://ramymahrous.blogspot.com/
Arabic technical blog http://fci-h-ar.blogspot.com/
English technical blog http://fci-h.blogspot.com/
Microsoft Student Partner
Personal blog http://ramymahrous.blogspot.com/
Arabic technical blog http://fci-h-ar.blogspot.com/
English technical blog http://fci-h.blogspot.com/
•
•
Join Date: Nov 2007
Location: � Jogja �
Posts: 2,584
Reputation: 
Rep Power: 11
Solved Threads: 235
•
•
•
•
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.
Never tried = Never Know
So, Please do something before post your thread.
* PM Asking will be ignored *
So, Please do something before post your thread.
* PM Asking will be ignored *
•
•
Join Date: Nov 2007
Location: � Jogja �
Posts: 2,584
Reputation:
Rep Power: 11
Solved Threads: 235
and don't forget to stop a server for a while when you want to backup data cause it will give you an error.
Never tried = Never Know
So, Please do something before post your thread.
* PM Asking will be ignored *
So, Please do something before post your thread.
* PM Asking will be ignored *
•
•
Join Date: Mar 2008
Posts: 2
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
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.
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 8:21 am.
•
•
Join Date: Dec 2007
Location: Raleigh, NC
Posts: 31
Reputation:
Rep Power: 1
Solved Threads: 4
Light Poster
Give this a shot from within sqlcmd or osql....
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
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
Aaron Sterling
|
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
•
•
•
•
ad advertising ajax architecture asp avoiding null results when adding two columns any of which is null in ms sql server backup business crash daniweb data database decimal seperator thousand seperator when using sql server deleting records from ms sql table where columns have duplicate values dell design developer development doubleclick enterprise europe google hacker how to insert big html markup with white spaces(i.e. line breaks) and single and double quotation marks to sql server hp internet linux mail management studio 2005 microsoft mmorpg msdn news normalization office open qmail red hat rhel security server server 2008 smtp software source sql sql cache dependency with polling-based invalidation survey vista windows
- Previous Thread: Inquiry on finding if a fields data is unique for the recordset
- Next Thread: deleteting multiple rows and related table entries
