January 6, 2011 at 12:11 pm
I had something quirky happen today, I was doing a database restore from Management Studio 2005 9.00.4035.00 on my desktop. I selected my backup file, then went to the options folder, selected overwrite the existing database. Now here's my problem, I click the ellipsis to select the file location, I navigate to the folder where the .mdf file is located and I cannot see the mdf files, but I can see the .ldf files which are on a different drive. So, then I logged into the server to verify that the files were at the location I had specified and they were. I tried Management Studio directly from the server where the files are located and I can not see the .mdf files there either. I also tried using Management Studio 2008 and got the same results. Why can I not see the mdf files?
January 7, 2011 at 2:16 am
When using .mdf files, isn't attach the preferred method instead of backup?
Backup is intended to restore .bkp or .trn files, if I'm not mistaken.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 7, 2011 at 5:51 am
I don't think you read my post completely before you answered.
January 7, 2011 at 5:55 am
Sheila.Roscoe (1/7/2011)
I don't think you read my post completely before you answered.
I've read it more times then you think.
But I'm still wondering why you are using mdf files and backup.
If you use the "attach" task, you should see the mdf files.
If you use the backup task, the wizard will look for .bak or .trn files, so logically you can't see them.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 7, 2011 at 6:30 am
ok, I am using the wizard to do a restore...I can select which backup file I want to use, what I am having trouble with is on the OPTIONS screen of the backup wizard. I want to make sure (since I am using a backup from another server) that the data (mdf) and log (ldf) are pointing to the new location (the database already exist on the destination server where restore is being performed). When I click the ellipsis and navigate to where I know the files are, I do not see them.
January 7, 2011 at 6:40 am
Also, I did this same restore last week on the same server and I had no difficulty.
January 7, 2011 at 6:46 am
OK, I did miss that part where you were going to the OPTIONS pane 😀
I can't seem to reproduce the problem, so I'm afraid I don't have a clue either.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply