Prev: Enforce Password Policy and Expiration. When?
Next: Using row_number() in Recurcive CTE
From: shapper on 16 Jun 2010 09:10
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
From: Scott Morris on 16 Jun 2010 09:37
"shapper" <mdmoura(a)gmail.com> wrote in message
news:04975680-ba45-4b3e-af33-26ce24bccbf3(a)e5g2000yqn.googlegroups.com...
> 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.


 | 
Pages: 1
Prev: Enforce Password Policy and Expiration. When?
Next: Using row_number() in Recurcive CTE