Sql Server – Backup and Restore Database using SQL Script (T-SQL)

it is easy to take backup in sql server using script without any External tools.
By SIMPLE ways.. as follows...

use master

create database mydatabase

backup database mydatabase to disk ='c:\mybackup.bak'

Yeah,i can be easily restore by simple steps...

use master

restore database mydatabase from disk ='c:\mybackup.bak'

thats all..

1 comment:

Alex said...

Today I opened my SQL Server and saw that it is working badly.But I remembered about software which can help in like situations-sql server data recovery.And utility helped me quite easy and free of charge.Moreover application showed me how it can help with this problem and retrieve the data, that was considered to be lost.