Video Screencast Help

Backup Exec 12.5 Restore SQL server database to an instance that doesn't exist

Created: 15 Jul 2013 | 6 comments

Good Evening all,

Long time searcher first time I have had a problem that I couldn't find the answer for.

I have had to restore a very large SQL database from backup and I have sent it to a different server as I can't place it directly back over the top as it is a very active database (luckily I only need a few non-active tables from that database as a whole). 

That said I was going through the options and realised some 7 hours into the restore that I accidentally sent it to an instance rather than a specific database. I'm loathed to cancel the job now as it is half way through however I don't want to get to the end and find I can't access this database somehow. So if I am better off cancelling and starting again then thats a pain but i will do.

Once the restore is complete will I be able to access this database even though it is sent to an instance that doesn't exist?

I have checked the network traffic between the servers and there is definitely data flowing between the two I just can't find the file(s) that are open on the recieveing server to try and verify that I will be able to get the data.

Any help is much appreciated.

Backup Exec 12.5, Windows Server 2003, SQL 2005 if it makes any difference.

(And yes we are in need of some software updates!)

Operating Systems:

Comments 6 CommentsJump to latest comment

Colin Weaver's picture

I believe it will create the database with it's original name but in that new instance as if it did not do that then not specifying a database name would have caused a failure to submit the restore job instead of letting you submit the job and seeing data transfer. 

rriiicchh's picture

OK thanks Colin. The restore is taking a lot longer than I thought as it hasn't completed by now, I can't see any logical files that would indicate the restore is actually taking place onto the server requested.

Is there any place that I should look where backup exec would place the files other than the locations specified?

Jaydeep S's picture

Like Colin said, it will restore the database with its original name and incase you forgot to specify the instance name, it goes to the Default SQL instance on that Server. The best place to locate the database in this situation is in the default data folder for that instance.

If it restores successfuly, you would be able to access it and get the tables that you need.

rriiicchh's picture

OK thanks. Its just that it has been running a restore for some 16+ hours now and I would expect to see at least something on the server. Is it a hidden file until the restore is fully complete?

Jaydeep S's picture

You could try to browse to the data location and see if you can see the files there. I am not entirely too sure, but you should start to see the files there (mdf and ldf)