Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sonu
Posting Yak Master
110 Posts |
 Posted - 2004-11-11 : 10:20:16
|
| Hello, I have a dbase on the server and I would like to copy all tables and stored procedures including the data from the server to my local system. How can I do that?Thanks |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-11-11 : 10:49:35
|
| Backup and RestoreYou could also DETACH and ATTACH, but I prefer the Backup/Restore routeKristen |
 |
|
|
sonu
Posting Yak Master
110 Posts |
Posted - 2004-11-11 : 10:58:22
|
| I dont see any option to backup the dbase to my local system. Please tell me how I can do that. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-11-11 : 13:42:26
|
| Enterprise Manager: Backup the database - that will be to the local disk on the server. Copy that backup file to your local machine. Restore it from that file into your local database (using Enterprise Manager again).Kristen |
|
|
|
sonu
Posting Yak Master
110 Posts |
Posted - 2004-11-11 : 15:47:11
|
| I dont have access to the local disk on the server. So I cant do it. Is there any other chance to copy the dbase from the webserver to my local system? |
|
|
|
AndyB13
Aged Yak Warrior
583 Posts |
Posted - 2004-11-11 : 15:55:59
|
| If its a web server, do you know the structure of the directories & where your wwwroot/ftproot directories are. If so just back it up as Kristen said "to the local disk on the server" and then download it via ftp or httpAndy |
|
|
|
sonu
Posting Yak Master
110 Posts |
Posted - 2004-11-11 : 18:53:20
|
| Honestly said, I would like to avoid this, because its not my web server. Is there any other possiblity? |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-11-11 : 21:43:11
|
| can dts serve your purpose?--------------------keeping it simple... |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-11-12 : 04:49:28
|
| Well my two pennyworth is that the owner of the server should eb providing you with a way to get access to your data. I would expect them to have a daily backup, or an on-demand process, that put, say, a ZIP of a backup of your database in an FTP area.You could script the database, using Enterprise Manager, use that to create a local database, and then DTS the data. But there are a number of pitfalls with that approach - such as foreign keys, encrypted SProcs and probably some other things which I haven't through of.Kristen |
|
|
|
|
|
|
|
|
Copy all tables and stored procedures