Total Pageviews

Search This Blog

Friday, August 21, 2009

Tip: Restoring SQL database which is on the network

Problem:
Recently, I came across this issue when I had to restore a AX Database backup. Initially, I did copy the database which was of 25 gb size to the server where I wanted to restore, but I ran out of space. So the only option left me with was to do a restore via the network.

Solution

There's an option wherein you can just type in the network path of the backup file, if your account has enough permissions on the SQL Server service which is running. Check the screenshot below



This will do the trick. Also, if you are interested in SQL Scripts, this can be done very much the scripting way too! Happy SQL'ing :-)

No comments: