Backup and Restore database using T-SQL

Hello,

Is it possible to backup and restore a database using T-SQL?

I need to backup the database, log and filegroup to a specific folder
and verify that everything is ok.

And later I would like to restore it.

I suppose I can't backup and restore the User, Login, Role, etc ...

Thank You,

Miguel

"shapper" wrote in message

> Hello,
>
> Is it possible to backup and restore a database using T-SQL?

Yes - you can read about the commands in the online help or on msdn.