SQL Restore - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SQL Restore

Author

Topic

SEP
Starting Member

5 Posts

Posted - 2009-05-06 : 11:43:40

sorry novice here.

I wish to restore a SQL 2005 database but its not working. Is this the correct way?

stop the server\instance
right-click on database
Tasks
Restore
Database
From database
select Restore point
overwrite existing database
start server\instance

I am getting this error:

Failed to retrieve data for this request
Failed to connect to server\instance
A network related or instance specific error occurred whiles establishing a connection to SQL server.
The server was not found or was not accessible. Verify that the instance name is correct and that Sql server is configured to allow remote connections. Provider: named pipes provider, error: 40 Could not open a connection to sql server. Error 2

kishore_pen
Starting Member

49 Posts

Posted - 2009-05-06 : 11:53:30

enable the TCP/IP ports for SQL Server using SQL Server configuration manager and also required privelages.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-05-06 : 12:23:30

Didn't get that.
How can you stop the server and then do anything on this server?

No, you're never too old to Yak'n'Roll if you're too young to die.

SEP
Starting Member

5 Posts

Posted - 2009-05-07 : 04:40:01

In SQL Management, at the top of the list is the servername\instance with the green arrow meaning it's running (red square is off). You can't do anything because it says the database is in use so you stop it right? Then you can make backups/restores etc.

I am doing this via remote desktop is that what that means enable tcp/ip which allows for remote connection?

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-05-07 : 04:58:56

why don't you refer to the BOL on this. There are details steps there

How to: Restore a Database Backup (SQL Server Management Studio)

KH
[spoiler]Time is always against us[/spoiler]

SEP
Starting Member

5 Posts

Posted - 2009-05-07 : 05:49:47

do you stop anything or leave everything running?

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-05-07 : 06:19:53

you don't have to stop the services or the SQL Server engine to restore. You do have to ensure nobody is access the database that you are going to restore

KH
[spoiler]Time is always against us[/spoiler]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources