Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- {
- conn = new ServerConnection
- {
- ConnectionString = @"Data Source =
- (localdb)MSSQLLocalDb;Initial Catalog=master;Integrated Security=true",
- };
- try
- {
- //Restore Full
- srv = new Server(conn);
- //lsrv = srv.LinkedServers[@"DEVSQLALPHA"]; need to figure out how to restore to linked server instead of local.
- //srv.KillAllProcesses("G4TestNew");
- var res = new Restore();
- res.Database = "G4TestNew";
- res.Action = RestoreActionType.Database;
- filePath = @"\CABCSERVERDatabaseTempFull.bak";
- res.Devices.AddDevice(filePath, DeviceType.File);
- res.ReplaceDatabase = true;
- res.NoRecovery = true;
- var dataFile = new RelocateFile("G4Test", @"C:TBDG4Test.mdf");
- var logFile = new RelocateFile("G4Test_log", @"C:TBDG4TestNew.ldf");
- res.RelocateFiles.Add(dataFile);
- res.RelocateFiles.Add(logFile);
- res.SqlRestore(srv);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement