Hi,
How does one install MSSQL 2000 on a machine that's already running MSDE 2000? Do i need to unintstall MSDE, or both can be installed seperately??
Is there a way to simply upgrade MSDE into MSSQL 2000?
Thanks!Its easy to upgrade from MSDE to SQL Server, review information from books online from the topic 'How to perform an edition upgrade within SQL Server 2000'sql
Showing posts with label machine. Show all posts
Showing posts with label machine. Show all posts
Friday, March 30, 2012
MSSQL 2000 DB Migration to Microsoft SQL 2005
Hi,
We're building new machine Windows 2003 with MSSQL 2005 server.
We have current machine running Windows 2000 with MSSQL 2000.
How do we migrate the MSSQL2000 database to MSSQL 2005 server?
A) My way: inplace upgrade (i know this one will 99% work!)[vbcol=seagreen]
w/MSSQL2000[vbcol=seagreen]
B) Another way: backup the MSSQL DB from Windows2000 and restore to
Windows2005 with MSSQL2005? work?
C) Detach and attach the database from MSSQL2000 and attach to MSSQL2005 ?
work?
Any other way which will guarantee work best?
Thanks for any input!!
J.H
"J.H" <jpthsd@.hotmail.com> wrote in message
news:%239XXAO1aHHA.4616@.TK2MSFTNGP03.phx.gbl...
> Hi,
> We're building new machine Windows 2003 with MSSQL 2005 server.
> We have current machine running Windows 2000 with MSSQL 2000.
> How do we migrate the MSSQL2000 database to MSSQL 2005 server?
> A) My way: inplace upgrade (i know this one will 99% work!)
> w/MSSQL2000
> B) Another way: backup the MSSQL DB from Windows2000 and restore to
> Windows2005 with MSSQL2005? work?
This will work.
I would do this.
That way if something "goes wrong" you still have your original 2000 DB and
a backup.
However, no matter WHAT choice you make, make sure to to test your
application thoroughly.
There shouldn't be any gotchas, but you never know.
> C) Detach and attach the database from MSSQL2000 and attach to MSSQL2005 ?
> work?
>
> Any other way which will guarantee work best?
> Thanks for any input!!
> J.H
>
Greg Moore
SQL Server DBA Consulting
Email: sql (at) greenms.com http://www.greenms.com
|||I did attach/dettach for all my database. Now working wothout any problems.
Don't forget to change compatibility level to 9 after attaching database.
Ramunas
"J.H" <jpthsd@.hotmail.com> wrote in message
news:%239XXAO1aHHA.4616@.TK2MSFTNGP03.phx.gbl...
> Hi,
> We're building new machine Windows 2003 with MSSQL 2005 server.
> We have current machine running Windows 2000 with MSSQL 2000.
> How do we migrate the MSSQL2000 database to MSSQL 2005 server?
> A) My way: inplace upgrade (i know this one will 99% work!)
> w/MSSQL2000
> B) Another way: backup the MSSQL DB from Windows2000 and restore to
> Windows2005 with MSSQL2005? work?
> C) Detach and attach the database from MSSQL2000 and attach to MSSQL2005 ?
> work?
>
> Any other way which will guarantee work best?
> Thanks for any input!!
> J.H
>
sql
We're building new machine Windows 2003 with MSSQL 2005 server.
We have current machine running Windows 2000 with MSSQL 2000.
How do we migrate the MSSQL2000 database to MSSQL 2005 server?
A) My way: inplace upgrade (i know this one will 99% work!)[vbcol=seagreen]
w/MSSQL2000[vbcol=seagreen]
B) Another way: backup the MSSQL DB from Windows2000 and restore to
Windows2005 with MSSQL2005? work?
C) Detach and attach the database from MSSQL2000 and attach to MSSQL2005 ?
work?
Any other way which will guarantee work best?
Thanks for any input!!
J.H
"J.H" <jpthsd@.hotmail.com> wrote in message
news:%239XXAO1aHHA.4616@.TK2MSFTNGP03.phx.gbl...
> Hi,
> We're building new machine Windows 2003 with MSSQL 2005 server.
> We have current machine running Windows 2000 with MSSQL 2000.
> How do we migrate the MSSQL2000 database to MSSQL 2005 server?
> A) My way: inplace upgrade (i know this one will 99% work!)
> w/MSSQL2000
> B) Another way: backup the MSSQL DB from Windows2000 and restore to
> Windows2005 with MSSQL2005? work?
This will work.
I would do this.
That way if something "goes wrong" you still have your original 2000 DB and
a backup.
However, no matter WHAT choice you make, make sure to to test your
application thoroughly.
There shouldn't be any gotchas, but you never know.
> C) Detach and attach the database from MSSQL2000 and attach to MSSQL2005 ?
> work?
>
> Any other way which will guarantee work best?
> Thanks for any input!!
> J.H
>
Greg Moore
SQL Server DBA Consulting
Email: sql (at) greenms.com http://www.greenms.com
|||I did attach/dettach for all my database. Now working wothout any problems.
Don't forget to change compatibility level to 9 after attaching database.
Ramunas
"J.H" <jpthsd@.hotmail.com> wrote in message
news:%239XXAO1aHHA.4616@.TK2MSFTNGP03.phx.gbl...
> Hi,
> We're building new machine Windows 2003 with MSSQL 2005 server.
> We have current machine running Windows 2000 with MSSQL 2000.
> How do we migrate the MSSQL2000 database to MSSQL 2005 server?
> A) My way: inplace upgrade (i know this one will 99% work!)
> w/MSSQL2000
> B) Another way: backup the MSSQL DB from Windows2000 and restore to
> Windows2005 with MSSQL2005? work?
> C) Detach and attach the database from MSSQL2000 and attach to MSSQL2005 ?
> work?
>
> Any other way which will guarantee work best?
> Thanks for any input!!
> J.H
>
sql
MSSQL 2000 DB Migration to Microsoft SQL 2005
Hi,
We're building new machine Windows 2003 with MSSQL 2005 server.
We have current machine running Windows 2000 with MSSQL 2000.
How do we migrate the MSSQL2000 database to MSSQL 2005 server?
A) My way: inplace upgrade (i know this one will 99% work!)
>> installing new Windows 2003R2 with MSSQL2000 w/SP4
>> restore the MSSQL2000 database file to the new machine Windows2003R2
w/MSSQL2000
>> doing inplace upgrade on Windows2003R2 w/MSSQL2000 /wSP4 >> MSSQL2005
B) Another way: backup the MSSQL DB from Windows2000 and restore to
Windows2005 with MSSQL2005? work?
C) Detach and attach the database from MSSQL2000 and attach to MSSQL2005 ?
work?
Any other way which will guarantee work best?
Thanks for any input!!
J.H"J.H" <jpthsd@.hotmail.com> wrote in message
news:%239XXAO1aHHA.4616@.TK2MSFTNGP03.phx.gbl...
> Hi,
> We're building new machine Windows 2003 with MSSQL 2005 server.
> We have current machine running Windows 2000 with MSSQL 2000.
> How do we migrate the MSSQL2000 database to MSSQL 2005 server?
> A) My way: inplace upgrade (i know this one will 99% work!)
>> installing new Windows 2003R2 with MSSQL2000 w/SP4
>> restore the MSSQL2000 database file to the new machine Windows2003R2
> w/MSSQL2000
>> doing inplace upgrade on Windows2003R2 w/MSSQL2000 /wSP4 >> MSSQL2005
> B) Another way: backup the MSSQL DB from Windows2000 and restore to
> Windows2005 with MSSQL2005? work?
This will work.
I would do this.
That way if something "goes wrong" you still have your original 2000 DB and
a backup.
However, no matter WHAT choice you make, make sure to to test your
application thoroughly.
There shouldn't be any gotchas, but you never know.
> C) Detach and attach the database from MSSQL2000 and attach to MSSQL2005 ?
> work?
>
> Any other way which will guarantee work best?
> Thanks for any input!!
> J.H
>
Greg Moore
SQL Server DBA Consulting
Email: sql (at) greenms.com http://www.greenms.com|||I did attach/dettach for all my database. Now working wothout any problems.
Don't forget to change compatibility level to 9 after attaching database.
Ramunas
"J.H" <jpthsd@.hotmail.com> wrote in message
news:%239XXAO1aHHA.4616@.TK2MSFTNGP03.phx.gbl...
> Hi,
> We're building new machine Windows 2003 with MSSQL 2005 server.
> We have current machine running Windows 2000 with MSSQL 2000.
> How do we migrate the MSSQL2000 database to MSSQL 2005 server?
> A) My way: inplace upgrade (i know this one will 99% work!)
> >> installing new Windows 2003R2 with MSSQL2000 w/SP4
> >> restore the MSSQL2000 database file to the new machine Windows2003R2
> w/MSSQL2000
> >> doing inplace upgrade on Windows2003R2 w/MSSQL2000 /wSP4 >> MSSQL2005
> B) Another way: backup the MSSQL DB from Windows2000 and restore to
> Windows2005 with MSSQL2005? work?
> C) Detach and attach the database from MSSQL2000 and attach to MSSQL2005 ?
> work?
>
> Any other way which will guarantee work best?
> Thanks for any input!!
> J.H
>
We're building new machine Windows 2003 with MSSQL 2005 server.
We have current machine running Windows 2000 with MSSQL 2000.
How do we migrate the MSSQL2000 database to MSSQL 2005 server?
A) My way: inplace upgrade (i know this one will 99% work!)
>> installing new Windows 2003R2 with MSSQL2000 w/SP4
>> restore the MSSQL2000 database file to the new machine Windows2003R2
w/MSSQL2000
>> doing inplace upgrade on Windows2003R2 w/MSSQL2000 /wSP4 >> MSSQL2005
B) Another way: backup the MSSQL DB from Windows2000 and restore to
Windows2005 with MSSQL2005? work?
C) Detach and attach the database from MSSQL2000 and attach to MSSQL2005 ?
work?
Any other way which will guarantee work best?
Thanks for any input!!
J.H"J.H" <jpthsd@.hotmail.com> wrote in message
news:%239XXAO1aHHA.4616@.TK2MSFTNGP03.phx.gbl...
> Hi,
> We're building new machine Windows 2003 with MSSQL 2005 server.
> We have current machine running Windows 2000 with MSSQL 2000.
> How do we migrate the MSSQL2000 database to MSSQL 2005 server?
> A) My way: inplace upgrade (i know this one will 99% work!)
>> installing new Windows 2003R2 with MSSQL2000 w/SP4
>> restore the MSSQL2000 database file to the new machine Windows2003R2
> w/MSSQL2000
>> doing inplace upgrade on Windows2003R2 w/MSSQL2000 /wSP4 >> MSSQL2005
> B) Another way: backup the MSSQL DB from Windows2000 and restore to
> Windows2005 with MSSQL2005? work?
This will work.
I would do this.
That way if something "goes wrong" you still have your original 2000 DB and
a backup.
However, no matter WHAT choice you make, make sure to to test your
application thoroughly.
There shouldn't be any gotchas, but you never know.
> C) Detach and attach the database from MSSQL2000 and attach to MSSQL2005 ?
> work?
>
> Any other way which will guarantee work best?
> Thanks for any input!!
> J.H
>
Greg Moore
SQL Server DBA Consulting
Email: sql (at) greenms.com http://www.greenms.com|||I did attach/dettach for all my database. Now working wothout any problems.
Don't forget to change compatibility level to 9 after attaching database.
Ramunas
"J.H" <jpthsd@.hotmail.com> wrote in message
news:%239XXAO1aHHA.4616@.TK2MSFTNGP03.phx.gbl...
> Hi,
> We're building new machine Windows 2003 with MSSQL 2005 server.
> We have current machine running Windows 2000 with MSSQL 2000.
> How do we migrate the MSSQL2000 database to MSSQL 2005 server?
> A) My way: inplace upgrade (i know this one will 99% work!)
> >> installing new Windows 2003R2 with MSSQL2000 w/SP4
> >> restore the MSSQL2000 database file to the new machine Windows2003R2
> w/MSSQL2000
> >> doing inplace upgrade on Windows2003R2 w/MSSQL2000 /wSP4 >> MSSQL2005
> B) Another way: backup the MSSQL DB from Windows2000 and restore to
> Windows2005 with MSSQL2005? work?
> C) Detach and attach the database from MSSQL2000 and attach to MSSQL2005 ?
> work?
>
> Any other way which will guarantee work best?
> Thanks for any input!!
> J.H
>
MSSQL 2000 DB Migration to Microsoft SQL 2005
Hi,
We're building new machine Windows 2003 with MSSQL 2005 server.
We have current machine running Windows 2000 with MSSQL 2000.
How do we migrate the MSSQL2000 database to MSSQL 2005 server?
A) My way: inplace upgrade (i know this one will 99% work!)[vbcol=seagreen]
w/MSSQL2000[vbcol=seagreen]
B) Another way: backup the MSSQL DB from Windows2000 and restore to
Windows2005 with MSSQL2005? work?
C) Detach and attach the database from MSSQL2000 and attach to MSSQL2005 ?
work?
Any other way which will guarantee work best?
Thanks for any input!!
J.H"J.H" <jpthsd@.hotmail.com> wrote in message
news:%239XXAO1aHHA.4616@.TK2MSFTNGP03.phx.gbl...
> Hi,
> We're building new machine Windows 2003 with MSSQL 2005 server.
> We have current machine running Windows 2000 with MSSQL 2000.
> How do we migrate the MSSQL2000 database to MSSQL 2005 server?
> A) My way: inplace upgrade (i know this one will 99% work!)
> w/MSSQL2000
> B) Another way: backup the MSSQL DB from Windows2000 and restore to
> Windows2005 with MSSQL2005? work?
This will work.
I would do this.
That way if something "goes wrong" you still have your original 2000 DB and
a backup.
However, no matter WHAT choice you make, make sure to to test your
application thoroughly.
There shouldn't be any gotchas, but you never know.
> C) Detach and attach the database from MSSQL2000 and attach to MSSQL2005 ?
> work?
>
> Any other way which will guarantee work best?
> Thanks for any input!!
> J.H
>
Greg Moore
SQL Server DBA Consulting
Email: sql (at) greenms.com http://www.greenms.com|||I did attach/dettach for all my database. Now working wothout any problems.
Don't forget to change compatibility level to 9 after attaching database.
Ramunas
"J.H" <jpthsd@.hotmail.com> wrote in message
news:%239XXAO1aHHA.4616@.TK2MSFTNGP03.phx.gbl...
> Hi,
> We're building new machine Windows 2003 with MSSQL 2005 server.
> We have current machine running Windows 2000 with MSSQL 2000.
> How do we migrate the MSSQL2000 database to MSSQL 2005 server?
> A) My way: inplace upgrade (i know this one will 99% work!)
> w/MSSQL2000
> B) Another way: backup the MSSQL DB from Windows2000 and restore to
> Windows2005 with MSSQL2005? work?
> C) Detach and attach the database from MSSQL2000 and attach to MSSQL2005 ?
> work?
>
> Any other way which will guarantee work best?
> Thanks for any input!!
> J.H
>
We're building new machine Windows 2003 with MSSQL 2005 server.
We have current machine running Windows 2000 with MSSQL 2000.
How do we migrate the MSSQL2000 database to MSSQL 2005 server?
A) My way: inplace upgrade (i know this one will 99% work!)[vbcol=seagreen]
w/MSSQL2000[vbcol=seagreen]
B) Another way: backup the MSSQL DB from Windows2000 and restore to
Windows2005 with MSSQL2005? work?
C) Detach and attach the database from MSSQL2000 and attach to MSSQL2005 ?
work?
Any other way which will guarantee work best?
Thanks for any input!!
J.H"J.H" <jpthsd@.hotmail.com> wrote in message
news:%239XXAO1aHHA.4616@.TK2MSFTNGP03.phx.gbl...
> Hi,
> We're building new machine Windows 2003 with MSSQL 2005 server.
> We have current machine running Windows 2000 with MSSQL 2000.
> How do we migrate the MSSQL2000 database to MSSQL 2005 server?
> A) My way: inplace upgrade (i know this one will 99% work!)
> w/MSSQL2000
> B) Another way: backup the MSSQL DB from Windows2000 and restore to
> Windows2005 with MSSQL2005? work?
This will work.
I would do this.
That way if something "goes wrong" you still have your original 2000 DB and
a backup.
However, no matter WHAT choice you make, make sure to to test your
application thoroughly.
There shouldn't be any gotchas, but you never know.
> C) Detach and attach the database from MSSQL2000 and attach to MSSQL2005 ?
> work?
>
> Any other way which will guarantee work best?
> Thanks for any input!!
> J.H
>
Greg Moore
SQL Server DBA Consulting
Email: sql (at) greenms.com http://www.greenms.com|||I did attach/dettach for all my database. Now working wothout any problems.
Don't forget to change compatibility level to 9 after attaching database.
Ramunas
"J.H" <jpthsd@.hotmail.com> wrote in message
news:%239XXAO1aHHA.4616@.TK2MSFTNGP03.phx.gbl...
> Hi,
> We're building new machine Windows 2003 with MSSQL 2005 server.
> We have current machine running Windows 2000 with MSSQL 2000.
> How do we migrate the MSSQL2000 database to MSSQL 2005 server?
> A) My way: inplace upgrade (i know this one will 99% work!)
> w/MSSQL2000
> B) Another way: backup the MSSQL DB from Windows2000 and restore to
> Windows2005 with MSSQL2005? work?
> C) Detach and attach the database from MSSQL2000 and attach to MSSQL2005 ?
> work?
>
> Any other way which will guarantee work best?
> Thanks for any input!!
> J.H
>
MSSQL 2000- Backup Activity on a Network Machine
Hi,
I am using an Enterprise Manager and i have created a Database Maintainance Plan, can anybody guide me as to how to create backup on a remote machine.
I also mapped that device(say M/c B) onto my server box(M/c A) but i am not able to see that particular location in my backup activity screen.
Can this be done in the first place ?
Regards,
Tahirwe need some clarification.
do you want to backup databases on machine A to machine B or do you want to manage backups of databases that are on machine B from machine A?|||Yes i want to backup databases on machine A to machine B through Enterprize manager.|||While doing the backup on a networked remote machine which has been given full rights the job fails giving this error
BACKUP failed to complete the command BACKUP DATABASE [qa_tm_bdr_fix2] TO DISK = N'\\192.168.156.7\DBBackup\MUMSV075\qa_tm_bdr_fix2 _db_200612262300.BAK' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT|||Is your SQL Instance on A running under the system-account? The system account had no rights on B.
But there should be a more useful messge somewhere about why the job fails. Maybe in the errorlog? Have looked at the details in the jobhistory?|||Lexiflex is right. Make sure that the service account running the SQL server on B has enough permissions on the share (on A) where it should write the backup file. So in your case the account under which SQL Server B is running should have the permissions on the \\192.168.156.7\DBBackup share. I assume you allready shared the folder ... The problem Lexiflex is referring to is that the 'local system account' from machine A is not the same as the 'local system account' on machine B ... although it looks like it's the same one, it's definitely not ! You shouldn't run SQL Server under the local system account ... ever.
Been there, done that, worked fine.
Gr,
Yveau|||I am betting this is the problem as well. You will need to change the sql server and sql agent accounts to run under a domain account that has rights to your backup location.|||Thanks a lot for all ur help......it works......
Regards,
Tahir
I am using an Enterprise Manager and i have created a Database Maintainance Plan, can anybody guide me as to how to create backup on a remote machine.
I also mapped that device(say M/c B) onto my server box(M/c A) but i am not able to see that particular location in my backup activity screen.
Can this be done in the first place ?
Regards,
Tahirwe need some clarification.
do you want to backup databases on machine A to machine B or do you want to manage backups of databases that are on machine B from machine A?|||Yes i want to backup databases on machine A to machine B through Enterprize manager.|||While doing the backup on a networked remote machine which has been given full rights the job fails giving this error
BACKUP failed to complete the command BACKUP DATABASE [qa_tm_bdr_fix2] TO DISK = N'\\192.168.156.7\DBBackup\MUMSV075\qa_tm_bdr_fix2 _db_200612262300.BAK' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT|||Is your SQL Instance on A running under the system-account? The system account had no rights on B.
But there should be a more useful messge somewhere about why the job fails. Maybe in the errorlog? Have looked at the details in the jobhistory?|||Lexiflex is right. Make sure that the service account running the SQL server on B has enough permissions on the share (on A) where it should write the backup file. So in your case the account under which SQL Server B is running should have the permissions on the \\192.168.156.7\DBBackup share. I assume you allready shared the folder ... The problem Lexiflex is referring to is that the 'local system account' from machine A is not the same as the 'local system account' on machine B ... although it looks like it's the same one, it's definitely not ! You shouldn't run SQL Server under the local system account ... ever.
Been there, done that, worked fine.
Gr,
Yveau|||I am betting this is the problem as well. You will need to change the sql server and sql agent accounts to run under a domain account that has rights to your backup location.|||Thanks a lot for all ur help......it works......
Regards,
Tahir
Wednesday, March 28, 2012
MSSQL 2000 + MSSQL 2005 on the same machine ?
Is it possible to install MSSQL 2000 and MSSQL 2005 on the same machine
? Or is NOT recommended to do so ? Thanks !
JulichHi,
If it is production; I will not recommend both in the same machine.
Personally, I mainly run SQL 2005 on a virtual machine.
Thanks
Hari
SQL Server MVP
"Julien Cheyssial" <julich@.gmail.com> wrote in message
news:1126457667.229869.247170@.z14g2000cwz.googlegroups.com...
> Is it possible to install MSSQL 2000 and MSSQL 2005 on the same machine
> ? Or is NOT recommended to do so ? Thanks !
> Julich
>|||SQL 2005 must be installed after SQL 2K I think... On my deve machine
however I also was running Reporting Services. When I installed SQL 2005
reporting services it broke my sql 2k RS..
I'm with Hari -not on a production machine definitely - and risky on a dev
machine...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Julien Cheyssial" <julich@.gmail.com> wrote in message
news:1126457667.229869.247170@.z14g2000cwz.googlegroups.com...
> Is it possible to install MSSQL 2000 and MSSQL 2005 on the same machine
> ? Or is NOT recommended to do so ? Thanks !
> Julich
>|||They work together, but since the code is still BETA for SQL 2005 do not put
on production.
One thing I lost with it in my dev environment was Query Analyzer no longer
gives color coding, so I have to use SQL Server Management Studio for
everything if I want color coding.
"Julien Cheyssial" <julich@.gmail.com> wrote in message
news:1126457667.229869.247170@.z14g2000cwz.googlegroups.com...
> Is it possible to install MSSQL 2000 and MSSQL 2005 on the same machine
> ? Or is NOT recommended to do so ? Thanks !
> Julich
>
? Or is NOT recommended to do so ? Thanks !
JulichHi,
If it is production; I will not recommend both in the same machine.
Personally, I mainly run SQL 2005 on a virtual machine.
Thanks
Hari
SQL Server MVP
"Julien Cheyssial" <julich@.gmail.com> wrote in message
news:1126457667.229869.247170@.z14g2000cwz.googlegroups.com...
> Is it possible to install MSSQL 2000 and MSSQL 2005 on the same machine
> ? Or is NOT recommended to do so ? Thanks !
> Julich
>|||SQL 2005 must be installed after SQL 2K I think... On my deve machine
however I also was running Reporting Services. When I installed SQL 2005
reporting services it broke my sql 2k RS..
I'm with Hari -not on a production machine definitely - and risky on a dev
machine...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Julien Cheyssial" <julich@.gmail.com> wrote in message
news:1126457667.229869.247170@.z14g2000cwz.googlegroups.com...
> Is it possible to install MSSQL 2000 and MSSQL 2005 on the same machine
> ? Or is NOT recommended to do so ? Thanks !
> Julich
>|||They work together, but since the code is still BETA for SQL 2005 do not put
on production.
One thing I lost with it in my dev environment was Query Analyzer no longer
gives color coding, so I have to use SQL Server Management Studio for
everything if I want color coding.
"Julien Cheyssial" <julich@.gmail.com> wrote in message
news:1126457667.229869.247170@.z14g2000cwz.googlegroups.com...
> Is it possible to install MSSQL 2000 and MSSQL 2005 on the same machine
> ? Or is NOT recommended to do so ? Thanks !
> Julich
>
MSSQL 2000 + MSSQL 2005 on the same machine ?
Is it possible to install MSSQL 2000 and MSSQL 2005 on the same machine
? Or is NOT recommended to do so ? Thanks !
Julich
Hi,
If it is production; I will not recommend both in the same machine.
Personally, I mainly run SQL 2005 on a virtual machine.
Thanks
Hari
SQL Server MVP
"Julien Cheyssial" <julich@.gmail.com> wrote in message
news:1126457667.229869.247170@.z14g2000cwz.googlegr oups.com...
> Is it possible to install MSSQL 2000 and MSSQL 2005 on the same machine
> ? Or is NOT recommended to do so ? Thanks !
> Julich
>
|||SQL 2005 must be installed after SQL 2K I think... On my deve machine
however I also was running Reporting Services. When I installed SQL 2005
reporting services it broke my sql 2k RS..
I'm with Hari -not on a production machine definitely - and risky on a dev
machine...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Julien Cheyssial" <julich@.gmail.com> wrote in message
news:1126457667.229869.247170@.z14g2000cwz.googlegr oups.com...
> Is it possible to install MSSQL 2000 and MSSQL 2005 on the same machine
> ? Or is NOT recommended to do so ? Thanks !
> Julich
>
|||They work together, but since the code is still BETA for SQL 2005 do not put
on production.
One thing I lost with it in my dev environment was Query Analyzer no longer
gives color coding, so I have to use SQL Server Management Studio for
everything if I want color coding.
"Julien Cheyssial" <julich@.gmail.com> wrote in message
news:1126457667.229869.247170@.z14g2000cwz.googlegr oups.com...
> Is it possible to install MSSQL 2000 and MSSQL 2005 on the same machine
> ? Or is NOT recommended to do so ? Thanks !
> Julich
>
? Or is NOT recommended to do so ? Thanks !
Julich
Hi,
If it is production; I will not recommend both in the same machine.
Personally, I mainly run SQL 2005 on a virtual machine.
Thanks
Hari
SQL Server MVP
"Julien Cheyssial" <julich@.gmail.com> wrote in message
news:1126457667.229869.247170@.z14g2000cwz.googlegr oups.com...
> Is it possible to install MSSQL 2000 and MSSQL 2005 on the same machine
> ? Or is NOT recommended to do so ? Thanks !
> Julich
>
|||SQL 2005 must be installed after SQL 2K I think... On my deve machine
however I also was running Reporting Services. When I installed SQL 2005
reporting services it broke my sql 2k RS..
I'm with Hari -not on a production machine definitely - and risky on a dev
machine...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Julien Cheyssial" <julich@.gmail.com> wrote in message
news:1126457667.229869.247170@.z14g2000cwz.googlegr oups.com...
> Is it possible to install MSSQL 2000 and MSSQL 2005 on the same machine
> ? Or is NOT recommended to do so ? Thanks !
> Julich
>
|||They work together, but since the code is still BETA for SQL 2005 do not put
on production.
One thing I lost with it in my dev environment was Query Analyzer no longer
gives color coding, so I have to use SQL Server Management Studio for
everything if I want color coding.
"Julien Cheyssial" <julich@.gmail.com> wrote in message
news:1126457667.229869.247170@.z14g2000cwz.googlegr oups.com...
> Is it possible to install MSSQL 2000 and MSSQL 2005 on the same machine
> ? Or is NOT recommended to do so ? Thanks !
> Julich
>
MSSQL 2000 + MSSQL 2005 on the same machine ?
Is it possible to install MSSQL 2000 and MSSQL 2005 on the same machine
? Or is NOT recommended to do so ? Thanks !
JulichHi,
If it is production; I will not recommend both in the same machine.
Personally, I mainly run SQL 2005 on a virtual machine.
Thanks
Hari
SQL Server MVP
"Julien Cheyssial" <julich@.gmail.com> wrote in message
news:1126457667.229869.247170@.z14g2000cwz.googlegroups.com...
> Is it possible to install MSSQL 2000 and MSSQL 2005 on the same machine
> ? Or is NOT recommended to do so ? Thanks !
> Julich
>|||SQL 2005 must be installed after SQL 2K I think... On my deve machine
however I also was running Reporting Services. When I installed SQL 2005
reporting services it broke my sql 2k RS..
I'm with Hari -not on a production machine definitely - and risky on a dev
machine...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Julien Cheyssial" <julich@.gmail.com> wrote in message
news:1126457667.229869.247170@.z14g2000cwz.googlegroups.com...
> Is it possible to install MSSQL 2000 and MSSQL 2005 on the same machine
> ? Or is NOT recommended to do so ? Thanks !
> Julich
>|||They work together, but since the code is still BETA for SQL 2005 do not put
on production.
One thing I lost with it in my dev environment was Query Analyzer no longer
gives color coding, so I have to use SQL Server Management Studio for
everything if I want color coding.
"Julien Cheyssial" <julich@.gmail.com> wrote in message
news:1126457667.229869.247170@.z14g2000cwz.googlegroups.com...
> Is it possible to install MSSQL 2000 and MSSQL 2005 on the same machine
> ? Or is NOT recommended to do so ? Thanks !
> Julich
>sql
? Or is NOT recommended to do so ? Thanks !
JulichHi,
If it is production; I will not recommend both in the same machine.
Personally, I mainly run SQL 2005 on a virtual machine.
Thanks
Hari
SQL Server MVP
"Julien Cheyssial" <julich@.gmail.com> wrote in message
news:1126457667.229869.247170@.z14g2000cwz.googlegroups.com...
> Is it possible to install MSSQL 2000 and MSSQL 2005 on the same machine
> ? Or is NOT recommended to do so ? Thanks !
> Julich
>|||SQL 2005 must be installed after SQL 2K I think... On my deve machine
however I also was running Reporting Services. When I installed SQL 2005
reporting services it broke my sql 2k RS..
I'm with Hari -not on a production machine definitely - and risky on a dev
machine...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Julien Cheyssial" <julich@.gmail.com> wrote in message
news:1126457667.229869.247170@.z14g2000cwz.googlegroups.com...
> Is it possible to install MSSQL 2000 and MSSQL 2005 on the same machine
> ? Or is NOT recommended to do so ? Thanks !
> Julich
>|||They work together, but since the code is still BETA for SQL 2005 do not put
on production.
One thing I lost with it in my dev environment was Query Analyzer no longer
gives color coding, so I have to use SQL Server Management Studio for
everything if I want color coding.
"Julien Cheyssial" <julich@.gmail.com> wrote in message
news:1126457667.229869.247170@.z14g2000cwz.googlegroups.com...
> Is it possible to install MSSQL 2000 and MSSQL 2005 on the same machine
> ? Or is NOT recommended to do so ? Thanks !
> Julich
>sql
Friday, March 23, 2012
MSMQ & Integration Services
I have a SSIS package in SQL Server 2005 that attempts to publish some data into a MSMQ Private queue located on another machine.
While I was creating the package the connection string was pointing to the local server something like: localhost\private$\csin
Now I'm trying to get to the remote machine but I'm not sure what type of connection string I need to enter:
I tried: mw59\private$\csin where mw59 is the name of the remote machine I need to publish to but that result into a "Invalid Queue Path Name."
I tried: formatname:DIRECT=OS:mw59\private$\csin but that results in "The specified format name does not support the requested operation...."
Any idea?
Thanks,
Thierry
I haven't tried MSMQ in SSIS yet but I know that in SQL 2000 DTS the standard MSMQ task could not access remote private queues. I got around this with a couple of fairly simple/generic VBS tasks.
One task reads a text file into the message body and sends the message to a remote private queue. The second taks reads messages from the queue and merges them into a single text file. The next step in this tasks uses the text file source connection to read the data from the text file into a SQL table.
Dick Campbell
|||The next Web update of Books Online, scheduled to coincide with Service Pack 1, contains an already-written new topic titled "Sending to a Remote Private Message Queue with the Script Task." Sadly, as we all know, it is not a pretty sight when one attempts to copy and paste the HTML of a BOL topic. Here is my best effort after converting it to plain text:
Sending to a Remote Private Message Queue with the Script Task
Microsoft Windows Message Queuing makes it easy for developers to communicate with application programs quickly and reliably by sending and receiving messages. A message queue may be located on the local computer or a remote computer, and may be public or private. The Integration Services MSMQ Connection Manager and Message Queue Task do not support sending to a private queue on a remote computer. However, by using the Script task, it is easy to send a message to a remote private queue.
Description
The following example uses an existing MSMQ connection manager, together with objects and methods from the System.Messaging namespace, to send the text contained in a package variable to a remote private message queue. The call to the AcquireConnection method of the MSMQ connection manager returns a MessageQueueTask object whose Send method accomplishes this task.
To configure this Script Task example
Create an MSMQ Connection Manager with the default name. Set its path to a valid remote private queue, in the following format:
FORMATNAME:DIRECT=OS:<computername>\private$\<queuename>
Create an Integration Services variable named MessageText of type String to pass the message text into the script. Enter a default message as the value of the variable.
Add a Script Task to the design surface and edit it. On the Script tab of the Script Task Editor, add the MessageText variable to the ReadOnlyVariables property to make the variable available inside the script.
Click Design Script to open the Visual Studio for Applications script editor.
Add a reference in the script project to the System.Messaging namespace.
Replace the contents of the script window with the code in the following section.
Imports System
Imports Microsoft.SqlServer.Dts.Runtime
Imports System.Messaging
Public Class ScriptMain
Public Sub Main()
Dim remotePrivateQueue As MessageQueue
Dim messageText As String
remotePrivateQueue = _
DirectCast(Dts.Connections("Message Queue Connection Manager").AcquireConnection(Dts.Transaction), _
MessageQueue)
messageText = DirectCast(Dts.Variables("MessageText").Value, String)
remotePrivateQueue.Send(messageText)
Dts.TaskResult = Dts.Results.Success
End Sub
End Class
-Doug
Wednesday, March 21, 2012
MSI Checker fails during install
I am trying to install UPS Worldship on an XP Pro machine and when it
gets to the point where its says Verifying MSI System Compatibility
the installation just closes without completing. The info below is
from the install log and shows the last thing the installer was doing
before it closed. Hopefully someone can shed some light on this
because UPS is no help.
Thanks in advance,
Adam
Log excerpt:
MSI (s) (A4:C4) [14:20:49:264]: Note: 1: 1728
MSI (s) (A4:C4) [14:20:49:264]: Product: MSIChecker -- Configuration
completed successfully.
MSI (s) (A4:C4) [14:20:49:280]: Cleaning up uninstalled install
packages, if any exist
MSI (s) (A4:C4) [14:20:49:280]: MainEngineThread is returning 0
=== Logging stopped: 6/13/2007 14:20:49 ===
MSI (c) (8C:98) [14:20:49:280]: Decrementing counter to disable
shutdown. If counter >= 0, shutdown will be denied. Counter after
decrement: -1
MSI (c) (8C:98) [14:20:49:280]: MainEngineThread is returning 0
=== Verbose logging stopped: 6/13/2007 14:20:49 ===
hi Adam,
amn0270 wrote:
> I am trying to install UPS Worldship on an XP Pro machine and when it
> gets to the point where its says Verifying MSI System Compatibility
> the installation just closes without completing. The info below is
> from the install log and shows the last thing the installer was doing
> before it closed. Hopefully someone can shed some light on this
> because UPS is no help.
please check the lines before and after the
RETURN VALUE 3
entries..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
-- remove DMO to reply
|||hi Adam,
amn0270 wrote:
> I am trying to install UPS Worldship on an XP Pro machine and when it
> gets to the point where its says Verifying MSI System Compatibility
> the installation just closes without completing. The info below is
> from the install log and shows the last thing the installer was doing
> before it closed. Hopefully someone can shed some light on this
> because UPS is no help.
please check the lines before and after the
RETURN VALUE 3
entries..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
-- remove DMO to reply
gets to the point where its says Verifying MSI System Compatibility
the installation just closes without completing. The info below is
from the install log and shows the last thing the installer was doing
before it closed. Hopefully someone can shed some light on this
because UPS is no help.
Thanks in advance,
Adam
Log excerpt:
MSI (s) (A4:C4) [14:20:49:264]: Note: 1: 1728
MSI (s) (A4:C4) [14:20:49:264]: Product: MSIChecker -- Configuration
completed successfully.
MSI (s) (A4:C4) [14:20:49:280]: Cleaning up uninstalled install
packages, if any exist
MSI (s) (A4:C4) [14:20:49:280]: MainEngineThread is returning 0
=== Logging stopped: 6/13/2007 14:20:49 ===
MSI (c) (8C:98) [14:20:49:280]: Decrementing counter to disable
shutdown. If counter >= 0, shutdown will be denied. Counter after
decrement: -1
MSI (c) (8C:98) [14:20:49:280]: MainEngineThread is returning 0
=== Verbose logging stopped: 6/13/2007 14:20:49 ===
hi Adam,
amn0270 wrote:
> I am trying to install UPS Worldship on an XP Pro machine and when it
> gets to the point where its says Verifying MSI System Compatibility
> the installation just closes without completing. The info below is
> from the install log and shows the last thing the installer was doing
> before it closed. Hopefully someone can shed some light on this
> because UPS is no help.
please check the lines before and after the
RETURN VALUE 3
entries..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
-- remove DMO to reply
|||hi Adam,
amn0270 wrote:
> I am trying to install UPS Worldship on an XP Pro machine and when it
> gets to the point where its says Verifying MSI System Compatibility
> the installation just closes without completing. The info below is
> from the install log and shows the last thing the installer was doing
> before it closed. Hopefully someone can shed some light on this
> because UPS is no help.
please check the lines before and after the
RETURN VALUE 3
entries..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
-- remove DMO to reply
Monday, March 12, 2012
Msg 2511
We are getting the following error on our production machine when we run
DBCC CHECKDB
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
(1:41060), slots 264 and 265.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
(1:41085), slots 75 and 76.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
(1:41125), slots 15 and 16.
CHECKTABLE found 0 allocation errors and 3 consistency errors in table
'INT_AUX_ACTIVITY' (object ID 1488776411).
repair_rebuild is the minimum repair level for the errors found by DBCC
CHECKTABLE (sca_master.dbo.INT_AUX_ACTIVITY ).
I searched Google and found the following article,
http://www.winnetmag.com/SQLServer/Forums/messageview.cfm?catid=1664&threadid=117814
However, my network admin tells me that he could not find anything wrong
with the server. If drop the index pointed out in the error, dbcc returns no
errors.
If add the index back, I get the errors again.
Did anybody expericence a similar issue. Any pointers would be appreciated.
Thanks.
PrasadUsing SQL 2K, SP3a, with MS03-031.
Using RAID5 for data.
RAM: 2GB
"Prasad Koukuntla" <prasad.koukuntla@.scapromo.com> wrote in message
news:ew6EAWkIEHA.3664@.TK2MSFTNGP11.phx.gbl...
> We are getting the following error on our production machine when we run
> DBCC CHECKDB
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41060), slots 264 and 265.
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41085), slots 75 and 76.
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41125), slots 15 and 16.
> CHECKTABLE found 0 allocation errors and 3 consistency errors in table
> 'INT_AUX_ACTIVITY' (object ID 1488776411).
> repair_rebuild is the minimum repair level for the errors found by DBCC
> CHECKTABLE (sca_master.dbo.INT_AUX_ACTIVITY ).
> I searched Google and found the following article,
>
http://www.winnetmag.com/SQLServer/Forums/messageview.cfm?catid=1664&threadid=117814
> However, my network admin tells me that he could not find anything wrong
> with the server. If drop the index pointed out in the error, dbcc returns
no
> errors.
> If add the index back, I get the errors again.
> Did anybody expericence a similar issue. Any pointers would be
appreciated.
> Thanks.
> Prasad
>|||I ran dbcc checktable(int_aux_activity, REPAIR_REBUILD) with no_infomsgs
as suggested in the error. However, the errors still showed up, when I ran
the DBCC CHECKTABLE without the repair option.
"Prasad Koukuntla" <prasad.koukuntla@.scapromo.com> wrote in message
news:ew6EAWkIEHA.3664@.TK2MSFTNGP11.phx.gbl...
> We are getting the following error on our production machine when we run
> DBCC CHECKDB
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41060), slots 264 and 265.
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41085), slots 75 and 76.
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41125), slots 15 and 16.
> CHECKTABLE found 0 allocation errors and 3 consistency errors in table
> 'INT_AUX_ACTIVITY' (object ID 1488776411).
> repair_rebuild is the minimum repair level for the errors found by DBCC
> CHECKTABLE (sca_master.dbo.INT_AUX_ACTIVITY ).
> I searched Google and found the following article,
>
http://www.winnetmag.com/SQLServer/Forums/messageview.cfm?catid=1664&threadid=117814
> However, my network admin tells me that he could not find anything wrong
> with the server. If drop the index pointed out in the error, dbcc returns
no
> errors.
> If add the index back, I get the errors again.
> Did anybody expericence a similar issue. Any pointers would be
appreciated.
> Thanks.
> Prasad
>
DBCC CHECKDB
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
(1:41060), slots 264 and 265.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
(1:41085), slots 75 and 76.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
(1:41125), slots 15 and 16.
CHECKTABLE found 0 allocation errors and 3 consistency errors in table
'INT_AUX_ACTIVITY' (object ID 1488776411).
repair_rebuild is the minimum repair level for the errors found by DBCC
CHECKTABLE (sca_master.dbo.INT_AUX_ACTIVITY ).
I searched Google and found the following article,
http://www.winnetmag.com/SQLServer/Forums/messageview.cfm?catid=1664&threadid=117814
However, my network admin tells me that he could not find anything wrong
with the server. If drop the index pointed out in the error, dbcc returns no
errors.
If add the index back, I get the errors again.
Did anybody expericence a similar issue. Any pointers would be appreciated.
Thanks.
PrasadUsing SQL 2K, SP3a, with MS03-031.
Using RAID5 for data.
RAM: 2GB
"Prasad Koukuntla" <prasad.koukuntla@.scapromo.com> wrote in message
news:ew6EAWkIEHA.3664@.TK2MSFTNGP11.phx.gbl...
> We are getting the following error on our production machine when we run
> DBCC CHECKDB
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41060), slots 264 and 265.
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41085), slots 75 and 76.
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41125), slots 15 and 16.
> CHECKTABLE found 0 allocation errors and 3 consistency errors in table
> 'INT_AUX_ACTIVITY' (object ID 1488776411).
> repair_rebuild is the minimum repair level for the errors found by DBCC
> CHECKTABLE (sca_master.dbo.INT_AUX_ACTIVITY ).
> I searched Google and found the following article,
>
http://www.winnetmag.com/SQLServer/Forums/messageview.cfm?catid=1664&threadid=117814
> However, my network admin tells me that he could not find anything wrong
> with the server. If drop the index pointed out in the error, dbcc returns
no
> errors.
> If add the index back, I get the errors again.
> Did anybody expericence a similar issue. Any pointers would be
appreciated.
> Thanks.
> Prasad
>|||I ran dbcc checktable(int_aux_activity, REPAIR_REBUILD) with no_infomsgs
as suggested in the error. However, the errors still showed up, when I ran
the DBCC CHECKTABLE without the repair option.
"Prasad Koukuntla" <prasad.koukuntla@.scapromo.com> wrote in message
news:ew6EAWkIEHA.3664@.TK2MSFTNGP11.phx.gbl...
> We are getting the following error on our production machine when we run
> DBCC CHECKDB
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41060), slots 264 and 265.
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41085), slots 75 and 76.
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41125), slots 15 and 16.
> CHECKTABLE found 0 allocation errors and 3 consistency errors in table
> 'INT_AUX_ACTIVITY' (object ID 1488776411).
> repair_rebuild is the minimum repair level for the errors found by DBCC
> CHECKTABLE (sca_master.dbo.INT_AUX_ACTIVITY ).
> I searched Google and found the following article,
>
http://www.winnetmag.com/SQLServer/Forums/messageview.cfm?catid=1664&threadid=117814
> However, my network admin tells me that he could not find anything wrong
> with the server. If drop the index pointed out in the error, dbcc returns
no
> errors.
> If add the index back, I get the errors again.
> Did anybody expericence a similar issue. Any pointers would be
appreciated.
> Thanks.
> Prasad
>
Msg 2511
We are getting the following error on our production machine when we run
DBCC CHECKDB
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
(1:41060), slots 264 and 265.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
(1:41085), slots 75 and 76.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
(1:41125), slots 15 and 16.
CHECKTABLE found 0 allocation errors and 3 consistency errors in table
'INT_AUX_ACTIVITY' (object ID 1488776411).
repair_rebuild is the minimum repair level for the errors found by DBCC
CHECKTABLE (sca_master.dbo.INT_AUX_ACTIVITY ).
I searched Google and found the following article,
http://www.winnetmag.com/SQLServer/F...hreadid=117814
However, my network admin tells me that he could not find anything wrong
with the server. If drop the index pointed out in the error, dbcc returns no
errors.
If add the index back, I get the errors again.
Did anybody expericence a similar issue. Any pointers would be appreciated.
Thanks.
Prasad
Using SQL 2K, SP3a, with MS03-031.
Using RAID5 for data.
RAM: 2GB
"Prasad Koukuntla" <prasad.koukuntla@.scapromo.com> wrote in message
news:ew6EAWkIEHA.3664@.TK2MSFTNGP11.phx.gbl...
> We are getting the following error on our production machine when we run
> DBCC CHECKDB
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41060), slots 264 and 265.
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41085), slots 75 and 76.
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41125), slots 15 and 16.
> CHECKTABLE found 0 allocation errors and 3 consistency errors in table
> 'INT_AUX_ACTIVITY' (object ID 1488776411).
> repair_rebuild is the minimum repair level for the errors found by DBCC
> CHECKTABLE (sca_master.dbo.INT_AUX_ACTIVITY ).
> I searched Google and found the following article,
>
http://www.winnetmag.com/SQLServer/F...hreadid=117814
> However, my network admin tells me that he could not find anything wrong
> with the server. If drop the index pointed out in the error, dbcc returns
no
> errors.
> If add the index back, I get the errors again.
> Did anybody expericence a similar issue. Any pointers would be
appreciated.
> Thanks.
> Prasad
>
|||I ran dbcc checktable(int_aux_activity, REPAIR_REBUILD) with no_infomsgs
as suggested in the error. However, the errors still showed up, when I ran
the DBCC CHECKTABLE without the repair option.
"Prasad Koukuntla" <prasad.koukuntla@.scapromo.com> wrote in message
news:ew6EAWkIEHA.3664@.TK2MSFTNGP11.phx.gbl...
> We are getting the following error on our production machine when we run
> DBCC CHECKDB
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41060), slots 264 and 265.
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41085), slots 75 and 76.
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41125), slots 15 and 16.
> CHECKTABLE found 0 allocation errors and 3 consistency errors in table
> 'INT_AUX_ACTIVITY' (object ID 1488776411).
> repair_rebuild is the minimum repair level for the errors found by DBCC
> CHECKTABLE (sca_master.dbo.INT_AUX_ACTIVITY ).
> I searched Google and found the following article,
>
http://www.winnetmag.com/SQLServer/F...hreadid=117814
> However, my network admin tells me that he could not find anything wrong
> with the server. If drop the index pointed out in the error, dbcc returns
no
> errors.
> If add the index back, I get the errors again.
> Did anybody expericence a similar issue. Any pointers would be
appreciated.
> Thanks.
> Prasad
>
DBCC CHECKDB
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
(1:41060), slots 264 and 265.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
(1:41085), slots 75 and 76.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
(1:41125), slots 15 and 16.
CHECKTABLE found 0 allocation errors and 3 consistency errors in table
'INT_AUX_ACTIVITY' (object ID 1488776411).
repair_rebuild is the minimum repair level for the errors found by DBCC
CHECKTABLE (sca_master.dbo.INT_AUX_ACTIVITY ).
I searched Google and found the following article,
http://www.winnetmag.com/SQLServer/F...hreadid=117814
However, my network admin tells me that he could not find anything wrong
with the server. If drop the index pointed out in the error, dbcc returns no
errors.
If add the index back, I get the errors again.
Did anybody expericence a similar issue. Any pointers would be appreciated.
Thanks.
Prasad
Using SQL 2K, SP3a, with MS03-031.
Using RAID5 for data.
RAM: 2GB
"Prasad Koukuntla" <prasad.koukuntla@.scapromo.com> wrote in message
news:ew6EAWkIEHA.3664@.TK2MSFTNGP11.phx.gbl...
> We are getting the following error on our production machine when we run
> DBCC CHECKDB
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41060), slots 264 and 265.
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41085), slots 75 and 76.
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41125), slots 15 and 16.
> CHECKTABLE found 0 allocation errors and 3 consistency errors in table
> 'INT_AUX_ACTIVITY' (object ID 1488776411).
> repair_rebuild is the minimum repair level for the errors found by DBCC
> CHECKTABLE (sca_master.dbo.INT_AUX_ACTIVITY ).
> I searched Google and found the following article,
>
http://www.winnetmag.com/SQLServer/F...hreadid=117814
> However, my network admin tells me that he could not find anything wrong
> with the server. If drop the index pointed out in the error, dbcc returns
no
> errors.
> If add the index back, I get the errors again.
> Did anybody expericence a similar issue. Any pointers would be
appreciated.
> Thanks.
> Prasad
>
|||I ran dbcc checktable(int_aux_activity, REPAIR_REBUILD) with no_infomsgs
as suggested in the error. However, the errors still showed up, when I ran
the DBCC CHECKTABLE without the repair option.
"Prasad Koukuntla" <prasad.koukuntla@.scapromo.com> wrote in message
news:ew6EAWkIEHA.3664@.TK2MSFTNGP11.phx.gbl...
> We are getting the following error on our production machine when we run
> DBCC CHECKDB
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41060), slots 264 and 265.
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41085), slots 75 and 76.
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41125), slots 15 and 16.
> CHECKTABLE found 0 allocation errors and 3 consistency errors in table
> 'INT_AUX_ACTIVITY' (object ID 1488776411).
> repair_rebuild is the minimum repair level for the errors found by DBCC
> CHECKTABLE (sca_master.dbo.INT_AUX_ACTIVITY ).
> I searched Google and found the following article,
>
http://www.winnetmag.com/SQLServer/F...hreadid=117814
> However, my network admin tells me that he could not find anything wrong
> with the server. If drop the index pointed out in the error, dbcc returns
no
> errors.
> If add the index back, I get the errors again.
> Did anybody expericence a similar issue. Any pointers would be
appreciated.
> Thanks.
> Prasad
>
Msg 2511
We are getting the following error on our production machine when we run
DBCC CHECKDB
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
(1:41060), slots 264 and 265.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
(1:41085), slots 75 and 76.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
(1:41125), slots 15 and 16.
CHECKTABLE found 0 allocation errors and 3 consistency errors in table
'INT_AUX_ACTIVITY' (object ID 1488776411).
repair_rebuild is the minimum repair level for the errors found by DBCC
CHECKTABLE (sca_master.dbo.INT_AUX_ACTIVITY ).
I searched Google and found the following article,
http://www.winnetmag.com/SQLServer/...=1178
14
However, my network admin tells me that he could not find anything wrong
with the server. If drop the index pointed out in the error, dbcc returns no
errors.
If add the index back, I get the errors again.
Did anybody expericence a similar issue. Any pointers would be appreciated.
Thanks.
PrasadUsing SQL 2K, SP3a, with MS03-031.
Using RAID5 for data.
RAM: 2GB
"Prasad Koukuntla" <prasad.koukuntla@.scapromo.com> wrote in message
news:ew6EAWkIEHA.3664@.TK2MSFTNGP11.phx.gbl...
> We are getting the following error on our production machine when we run
> DBCC CHECKDB
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41060), slots 264 and 265.
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41085), slots 75 and 76.
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41125), slots 15 and 16.
> CHECKTABLE found 0 allocation errors and 3 consistency errors in table
> 'INT_AUX_ACTIVITY' (object ID 1488776411).
> repair_rebuild is the minimum repair level for the errors found by DBCC
> CHECKTABLE (sca_master.dbo.INT_AUX_ACTIVITY ).
> I searched Google and found the following article,
>
http://www.winnetmag.com/SQLServer/...threadid=117814darkred">
> However, my network admin tells me that he could not find anything wrong
> with the server. If drop the index pointed out in the error, dbcc returns
no
> errors.
> If add the index back, I get the errors again.
> Did anybody expericence a similar issue. Any pointers would be
appreciated.
> Thanks.
> Prasad
>|||I ran dbcc checktable(int_aux_activity, REPAIR_REBUILD) with no_infomsgs
as suggested in the error. However, the errors still showed up, when I ran
the DBCC CHECKTABLE without the repair option.
"Prasad Koukuntla" <prasad.koukuntla@.scapromo.com> wrote in message
news:ew6EAWkIEHA.3664@.TK2MSFTNGP11.phx.gbl...
> We are getting the following error on our production machine when we run
> DBCC CHECKDB
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41060), slots 264 and 265.
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41085), slots 75 and 76.
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41125), slots 15 and 16.
> CHECKTABLE found 0 allocation errors and 3 consistency errors in table
> 'INT_AUX_ACTIVITY' (object ID 1488776411).
> repair_rebuild is the minimum repair level for the errors found by DBCC
> CHECKTABLE (sca_master.dbo.INT_AUX_ACTIVITY ).
> I searched Google and found the following article,
>
http://www.winnetmag.com/SQLServer/...threadid=117814darkred">
> However, my network admin tells me that he could not find anything wrong
> with the server. If drop the index pointed out in the error, dbcc returns
no
> errors.
> If add the index back, I get the errors again.
> Did anybody expericence a similar issue. Any pointers would be
appreciated.
> Thanks.
> Prasad
>
DBCC CHECKDB
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
(1:41060), slots 264 and 265.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
(1:41085), slots 75 and 76.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
(1:41125), slots 15 and 16.
CHECKTABLE found 0 allocation errors and 3 consistency errors in table
'INT_AUX_ACTIVITY' (object ID 1488776411).
repair_rebuild is the minimum repair level for the errors found by DBCC
CHECKTABLE (sca_master.dbo.INT_AUX_ACTIVITY ).
I searched Google and found the following article,
http://www.winnetmag.com/SQLServer/...=1178
14
However, my network admin tells me that he could not find anything wrong
with the server. If drop the index pointed out in the error, dbcc returns no
errors.
If add the index back, I get the errors again.
Did anybody expericence a similar issue. Any pointers would be appreciated.
Thanks.
PrasadUsing SQL 2K, SP3a, with MS03-031.
Using RAID5 for data.
RAM: 2GB
"Prasad Koukuntla" <prasad.koukuntla@.scapromo.com> wrote in message
news:ew6EAWkIEHA.3664@.TK2MSFTNGP11.phx.gbl...
> We are getting the following error on our production machine when we run
> DBCC CHECKDB
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41060), slots 264 and 265.
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41085), slots 75 and 76.
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41125), slots 15 and 16.
> CHECKTABLE found 0 allocation errors and 3 consistency errors in table
> 'INT_AUX_ACTIVITY' (object ID 1488776411).
> repair_rebuild is the minimum repair level for the errors found by DBCC
> CHECKTABLE (sca_master.dbo.INT_AUX_ACTIVITY ).
> I searched Google and found the following article,
>
http://www.winnetmag.com/SQLServer/...threadid=117814darkred">
> However, my network admin tells me that he could not find anything wrong
> with the server. If drop the index pointed out in the error, dbcc returns
no
> errors.
> If add the index back, I get the errors again.
> Did anybody expericence a similar issue. Any pointers would be
appreciated.
> Thanks.
> Prasad
>|||I ran dbcc checktable(int_aux_activity, REPAIR_REBUILD) with no_infomsgs
as suggested in the error. However, the errors still showed up, when I ran
the DBCC CHECKTABLE without the repair option.
"Prasad Koukuntla" <prasad.koukuntla@.scapromo.com> wrote in message
news:ew6EAWkIEHA.3664@.TK2MSFTNGP11.phx.gbl...
> We are getting the following error on our production machine when we run
> DBCC CHECKDB
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41060), slots 264 and 265.
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41085), slots 75 and 76.
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41125), slots 15 and 16.
> CHECKTABLE found 0 allocation errors and 3 consistency errors in table
> 'INT_AUX_ACTIVITY' (object ID 1488776411).
> repair_rebuild is the minimum repair level for the errors found by DBCC
> CHECKTABLE (sca_master.dbo.INT_AUX_ACTIVITY ).
> I searched Google and found the following article,
>
http://www.winnetmag.com/SQLServer/...threadid=117814darkred">
> However, my network admin tells me that he could not find anything wrong
> with the server. If drop the index pointed out in the error, dbcc returns
no
> errors.
> If add the index back, I get the errors again.
> Did anybody expericence a similar issue. Any pointers would be
appreciated.
> Thanks.
> Prasad
>
Friday, March 9, 2012
MSDTC!
I have SQL Server 7.0 installed in my Win2K Pro machine. When I
navigate to Start-->SQL Server 7.0-->MSDTC Administrative Console, I
get the "Missing Shortcut" error. Even a search on 'dac.exe' doesn't
yield any result. Does this mean that the DTC console didn't get
installed while SQL Server 7.0 was installed? How do I install it
directly from the SQL Server Setup CD or do I have to uninstall & then
reinstall SQL Server 7.0 to make use of DTC? Or is there an altogether
different Setup CD for DTC?
This is the first time I am trying to use DTC.
Thanks,
Arpan
There isn't a seperate CD/setup for DTC. I would un-install and
re-install.
ALI
navigate to Start-->SQL Server 7.0-->MSDTC Administrative Console, I
get the "Missing Shortcut" error. Even a search on 'dac.exe' doesn't
yield any result. Does this mean that the DTC console didn't get
installed while SQL Server 7.0 was installed? How do I install it
directly from the SQL Server Setup CD or do I have to uninstall & then
reinstall SQL Server 7.0 to make use of DTC? Or is there an altogether
different Setup CD for DTC?
This is the first time I am trying to use DTC.
Thanks,
Arpan
There isn't a seperate CD/setup for DTC. I would un-install and
re-install.
ALI
MSDTC!
I have SQL Server 7.0 installed in my Win2K Pro machine. When I
navigate to Start-->SQL Server 7.0-->MSDTC Administrative Console, I
get the "Missing Shortcut" error. Even a search on 'dac.exe' doesn't
yield any result. Does this mean that the DTC console didn't get
installed while SQL Server 7.0 was installed? How do I install it
directly from the SQL Server Setup CD or do I have to uninstall & then
reinstall SQL Server 7.0 to make use of DTC? Or is there an altogether
different Setup CD for DTC?
This is the first time I am trying to use DTC.
Thanks,
ArpanThere isn't a seperate CD/setup for DTC. I would un-install and
re-install.
ALI
navigate to Start-->SQL Server 7.0-->MSDTC Administrative Console, I
get the "Missing Shortcut" error. Even a search on 'dac.exe' doesn't
yield any result. Does this mean that the DTC console didn't get
installed while SQL Server 7.0 was installed? How do I install it
directly from the SQL Server Setup CD or do I have to uninstall & then
reinstall SQL Server 7.0 to make use of DTC? Or is there an altogether
different Setup CD for DTC?
This is the first time I am trying to use DTC.
Thanks,
ArpanThere isn't a seperate CD/setup for DTC. I would un-install and
re-install.
ALI
MSDTC!
I have SQL Server 7.0 installed in my Win2K Pro machine. When I
navigate to Start-->SQL Server 7.0-->MSDTC Administrative Console, I
get the "Missing Shortcut" error. Even a search on 'dac.exe' doesn't
yield any result. Does this mean that the DTC console didn't get
installed while SQL Server 7.0 was installed? How do I install it
directly from the SQL Server Setup CD or do I have to uninstall & then
reinstall SQL Server 7.0 to make use of DTC? Or is there an altogether
different Setup CD for DTC?
This is the first time I am trying to use DTC.
Thanks,
ArpanThere isn't a seperate CD/setup for DTC. I would un-install and
re-install.
ALI
navigate to Start-->SQL Server 7.0-->MSDTC Administrative Console, I
get the "Missing Shortcut" error. Even a search on 'dac.exe' doesn't
yield any result. Does this mean that the DTC console didn't get
installed while SQL Server 7.0 was installed? How do I install it
directly from the SQL Server Setup CD or do I have to uninstall & then
reinstall SQL Server 7.0 to make use of DTC? Or is there an altogether
different Setup CD for DTC?
This is the first time I am trying to use DTC.
Thanks,
ArpanThere isn't a seperate CD/setup for DTC. I would un-install and
re-install.
ALI
Subscribe to:
Posts (Atom)