SQL Server - SQL Server Database Backup Restore through query

Restoring database backup through query:

----Make Database to single user Mode
ALTER DATABASE SVCBK.bak
SET SINGLE_USER WITH
ROLLBACK IMMEDIATE

----Restore Database
RESTORE DATABASE YourDB
FROM DISK = 'D:\SVCBK.bak'
WITH MOVE 'YourMDFLogicalName' TO 'D:\SVCBK.mdf',
MOVE 'YourLDFLogicalName' TO 'D:\SVCBK.LOG'

/*If there is no error in statement before database will be in multiuser
mode.
If error occurs please execute following command it will convert
database in multi user.*/
ALTER DATABASE YourDB SET MULTI_USER
GO


Thanks,

u can take back up by query as follows

Transact-SQL commands executed from SQL Query Analyzer. An example of such a command is illustrated below.

BACKUP DATABASE northwind 
TO DISK = 'd:\backups\northwind\nwind.bak'

using Transact-SQL commands. Assuming that the database backup file name is c:\backups\northwind\nwind.bak, the following command will restore the database to nwind_new:
RESTORE DATABASE nwind_new FROM DISK = 'c:\backups\northwind\nwind.bak'
WITH
MOVE 'northwind' TO 'd:\Program Files\Microsoft SQL 
Server\Data\nwind_new.mdf'
MOVE 'northwind_log' TO 'd:\Program Files\Microsoft SQL
Server\Data\nwind_new_log.ldf'
http://technet.microsoft.com/en-us/library/cc966495.aspx

ALTER DATABASE YourDB
SET SINGLE_USER WITH
ROLLBACK IMMEDIATE

RESTORE DATABASE YourDB
FROM DISK = 'D:SVCBK.bak'
WITH MOVE 'SVCBK' TO 'D:SVCBK.mdf',
MOVE 'SVCBK' TO 'D:SVCBK.mdf'


Thank you