Example Sql for restore backup to new database sql server-450294

Search

SCRIPT & CODE EXAMPLE

CODE EXAMPLE FOR SQL

restore backup to new database sql server

RESTORE DATABASE MyTempCopy FROM DISK='c:your.bak'
WITH 
   MOVE 'LogicalNameForTheMDF' TO 'c:MyTempCopy.mdf',
   MOVE 'LogicalNameForTheLDF' TO 'c:MyTempCopy_log.ldf'

Source by stackoverflow.com #

PREVIOUS	NEXT

Tagged: #restore #backup #database #sql #server

ADD COMMENT