June 20, 2007 at 5:47 am
I am using sql server 2005 express edition
I am an authenticated user of a remote data base
I 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 computer
Is there any way to do this?
The problem is that I don’t have access to the directory where database is located
Can i mport the database?
But in my “task menu”
There is only 5 options
Detach
Shrink
Backup
Restore
Generate script
There is no export/import
Help me …..
What should I do to get a local copy?
June 20, 2007 at 6:00 am
the obvious question is if you should be able to do this or not?
You should talk to the system administrator of the system you want the copy from, protecting the backups gives a measure of security.
You could probably get the data using SSIS.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
June 20, 2007 at 7:10 am
backup the database. Copy the backup file and then restore the same in the remote machine. Else use copy database wizard to copy the database to your remote machine.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 21, 2007 at 8:57 am
check out the
mirror to command
that should create a backup and a mirror
for you at about the same time it takes
to create a single backup .
Mike
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply