difference between 2000 and 2005

Hello:

I noticed a difference between the use of SQL Tools for SQL 2000 and SQL
Management Studio for SQL 2005.

If you use SQL 2000 Tools on a workstation and you use Enterprise Manager to
backup a database that is sitting on a server, the backup file will reside on
your workstation.

But, if you use SQL 2005 Management Studio and you make a similar backup,
the backup will reside on the server.

Why this difference?

SQL Programmer (it's just a name)

I can't suggest an explanation because I just ran a test and, as
expected, the backup file was created on the server where SQL Server
2000 is running. If I had to make it go to the client I would have
had to specify a UNC path along the lines of:
\\clientsystem\sharename\folder\db.bak

Roy Harvey
Beacon Falls, CT

On Sun, 28 Sep 2008 13:27:00 -0700, SQL Programmer
wrote:

>Hello:
>
>I noticed a difference between the use of SQL Tools for SQL 2000 and SQL
>Management Studio for SQL 2005.
>
>If you use SQL 2000 Tools on a workstation and you use Enterprise Manager to
>backup a database that is sitting on a server, the backup file will reside on
>your workstation.
>
>But, if you use SQL 2005 Management Studio and you make a similar backup,
>the backup will reside on the server.
>
>Why this difference?
>
>SQL Programmer (it's just a name)