Im looking for a scrip that I can just point at a .bak file and it will delete the current db and then restore the .bak file in its place. And will close all connections. Does anybody know of a script that will do this?
I want to do it in c#.
Asked
Active
Viewed 292 times
-1
-
1http://stackoverflow.com/questions/1466651/how-to-restore-a-database-from-c-sharp it's asked before! – Mazen313 Oct 31 '11 at 12:25
-
I dont know where I can get the dlls from? – Exitos Oct 31 '11 at 15:36
1 Answers
0
You should start by looking at SQL Server Management Object, in particular the Restore class.
Joe
- 122,218
- 32
- 205
- 338