Restore-DbaDatabase

 

Restoring database using dbatools-Restore-DbaDatabase
cls
Restore-DbaDatabase `
-SqlInstance InstanceNamehere `
-Path C:\Temp\BakFileNameHere.bak `
-DatabaseName  RestoreDatabaseNamehere `
-DestinationDataDirectory F:\MSSQL12.MSSQLSERVER\MSSQL\DATA\DatabaseData_Data.mdf `
-DestinationLogDirectory G:\LOGs\DatabaseName_Log.ldf `
-Verbose

Comments

Popular posts from this blog

System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out

Pre login Handshake or Connection Timeout Period

Transparent Data Encryption(TDE) with Master Key and Certificate in SQL Server