SQL2000 database restore issue
#1
Scooby Regular
Thread Starter
Join Date: Feb 2001
Location: Hemel Hempstead
Posts: 7,953
Likes: 0
Received 0 Likes
on
0 Posts
Ok, this has me a little baffled, prob fairly straight forward though.
Server: W2000SVR + SQL2000
BackUP SW: Backupexec + SQL plug in
Device: HP Quantum DAT
I have a fresh install of SQL2k on the server, (although this is not the orignal location of the databases). Through Backupexec I select the DBs from the tape and set to restore.
They appear in the 'databases' section of SQL, BUT they are in grey with '(loading)' under them. I have given them plenty of time (overnight) but still nothing...
Have tried just restoring one of the smaller databases (v small) but still the same problem.
Any thoughts?
Server: W2000SVR + SQL2000
BackUP SW: Backupexec + SQL plug in
Device: HP Quantum DAT
I have a fresh install of SQL2k on the server, (although this is not the orignal location of the databases). Through Backupexec I select the DBs from the tape and set to restore.
They appear in the 'databases' section of SQL, BUT they are in grey with '(loading)' under them. I have given them plenty of time (overnight) but still nothing...
Have tried just restoring one of the smaller databases (v small) but still the same problem.
Any thoughts?
#2
Scooby Senior
Join Date: Oct 2000
Location: Zurich, Switzerland
Posts: 3,105
Likes: 0
Received 0 Likes
on
0 Posts
Disclaimer: *I'm still learning SQL*
The main DB for the restores you're trying to do will have entries for the path of all other DB's. If you're trying to restore them to a different path it wont work out of the box. I guess you can use 'Query Analyzer' to fix it....but god know's how (let me know when you find out )!
Richard
The main DB for the restores you're trying to do will have entries for the path of all other DB's. If you're trying to restore them to a different path it wont work out of the box. I guess you can use 'Query Analyzer' to fix it....but god know's how (let me know when you find out )!
Richard
#3
Scooby Regular
Join Date: Sep 1999
Location: Bedfordshire
Posts: 4,037
Likes: 0
Received 0 Likes
on
0 Posts
POC
At a glance it sounds like the option 'Restore and leave database operational' has not been set so once the restore is complete the database is still offline. In enterprise manager right click on the database in question and see if there is a option (can remember exactly what it is) that says 'make online', I'll have a look in books online as well.
Gary
At a glance it sounds like the option 'Restore and leave database operational' has not been set so once the restore is complete the database is still offline. In enterprise manager right click on the database in question and see if there is a option (can remember exactly what it is) that says 'make online', I'll have a look in books online as well.
Gary
#4
Scooby Regular
Thread Starter
Join Date: Feb 2001
Location: Hemel Hempstead
Posts: 7,953
Likes: 0
Received 0 Likes
on
0 Posts
Problem Solved, thanks for the help guys.
Solution here:
http://support.microsoft.com/default...&Product=sql2k
Solution here:
http://support.microsoft.com/default...&Product=sql2k
Thread
Thread Starter
Forum
Replies
Last Post
Phil3822
General Technical
0
30 September 2015 06:29 PM