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
regards
On Wed, 29 Sep 2004 10:03:24 +0530, uppal wrote:
Hi uppal,
Already answered in microsoft.public.sqlserver.server. Please post a
question to one newsgroup only. And if you really feel that you must post
to multiple groups, then at least use the cross-posting feature of your
newsreader.
http://www.aspfaq.com/etiquette.asp?id=5003
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)

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
regards
See if this helps:
http://vyaskn.tripod.com/sql_enterpr...r_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
>