Restore with dynamic fields

jonstahura · October 19, 2012 3:14PM

Hi.. I don't know if anyone has done this, but I have quite a few databases I would like to restore automatically. I have a vb.net program passing variables to a stored procedure and would like the sql backup 7 to use those in the restore command... something like below:

EXECUTE master..sqlbackup '-SQL "RESTORE DATABASE [@sitename + ''_APP_'' + @DBSUFFIX]
FROM DISK = @backupfilepath WITH MOVE DATAFILES TO @dbdirectory,
MOVE LOGFILES TO @tlogdirectory, REPLACE " '

Brian Donahue · October 22, 2012 11:25AM

Thanks for your question. It's not something that we support directly, but the .NET Framework does have a SqlClient namespace that you can use to run queries. To do what you want to in your example, I think it's best to use a parameterized query as in this example: http://www.dotnetperls.com/sqlparameter

jonstahura · October 22, 2012 12:31PM

thanks for the link.. i figured it out.

I needed more single quotes... a LOT more.... and then it worked!

Brian Donahue · October 23, 2012 3:50AM

Thanks, I'm glad that worked.

Restore with dynamic fields

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk