SQL Server Database Restore.

Question

SQL Server Database Restore.

mbarnes 6537

Valued Member

Points: 62
More actions
August 16, 2010 at 10:26 pm

#140320

Hi,
Im able to restore a database from a .BAK file & the data imports fine, the issue im having is after the data has been successfully imported...
Before the database restore the database name (In my case GlobalSTORE) has a little hand? under the database, then after the restore its gone and consequently I cant get the GlobalSTORE application to make a connection with the GlobalSTORE database.
I need to know how to get that little hand? back again. I presume this has something to do with replication??
Please see pic below as to the "Little Hand" i refer.
Below is a step by step account of how I restore the database.
-Open SQL Enterprise 2000 & navigate to the "GlobalSTORE" Database.
-Right click on the "GlobalSTORE" database >> All Tasks >> Restore from Database.
-I restore "From a Device" which is the local HDD and select the appropriate .BAK file.
-Under the options tab i select the checkbox "Force Restore Over Existing Database"
-Click OK and the restore begins & ends successfully.
Regards
-Mike

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Mohit K. Gupta SSChampion Points: 12130 More actions · Answer 1

When the application tries to connect to restored database it is on same server or a different server? Also are you using SQL Logins or Windows authentication?

What is the error application getting?

[font="Arial"]---

Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE

* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]

How to ask for help .. Read Best Practices here[/url].

Steve Jones - SSC Editor SSC Guru Points: 736602 More actions · Answer 2

It is for replication. You might need to reset this up as a subscriber, or is this a publisher?

mbarnes 6537 Valued Member Points: 62 More actions · Answer 3

This is the publisher, it holds all the databases and the clients update from this server.

I believe there is a way i can script the replication from the original database and apply that script to the restored database?

Cheers

-Mike

Steve Jones - SSC Editor SSC Guru Points: 736602 More actions · Answer 4

Yes, you can script replication. Was it setup before this backup was made? Is this on a new server? If so, you might need that script to reset the jobs and articles. However, you don't want these going to the same subscribers, do you?