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 |
|
sujithukvl@gmail.com
Starting Member
22 Posts |
 Posted - 2007-06-18 : 07:36:30
|
| I am an authenticated user of a remote data baseI can log in and add tables and even I can back up the database .Good. But I want to get a copy of the database to my local computerIs there any way to do this? _sujithsql_ |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-06-18 : 07:44:39
|
| Copy the backup file on the remote server to your local machine. Restore this backup file on your local server.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
sujithukvl@gmail.com
Starting Member
22 Posts |
Posted - 2007-06-18 : 07:58:19
|
| but don't have shell access to the serveror cant move to particular folder in the server |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-06-18 : 08:05:16
|
| Then use the DTS Import/Export wizard to import the database objects on your local server.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
sujithukvl@gmail.com
Starting Member
22 Posts |
Posted - 2007-06-18 : 09:07:19
|
| DTS Import/ExportI don't understand this... how can i do this?pleasei am just a new be |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-18 : 16:01:32
|
| Take look at SSIS in books online. |
|
|
|
|
|
|
getiing a copy of data bse from a remote server