Restore SQL Database
-
Thanks in advance, I Want to restore a SQL 2005 databse .bak file during setup while i am installing SQL Server in silent mode. Any Suggestions.
SOFTDEV Luck in life always exists in the form of an abstract class that cannot be instantiated directly and needs to be inherited by hard work and dedication.
-
Thanks in advance, I Want to restore a SQL 2005 databse .bak file during setup while i am installing SQL Server in silent mode. Any Suggestions.
SOFTDEV Luck in life always exists in the form of an abstract class that cannot be instantiated directly and needs to be inherited by hard work and dedication.
Why not create a command script (or similar) which first calls the silent setup and after that the script to restore the database. To run the restore script, you could use the newly installed SQLCMD[^].
The need to optimize rises from a bad design.My articles[^]
-
Thanks in advance, I Want to restore a SQL 2005 databse .bak file during setup while i am installing SQL Server in silent mode. Any Suggestions.
SOFTDEV Luck in life always exists in the form of an abstract class that cannot be instantiated directly and needs to be inherited by hard work and dedication.
RESTORE DATABASE AdventureWorks2008R2
FROM DISK = 'd:\SQLServerBackups\sampleDB.bak'
WITH FILE=1,
NORECOVERY;