Search code examples
sql-serversql-server-2000database-restore

How to restore database from remote database?

I want to restore my local dev database from a database that sits on a different server.

restore localdb from foreigndb....
Solution

  • I assume that when you said you want to restore database, you already have backup file (.BAK) for that database.

    It can be done couple of differnt ways,

    1) You can restore database from .BAK file stored on network drive, but it can take really long time and it is not reliable. And also account under which SQL Server service is running has enough permissions to do the operation.

    2) As E.J. suggested, You can copy that .BAK file from network drive to your local machine and do restore that will be more reliable and faster operation.

    3) Alternatively you can create SSIS package to automate this whole process.