Tell me more ×
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.
up vote 0 down vote favorite

How can I RESTORE a database through SQL Server Management Studio by connecting "remotely" to it.

If I know the "IP address" of the target machine what else do I need to know?

If the port number is a requirement, how can i find it?

share|improve this question
Can you access the sql servers local filesystem by some share? – bernd_k Dec 22 '11 at 13:50
Follow the steps described in this answer to get your remote connection working. Read the documentation on Backing Up and Restoring Databases in SQL Server for the basics. – Mark Storey-Smith Dec 22 '11 at 14:09
If its an Express, it might not be listening on any IP address at all. You will need to at least provide the version your using SQL Server 2000, 2005, 2008 and what edition Express, Standard. – Craig Efrein Dec 22 '11 at 17:39
Craig I only know the IP address of the target machine. I want to know on which port the sql server runs. I am given the task to connect to sql server instance. and take the backup. – user1057735 Dec 23 '11 at 5:21

1 Answer

up vote 2 down vote

This article details several ways to determine the port number SQL is running on

  • go right to the registry and look at the TCP settings
  • xp_readerrorlog. This will show the current SQL Server log and you can find the row “Server is listening on”.
  • use the SQL Server Configuration Manager
  • if you are on the machine, look at Task Manager

Then you should be able to use IPAddress,Port to connect. Or you can create a client side Alias using CliConfg on the client that allows you to connect to an alias.

share|improve this answer

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.