Backup(s) using SQL Enterprise Manager

12 Sep 2006 7:39 PM

George G. Ioannides

Can someone please tell me the pros and cons of using SQL Enterprise Manager
2000 to do my backups of databases? then to use a third party program like
Veritas backup exec.

Looking forward to your response...

Thank you in advance.

George

13 Sep 2006 1:41 AM

Hari Prasad

Hi,

You could use the SQL Server native backup. Take a look into Backup database
/ Backup Log commands
in books online. Once you construct the backup script you could schedule the
script
using SQL Agent. For one time you could very well use enterprise manager to
backup the database.
There is no disadvantages in taking backup using Enterprise manager.

Thanks
Hari
SQL Server MVP

Show quote

"George G. Ioannides" <GeorgeGIoanni***@discussions.microsoft.com> wrote in
message news:BDE002C1-9633-4FEB-9ACA-3643E40239C5@microsoft.com...
> Can someone please tell me the pros and cons of using SQL Enterprise
> Manager
> 2000 to do my backups of databases? then to use a third party program like
> Veritas backup exec.
>
> Looking forward to your response...
>
> Thank you in advance.
>
> George
>
>

14 Sep 2006 8:46 AM

Hank Arnold

Pro:
1) It's free (assuming you paid for SQL). To backup with Veritas
(assuming you are using V9 or higher), you will need a license for an
agent that is installed on the SQL server ($$).....

Cons:
1) You still have to backup the backup file somewhere (to tape)

Regards,
Hank Arnold

George G. Ioannides wrote:
Show quote

> Can someone please tell me the pros and cons of using SQL Enterprise Manager
> 2000 to do my backups of databases? then to use a third party program like
> Veritas backup exec.
>
> Looking forward to your response...
>
> Thank you in advance.
>
> George
>
>

15 Sep 2006 7:28 PM

Keith Kratochvil

Hopefully you will schedule the backups to happen automatically.

By the way, you can also use Query Analyzer to perform the backup. All that
is required is passing the appropriate T-SQL statement to SQL Server.

Books Online has lots of good information regarding BACKUP and RESTORE.

--
Keith Kratochvil

Show quote

"George G. Ioannides" <GeorgeGIoanni***@discussions.microsoft.com> wrote in
message news:BDE002C1-9633-4FEB-9ACA-3643E40239C5@microsoft.com...
> Can someone please tell me the pros and cons of using SQL Enterprise
> Manager
> 2000 to do my backups of databases? then to use a third party program like
> Veritas backup exec.
>
> Looking forward to your response...
>
> Thank you in advance.
>
> George
>
>