0 Replies - 1876 Views - Last Post: 10 July 2008 - 12:32 AM

#1 dineeshd   User is offline

  • member icon

Reputation: 39
  • View blog
  • Posts: 619
  • Joined: 30-June 08

Snippet to Restore Database in MSSQL

Posted 10 July 2008 - 12:32 AM

Description: By using this snippet you can restore a database from a file on the disk.
USE master
GO
RESTORE DATABASE Northwind -- Provide the Database name to restore
FROM DISK = 'C:DatabaseNorhtWind_Backup_31032008' -- Backup File name has to be specified here
WITH REPLACE
GO



Is This A Good Question/Topic? 0
  • +

Replies To: Snippet to Restore Database in MSSQL

#2 dineeshd   User is offline

  • member icon

Reputation: 39
  • View blog
  • Posts: 619
  • Joined: 30-June 08

Re: Snippet to Restore Database in MSSQL

Posted 10 July 2008 - 12:32 AM

Description: By using this snippet you can restore a database from a backup file on the disk.
USE master
GO
RESTORE DATABASE Northwind -- Provide the Database name to restore
FROM DISK = 'C:DatabaseNorhtWind_Backup_31032008' -- Backup File name has to be specified here
WITH REPLACE
GO



Was This Post Helpful? 0
  • +
  • -

Page 1 of 1