Hi Friends
How to create backup of data in Sql Server?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Kunal NaikPosted Nov 25, 2011, 12:54 AM
You can also try this,
sp_addumpdevice 'disk',
'yourDBname',
'd:\backups\filename.bak'
Pravin MorePosted Nov 24, 2011, 11:34 PM
hi Akshay,
here is process of backup through GUI.... Click Here
and below is by query.....
BACKUP DATABASE TO DISK = 'C:\DBBackup\FileName.bak'
Thanks,
Pravin.