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 |
|
gdeconto
Posting Yak Master
107 Posts |
 Posted - 2002-04-24 : 12:21:10
|
| Sigh.Sometimes, working with computers really does seem more a mysterious black art than science.I am still experiencing problems when trying to restore databases using the sql2k enterprise manager:1. I still get a "no disk" message when I go to locate a file to restore; for some reason it keeps requesting that I insert a disk in drive A, even though I shouldn't have to (and didn't need to before)2. a NEW problem is that when I finally get the dialog box that shows me the contents of the backup folder, there are NO FILES LISTED even though I know that there are 30 or 40 files there!?!?! I can manually enter the name, of course, but the names are long and I am concerned about keyboard errorsCan ANYONE help me with either problem? I'm ready to toss the server into the nearest lake... |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2002-04-24 : 13:05:49
|
| May be you are running into this bug:http://support.microsoft.com/default.aspx?scid=kb;EN-US;q281345This article has a nice workaround ;-)Anyways, I never use Enterprise Maanger for doing backups. I know it's tough, but once you get used to working with commands in Query Analyzer, you'll enjoy the amount of control you gain!--HTH,VyasCheck out my SQL Server site @http://vyaskn.tripod.com |
 |
|
|
gdeconto
Posting Yak Master
107 Posts |
Posted - 2002-04-25 : 17:21:29
|
| Thx. I saw the listing but only saw sql 7 reference and ignored it, instead of seeing that it also mentions sql 2k at the top. |
|
|
|
gdeconto
Posting Yak Master
107 Posts |
Posted - 2002-04-25 : 17:23:22
|
| PARTIAL SUCCESS:There appears to be a weird bug in the sql2k restore facility (at least in the installation that we have) that prevents a listing of any backup that has a filename extension. My problem was that I had setup a default backup extension of ".BAK".silly of me to do something useful.once I renamed the files so that they had no extension, the files appeared in the restore listusers beware!!!!! |
|
|
|
|
|
|
help! another weird restore problem