Loading ...

SQL Server: Restore database via command | CodeAsp.Net

SQL Server: Restore database via command

 /5
0 (0votes)

Restoring database via SSMS via GUI produces some time lag in doing that. If you want to do the same restore stuff via command it can be an instant process. You can use the following query to restore your database from a backup:

Syntax:

RESTORE DATABASE <YourDBName> FROM DISK='<Database backup physical location>' WITH REPLACE

Sample:

RESTORE DATABASE test FROM DISK='D:\DB Backups\test.bak' WITH REPLACE

Comments (no comments yet)

Top Posts