Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Revisiting restore procedure
Message
De
06/02/2017 10:01:20
 
 
À
Tous
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Titre:
Revisiting restore procedure
Versions des environnements
Environment:
VB 9.0
OS:
Windows 8.1
Network:
Windows Server 2012
Database:
Visual FoxPro
Application:
Web
Divers
Thread ID:
01647592
Message ID:
01647592
Vues:
73
I have a restore procedure like this:
Dim lcRestoringDatabase As String = ""
Dim loRestore As Microsoft.SqlServer.Management.Smo.Restore = New Microsoft.SqlServer.Management.Smo.Restore
Dim loServer As Microsoft.SqlServer.Management.Smo.Server = New Microsoft.SqlServer.Management.Smo.Server

loRestore.Devices.AddDevice(cPath + "\" + cDatabase + ".bak", Microsoft.SqlServer.Management.Smo.DeviceType.File)
loRestore.Database = cDatabase
loRestore.Action = Microsoft.SqlServer.Management.Smo.RestoreActionType.Database
loRestore.ReplaceDatabase = True
loRestore.PercentCompleteNotification = 1
AddHandler loRestore.PercentComplete, AddressOf ProgressEventHandler2
loRestore.SqlRestore(loServer)
I need to add support in there for something that would be able to support this extra move files such as this:

RESTORE DATABASE [MyDatabase] FROM DISK = N'D:\SQLData\MyDatabase.bak'
WITH Move 'MyDatabase' TO 'D:\SQLData\MyDirectory\MyDatabase.mdf',
MOVE 'MyDatabase_log' TO 'D:\SQLData\MyDirectory\MyDatabase.ldf',
MOVE 'Hit' TO 'D:\SQLData\MyDirectory\Hit.ndf',
MOVE 'CateFilt' TO 'D:\SQLData\MyDirectory\CateFilt.ndf',
FILE = 1, NOUNLOAD, REPLACE, STATS = 10
GO

Is that possible?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Répondre
Fil
Voir

Click here to load this message in the networking platform