0

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?

jarlh
  • 42,561
  • 8
  • 45
  • 63
lassedev
  • 317
  • 1
  • 4
  • 12
  • you can create the script of the DB (also with data) .. or even you can use a powershell script i think – federico scamuzzi Jan 13 '17 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 Jan 13 '17 at 10:48
  • You can see this answer: http://stackoverflow.com/questions/13396027/restoring-a-database-from-bak-file-on-another-machine – Joe Taras Jan 13 '17 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 Jan 13 '17 at 12:16

1 Answers1

0

Yes you can do it.Share the folder containig .bak file on a server where you want to restore the database .Now paste the path when browsing the .bak file.

anjali
  • 84
  • 6