Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

How can I update or restore a database through SQL Server Management Studio by connecting "remotely" to it?

If I know the "IP address" of machine, what else do I need to do? If a port number is required, how can I find it?

share|improve this question

migrated from stackoverflow.com Dec 23 '11 at 5:57

This question came from our site for professional and enthusiast programmers.

2  
Probably a better fit for dba.se; also, you may want to start marking some of yoru questions as answered. –  Stuart Ainsworth Dec 22 '11 at 13:20
add comment

1 Answer 1

If you can connect to the server and you have the rights to do so, you can restore a database. The other thing that you'll need is to be able to get the backup files on to the servers hard drives or a network share that the SQL Server instance has rights to read.

share|improve this answer
    
merdenny, actually the task was/is to connect to the remote machine and take the backup of db. I got only the IP address but the porblem was i did not know on which port the sql server instance is running. So i was not able to establish a remote connection to the database through the sql management studio. That was the main issue and still looking for some help –  user1057735 Dec 23 '11 at 9:38
    
If you know the instance name, passing that as part of the server name will get you connected. If you don't have the instance name, or if dealing with the default instance and you don't have the port number they will need to provide the port number. –  mrdenny Dec 23 '11 at 20:39
    
If SQL is running on the default port as a default instance, you shouldn't need anything other than the IP in the Server Name field. If it's a named instance, you can just append the instance name to the IP with a "\". If it's running on a non-standard port, you either need the port number (append to the IP using a comma ",") or the server needs to be running the SQL Browser service so that it's advertising its instances. –  Brandon Dec 28 '11 at 17:07
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.