SQL Server 2000 Database Restore
-
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
-
Apologies, I just realized I pasted this under the SQL 2005 section.
Is anyone still able to shed some light on this issue?
Regards
-Mike
-
Do you know what kind of replication you have setup on the database? You can script the replication from database on the source and then run that script on the destination.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply