sql reports: February 2012

Saturday, February 25, 2012

Can SQL 2005 Backup to a different file name each night?

In SQL 2000, I could use the DB Maint Wizard to create a backup that created
a new backup file each night. This basic feature does not appear to be an
option in SQL 2005. Is there some workaround? Anyone know if this will be
part of SP01?
I have hundreds of systems that have 4 5GB databases where we do full
backups every night. I do NOT want to append the previous nights backup to
the existing file, and I do NOT want to overwrite last nights backup because
I don't want to be without a backup if tonight's backup fails.
All suggestions are welcome, but I need a very simple way to set this up on
hundreds of systems by non-computer literate people.
Rob KraftNever mind group. I cannot recreate the problem I had. Originally in
testing, all of the backups were appending to the same date/time stamped
filename. I set up a new plan and it seems to work as desired - creating a
new file each time the backup runs. I have to manually add a cleanup task
to the DB Maint Plan created by the wizard to delete old DB files, but I've
got that figured out too.
Rob Kraft
"Rob Kraft" <robkraft@.msn.com> wrote in message
news:%23nhHf4%23VGHA.3284@.TK2MSFTNGP09.phx.gbl...
> In SQL 2000, I could use the DB Maint Wizard to create a backup that
> created a new backup file each night. This basic feature does not appear
> to be an option in SQL 2005. Is there some workaround? Anyone know if
> this will be part of SP01?
> I have hundreds of systems that have 4 5GB databases where we do full
> backups every night. I do NOT want to append the previous nights backup
> to the existing file, and I do NOT want to overwrite last nights backup
> because I don't want to be without a backup if tonight's backup fails.
> All suggestions are welcome, but I need a very simple way to set this up
> on hundreds of systems by non-computer literate people.
> Rob Kraft
>|||Rob,
How do you add the delete of the oldest file? I cannot seem to manage this
so far.
Thanks
Chris Wood
"Rob Kraft" <robkraft@.msn.com> wrote in message
news:e4R3FI$VGHA.4328@.TK2MSFTNGP12.phx.gbl...
> Never mind group. I cannot recreate the problem I had. Originally in
> testing, all of the backups were appending to the same date/time stamped
> filename. I set up a new plan and it seems to work as desired - creating
> a new file each time the backup runs. I have to manually add a cleanup
> task to the DB Maint Plan created by the wizard to delete old DB files,
> but I've got that figured out too.
> Rob Kraft
> "Rob Kraft" <robkraft@.msn.com> wrote in message
> news:%23nhHf4%23VGHA.3284@.TK2MSFTNGP09.phx.gbl...
>> In SQL 2000, I could use the DB Maint Wizard to create a backup that
>> created a new backup file each night. This basic feature does not appear
>> to be an option in SQL 2005. Is there some workaround? Anyone know if
>> this will be part of SP01?
>> I have hundreds of systems that have 4 5GB databases where we do full
>> backups every night. I do NOT want to append the previous nights backup
>> to the existing file, and I do NOT want to overwrite last nights backup
>> because I don't want to be without a backup if tonight's backup fails.
>> All suggestions are welcome, but I need a very simple way to set this up
>> on hundreds of systems by non-computer literate people.
>> Rob Kraft
>|||Look at maintenance cleanup task in Management plan.
Regards
Amish Shah|||Chris, I could not do this using the Maintenance Plan Wizard. Instead, after
creating the plan, right-click on the plan and select Modify. Then, on the
left hand side (probably) -drag a "Maintenance Cleanup Task" from the
Toolbox window into your plan (make sure you do NOT grab the "History
Cleanup Task"). Right-click on the "Maintenance Cleanup Task" and select
Edit. They you can specify to delete files in a specific folder that are
older than a n Weeks (or n Days). (and you can specify to delete files with
just a specific extension such as bak). Close that window then click on the
"Maintenance Cleanup Task" in the maintence plan and click and drag the
green arrow that appears down to the "Back Up Database Task" you just
created to cause the "Back Up Database Task" to execute after the file
delete.
Technically, I don't see a way using these tools to delete "the oldest
file"; but you can delete "all files over n days old".
Rob Kraft
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:exAKTW$VGHA.5076@.TK2MSFTNGP14.phx.gbl...
> Rob,
> How do you add the delete of the oldest file? I cannot seem to manage this
> so far.
> Thanks
> Chris Wood
> "Rob Kraft" <robkraft@.msn.com> wrote in message
> news:e4R3FI$VGHA.4328@.TK2MSFTNGP12.phx.gbl...
>> Never mind group. I cannot recreate the problem I had. Originally in
>> testing, all of the backups were appending to the same date/time stamped
>> filename. I set up a new plan and it seems to work as desired - creating
>> a new file each time the backup runs. I have to manually add a cleanup
>> task to the DB Maint Plan created by the wizard to delete old DB files,
>> but I've got that figured out too.
>> Rob Kraft
>> "Rob Kraft" <robkraft@.msn.com> wrote in message
>> news:%23nhHf4%23VGHA.3284@.TK2MSFTNGP09.phx.gbl...
>> In SQL 2000, I could use the DB Maint Wizard to create a backup that
>> created a new backup file each night. This basic feature does not
>> appear to be an option in SQL 2005. Is there some workaround? Anyone
>> know if this will be part of SP01?
>> I have hundreds of systems that have 4 5GB databases where we do full
>> backups every night. I do NOT want to append the previous nights backup
>> to the existing file, and I do NOT want to overwrite last nights backup
>> because I don't want to be without a backup if tonight's backup fails.
>> All suggestions are welcome, but I need a very simple way to set this up
>> on hundreds of systems by non-computer literate people.
>> Rob Kraft
>>
>|||Thank you Rob.
Works like a treat. Another 2005 nuance out of the way.
Chris
"Rob Kraft" <robkraft@.msn.com> wrote in message
news:e7ziF2XWGHA.1564@.TK2MSFTNGP03.phx.gbl...
> Chris, I could not do this using the Maintenance Plan Wizard. Instead,
> after creating the plan, right-click on the plan and select Modify. Then,
> on the left hand side (probably) -drag a "Maintenance Cleanup Task" from
> the Toolbox window into your plan (make sure you do NOT grab the "History
> Cleanup Task"). Right-click on the "Maintenance Cleanup Task" and select
> Edit. They you can specify to delete files in a specific folder that are
> older than a n Weeks (or n Days). (and you can specify to delete files
> with just a specific extension such as bak). Close that window then click
> on the "Maintenance Cleanup Task" in the maintence plan and click and drag
> the green arrow that appears down to the "Back Up Database Task" you just
> created to cause the "Back Up Database Task" to execute after the file
> delete.
> Technically, I don't see a way using these tools to delete "the oldest
> file"; but you can delete "all files over n days old".
> Rob Kraft
>
> "Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
> news:exAKTW$VGHA.5076@.TK2MSFTNGP14.phx.gbl...
>> Rob,
>> How do you add the delete of the oldest file? I cannot seem to manage
>> this so far.
>> Thanks
>> Chris Wood
>> "Rob Kraft" <robkraft@.msn.com> wrote in message
>> news:e4R3FI$VGHA.4328@.TK2MSFTNGP12.phx.gbl...
>> Never mind group. I cannot recreate the problem I had. Originally in
>> testing, all of the backups were appending to the same date/time stamped
>> filename. I set up a new plan and it seems to work as desired -
>> creating a new file each time the backup runs. I have to manually add a
>> cleanup task to the DB Maint Plan created by the wizard to delete old DB
>> files, but I've got that figured out too.
>> Rob Kraft
>> "Rob Kraft" <robkraft@.msn.com> wrote in message
>> news:%23nhHf4%23VGHA.3284@.TK2MSFTNGP09.phx.gbl...
>> In SQL 2000, I could use the DB Maint Wizard to create a backup that
>> created a new backup file each night. This basic feature does not
>> appear to be an option in SQL 2005. Is there some workaround? Anyone
>> know if this will be part of SP01?
>> I have hundreds of systems that have 4 5GB databases where we do full
>> backups every night. I do NOT want to append the previous nights
>> backup to the existing file, and I do NOT want to overwrite last nights
>> backup because I don't want to be without a backup if tonight's backup
>> fails.
>> All suggestions are welcome, but I need a very simple way to set this
>> up on hundreds of systems by non-computer literate people.
>> Rob Kraft
>>
>>
>|||See also the discussion in thread
http://forums.microsoft.com/MSDN/ShowPost.aspx?postid=111810&siteid=1
"Chris Wood" wrote:
> Thank you Rob.
> Works like a treat. Another 2005 nuance out of the way.
> Chris
> "Rob Kraft" <robkraft@.msn.com> wrote in message
> news:e7ziF2XWGHA.1564@.TK2MSFTNGP03.phx.gbl...
> > Chris, I could not do this using the Maintenance Plan Wizard. Instead,
> > after creating the plan, right-click on the plan and select Modify. Then,
> > on the left hand side (probably) -drag a "Maintenance Cleanup Task" from
> > the Toolbox window into your plan (make sure you do NOT grab the "History
> > Cleanup Task"). Right-click on the "Maintenance Cleanup Task" and select
> > Edit. They you can specify to delete files in a specific folder that are
> > older than a n Weeks (or n Days). (and you can specify to delete files
> > with just a specific extension such as bak). Close that window then click
> > on the "Maintenance Cleanup Task" in the maintence plan and click and drag
> > the green arrow that appears down to the "Back Up Database Task" you just
> > created to cause the "Back Up Database Task" to execute after the file
> > delete.
> >
> > Technically, I don't see a way using these tools to delete "the oldest
> > file"; but you can delete "all files over n days old".
> >
> > Rob Kraft
> >
> >
> > "Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
> > news:exAKTW$VGHA.5076@.TK2MSFTNGP14.phx.gbl...
> >> Rob,
> >>
> >> How do you add the delete of the oldest file? I cannot seem to manage
> >> this so far.
> >>
> >> Thanks
> >>
> >> Chris Wood
> >>
> >> "Rob Kraft" <robkraft@.msn.com> wrote in message
> >> news:e4R3FI$VGHA.4328@.TK2MSFTNGP12.phx.gbl...
> >> Never mind group. I cannot recreate the problem I had. Originally in
> >> testing, all of the backups were appending to the same date/time stamped
> >> filename. I set up a new plan and it seems to work as desired -
> >> creating a new file each time the backup runs. I have to manually add a
> >> cleanup task to the DB Maint Plan created by the wizard to delete old DB
> >> files, but I've got that figured out too.
> >>
> >> Rob Kraft
> >>
> >> "Rob Kraft" <robkraft@.msn.com> wrote in message
> >> news:%23nhHf4%23VGHA.3284@.TK2MSFTNGP09.phx.gbl...
> >> In SQL 2000, I could use the DB Maint Wizard to create a backup that
> >> created a new backup file each night. This basic feature does not
> >> appear to be an option in SQL 2005. Is there some workaround? Anyone
> >> know if this will be part of SP01?
> >> I have hundreds of systems that have 4 5GB databases where we do full
> >> backups every night. I do NOT want to append the previous nights
> >> backup to the existing file, and I do NOT want to overwrite last nights
> >> backup because I don't want to be without a backup if tonight's backup
> >> fails.
> >>
> >> All suggestions are welcome, but I need a very simple way to set this
> >> up on hundreds of systems by non-computer literate people.
> >>
> >> Rob Kraft
> >>
> >>
> >>
> >>
> >>
> >
> >
>
>

Can SQL 2005 Backup to a different file name each night?

Can SQL 2005 and SQL Express 2005 work on one machine?

Can SQL 2005 developer edition and SQL Express 2005 work on one machine?

Yep, sure can. I have SQL Server 2000, SQL Server 2005 Dev Edition, and SQL Express all running on this machine. You can have multiple instances installed and running.

Don

|||

Thank you!

Just installed the express edition on top of the developer edition. - No problem so far.

Can SQL 2005 already be used ?

Hi,
Maybe this is a silly question, but can SQL 2005 already be used for
customers?
We have some new customer-projects for which we have to write our own data
extensions for webservices and xml in Reporting Services 2000 while it's a
standard Rep srv 2005!
Can we start with 2005 even though the official release date is November
7th?
Please say yes ;-)
Kind regards,
Jeroen dbNo.
http://www.microsoft.com/sql/2005/productinfo/ctp.mspx
"SQL Server June 2005 Community Technology Preview (CTP) is the first
version of SQL Server 2005 made available for general testing. Previous
versions have been available only to customers enrolled in the SQL Server
2005 beta program or those with an MSDN subscription. Please note that you
cannot deploy SQL Server June 2005 Community Technology Preview in
production environments"
And license.txt that ships with the setup:
" (a) Microsoft grants to Recipient a limited, non-exclusive,
nontransferable, royalty-free license to install and use up to twenty-five
(25) total copies of the executable code of the Software on computers,
including servers, workstations, terminals or other digital electronic
devices residing on Recipient's premises, solely for purposes of testing
software programs that run in conjunction with the Software, and to evaluate
the Software for the purpose of providing feedback thereon to Microsoft.
Due to the nature of the development work, Microsoft provides no assurance
that any specific errors or discrepancies in the Software will be
corrected."
" (f) Recipient may not use the Software in a live operating environment
where it may be relied upon to perform in the same manner as a commercially
released product. The default installation configuration in this
pre-release version of the Software does not necessarily reflect which
features will be enabled in the commercially released version based on final
trustworthy computing analysis. Recipient must take adequate precautionary
measures to back up and protect its data prior to installing the Software."
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jeroen De Brabander" <Jeroen.De.Brabander@.edan.be> wrote in message
news:%23HhM83gbFHA.2968@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Maybe this is a silly question, but can SQL 2005 already be used for
> customers?
> We have some new customer-projects for which we have to write our own data
> extensions for webservices and xml in Reporting Services 2000 while it's a
> standard Rep srv 2005!
> Can we start with 2005 even though the official release date is November
> 7th?
> Please say yes ;-)
> Kind regards,
> Jeroen db
>|||Mike is correct unless for a specific customer they contact MS and get on
the Ascend program. This is the program for early adopters which MS
encourages but also reminds you that support is limited to nonexistent.
Danny
"Jeroen De Brabander" <Jeroen.De.Brabander@.edan.be> wrote in message
news:%23HhM83gbFHA.2968@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Maybe this is a silly question, but can SQL 2005 already be used for
> customers?
> We have some new customer-projects for which we have to write our own data
> extensions for webservices and xml in Reporting Services 2000 while it's a
> standard Rep srv 2005!
> Can we start with 2005 even though the official release date is November
> 7th?
> Please say yes ;-)
> Kind regards,
> Jeroen db
>

Can SQL 2005 already be used ?

Hi,
Maybe this is a silly question, but can SQL 2005 already be used for
customers?
We have some new customer-projects for which we have to write our own data
extensions for webservices and xml in Reporting Services 2000 while it's a
standard Rep srv 2005!
Can we start with 2005 even though the official release date is November
7th?
Please say yes ;-)
Kind regards,
Jeroen db
No.
http://www.microsoft.com/sql/2005/productinfo/ctp.mspx
"SQL Server June 2005 Community Technology Preview (CTP) is the first
version of SQL Server 2005 made available for general testing. Previous
versions have been available only to customers enrolled in the SQL Server
2005 beta program or those with an MSDN subscription. Please note that you
cannot deploy SQL Server June 2005 Community Technology Preview in
production environments"
And license.txt that ships with the setup:
" (a) Microsoft grants to Recipient a limited, non-exclusive,
nontransferable, royalty-free license to install and use up to twenty-five
(25) total copies of the executable code of the Software on computers,
including servers, workstations, terminals or other digital electronic
devices residing on Recipient's premises, solely for purposes of testing
software programs that run in conjunction with the Software, and to evaluate
the Software for the purpose of providing feedback thereon to Microsoft.
Due to the nature of the development work, Microsoft provides no assurance
that any specific errors or discrepancies in the Software will be
corrected."
" (f) Recipient may not use the Software in a live operating environment
where it may be relied upon to perform in the same manner as a commercially
released product. The default installation configuration in this
pre-release version of the Software does not necessarily reflect which
features will be enabled in the commercially released version based on final
trustworthy computing analysis. Recipient must take adequate precautionary
measures to back up and protect its data prior to installing the Software."
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jeroen De Brabander" <Jeroen.De.Brabander@.edan.be> wrote in message
news:%23HhM83gbFHA.2968@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Maybe this is a silly question, but can SQL 2005 already be used for
> customers?
> We have some new customer-projects for which we have to write our own data
> extensions for webservices and xml in Reporting Services 2000 while it's a
> standard Rep srv 2005!
> Can we start with 2005 even though the official release date is November
> 7th?
> Please say yes ;-)
> Kind regards,
> Jeroen db
>
|||Mike is correct unless for a specific customer they contact MS and get on
the Ascend program. This is the program for early adopters which MS
encourages but also reminds you that support is limited to nonexistent.
Danny
"Jeroen De Brabander" <Jeroen.De.Brabander@.edan.be> wrote in message
news:%23HhM83gbFHA.2968@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Maybe this is a silly question, but can SQL 2005 already be used for
> customers?
> We have some new customer-projects for which we have to write our own data
> extensions for webservices and xml in Reporting Services 2000 while it's a
> standard Rep srv 2005!
> Can we start with 2005 even though the official release date is November
> 7th?
> Please say yes ;-)
> Kind regards,
> Jeroen db
>

Can SQL 2005 already be used ?

Can SQL 2000 upgrade to SQL 2005 CTP June directly?

Hi,
Can SQL 2000 upgrade to SQL 2005 CTP June directly?
I have stop the services of SQL Server, AS Server and Agnet and during the
Existing components page,
SQL Server Database Services 8.00.761 and Analysis Services 8.0.760.0 is
disable can't select.
How should I do?
Thanks!
Angi
Hi,
After reading the Online Book of April and June and found...
1. April Edition: SQL Server 2K Sp3 can't upgrade to 2005
2. June Edition: SQL Server 2K Sp3 can upgrade to 2005
3. SQL Server 2000 Workgroup Edition (SP3a) can upgrade on June edition but
can't on April
So, it seems that SQL Server 2000 Sp3a Enterprise Edition can't upgrade to
2005 June Edition, right?
Angi
"Angi" <enchiw@.msn.com> glsD:%237$iLt6eFHA.2928@.TK2MSFTNGP10.phx .gbl...
> Hi,
> Can SQL 2000 upgrade to SQL 2005 CTP June directly?
> I have stop the services of SQL Server, AS Server and Agnet and during the
> Existing components page,
> SQL Server Database Services 8.00.761 and Analysis Services 8.0.760.0 is
> disable can't select.
> How should I do?
> Thanks!
> Angi
>

Can SQL 2000 upgrade to SQL 2005 CTP June directly?

Hi,
Can SQL 2000 upgrade to SQL 2005 CTP June directly?
I have stop the services of SQL Server, AS Server and Agnet and during the
Existing components page,
SQL Server Database Services 8.00.761 and Analysis Services 8.0.760.0 is
disable can't select.
How should I do?
Thanks!
AngiHi,
After reading the Online Book of April and June and found...
1. April Edition: SQL Server 2K Sp3 can't upgrade to 2005
2. June Edition: SQL Server 2K Sp3 can upgrade to 2005
3. SQL Server 2000 Workgroup Edition (SP3a) can upgrade on June edition but
can't on April
So, it seems that SQL Server 2000 Sp3a Enterprise Edition can't upgrade to
2005 June Edition, right?
Angi
"Angi" <enchiw@.msn.com> ¼¶¼g©ó¶l¥ó·s»D:%237$iLt6eFHA.2928@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Can SQL 2000 upgrade to SQL 2005 CTP June directly?
> I have stop the services of SQL Server, AS Server and Agnet and during the
> Existing components page,
> SQL Server Database Services 8.00.761 and Analysis Services 8.0.760.0 is
> disable can't select.
> How should I do?
> Thanks!
> Angi
>

Can SQL 2000 upgrade to SQL 2005 CTP June directly?

Hi,
Can SQL 2000 upgrade to SQL 2005 CTP June directly?
I have stop the services of SQL Server, AS Server and Agnet and during the
Existing components page,
SQL Server Database Services 8.00.761 and Analysis Services 8.0.760.0 is
disable can't select.
How should I do?
Thanks!
AngiHi,
After reading the Online Book of April and June and found...
1. April Edition: SQL Server 2K Sp3 can't upgrade to 2005
2. June Edition: SQL Server 2K Sp3 can upgrade to 2005
3. SQL Server 2000 Workgroup Edition (SP3a) can upgrade on June edition but
can't on April
So, it seems that SQL Server 2000 Sp3a Enterprise Edition can't upgrade to
2005 June Edition, right?
Angi
"Angi" <enchiw@.msn.com> glsD:%237$iLt6eFHA.2928@.TK2MSFTNGP10.phx.gbl...reen">
> Hi,
> Can SQL 2000 upgrade to SQL 2005 CTP June directly?
> I have stop the services of SQL Server, AS Server and Agnet and during the
> Existing components page,
> SQL Server Database Services 8.00.761 and Analysis Services 8.0.760.0 is
> disable can't select.
> How should I do?
> Thanks!
> Angi
>

can SQL 2000 still be used after the upgrade?

Hello:
Let's say that you have SQL Server 2000 SP3 on a server, and let's say that
you upgrade SQL 2000 to 2005.
It's a long story as to why I ask, but is it possible after the upgrade to
utilize SQL 2000 still? Or, after you perform such an upgrade, should you
stay away from SQL 2000?
Can SQL 2000 and SQL 2005 co-exist on the same server like this? Or, is SQL
2000 "dead" after such an upgrade?
Generally, after I upgrade a product of any kind, I don't mess with the
older product afterward. That's why I ask.
Thanks!
childofthe1980sYou can have both SQL 2000 and SQL 2005 on the same box, but SQL 2000 must
be installed before SQL 2005. In your case, you upgraded, so there is only
one instance of SQL Server on your machine.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:A185952C-BB25-44E9-B5B9-00C3B5E0C2C6@.microsoft.com...
Hello:
Let's say that you have SQL Server 2000 SP3 on a server, and let's say that
you upgrade SQL 2000 to 2005.
It's a long story as to why I ask, but is it possible after the upgrade to
utilize SQL 2000 still? Or, after you perform such an upgrade, should you
stay away from SQL 2000?
Can SQL 2000 and SQL 2005 co-exist on the same server like this? Or, is SQL
2000 "dead" after such an upgrade?
Generally, after I upgrade a product of any kind, I don't mess with the
older product afterward. That's why I ask.
Thanks!
childofthe1980s

can SQL 2000 still be used after the upgrade?

Hello:
Let's say that you have SQL Server 2000 SP3 on a server, and let's say that
you upgrade SQL 2000 to 2005.
It's a long story as to why I ask, but is it possible after the upgrade to
utilize SQL 2000 still? Or, after you perform such an upgrade, should you
stay away from SQL 2000?
Can SQL 2000 and SQL 2005 co-exist on the same server like this? Or, is SQL
2000 "dead" after such an upgrade?
Generally, after I upgrade a product of any kind, I don't mess with the
older product afterward. That's why I ask.
Thanks!
childofthe1980s
You can have both SQL 2000 and SQL 2005 on the same box, but SQL 2000 must
be installed before SQL 2005. In your case, you upgraded, so there is only
one instance of SQL Server on your machine.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:A185952C-BB25-44E9-B5B9-00C3B5E0C2C6@.microsoft.com...
Hello:
Let's say that you have SQL Server 2000 SP3 on a server, and let's say that
you upgrade SQL 2000 to 2005.
It's a long story as to why I ask, but is it possible after the upgrade to
utilize SQL 2000 still? Or, after you perform such an upgrade, should you
stay away from SQL 2000?
Can SQL 2000 and SQL 2005 co-exist on the same server like this? Or, is SQL
2000 "dead" after such an upgrade?
Generally, after I upgrade a product of any kind, I don't mess with the
older product afterward. That's why I ask.
Thanks!
childofthe1980s

can SQL 2000 still be used after the upgrade?

Hello:
Let's say that you have SQL Server 2000 SP3 on a server, and let's say that
you upgrade SQL 2000 to 2005.
It's a long story as to why I ask, but is it possible after the upgrade to
utilize SQL 2000 still? Or, after you perform such an upgrade, should you
stay away from SQL 2000?
Can SQL 2000 and SQL 2005 co-exist on the same server like this? Or, is SQL
2000 "dead" after such an upgrade?
Generally, after I upgrade a product of any kind, I don't mess with the
older product afterward. That's why I ask.
Thanks!
childofthe1980sYou can have both SQL 2000 and SQL 2005 on the same box, but SQL 2000 must
be installed before SQL 2005. In your case, you upgraded, so there is only
one instance of SQL Server on your machine.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:A185952C-BB25-44E9-B5B9-00C3B5E0C2C6@.microsoft.com...
Hello:
Let's say that you have SQL Server 2000 SP3 on a server, and let's say that
you upgrade SQL 2000 to 2005.
It's a long story as to why I ask, but is it possible after the upgrade to
utilize SQL 2000 still? Or, after you perform such an upgrade, should you
stay away from SQL 2000?
Can SQL 2000 and SQL 2005 co-exist on the same server like this? Or, is SQL
2000 "dead" after such an upgrade?
Generally, after I upgrade a product of any kind, I don't mess with the
older product afterward. That's why I ask.
Thanks!
childofthe1980s

Can SQL 2000 restore database and user login on another server?

Can SQL 2000 restore user login and database to another
domain and computer name? If it can't, how to export user
login to another computer?
You can migrate logins from one server to another server by generating a
script using a routine called sp_help_revlogin. Here is an article I wrote
about it:
http://databasejournal.com/features/...le.php/2228611
----
-
Need SQL Server Examples check out my website
http://www.geocities.com/sqlserverexamples
"Mesak" <anonymous@.discussions.microsoft.com> wrote in message
news:481301c49fe2$d7215e10$a401280a@.phx.gbl...
> Can SQL 2000 restore user login and database to another
> domain and computer name? If it can't, how to export user
> login to another computer?

Can SQL 2000 restore database and user login on another server?

Can SQL 2000 restore user login and database to another
domain and computer name? If it can't, how to export user
login to another computer?You can migrate logins from one server to another server by generating a
script using a routine called sp_help_revlogin. Here is an article I wrote
about it:
http://databasejournal.com/features/mssql/article.php/2228611
--
----
----
-
Need SQL Server Examples check out my website
http://www.geocities.com/sqlserverexamples
"Mesak" <anonymous@.discussions.microsoft.com> wrote in message
news:481301c49fe2$d7215e10$a401280a@.phx.gbl...
> Can SQL 2000 restore user login and database to another
> domain and computer name? If it can't, how to export user
> login to another computer?

can SQL 2000 evaluation install on XP

Hi ,
i am using sql server 2000 evaluation copy , can it be installed on XP
professional ?
rdgs
Which edition? Personal, standard or enterprise? Standard & Enterprise
must go on a server O/S. Personal edition can go on a workstation O/S
(XP Pro, Win 2000 pro, NT 4.0 Workstation). The Developer edition is
the same as the Enterprise edition except just licensed differently.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:

>Hi ,
> i am using sql server 2000 evaluation copy , can it be installed on XP
>professional ?
>rdgs
>
>
|||Which edition? Personal, standard or enterprise? Standard & Enterprise
must go on a server O/S. Personal edition can go on a workstation O/S
(XP Pro, Win 2000 pro, NT 4.0 Workstation). The Developer edition is
the same as the Enterprise edition except just licensed differently.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:

>Hi ,
> i am using sql server 2000 evaluation copy , can it be installed on XP
>professional ?
>rdgs
>
>
|||Which edition? Personal, standard or enterprise? Standard & Enterprise
must go on a server O/S. Personal edition can go on a workstation O/S
(XP Pro, Win 2000 pro, NT 4.0 Workstation). The Developer edition is
the same as the Enterprise edition except just licensed differently.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:

>Hi ,
> i am using sql server 2000 evaluation copy , can it be installed on XP
>professional ?
>rdgs
>
>
|||Sorry about the multi-posts. Thunderbird spat the dummy.
Mike Hodgson wrote:
[vbcol=seagreen]
> Which edition? Personal, standard or enterprise? Standard &
> Enterprise must go on a server O/S. Personal edition can go on a
> workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation). The
> Developer edition is the same as the Enterprise edition except just
> licensed differently.
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
> http://www.mallesons.com
>
> maxzsim wrote:
|||Hi Mike ,
i am using the evaluation copy of the Enterprise Edition
rdgs
"Mike Hodgson" wrote:

> Sorry about the multi-posts. Thunderbird spat the dummy.
>
> Mike Hodgson wrote:
>
|||You'd need one of the Windows NT Server, Window 2000 Server or Windows
2003 Server O/S families for Enterprise Edition (even if it is just an
eval - that just means it's time bombed for 120 days). For Windows XP
Pro you'll need the Personal Edition of SQL Server 2000.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:
[vbcol=seagreen]
>Hi Mike ,
> i am using the evaluation copy of the Enterprise Edition
>rdgs
>"Mike Hodgson" wrote:
>
|||Yes...the Enterprise Evaluation Edition is supported on XP
Pro. You can find the supported operating systems at:
http://msdn.microsoft.com/library/en...ar_ts_7eur.asp
-Sue
On Wed, 23 Feb 2005 19:11:02 -0800, "maxzsim"
<maxzsim@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Hi Mike ,
> i am using the evaluation copy of the Enterprise Edition
>rdgs
>"Mike Hodgson" wrote:
|||Hmmm...oops. Sorry 'bout my errata. :-[ I'm having a shocker
lately. Maybe I should take a break from the newsgroups for a while and
going back to playing chess.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Sue Hoegemeier wrote:

>Yes...the Enterprise Evaluation Edition is supported on XP
>Pro. You can find the supported operating systems at:
>http://msdn.microsoft.com/library/en...ar_ts_7eur.asp
>-Sue
>On Wed, 23 Feb 2005 19:11:02 -0800, "maxzsim"
> <maxzsim@.discussions.microsoft.com> wrote:
>
>
>
|||thks everyone for the help given
"Mike Hodgson" wrote:

> Hmmm...oops. Sorry 'bout my errata. :-[ I'm having a shocker
> lately. Maybe I should take a break from the newsgroups for a while and
> going back to playing chess.
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
>
> Sue Hoegemeier wrote:
>

can SQL 2000 evaluation install on XP

Hi ,
i am using sql server 2000 evaluation copy , can it be installed on XP
professional ?
rdgsThis is a multi-part message in MIME format.
--020107020505020303050800
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Which edition? Personal, standard or enterprise? Standard & Enterprise
must go on a server O/S. Personal edition can go on a workstation O/S
(XP Pro, Win 2000 pro, NT 4.0 Workstation). The Developer edition is
the same as the Enterprise edition except just licensed differently.
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:
>Hi ,
> i am using sql server 2000 evaluation copy , can it be installed on XP
>professional ?
>rdgs
>
>
--020107020505020303050800
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Which edition?Â Personal, standard or enterprise?Â Standard &
Enterprise must go on a server O/S.Â Personal edition can go on a
workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation).Â The
Developer edition is the same as the Enterprise edition except just
licensed differently.</tt> 
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
-- 
 mike
hodgson | database administrator
| mallesons stephen jaques 
T +61 (2) 9296 3668 | F +61
(2) 9296 3885 | M +61
(408) 675 907 
E
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> | W <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a> 
</div>
 
 
maxzsim wrote:
<blockquote cite="midE0C7A008-8152-49CF-888B-F3CB9A87E7F8@.microsoft.com"
type="cite">
<pre wrap="">Hi ,
i am using sql server 2000 evaluation copy , can it be installed on XP
professional ?
rdgs
</pre>
</blockquote>
</body>
</html>
--020107020505020303050800--|||This is a multi-part message in MIME format.
--020009090209050906080707
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Which edition? Personal, standard or enterprise? Standard & Enterprise
must go on a server O/S. Personal edition can go on a workstation O/S
(XP Pro, Win 2000 pro, NT 4.0 Workstation). The Developer edition is
the same as the Enterprise edition except just licensed differently.
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:
>Hi ,
> i am using sql server 2000 evaluation copy , can it be installed on XP
>professional ?
>rdgs
>
>
--020009090209050906080707
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Which edition?Â Personal, standard or enterprise?Â Standard &
Enterprise must go on a server O/S.Â Personal edition can go on a
workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation).Â The
Developer edition is the same as the Enterprise edition except just
licensed differently.</tt> 
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
-- 
 mike
hodgson | database administrator
| mallesons stephen jaques 
T +61 (2) 9296 3668 | F +61
(2) 9296 3885 | M +61
(408) 675 907 
E
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">mailto:mike.hodgson@.mallesons.nospam.com</a>
| W <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a> 
</div>
 
 
maxzsim wrote:
<blockquote cite="midE0C7A008-8152-49CF-888B-F3CB9A87E7F8@.microsoft.com"
type="cite">
<pre wrap="">Hi ,
i am using sql server 2000 evaluation copy , can it be installed on XP
professional ?
rdgs
</pre>
</blockquote>
</body>
</html>
--020009090209050906080707--|||This is a multi-part message in MIME format.
--090003090205020301090702
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Which edition? Personal, standard or enterprise? Standard & Enterprise
must go on a server O/S. Personal edition can go on a workstation O/S
(XP Pro, Win 2000 pro, NT 4.0 Workstation). The Developer edition is
the same as the Enterprise edition except just licensed differently.
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:
>Hi ,
> i am using sql server 2000 evaluation copy , can it be installed on XP
>professional ?
>rdgs
>
>
--090003090205020301090702
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Which edition?Â Personal, standard or enterprise?Â Standard &
Enterprise must go on a server O/S.Â Personal edition can go on a
workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation).Â The
Developer edition is the same as the Enterprise edition except just
licensed differently.</tt> 
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
-- 
 mike
hodgson | database administrator
| mallesons stephen jaques 
T +61 (2) 9296 3668 | F +61
(2) 9296 3885 | M +61
(408) 675 907 
E
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">mailto:mike.hodgson@.mallesons.nospam.com</a>
| W <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a> 
</div>
 
 
maxzsim wrote:
<blockquote cite="midE0C7A008-8152-49CF-888B-F3CB9A87E7F8@.microsoft.com"
type="cite">
<pre wrap="">Hi ,
i am using sql server 2000 evaluation copy , can it be installed on XP
professional ?
rdgs
</pre>
</blockquote>
</body>
</html>
--090003090205020301090702--|||This is a multi-part message in MIME format.
--000409060207070309090809
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Sorry about the multi-posts. Thunderbird spat the dummy.
Mike Hodgson wrote:
> Which edition? Personal, standard or enterprise? Standard &
> Enterprise must go on a server O/S. Personal edition can go on a
> workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation). The
> Developer edition is the same as the Enterprise edition except just
> licensed differently.
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
> http://www.mallesons.com
>
> maxzsim wrote:
>>Hi ,
>> i am using sql server 2000 evaluation copy , can it be installed on XP
>>professional ?
>>rdgs
>>
>>
--000409060207070309090809
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Sorry about the multi-posts.Â Thunderbird spat the dummy.</tt> 
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
</div>
 
 
 
Mike Hodgson wrote:
<blockquote cite="mid421D4005.3080803@.mallesons.nospam.com" type="cite">
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
<tt>Which edition?Â Personal, standard or enterprise?Â Standard &
Enterprise must go on a server O/S.Â Personal edition can go on a
workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation).Â The
Developer edition is the same as the Enterprise edition except just
licensed differently.</tt> 
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
-- 
 mike
hodgson | database administrator
| mallesons stephen jaques 
T +61 (2) 9296 3668 | F +61
(2) 9296 3885 | M +61
(408) 675 907 
E
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">mailto:mike.hodgson@.mallesons.nospam.com</a>
| W <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a> 
</div>
 
 
maxzsim wrote:
<blockquote
cite="midE0C7A008-8152-49CF-888B-F3CB9A87E7F8@.microsoft.com"
type="cite">
<pre wrap="">Hi ,
i am using sql server 2000 evaluation copy , can it be installed on XP
professional ?
rdgs
</pre>
</blockquote>
</blockquote>
</body>
</html>
--000409060207070309090809--|||Hi Mike ,
i am using the evaluation copy of the Enterprise Edition
rdgs
"Mike Hodgson" wrote:
> Sorry about the multi-posts. Thunderbird spat the dummy.
>
> Mike Hodgson wrote:
> > Which edition? Personal, standard or enterprise? Standard &
> > Enterprise must go on a server O/S. Personal edition can go on a
> > workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation). The
> > Developer edition is the same as the Enterprise edition except just
> > licensed differently.
> >
> > --
> > *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> > *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> > *E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
> > http://www.mallesons.com
> >
> >
> >
> > maxzsim wrote:
> >
> >>Hi ,
> >>
> >> i am using sql server 2000 evaluation copy , can it be installed on XP
> >>professional ?
> >>
> >>rdgs
> >>
> >>
> >>
> >>
>|||This is a multi-part message in MIME format.
--060404050301060308050608
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
You'd need one of the Windows NT Server, Window 2000 Server or Windows
2003 Server O/S families for Enterprise Edition (even if it is just an
eval - that just means it's time bombed for 120 days). For Windows XP
Pro you'll need the Personal Edition of SQL Server 2000.
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:
>Hi Mike ,
> i am using the evaluation copy of the Enterprise Edition
>rdgs
>"Mike Hodgson" wrote:
>
>>Sorry about the multi-posts. Thunderbird spat the dummy.
>>
>>Mike Hodgson wrote:
>>
>>Which edition? Personal, standard or enterprise? Standard &
>>Enterprise must go on a server O/S. Personal edition can go on a
>>workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation). The
>>Developer edition is the same as the Enterprise edition except just
>>licensed differently.
>>--
>>*mike hodgson* |/ database administrator/ | mallesons stephen jaques
>>*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
>>*E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
>>http://www.mallesons.com
>>
>>maxzsim wrote:
>>
>>Hi ,
>> i am using sql server 2000 evaluation copy , can it be installed on XP
>>professional ?
>>rdgs
>>
>>
>>
--060404050301060308050608
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>You'd need one of the Windows NT Server, Window 2000 Server or
Windows 2003 Server O/S families for Enterprise Edition (even if it is
just an eval - that just means it's time bombed for 120 days).Â For
Windows XP Pro you'll need the Personal Edition of SQL Server 2000.</tt> 
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
-- 
 mike
hodgson | database administrator
| mallesons stephen jaques 
T +61 (2) 9296 3668 | F +61
(2) 9296 3885 | M +61
(408) 675 907 
E
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> | W <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a> 
</div>
 
 
maxzsim wrote:
<blockquote cite="mid1AFC65A9-8C8F-4F0B-ADF8-A7E78AD678BC@.microsoft.com"
type="cite">
<pre wrap="">Hi Mike ,
i am using the evaluation copy of the Enterprise Edition
rdgs
"Mike Hodgson" wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Sorry about the multi-posts. Thunderbird spat the dummy.
Mike Hodgson wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Which edition? Personal, standard or enterprise? Standard &
Enterprise must go on a server O/S. Personal edition can go on a
workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation). The
Developer edition is the same as the Enterprise edition except just
licensed differently.
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* <a class="moz-txt-link-freetext" href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">mailto:mike.hodgson@.mallesons.nospam.com</a> |* W*
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://www.mallesons.com</a>">http://www.mallesons.com">http://www.mallesons.com</a>
maxzsim wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hi ,
i am using sql server 2000 evaluation copy , can it be installed on XP
professional ?
rdgs
</pre>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
</body>
</html>
--060404050301060308050608--|||Yes...the Enterprise Evaluation Edition is supported on XP
Pro. You can find the supported operating systems at:
http://msdn.microsoft.com/library/en-us/architec/8_ar_ts_7eur.asp
-Sue
On Wed, 23 Feb 2005 19:11:02 -0800, "maxzsim"
<maxzsim@.discussions.microsoft.com> wrote:
>Hi Mike ,
> i am using the evaluation copy of the Enterprise Edition
>rdgs
>"Mike Hodgson" wrote:
>> Sorry about the multi-posts. Thunderbird spat the dummy.
>>
>> Mike Hodgson wrote:
>> > Which edition? Personal, standard or enterprise? Standard &
>> > Enterprise must go on a server O/S. Personal edition can go on a
>> > workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation). The
>> > Developer edition is the same as the Enterprise edition except just
>> > licensed differently.
>> >
>> > --
>> > *mike hodgson* |/ database administrator/ | mallesons stephen jaques
>> > *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
>> > *E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
>> > http://www.mallesons.com
>> >
>> >
>> >
>> > maxzsim wrote:
>> >
>> >>Hi ,
>> >>
>> >> i am using sql server 2000 evaluation copy , can it be installed on XP
>> >>professional ?
>> >>
>> >>rdgs
>> >>
>> >>
>> >>
>> >>|||This is a multi-part message in MIME format.
--030203010807050905000109
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Hmmm...oops. Sorry 'bout my errata. :-[ I'm having a shocker
lately. Maybe I should take a break from the newsgroups for a while and
going back to playing chess.
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Sue Hoegemeier wrote:
>Yes...the Enterprise Evaluation Edition is supported on XP
>Pro. You can find the supported operating systems at:
>http://msdn.microsoft.com/library/en-us/architec/8_ar_ts_7eur.asp
>-Sue
>On Wed, 23 Feb 2005 19:11:02 -0800, "maxzsim"
> <maxzsim@.discussions.microsoft.com> wrote:
>
>>Hi Mike ,
>>i am using the evaluation copy of the Enterprise Edition
>>rdgs
>>"Mike Hodgson" wrote:
>>
>>Sorry about the multi-posts. Thunderbird spat the dummy.
>>
>>Mike Hodgson wrote:
>>
>>Which edition? Personal, standard or enterprise? Standard &
>>Enterprise must go on a server O/S. Personal edition can go on a
>>workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation). The
>>Developer edition is the same as the Enterprise edition except just
>>licensed differently.
>>--
>>*mike hodgson* |/ database administrator/ | mallesons stephen jaques
>>*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
>>*E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
>>http://www.mallesons.com
>>
>>maxzsim wrote:
>>
>>Hi ,
>> i am using sql server 2000 evaluation copy , can it be installed on XP
>>professional ?
>>rdgs
>>
>>
>>
>
>
--030203010807050905000109
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Hmmm...oops. Sorry 'bout my errata. 
:-[ I'm having a shocker lately. Maybe I should
take a break from the newsgroups for a while and going back to playing
chess.</tt> 
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
-- 
 mike
hodgson | database administrator
| mallesons stephen jaques 
T +61 (2) 9296 3668 | F +61
(2) 9296 3885 | M +61
(408) 675 907 
E
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> | W <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a> 
</div>
 
 
Sue Hoegemeier wrote:
<blockquote cite="midalkq11h6gpb048hoi2rum3otilivp4ci8q@.4ax.com"
type="cite">
<pre wrap="">Yes...the Enterprise Evaluation Edition is supported on XP
Pro. You can find the supported operating systems at:
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://msdn.microsoft.com/library/en-us/architec/8_ar_ts_7eur.asp</a>">http://msdn.microsoft.com/library/en-us/architec/8_ar_ts_7eur.asp">http://msdn.microsoft.com/library/en-us/architec/8_ar_ts_7eur.asp</a>
-Sue
On Wed, 23 Feb 2005 19:11:02 -0800, "maxzsim"
<a class="moz-txt-link-rfc2396E" href="http://links.10026.com/?link=mailto:maxzsim@.discussions.microsoft.com"><maxzsim@.discussions.microsoft.com></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hi Mike ,
i am using the evaluation copy of the Enterprise Edition
rdgs
"Mike Hodgson" wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Sorry about the multi-posts. Thunderbird spat the dummy.
Mike Hodgson wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Which edition? Personal, standard or enterprise? Standard &
Enterprise must go on a server O/S. Personal edition can go on a
workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation). The
Developer edition is the same as the Enterprise edition except just
licensed differently.
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* <a class="moz-txt-link-freetext" href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">mailto:mike.hodgson@.mallesons.nospam.com</a> |* W*
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://www.mallesons.com</a>">http://www.mallesons.com">http://www.mallesons.com</a>
maxzsim wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hi ,
i am using sql server 2000 evaluation copy , can it be installed on XP
professional ?
rdgs
</pre>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
<pre wrap=""><!-->
</pre>
</blockquote>
</body>
</html>
--030203010807050905000109--|||thks everyone for the help given
"Mike Hodgson" wrote:
> Hmmm...oops. Sorry 'bout my errata. :-[ I'm having a shocker
> lately. Maybe I should take a break from the newsgroups for a while and
> going back to playing chess.
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
>
> Sue Hoegemeier wrote:
> >Yes...the Enterprise Evaluation Edition is supported on XP
> >Pro. You can find the supported operating systems at:
> >http://msdn.microsoft.com/library/en-us/architec/8_ar_ts_7eur.asp
> >
> >-Sue
> >
> >On Wed, 23 Feb 2005 19:11:02 -0800, "maxzsim"
> > <maxzsim@.discussions.microsoft.com> wrote:
> >
> >
> >
> >>Hi Mike ,
> >>
> >>i am using the evaluation copy of the Enterprise Edition
> >>
> >>rdgs
> >>
> >>"Mike Hodgson" wrote:
> >>
> >>
> >>
> >>Sorry about the multi-posts. Thunderbird spat the dummy.
> >>
> >>
> >>
> >>Mike Hodgson wrote:
> >>
> >>
> >>
> >>Which edition? Personal, standard or enterprise? Standard &
> >>Enterprise must go on a server O/S. Personal edition can go on a
> >>workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation). The
> >>Developer edition is the same as the Enterprise edition except just
> >>licensed differently.
> >>
> >>--
> >>*mike hodgson* |/ database administrator/ | mallesons stephen jaques
> >>*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> >>*E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
> >>http://www.mallesons.com
> >>
> >>
> >>
> >>maxzsim wrote:
> >>
> >>
> >>
> >>Hi ,
> >>
> >> i am using sql server 2000 evaluation copy , can it be installed on XP
> >>professional ?
> >>
> >>rdgs
> >>
> >>
> >>
> >>
> >>
> >>
> >
> >
> >
>|||No problem Mike...we all have those moments. Don't worry
about it.
-Sue
On Thu, 24 Feb 2005 15:26:40 +1100, Mike Hodgson
<mike.hodgson@.mallesons.nospam.com> wrote:
>Hmmm...oops. Sorry 'bout my errata. :-[ I'm having a shocker
>lately. Maybe I should take a break from the newsgroups for a while and
>going back to playing chess.

can SQL 2000 evaluation install on XP

Hi ,
i am using sql server 2000 evaluation copy , can it be installed on XP
professional ?
rdgsWhich edition? Personal, standard or enterprise? Standard & Enterprise
must go on a server O/S. Personal edition can go on a workstation O/S
(XP Pro, Win 2000 pro, NT 4.0 Workstation). The Developer edition is
the same as the Enterprise edition except just licensed differently.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:

>Hi ,
> i am using sql server 2000 evaluation copy , can it be installed on XP
>professional ?
>rdgs
>
>|||Which edition? Personal, standard or enterprise? Standard & Enterprise
must go on a server O/S. Personal edition can go on a workstation O/S
(XP Pro, Win 2000 pro, NT 4.0 Workstation). The Developer edition is
the same as the Enterprise edition except just licensed differently.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:

>Hi ,
> i am using sql server 2000 evaluation copy , can it be installed on XP
>professional ?
>rdgs
>
>|||Which edition? Personal, standard or enterprise? Standard & Enterprise
must go on a server O/S. Personal edition can go on a workstation O/S
(XP Pro, Win 2000 pro, NT 4.0 Workstation). The Developer edition is
the same as the Enterprise edition except just licensed differently.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:

>Hi ,
> i am using sql server 2000 evaluation copy , can it be installed on XP
>professional ?
>rdgs
>
>|||Sorry about the multi-posts. Thunderbird spat the dummy.
Mike Hodgson wrote:
[vbcol=seagreen]
> Which edition? Personal, standard or enterprise? Standard &
> Enterprise must go on a server O/S. Personal edition can go on a
> workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation). The
> Developer edition is the same as the Enterprise edition except just
> licensed differently.
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
> http://www.mallesons.com
>
> maxzsim wrote:
>|||Hi Mike ,
i am using the evaluation copy of the Enterprise Edition
rdgs
"Mike Hodgson" wrote:

> Sorry about the multi-posts. Thunderbird spat the dummy.
>
> Mike Hodgson wrote:
>
>|||You'd need one of the Windows NT Server, Window 2000 Server or Windows
2003 Server O/S families for Enterprise Edition (even if it is just an
eval - that just means it's time bombed for 120 days). For Windows XP
Pro you'll need the Personal Edition of SQL Server 2000.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:
[vbcol=seagreen]
>Hi Mike ,
> i am using the evaluation copy of the Enterprise Edition
>rdgs
>"Mike Hodgson" wrote:
>
>|||Yes...the Enterprise Evaluation Edition is supported on XP
Pro. You can find the supported operating systems at:
http://msdn.microsoft.com/library/e..._ar_ts_7eur.asp
-Sue
On Wed, 23 Feb 2005 19:11:02 -0800, "maxzsim"
<maxzsim@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Hi Mike ,
> i am using the evaluation copy of the Enterprise Edition
>rdgs
>"Mike Hodgson" wrote:
>|||Hmmm...oops. Sorry 'bout my errata. :-[ I'm having a shocker
lately. Maybe I should take a break from the newsgroups for a while and
going back to playing chess.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Sue Hoegemeier wrote:

>Yes...the Enterprise Evaluation Edition is supported on XP
>Pro. You can find the supported operating systems at:
>http://msdn.microsoft.com/library/e..._ar_ts_7eur.asp
>-Sue
>On Wed, 23 Feb 2005 19:11:02 -0800, "maxzsim"
> <maxzsim@.discussions.microsoft.com> wrote:
>
>
>
>|||thks everyone for the help given
"Mike Hodgson" wrote:

> Hmmm...oops. Sorry 'bout my errata. :-[ I'm having a shocker
> lately. Maybe I should take a break from the newsgroups for a while and
> going back to playing chess.
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W* [url]http://www.mallesons.com[/url
]
>
> Sue Hoegemeier wrote:
>
>

Can SQL 2000 Enterprise Manager & SQL 2005 Mgnt Studio coexist ?

Hi,
I have SQL 2000 Client (Enterprise Manager, QA etc) installed on my PC. I
would like to install SQL 2005 native client (Mgnt Studio etc) on the same PC.
Can they be coexisted and both can be used ? OR
I have to uninstall 2000 client first.
Regards,
Johnny
Hello,
They can co-exist. Make sure you installl the software in seperate
directory.
Thanks
Hari
"Johnny" <Johnny@.discussions.microsoft.com> wrote in message
news:F553693B-19D1-4EA7-9EEC-062287EE1628@.microsoft.com...
> Hi,
> I have SQL 2000 Client (Enterprise Manager, QA etc) installed on my PC. I
> would like to install SQL 2005 native client (Mgnt Studio etc) on the same
> PC.
> Can they be coexisted and both can be used ? OR
> I have to uninstall 2000 client first.
> Regards,
> Johnny
|||Johnny (Johnny@.discussions.microsoft.com) writes:
> I have SQL 2000 Client (Enterprise Manager, QA etc) installed on my PC.
> I would like to install SQL 2005 native client (Mgnt Studio etc) on the
> same PC.
> Can they be coexisted and both can be used ? OR
> I have to uninstall 2000 client first.
They can co-exist as Hari said.
I just like to make a clafication: SQL Native Client is a single DLL
which contains an updated ODBC driver and an updated OLE DB provider
for SQL 2005. SQL Native is a redistributable component. SQL Native is
about the first which is installed when you run the SQL Server installation.
You are apparently thinking of the Workstation components, of which some
may use SQL Native Client, but far from all do. Management Studio, for
instance, uses SqlClient, a .Net provider. ("Native" in SQL Native Client
refers to that it is in native code, as opposed to the managed code of
..Net.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Can SQL 2000 and WID coexist

My question is can the new version of MSDE (Windows Internal Database or SQL Express) reside on the server along with SQL 2000 without causing problems? We cannot upgrade the SQL 2000 because of an older application that doesn't work with SQL 2005. Currently we run WSUS 2.0 using MSDE and have no problems.

See replies to your similar post in the Getting Started with SQL Server forum.

Often, the quality of the responses received is related to our ability to ‘bounce’ ideas off of each other. In the future, to make it easier for us to offer you assistance, and to prevent folks from wasting time on already answered questions, please don't post to multiple newsgroups. Choose the one that best fits your question and post there. Only post to another newsgroup if you get no answer in a day or two (or if you accidentally posted to the wrong newsgroup –and you indicate that you've already posted elsewhere).

Can Sql 2000 and Sql 2005 exist on same server?

My instructions are to install Sql 2005 on server BIGPETE2. I found that there was already an installation of Sql 2000, with databases that I was quite sure should remain as SQL 2000.

According to info I found on the internet, it should be possible to have separate instances of 2000 and 2005, so I went ahead and tried to install, giving the 2005 version a different name, BIGPETE2005. It didn't hit me with any error messages, but neither did it install a different database server. When I was finished, I was able to open Management Studio, but the only database server it could find to open was BIGPETE2, which is not what I wanted.

Enterprise Manager still works, and the mdf dates haven't updated, so I'm guessing the data is still safe, but I need both servers up and running.

Okay, I just read through the installation report, and I saw this:

Service pack requirement check:

Your upgrade is blocked because of service pack requirements. To proceed, apply the required service pack and then rerun SQL Server Setup. For more information about upgrade support, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

1. What service pack is it asking for?

2. And doesn't that imply that it's upgrading my Sql 2000 installation instead of installing a new instance of Sql 2005?

In Management Studio, you will be able to connect to both instances. To connect to your SQL 2005 instance, you'll need to supply machine name / instance name (ex: MACHINE/BIGPETE2005).

Thanks,
Sam Lester (MSFT)

|||How do you connect to both instances in SQL 2005? Can we have a step by step with screen shots? Are any other modules needed such as the backwards compatibility module?

Can Sql 2000 and 2005 express work together?

I have a server (win server 2003) that is running Symantec Backup Exec for backups. I found that this soft uses an SQL server 2000 instance to keep his data... The problem is that I developed an application in asp.net (with VS2003) that use an SQL server 2005 express database. What I want to know is if I install SQL server 2005 express, is the backup will still work? I mean that the 2005 express wont upgrade sql 2000? What do I have to do to make it works?

hi,

SQL Server 2000 (including MSDE) and SQL Server 2005 (including SQLExpress) cna be installed "side by side"...

you can install up to 16 different instances per box, and each instance will maintain it's own binaries and registry settings separated from all other instances.. even at different service pack levels..

obviously you have not to mismatch instance's names.. only 1 instance per box can be the "default" instance, known as "ComputerName" or "." or "(Local)" (the last 2 only for local connections), where all the other instances have to be "named" instances, known as "ComputerName\InstanceName" or ".\InstanceName" or "(Local)\InstanceName" ... further info at http://msdn2.microsoft.com/en-us/library/ms143547.aspx

a little "note" should be mentioned about shared components.. this binaries are actually shared among all instances of the same code base.. so all 2000 related shared binaries will be shared among all 2000 instances, where 2005 shared components will be shared with all 2005 instances, at the higher service pack level..

another "side note".. and this is COM related.. COM components do not allow "side by side" implementation, so that SQL Server 2005 installs some of them at the 2005 edition level.. and SQL Server 2000 will "inherit" those components.. think about SQL-DMO and the like, but you should not be interested with that as 2005 versions are downwards compatible...

regards

|||Thanks a lot!

Saturday, February 25, 2012

Can SQL 2005 Backup to a different file name each night?

Can SQL 2005 Backup to a different file name each night?

Can SQL 2005 Backup to a different file name each night?

Can SQL 2005 and SQL Express 2005 work on one machine?

Can SQL 2005 already be used ?

Can SQL 2005 already be used ?

Can SQL 2005 already be used ?

Can SQL 2000 upgrade to SQL 2005 CTP June directly?

Can SQL 2000 upgrade to SQL 2005 CTP June directly?

Can SQL 2000 upgrade to SQL 2005 CTP June directly?

can SQL 2000 still be used after the upgrade?

can SQL 2000 still be used after the upgrade?

can SQL 2000 still be used after the upgrade?

Can SQL 2000 restore database and user login on another server?

Can SQL 2000 restore database and user login on another server?

can SQL 2000 evaluation install on XP

can SQL 2000 evaluation install on XP

can SQL 2000 evaluation install on XP

Can SQL 2000 Enterprise Manager & SQL 2005 Mgnt Studio coexist ?

Can SQL 2000 and WID coexist

Can Sql 2000 and Sql 2005 exist on same server?

Can Sql 2000 and 2005 express work together?

sql reports

Blog Archive

About Me