March 22, 2007 at 6:07 am
Hi,
I want to restore backup from a backup file which is kept in a computer which is other than the computer in which Sql Server is intalled.
Please Help!
Thanks
Vijay Soni
March 22, 2007 at 6:42 am
If you have the drive mapped, then go to Server Objects, right click on backup devices and create a new one from File.
I don't know why management studio only shows fisical drives, and not mapped drives. The above short cut will help if you dump your backups to that location.
March 26, 2007 at 3:37 am
"I don't know why management studio only shows fisical drives, and not mapped drives"
I imagine it's because the drive is mapped in the context of your login and not in the context of the account that starts the SQL Server service. Talking of which, the most important thing to remember is that the service account must be a domain account with permissions on the resource from which you wish to carry out the restore.
John
March 26, 2007 at 8:38 am
I'd make the space and copy it over. Any network hiccups will cause your restore to abort.
March 26, 2007 at 11:12 am
It is actually simple put the .bak in the location below in 2000 the location could be different but you go to the Microsoft SQL Server folder in programs and place the file in the Backup subfolder. Then go to Management Studio/Enterprise Manager use the Backup and Restore Wizard choose restore for device option click on the ellispe and let SQL Server create the file path for you, this part is important if you create the file path SQL Server gets confused. And it is almost done. Post again if you still have questions. Hope this helps.
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup
Kind regards,
Gift Peddie
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply