EM VS TSQL

We are using SQL 2000
Please tell me that is it not recommended to use Enterprise manager for all
operations?
Is it OK if i use EM for all backup , restore & Maintenance Plan?
Could you please provide me the TSQL for Backup , Restore & Maintenance
Plan.
Thanking you in anticipation
regardsSee if this helps:
http://vyaskn.tripod.com/sql_enterprise_manager_or_t-sql.htm
Also check the BACKUP and RESTORE commands in SQL Server Books Online.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"uppal" <compaq@.smil.co.in> wrote in message
news:eZItzydpEHA.1992@.TK2MSFTNGP09.phx.gbl...
We are using SQL 2000
Please tell me that is it not recommended to use Enterprise manager for all
operations?
Is it OK if i use EM for all backup , restore & Maintenance Plan?
Could you please provide me the TSQL for Backup , Restore & Maintenance
Plan.
Thanking you in anticipation
regards|||On Wed, 29 Sep 2004 10:02:55 +0530, uppal wrote:
>Please tell me that is it not recommended to use Enterprise manager for all
>operations?
Hi Uppal,
On the contrary. EM is very suitable for *SOME* operations. Just don't use
EM for creation of tables, views, procuderes and functions or for changing
data in your tables. Using EM to manage your SQL Server installation is
okay.
>Is it OK if i use EM for all backup , restore & Maintenance Plan?
That's one of the operations that EM excels in.
>Could you please provide me the TSQL for Backup , Restore & Maintenance
>Plan.
I have no idea. If you really need to know it, you should either look in
Books Online or you could run a trace to find out which commands are
executed when you execute these operations through EM.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||"uppal" <compaq@.smil.co.in> wrote in message
news:eZItzydpEHA.1992@.TK2MSFTNGP09.phx.gbl...
> We are using SQL 2000
> Please tell me that is it not recommended to use Enterprise manager for
all
> operations?
> Is it OK if i use EM for all backup , restore & Maintenance Plan?
>
Control.
It all comes down to how much control you want.
> Could you please provide me the TSQL for Backup , Restore & Maintenance
> Plan.
> Thanking you in anticipation
> regards
>