dbTalk Databases Forums  

difference between 2000 and 2005

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.tools difference between 2000 and 2005

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss difference between 2000 and 2005 in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
SQL Programmer
 
Posts: n/a

Default difference between 2000 and 2005 - 09-28-2008 , 03:27 PM





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)

Reply With Quote
  #2  
Old   
Roy Harvey (SQL Server MVP)
 
Posts: n/a

Default Re: difference between 2000 and 2005 - 09-28-2008 , 03:58 PM





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
<SQLProgrammer (AT) discussions (DOT) microsoft.com> wrote:

Quote:
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)

Reply With Quote
  #3  
Old   
Roy Harvey (SQL Server MVP)
 
Posts: n/a

Default Re: difference between 2000 and 2005 - 09-28-2008 , 03:58 PM


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
<SQLProgrammer (AT) discussions (DOT) microsoft.com> wrote:

Quote:
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)

Reply With Quote
  #4  
Old   
Roy Harvey (SQL Server MVP)
 
Posts: n/a

Default Re: difference between 2000 and 2005 - 09-28-2008 , 03:58 PM


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
<SQLProgrammer (AT) discussions (DOT) microsoft.com> wrote:

Quote:
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)

Reply With Quote
  #5  
Old   
Roy Harvey (SQL Server MVP)
 
Posts: n/a

Default Re: difference between 2000 and 2005 - 09-28-2008 , 03:58 PM


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
<SQLProgrammer (AT) discussions (DOT) microsoft.com> wrote:

Quote:
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)

Reply With Quote
  #6  
Old   
Roy Harvey (SQL Server MVP)
 
Posts: n/a

Default Re: difference between 2000 and 2005 - 09-28-2008 , 03:58 PM


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
<SQLProgrammer (AT) discussions (DOT) microsoft.com> wrote:

Quote:
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)

Reply With Quote
  #7  
Old   
Roy Harvey (SQL Server MVP)
 
Posts: n/a

Default Re: difference between 2000 and 2005 - 09-28-2008 , 03:58 PM


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
<SQLProgrammer (AT) discussions (DOT) microsoft.com> wrote:

Quote:
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)

Reply With Quote
  #8  
Old   
Roy Harvey (SQL Server MVP)
 
Posts: n/a

Default Re: difference between 2000 and 2005 - 09-28-2008 , 03:58 PM


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
<SQLProgrammer (AT) discussions (DOT) microsoft.com> wrote:

Quote:
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)

Reply With Quote
  #9  
Old   
Roy Harvey (SQL Server MVP)
 
Posts: n/a

Default Re: difference between 2000 and 2005 - 09-28-2008 , 03:58 PM


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
<SQLProgrammer (AT) discussions (DOT) microsoft.com> wrote:

Quote:
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)

Reply With Quote
  #10  
Old   
Roy Harvey (SQL Server MVP)
 
Posts: n/a

Default Re: difference between 2000 and 2005 - 09-28-2008 , 03:58 PM


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
<SQLProgrammer (AT) discussions (DOT) microsoft.com> wrote:

Quote:
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)

Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top