I have a .bak file on my client and want to use it, to restore a database on a server running on another machine. Is there any way to achieve this without transfering the file to the servers filesystem?
-
you can create the script of the DB (also with data) .. or even you can use a powershell script i thinkfederico scamuzzi– federico scamuzzi2017-01-13 10:46:31 +00:00Commented Jan 13, 2017 at 10:46
-
The bak file was created by an admin on a prod database and i need it to restore the dev environment. I really need a solution to use the BAK file.lassedev– lassedev2017-01-13 10:48:09 +00:00Commented Jan 13, 2017 at 10:48
-
You can see this answer: stackoverflow.com/questions/13396027/…Joe Taras– Joe Taras2017-01-13 11:06:05 +00:00Commented Jan 13, 2017 at 11:06
-
You can restore from any path, including from network folders. Have you tried sharing the folder where the backup file is stored?Panagiotis Kanavos– Panagiotis Kanavos2017-01-13 12:16:49 +00:00Commented Jan 13, 2017 at 12:16
Add a comment
|