--call the database for example manufacturing
--back up database
backup database [manufacturing] to disk = N'E:\Transfer\manufacturing.bak' with format
--back up log this is not required
backup log [manufacturing] to disk = N'E:\Transfer\manufacturinglog.bak' with format
--restore database
restore database manufacturing
from disk = 'c:\transfer\manufacturing.bak'
with recovery,
move 'Manufacturing_Data' to 'E:\Manufacturing_Data.mdf',
move 'Manufacturing_Log' to 'F:\Manufacturing_Data.ldf'
you may also get the how the html typed data are saved into the database tool
ReplyDeleteSome times we can not restoe our database by restoration process than we can use third party sql database recovery software.
ReplyDelete