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.
| Author |
Topic |
|
abeirnes
Starting Member
2 Posts |
 Posted - 2010-08-06 : 11:04:24
|
| I have 2 different customer's SQL2000 servers where when I attempt to restore a database ( any non-system database ) the 'Restore database files as' box is completely empty. There are no mdf and ldf files listed. I am able to restore using t-sql, but we'd like to know why this is happening. We've had at least one of the servers re-started.Any help would be greatly appreciatedAaron |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-08-06 : 11:47:14
|
Is the MSDB database huge? There is no automatic cleardown of backup history (etc.) info in MSDB in SQL2000. (If this is the case do NOT use the Sproc MS provided to do the cleardown - it will take WEEKS to run (I mean that, literally  ) |
 |
|
|
abeirnes
Starting Member
2 Posts |
Posted - 2010-08-06 : 12:15:05
|
| Well, MSDB: Size: 95.00 MB Space Available: 1.4 MBI guess that would be an issue, wouldn't it?Do I just increase the 'Space allocated (MB)' amount ( Currently set to 93 MB ) under the Data Files tab?Thanks,Aaron |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-08-06 : 13:01:23
|
| If its got to that big then it is probably on auto-grow, so I doubt size limit / free space is a problem.95MB is not huge, but probably way more than it needs to be.http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=36201Sproc is at the top of Page 2 if you get bored of reading the saga before then! |
|
|
|
|
|
|
Database restore problem - Restore Files empty