MSDE 2K Is there a compatibility issue with Backupexe or Sharepoint

We have installed an application that usese MSDE as the database, no error m
essage during install process. When application is opened and attempts to c
onnect with the database we get the following message:
sql code = -1
sql db code = 10004
"SQL Error: unable to connect: SQL server is unavailable or does not
exist. unable to connect: sql server does not exist or network access
denied"
We can get to the database and view contents using ODBC and OSQL. The syste
m is Windows Server 2003 Small Business Server, and we are using MSDE releas
e A. Other software on the system that might create a problem (hints I've s
een on other forums) are Ba
ckupexe and Sharepoint.
We have checked all issues of access rights and security issues we can think
of but apparently have overlooked something. This is a pretty high priorit
y issue for us so if anyone can help we would certainly appreciate it!I know this may not help much, but if you have no problem connecting from
OSQL and other application, you might want to check with teh vendor of the
application and find out how the connection to SQL Server is made from the
application. This might help lead to you why the error is occurring.
Rand
This posting is provided "as is" with no warranties and confers no rights.sql

MSDE 2000a

What is going on with this program?

When I try to install it I get the error message:

"A strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer to readme for more details. Setup will now exit."

Runing Win2k server, logged in as Administration.
Readme file says nothing about this
As usual, you can't find anything on M$ KB site.

I also tried the MSDE SP3 version - got the same results.I finally got it to install...had to edit the setup.ini file.

The server is running, the service is running but...

there is no enterprise manager...how are you suppose to manage your databases?|||There are a few things to manage your database. First of all there's the command-line tool called osql.exe that can be used to execute commands on your database. The second option is to use Access projects (supported on Access 2000 and higher if I'm not mistaken). Projects are a way to connect to a SQL Server or MSDE instance from within the Access product (pretty powerful). Last but not least there is the Web Data Administrator that can be downloaded fromhttp://www.microsoft.com/downloads/details.aspx?FamilyId=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en.

Hope this can help?|||Hi if anyone is still reading this thread this is very helpfull. I was trying to use MSDE via MATRIX but there seems to be only an option to create tables but not relationships between them so I am wondering how to actually access MSDE directly , which of above 3 ways do you suggest and where do I find more about command line and projects?sql

MSDE 2000 SP3a install failure

I am getting an error when installing SP3a of MSDE. I get the error message "The instance name specified is invalid." This is the first SQL database installed, so there is no instance name. I have tried "default" and "MSSQLSERVER" as instance names without success.

your help is appreciated.the instance name is "MSDE"

Why is this not in the setup documentation?

MSDE 2000 installation fails on Windows Vista 64-bit

Installation of MSDE 2000 fails on 64-bit Windows Vista (Build 5308).

The error message is "Setup failed to configure the server.Please refer the error logs for more information". No error log can be found on the machine at the time of installation. Please let me know if anyone else has encountered this problem?

Is it possible to install MSDE 2000 on 64-bit Windows Vista(Build 5308)?

Thanks in advance.

I don't believe any version of SQL Server or MSDE prior to SQL Server 2005 is supported on Vista. Someone else on the team who works on SQL Server 2000 should reply with a definitive answer...

Paul

|||Vista is still under development, so the right place to post your questions is Vista Newsgroups under "Application Compatibility" issues. I think the OS group has a AppCompat team that should be able to help you.|||

"Earlier versions of SQL Server, including SQL Server 2000 (all editions including Desktop Engine edition, a.k.a MSDE), SQL Server 7.0, and SQL Server 6.5, will not be supported on Windows Server "Longhorn" or Windows Vista."

from http://www.microsoft.com/sql/howtobuy/sqlonvista.mspx

sql

MSDE 2000 installation fails on Windows Vista 64-bit

Installation of MSDE 2000 fails on 64-bit Windows Vista (Build 5308).

The error message is "Setup failed to configure the server.Please refer the error logs for more information". No error log can be found on the machine at the time of installation. Please let me know if anyone else has encountered this problem?

Is it possible to install MSDE 2000 on 64-bit Windows Vista(Build 5308)?

Thanks in advance.

I don't believe any version of SQL Server or MSDE prior to SQL Server 2005 is supported on Vista. Someone else on the team who works on SQL Server 2000 should reply with a definitive answer...

Paul

|||Vista is still under development, so the right place to post your questions is Vista Newsgroups under "Application Compatibility" issues. I think the OS group has a AppCompat team that should be able to help you.|||

"Earlier versions of SQL Server, including SQL Server 2000 (all editions including Desktop Engine edition, a.k.a MSDE), SQL Server 7.0, and SQL Server 6.5, will not be supported on Windows Server "Longhorn" or Windows Vista."

from http://www.microsoft.com/sql/howtobuy/sqlonvista.mspx

MSDE 2000 install problem - Setup failed to configure the server

Hi,
I keep getting a "Setup failed to configure the server" message everytime i
try to install MSDE 2000. I have entered a strong pasword, as that was
required, removed any instances of previous msde installations and it makes
no difference.
I have read and followed instructions from various web sites and still no
installation.
Any help/advice appreciated.
Thanks
Jen
P.S. I am running XP SP2
Hello,
When you say that you removed every msde instance, did you remove the
Microsoft SQL Server directory?
My custommers have problems when they uninstall msde and they don't delete
the directory by hand after
Marc Allard
Allcomp
"JenC" <JenC@.discussions.microsoft.com> a crit dans le message de news:
EB81AD99-9F73-4731-B15F-BA1624075E9A@.microsoft.com...
> Hi,
> I keep getting a "Setup failed to configure the server" message everytime
> i
> try to install MSDE 2000. I have entered a strong pasword, as that was
> required, removed any instances of previous msde installations and it
> makes
> no difference.
> I have read and followed instructions from various web sites and still no
> installation.
> Any help/advice appreciated.
> Thanks
> Jen
> P.S. I am running XP SP2
|||If you setup is failing, specify a command line parameter DISABLEROLLBACK =
1, this would stop MSDE Installer from rolling back in case of failure.
Also specify /L*v <log file patch with name>. This would enable setup to
write logs into the specified file. Try to search "return value 3" and
check where did it fail.
Once we know where it is failing we can help better. Also add the logfile
when you reply next.
|||Try changing the parameters you use for setup.exe. For example, I removed the
DISABLENETWORKPROTOCOLS =1 and INSTANCENAME=MSDE2 parameters and it worked
fine after that.
Good luck.
"JenC" wrote:

> Hi,
> I keep getting a "Setup failed to configure the server" message everytime i
> try to install MSDE 2000. I have entered a strong pasword, as that was
> required, removed any instances of previous msde installations and it makes
> no difference.
> I have read and followed instructions from various web sites and still no
> installation.
> Any help/advice appreciated.
> Thanks
> Jen
> P.S. I am running XP SP2
sql

MSDE 2000 how many users

This is a multi-part message in MIME format.
--=_NextPart_000_000B_01C68BB6.585C23A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
How many users and transaction can handle MSDE 2000. I have an = application with 2 pc and I would like to know if MSDE 2000 would work = perfectly on that environment. I was reading the MSDE documentation and = I did not found anything about it. Any additional information I would = appreciate.
Sincerely,
Rafael
--=_NextPart_000_000B_01C68BB6.585C23A0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
How many users and transaction can = handle MSDE 2000. I have an application with 2 pc and I would like to know if MSDE = 2000 would work perfectly on that environment. I was reading the MSDE = documentation and I did not found anything about it. Any additional information I = would appreciate.

Sincerely,


Rafael
--=_NextPart_000_000B_01C68BB6.585C23A0--Hi
There is quite alot of information in Books Online which can be downloaded
at
http://www.microsoft.com/downloads/details.aspx?familyid=a6f79cb1-a420-445f-8a4b-bd77a7da194b&displaylang=en
For information on the workload govenor see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_0neh.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_5fs6.asp
For capacity details se
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
For features se
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
If you have two users each with a single connection, you should be fine. You
throughput may be limited by the specification of the machine that it is
running on.
John
"Rafael Tejera" wrote:
> How many users and transaction can handle MSDE 2000. I have an application with 2 pc and I would like to know if MSDE 2000 would work perfectly on that environment. I was reading the MSDE documentation and I did not found anything about it. Any additional information I would appreciate.
> Sincerely,
>
> Rafael|||This is a multi-part message in MIME format.
--=_NextPart_000_00F2_01C68BB5.0B328700
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Why not use SQL Server 2005 Express Edition?
David
"Rafael Tejera" <rafaeltejera@.hotmail.com> wrote in message =news:uDRTNf9iGHA.836@.TK2MSFTNGP02.phx.gbl...
How many users and transaction can handle MSDE 2000. I have an =application with 2 pc and I would like to know if MSDE 2000 would work =perfectly on that environment. I was reading the MSDE documentation and =I did not found anything about it. Any additional information I would =appreciate.
Sincerely,
Rafael
--=_NextPart_000_00F2_01C68BB5.0B328700
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

Why not use SQL Server 2005 Express =Edition?
David
"Rafael Tejera" = wrote in message news:uDRTNf9iGHA.836@.T=K2MSFTNGP02.phx.gbl...
How many users and transaction can =handle MSDE 2000. I have an application with 2 pc and I would like to know if MSDE =2000 would work perfectly on that environment. I was reading the MSDE =documentation and I did not found anything about it. Any additional information I =would appreciate.

Sincerely,


Rafael

---

--=_NextPart_000_00F2_01C68BB5.0B328700--|||"Rafael Tejera" <rafaeltejera@.hotmail.com> wrote in message
news:uDRTNf9iGHA.836@.TK2MSFTNGP02.phx.gbl...
How many users and transaction can handle MSDE 2000. I have an application
with 2 pc and I would like to know if MSDE 2000 would work perfectly on that
environment. I was reading the MSDE documentation and I did not found
anything about it. Any additional information I would appreciate.
Depends on the PC hosting. Is it at least Win2000 or XP (Pro)?
Then no problem. I have a few clients running a small network all with
MSDE. They have 10 users on their network and only a few are ever in the
app at any time (5) .

MSDE (SQL Server does not exist or access denied.)

Hi all,
I'm getting this error message when I try to connect my MSDE database from other machine using enterprise manager application. Both of the machines are WinXP SP2. I found some solution such as using 'SQLServer Network Utility' but didn't work out for me. I even can not connect my database on my computer using TCP/IP. When I connect with name, it worked fine. I already enable both TCP/IP and Named pipe protocol on the MSDE machine.
If someone has solution on that please let me know.

Thanks,
MyoDid you open the ports on the computers ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||If you have SQL Server 2005 installed on the same box as the MSDE, you need make sure SQL Browser is running. Make sure the ports (UDP/1434 and your TCP Port) are open if firewall exists. Also try file sharing between machines and make it work, otherwise NP won't work. When you use cliconfg.exe, make TCP and NP are on the client protocol lists.|||
Yes,
There is also SQL 2000 and 2005Express running together with MSDE. I already changed the port no and try to connect it. But, still didn't work out. I tried at the other machine and it works. I don't know why it still doesn't work at this machine. May be I miss some configuration. I'll try again. Thanks for the message.

Regards,
Myo|||

I have exactly the same issue. I have installed MSDE2000 on a PC with Windows XP Professional and SP2. I have tried everything to connect to another remote server and still get the same error message

I have added ports 135 and ports 445 to the firewall but again without much success. Does anyone out there have any ideas on how to get this working?

|||You will first have to determine the port that MSDE is using by starting the application Srvnetcn.exe naviagte to TCP and note that number down. After this you will have to create an exclude filter for the firewall for the application sqlservr.exe using this number and the 1434 UDP for incoming request. That should egt you started for SQL Server.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Hi Jens,

Many thanks for your prompt response. I have tried all your suggestions but still cannot gain access to a remote database. TCP/IP is running on port 1433, using Srvnetcn.exe to check, and I have added both the entries you have suggested to the firewall exclude lists. Any other ideas? Thanks in advance

MSDE - 17207, udopen: Operating system error 32(error not found) during the creation/openi

Hi there
I'm hoping somebody here can help with this problem. In the Application Event Viewer we're seeing a problem. The error message is below
The description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: 17207, udopen: Operating system error 32(error not found) during the creation/opening of physical device C:\Program Files\Microsoft SQL Server\MSSQL\Data\Genifax.mdf
Its promptly followed by this error
The description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: 17204, FCB::Open failed: Could not open device C:\Program Files\Microsoft SQL Server\MSSQL\Data\Genifax.mdf for virtual device number (VDN) 1
The machine is running MSDE as its SQL Server and has two DBs
DB on D: which is 148,628k
DB on C: which is 237,568k
I'm pretty stuck on this one, so if anybody knows what's causing this problem, and more importantly how I can go about fixing it, it'd be most appreciated - I'm no SQL Guru and haven't been able to find a huge amount on knowledgebase searches or google searches
Thanks in anticipation
Steve S
stevesdmREMOVETHIS@.hotmail.comI dont know if this will help anyone, but the sql log shows this
2004-05-26 12:33:58.27 spid7 Starting up database 'Genifax'
2004-05-26 12:34:56.71 spid52 Starting up database 'Genifax'
2004-05-26 12:34:58.60 spid7 Starting up database 'Genifax'
2004-05-26 12:35:06.49 spid52 Starting up database 'Genifax'
2004-05-26 12:35:28.27 spid7 Starting up database 'Genifax'
2004-05-26 12:35:53.69 spid52 Starting up database 'Genifax'
2004-05-26 12:35:58.68 spid7 Starting up database 'Genifax'
2004-05-26 12:36:00.65 spid52 Starting up database 'Genifax'
2004-05-26 12:36:28.43 spid7 Starting up database 'Genifax'
2004-05-26 12:36:53.69 spid52 Starting up database 'Genifax'
2004-05-26 12:37:52.49 spid52 Starting up database 'Genifax'
2004-05-26 12:38:01.08 spid52 Starting up database 'Genifax'
2004-05-26 12:38:53.72 spid52 Starting up database 'Genifax'
2004-05-26 12:38:53.72 spid52 udopen: Operating system error 32(error not found) during the creation/opening of physical device C:\Program Files\Microsoft SQL Server\MSSQL\Data\Genifax.mdf
2004-05-26 12:38:53.74 spid52 FCB::Open failed: Could not open device C:\Program Files\Microsoft SQL Server\MSSQL\Data\Genifax.mdf for virtual device number (VDN) 1
2004-05-26 13:23:09.55 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager
The bottom line is where MSDE is restarted (which cures the problem for a day or two upon which MSDE causes problems again)
Like I said in my last message, any help is very very much appreciated
Thanks
Stev

MSDE

I'm trying to install MSDE so I can use MSQL with web matrix. On trying the install I'm getting a message about using SAPWD switch. I've got no idea what that's about, but obviously need to do something somewhere!

I'm running WINXP PRO

ThankxHi, it means that you need to set up a password for the sa account when installing MSDE. Read this:
http://msdn.microsoft.com/library/en-us/distsql/distsql_84xl.asp?frame=true|||how can you tell if you have msde installed or not?|||It will install itself in the c:\program files folder as Microsoft SQL Server|||Follow the instruction in the readme.ntml file. I believe it's section 3.8. Careful when typing the installation string it can be tricky. No spaces between the "="|||Thankx.

I entered the following and ran it. The installation started

C:\sql2ksp3\MSDE\setup SECURITYMODE=SQL SAPWD=my password

After the install ran I got a message saying that : "setup failed to configure the server. Reger to the server error and setup logs"

any clues?|||What do the error logs look like - can you try installing a named instance of msde - your command prompt should look as follows

setup SAPWD="AStrongSAPwd" SECURITYMODE=SQL INSTANCENAME=MyInstance

-Kashif|||I don't know where to access the error logs!

I tried the command that you suggested, I get the message: Please go to the Control Panel to install and configure system components

Thanks|||try this

setup SAPWD="AStrongSAPwd" SECURITYMODE=SQL /l* install.log

to get the logs.

-Kashif|||Kashif, thanks a lot, the following got it all going, my ASP.net apps are all working fine!

setup SAPWD= mypassword SECURITYMODE=SQL INSTANCENAME=MyInstance|||2003-09-02 16:41:40.29 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 1)

2003-09-02 16:41:40.29 server Copyright (C) 1988-2002 Microsoft Corporation.
2003-09-02 16:41:40.29 server All rights reserved.
2003-09-02 16:41:40.29 server Server Process ID is 164.
2003-09-02 16:41:40.29 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG'.
2003-09-02 16:41:40.30 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2003-09-02 16:41:40.40 server SQL Server configured for thread mode processing.
2003-09-02 16:41:40.40 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2003-09-02 16:41:40.47 spid3 Warning ******************
2003-09-02 16:41:40.47 spid3 SQL Server started in single user mode. Updates allowed to system catalogs.
2003-09-02 16:41:40.48 spid3 Starting up database 'master'.
2003-09-02 16:41:40.67 server Using 'SSNETLIB.DLL' version '8.0.766'.
2003-09-02 16:41:40.67 spid5 Starting up database 'model'.
2003-09-02 16:41:40.72 spid3 Server name is 'IANO-SMXPDT'.
2003-09-02 16:41:40.72 spid3 Skipping startup of clean database id 5
2003-09-02 16:41:40.73 spid3 Skipping startup of clean database id 6
2003-09-02 16:41:40.73 spid3 Starting up database 'msdb'.
2003-09-02 16:41:40.76 server SQL server listening on Shared Memory.
2003-09-02 16:41:40.76 server SQL Server is ready for client connections
2003-09-02 16:41:40.83 spid5 Clearing tempdb database.
2003-09-02 16:41:41.20 spid5 Starting up database 'tempdb'.
2003-09-02 16:41:41.27 spid3 Recovery complete.
2003-09-02 16:41:41.27 spid3 SQL global counter collection task is created.
2003-09-02 16:41:41.29 spid3 Warning: override, autoexec procedures skipped.
2003-09-02 16:43:45.56 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.

What do I need to do to make this work?|||Are you having problems connecting to msde - what is the error that you see? The log file looks fine. Also can you check the version of ssnetlib.dll and post it here.

-Kashif|||Thanks for getting back to me.

Is this it ?
2000.80.766.0

I did a search and got SSnetlib.dll.CC1A8C58_27D1_4D38_BF11_C0A5CCB90616
It did not allow me to right click for properties so I copied it to a Temp directory
Where I go the above version.

Question:
At the end of the posted log file where it says
2003-09-03 09:54:23.12 spid5 Clearing tempdb database.
2003-09-03 09:54:23.51 spid5 Starting up database 'tempdb'.
2003-09-03 09:54:23.61 spid3 Recovery complete.
2003-09-03 09:54:23.61 spid3 SQL global counter collection task is created.
2003-09-03 09:54:23.64 spid3 Warning: override, autoexec procedures skipped.
2003-09-03 09:56:28.14 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.

Doesn't that 'stop' request mean that I have some service that needs starting or something?

- IanO -|||I forgot to post this. It may help you"
cnfgsvr.out

###############################################################################

Starting Service ...

SQL_Latin1_General_CP1_CI_AS

-m -Q -T4022 -T3659

An error occurred while attempting to start the service (1460)

SQL Server configuration failed.

###############################################################################|||Hasn't this gone on long enough?

How about disclosing the checks that the MSDE installer make and tell us what we have to do to our systems so it will pass the checks?

I and I suspect many others are beyond "just try this" suggestions.

I am appealing to the staff people who KNOW how the MSDE install script is written.
It is an obsurd waste of time and energy on this item and it delays getting into the purpose of this site - Allowing developers to get some experience building some .Net web applications.

So what say you?
Tell us how it works so we can move on?
Please include what service must be running etc.

IanOwm

msdb marked as suspect

Hi All,
Following error message is displayed whenever i open the Sql Server
Management Studio
Database 'msdb' cannot be opened. It has been marked SUSPECT by recovery.
See the SQL Server errorlog for more information. (.Net SqlClient Data
Provider)
I am using Sql Server 2005 with single instance
-Regards,
Seems you are in for a restore of your msdb database:
http://www.karaszi.com/SQLServer/inf...suspect_db.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Kallu" <Kallu@.discussions.microsoft.com> wrote in message
news:75BDFAB6-C334-475E-B60F-6327C32C4E8D@.microsoft.com...
> Hi All,
> Following error message is displayed whenever i open the Sql Server
> Management Studio
> Database 'msdb' cannot be opened. It has been marked SUSPECT by recovery.
> See the SQL Server errorlog for more information. (.Net SqlClient Data
> Provider)
> I am using Sql Server 2005 with single instance
> -Regards,
>

msdb marked as suspect

Hi All,
Following error message is displayed whenever i open the Sql Server
Management Studio
Database 'msdb' cannot be opened. It has been marked SUSPECT by recovery.
See the SQL Server errorlog for more information. (.Net SqlClient Data
Provider)
I am using Sql Server 2005 with single instance
-Regards,Seems you are in for a restore of your msdb database:
http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Kallu" <Kallu@.discussions.microsoft.com> wrote in message
news:75BDFAB6-C334-475E-B60F-6327C32C4E8D@.microsoft.com...
> Hi All,
> Following error message is displayed whenever i open the Sql Server
> Management Studio
> Database 'msdb' cannot be opened. It has been marked SUSPECT by recovery.
> See the SQL Server errorlog for more information. (.Net SqlClient Data
> Provider)
> I am using Sql Server 2005 with single instance
> -Regards,
>

msdb marked as suspect

Hi All,
Following error message is displayed whenever i open the Sql Server
Management Studio
Database 'msdb' cannot be opened. It has been marked SUSPECT by recovery.
See the SQL Server errorlog for more information. (.Net SqlClient Data
Provider)
I am using Sql Server 2005 with single instance
-Regards,Seems you are in for a restore of your msdb database:
http://www.karaszi.com/SQLServer/in..._suspect_db.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Kallu" <Kallu@.discussions.microsoft.com> wrote in message
news:75BDFAB6-C334-475E-B60F-6327C32C4E8D@.microsoft.com...
> Hi All,
> Following error message is displayed whenever i open the Sql Server
> Management Studio
> Database 'msdb' cannot be opened. It has been marked SUSPECT by recovery.
> See the SQL Server errorlog for more information. (.Net SqlClient Data
> Provider)
> I am using Sql Server 2005 with single instance
> -Regards,
>

msdb error

Hi

Need help with a duff msdb database in SQL7. The error -2147467259 comes up when trying to connect to msdb. Also, the message in brackets in the database view reads (Loading\Suspect) next to msdb, which is greyed out - there are also "no items" listed under the database in this view.

Having taken on the role of I.T.Manager, there have been no backups of the msdb database and a bit of a hotchpotch system for backing up the critical data was done via Winzip. I have created a batchfile that schedules a backup of the data on a nightly basis BUT can not restore a good msdb due to the fact there has never been a backup made (!!).

I have considered running the scripts from the instal CD, but am not sure that this will overwrite the dud successfully.

I am not highly skilled in the under the hood workings of SQL7 and would appreciate any advice from my peers

Thanks

KevQ1 I am not highly skilled in the under the hood workings of SQL7 and would appreciate any advice from my peers

(It has been a few years since I delt with this topic in pre Sql Server 2k environments; but for the most part, I think the following is valid for 7.0 also.)

A1 'Loading' may indicate that an MSDB restore was performed but not recovered following completion. Have you simply tried to recover i.e.(RESTORE DATABASE msdb WITH RECOVERY)?

A2 If that doesn't work, creating MSDB with install scripts is going to be involved, (not simple, but should be 'possible'). You will likely find it easier to: Install Sql Server elsewhere and backup MSDB from there (to disk). Then, use that MSDB backup dump to restore over your MSDB database.

A3 Restoring over the MSDB database is sometimes not possible (due to problems in Master), in which case you'll want to restore master and then try restoring MSDB again.

A4 If A3 doesn't allow a sucessful restoring over the MSDB database; you probably need to use rebuildm.exe (C:\Program Files\Microsoft SQL Server\80\Tools\Binn) which will fix master. Then run all your login scripts, restore / reattach your user DBs etc., etc., as necessary.

MSDB database restore

I am trying to restore the msdb to another server. When I do, I get the
following message:
V-79-57344-33938 -
An error occurred on a query to database msdb.
V-79-57344-33938 - The backup of the system database on device
msdb_00__60f69b04_bfad_4b17_a284_4047d59b9e28_ cannot be restored because it
was created by a different version of the server (134218407) than this server
(134218262).
I understand what the message is saying but how do I find out what SPs and
hotfixes I need to install in order to get the target server to the correct
version? Is there a table or a document that will tell me what needs to be
installed on the target server?
ThanksYou can restore to a new version so as long as your up to the latest version
you should be OK. This generally isn't an issue when moving between service
pack and hot fixes so my guess is that you are trying to restore to a
pre-released version of SQL Server. Looking at the SELECT @.@.version output
should help determine what you are running.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Paul Oren" <PaulOren@.discussions.microsoft.com> wrote in message
news:0C01112B-319F-4B14-8A49-F1EBAB72BF6A@.microsoft.com...
>I am trying to restore the msdb to another server. When I do, I get the
> following message:
> V-79-57344-33938 -
> An error occurred on a query to database msdb.
> V-79-57344-33938 - The backup of the system database on device
> msdb_00__60f69b04_bfad_4b17_a284_4047d59b9e28_ cannot be restored because
> it
> was created by a different version of the server (134218407) than this
> server
> (134218262).
> I understand what the message is saying but how do I find out what SPs and
> hotfixes I need to install in order to get the target server to the
> correct
> version? Is there a table or a document that will tell me what needs to
> be
> installed on the target server?
> Thanks
>|||The backup I am restoring from is on tape so I can not get it restored in
order to run the the select statement. All my databases were loaded from MS
CDs so a pre-released version of SQL server should not be an issue.
"Roger Wolter[MSFT]" wrote:
> You can restore to a new version so as long as your up to the latest version
> you should be OK. This generally isn't an issue when moving between service
> pack and hot fixes so my guess is that you are trying to restore to a
> pre-released version of SQL Server. Looking at the SELECT @.@.version output
> should help determine what you are running.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Paul Oren" <PaulOren@.discussions.microsoft.com> wrote in message
> news:0C01112B-319F-4B14-8A49-F1EBAB72BF6A@.microsoft.com...
> >I am trying to restore the msdb to another server. When I do, I get the
> > following message:
> >
> > V-79-57344-33938 -
> > An error occurred on a query to database msdb.
> > V-79-57344-33938 - The backup of the system database on device
> > msdb_00__60f69b04_bfad_4b17_a284_4047d59b9e28_ cannot be restored because
> > it
> > was created by a different version of the server (134218407) than this
> > server
> > (134218262).
> >
> > I understand what the message is saying but how do I find out what SPs and
> > hotfixes I need to install in order to get the target server to the
> > correct
> > version? Is there a table or a document that will tell me what needs to
> > be
> > installed on the target server?
> >
> > Thanks
> >
>|||So apply SQL 2005 SP2 and you will assuredly be more recent that the tape
backup.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Paul Oren" <PaulOren@.discussions.microsoft.com> wrote in message
news:339C5DF0-6C3A-4FDA-B0AF-F65D59CB7349@.microsoft.com...
> The backup I am restoring from is on tape so I can not get it restored in
> order to run the the select statement. All my databases were loaded from
> MS
> CDs so a pre-released version of SQL server should not be an issue.
> "Roger Wolter[MSFT]" wrote:
>> You can restore to a new version so as long as your up to the latest
>> version
>> you should be OK. This generally isn't an issue when moving between
>> service
>> pack and hot fixes so my guess is that you are trying to restore to a
>> pre-released version of SQL Server. Looking at the SELECT @.@.version
>> output
>> should help determine what you are running.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> Use of included script samples are subject to the terms specified at
>> http://www.microsoft.com/info/cpyright.htm
>> "Paul Oren" <PaulOren@.discussions.microsoft.com> wrote in message
>> news:0C01112B-319F-4B14-8A49-F1EBAB72BF6A@.microsoft.com...
>> >I am trying to restore the msdb to another server. When I do, I get the
>> > following message:
>> >
>> > V-79-57344-33938 -
>> > An error occurred on a query to database msdb.
>> > V-79-57344-33938 - The backup of the system database on device
>> > msdb_00__60f69b04_bfad_4b17_a284_4047d59b9e28_ cannot be restored
>> > because
>> > it
>> > was created by a different version of the server (134218407) than this
>> > server
>> > (134218262).
>> >
>> > I understand what the message is saying but how do I find out what SPs
>> > and
>> > hotfixes I need to install in order to get the target server to the
>> > correct
>> > version? Is there a table or a document that will tell me what needs
>> > to
>> > be
>> > installed on the target server?
>> >
>> > Thanks
>> >|||We are running SQL 2000 not SQL 2005.
"Roger Wolter[MSFT]" wrote:
> So apply SQL 2005 SP2 and you will assuredly be more recent that the tape
> backup.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Paul Oren" <PaulOren@.discussions.microsoft.com> wrote in message
> news:339C5DF0-6C3A-4FDA-B0AF-F65D59CB7349@.microsoft.com...
> > The backup I am restoring from is on tape so I can not get it restored in
> > order to run the the select statement. All my databases were loaded from
> > MS
> > CDs so a pre-released version of SQL server should not be an issue.
> >
> > "Roger Wolter[MSFT]" wrote:
> >
> >> You can restore to a new version so as long as your up to the latest
> >> version
> >> you should be OK. This generally isn't an issue when moving between
> >> service
> >> pack and hot fixes so my guess is that you are trying to restore to a
> >> pre-released version of SQL Server. Looking at the SELECT @.@.version
> >> output
> >> should help determine what you are running.
> >>
> >> --
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >> Use of included script samples are subject to the terms specified at
> >> http://www.microsoft.com/info/cpyright.htm
> >>
> >> "Paul Oren" <PaulOren@.discussions.microsoft.com> wrote in message
> >> news:0C01112B-319F-4B14-8A49-F1EBAB72BF6A@.microsoft.com...
> >> >I am trying to restore the msdb to another server. When I do, I get the
> >> > following message:
> >> >
> >> > V-79-57344-33938 -
> >> > An error occurred on a query to database msdb.
> >> > V-79-57344-33938 - The backup of the system database on device
> >> > msdb_00__60f69b04_bfad_4b17_a284_4047d59b9e28_ cannot be restored
> >> > because
> >> > it
> >> > was created by a different version of the server (134218407) than this
> >> > server
> >> > (134218262).
> >> >
> >> > I understand what the message is saying but how do I find out what SPs
> >> > and
> >> > hotfixes I need to install in order to get the target server to the
> >> > correct
> >> > version? Is there a table or a document that will tell me what needs
> >> > to
> >> > be
> >> > installed on the target server?
> >> >
> >> > Thanks
> >> >
> >>
>