How do I restore a database on a remote SQL server 2005 from a local backup?
Posted
by MatsT
on Server Fault
See other posts from Server Fault
or by MatsT
Published on 2010-03-07T23:05:57Z
Indexed on
2010/03/08
3:32 UTC
Read the original article
Hit count: 353
I have been given access to (parts of) a remote SQL Server 2005 with SQL Server authentication in order to be able to make changes to a database without involving other people who is not working on the project. The database have been created on my local machine. Is there any way to restore the remote database from a backup file on my local computer? I do not currently have access to the filesystem on the remote server.
EDIT: To clarify, the access I have is that i can log in to the server via the SQL Server Management Studio. I have one connection to my local database server and one connection to the remote server. What I basically want to do is copy the database from one connection to the other.
© Server Fault or respective owner