Does anyone know or have run MSDE on an encrypted hard disk ? I can't
find much about Microsoft's support of this, I know they support
encrypting the MDF's with EFS, but what about products that encrypt
the entire hard disk, specifically PC Guardian or PGPDisk ?
Anyone have experience with this ?
thanks
bob
"Bob Horkay" <bob@.lifeasbob.com> wrote in message
news:e310ee8f.0406180908.66c05525@.posting.google.c om...
> Does anyone know or have run MSDE on an encrypted hard disk ? I can't
> find much about Microsoft's support of this, I know they support
> encrypting the MDF's with EFS, but what about products that encrypt
> the entire hard disk, specifically PC Guardian or PGPDisk ?
> Anyone have experience with this ?
I've run MSDE on a disk that was encrypted by PC Guardian. It works.
Steve
Showing posts with label run. Show all posts
Showing posts with label run. Show all posts
Friday, March 30, 2012
Wednesday, March 28, 2012
MSDE 2000 sp3a microsoft JDBC & W98
hi
I'm esperiencing a problem within a notebook where I have to run a web
application (I use a TomCat Catalina server). This notebook isn't connect in
a network and don't have a network card in it.
I've set TCP protocol within MSDE via SVRNETCN but I can't run my
appilcation I get an errore like Can't create a pooling connection
The same application with same Hardware + network card run fine.
please help
Gian Claudio
Hello Gian Claudio,
Are you sure the MSDE instance is listening on TCP/IP? You can check that
in your error log. You should see something like:
2005-05-02 14:35:38.48 server SQL server listening on 65.53.8.223: 1433.
2005-05-02 14:35:38.49 server SQL server listening on 127.0.0.1: 1433.
2005-05-02 14:35:38.56 server SQL server listening on TCP, Named Pipes.
2005-05-02 14:35:38.64 server SQL Server is ready for client connections
That tells you which IPs and port the server is listening on.
On a default installation of MSDE you would see something like:
2005-05-03 11:33:20.95 server SQL server listening on Shared Memory.
2005-05-03 11:33:20.95 server SQL Server is ready for client connections
which means it only listens on Shared Memory. The JDBC driver can only
connect through TCP/IP.
Additionally, can you test that you can connect to the SQL Server locally
with Query Analyzer over TCP/IP? You can specify tcp:servername in the
connect dialog to force connecting with TCP/IP. Otherwise you could be
connecting with named pipes or shared memory.
If all that works, can you also try connecting with a simple JDBC
application outside of TomCat and let me know what the exact exception and
full stack is?
Thanks,
Kamil
Kamil Sykora
Microsoft Developer Support - Web Data
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/securXity.
| From: "Gian Claudio Bernardi" <poc3796@.iperbole.bologna.it>
| Newsgroups: microsoft.public.sqlserver.jdbcdriver
| Subject: MSDE 2000 sp3a microsoft JDBC & W98
| Date: Thu, 14 Apr 2005 18:27:42 GMT
|
| hi
| I'm esperiencing a problem within a notebook where I have to run a web
| application (I use a TomCat Catalina server). This notebook isn't connect
in
| a network and don't have a network card in it.
|
| I've set TCP protocol within MSDE via SVRNETCN but I can't run my
| appilcation I get an errore like Can't create a pooling connection
|
| The same application with same Hardware + network card run fine.
|
| please help
|
| Gian Claudio
|
|
|
sql
I'm esperiencing a problem within a notebook where I have to run a web
application (I use a TomCat Catalina server). This notebook isn't connect in
a network and don't have a network card in it.
I've set TCP protocol within MSDE via SVRNETCN but I can't run my
appilcation I get an errore like Can't create a pooling connection
The same application with same Hardware + network card run fine.
please help
Gian Claudio
Hello Gian Claudio,
Are you sure the MSDE instance is listening on TCP/IP? You can check that
in your error log. You should see something like:
2005-05-02 14:35:38.48 server SQL server listening on 65.53.8.223: 1433.
2005-05-02 14:35:38.49 server SQL server listening on 127.0.0.1: 1433.
2005-05-02 14:35:38.56 server SQL server listening on TCP, Named Pipes.
2005-05-02 14:35:38.64 server SQL Server is ready for client connections
That tells you which IPs and port the server is listening on.
On a default installation of MSDE you would see something like:
2005-05-03 11:33:20.95 server SQL server listening on Shared Memory.
2005-05-03 11:33:20.95 server SQL Server is ready for client connections
which means it only listens on Shared Memory. The JDBC driver can only
connect through TCP/IP.
Additionally, can you test that you can connect to the SQL Server locally
with Query Analyzer over TCP/IP? You can specify tcp:servername in the
connect dialog to force connecting with TCP/IP. Otherwise you could be
connecting with named pipes or shared memory.
If all that works, can you also try connecting with a simple JDBC
application outside of TomCat and let me know what the exact exception and
full stack is?
Thanks,
Kamil
Kamil Sykora
Microsoft Developer Support - Web Data
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/securXity.
| From: "Gian Claudio Bernardi" <poc3796@.iperbole.bologna.it>
| Newsgroups: microsoft.public.sqlserver.jdbcdriver
| Subject: MSDE 2000 sp3a microsoft JDBC & W98
| Date: Thu, 14 Apr 2005 18:27:42 GMT
|
| hi
| I'm esperiencing a problem within a notebook where I have to run a web
| application (I use a TomCat Catalina server). This notebook isn't connect
in
| a network and don't have a network card in it.
|
| I've set TCP protocol within MSDE via SVRNETCN but I can't run my
| appilcation I get an errore like Can't create a pooling connection
|
| The same application with same Hardware + network card run fine.
|
| please help
|
| Gian Claudio
|
|
|
sql
Monday, March 26, 2012
MSDE 2000 on XP help...
Hello all, im new here and do not have no experience with sql. I am trying to install a tax software that I need to run my little business. When I install it gets to a popint that it asks me for my SQL server usernme and password. I remember doing this last year and I reinstalled MSDE and set up a username and password. I seem to not remember what I used, i tried all that I would have but can not get past that step.
I remember adding some lines in the setup,ini file when I installed it last year. Now I can go ahead and reinstall it again and set up a new one, but will the uninstalling and reinstalling of MSDE affect my previous software from last year? Its the same software but I need this years installed.
I have tried using sa as the username and a blank password, with a password and others that I have read up on, still cant log on. Keep getting worng credential screen.
Is there a way to get that info, i doubt it or else it would not be secure, or can I just simply reinstall MSDE?
Many thanks!!
Forget MSDE. Use Sql Server Express instead. It's much easier:http://www.microsoft.com/sql/editions/express/default.mspx
|||
If you are going to uninstall and reinstall it again, you will be loosing all the data that is there from the previous year. So if you are ok with that , you can go ahead and reinstall it.
Also, since you are using a application, the application needs to store the access details some where, may be in registry or INI or something like that, so check for that or ask the maker of the software to send you the details about where the Server details are stored by the application. Then, you can open them up and find the details.
|||Yeah thats the thing, I don't want to loose the data. OK, so I will talk to them and see what they can help me with. Thanks.
|||Well don't know anything about sql, msde, all i know is that the program asks for the login credentials when its installing, other than that, I don't mess with MSDE.
sqlFriday, March 23, 2012
MSDE 2000 Install Problems
I have been developing an application that uses MSDE 2000 as it's database.
In the process of testing/debugging my installation, I have run into an
interesting and very frustrating problem. MSDE now completely refuses to
install anymore! I cannot get the installer to install either as part of my
installer package using the MSDEBootstrap release candidate "or" by running
the MSDE setup from the command line.
I tried attaching the verbose log from my last command-line attempt, but
this newsgroup blocks my message due to size constraints. If anyone can
provide me any insight into how to resolve this, it would be much
appreciated. The error generated by the install is the ambiguous error
1603. The portion of the log which seems to contain the location where
things are goofin up follows:
MSI (s) (2C:08): Doing action:
SetPropSQLMSDEInstalled.2D02443E_7002_4C0B_ABC9_EA B2C064397B
Action start 8:35:54:
SetPropSQLMSDEInstalled.2D02443E_7002_4C0B_ABC9_EA B2C064397B.
MSI (s) (2C:08): Creating MSIHANDLE (49) of type 790542 for thread 3592
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{689404D2-1C94-44B3-9203-BEC5594FDA7A}
TempFolder is
C:\DOCUME~1\sbrodie\LOCALS~1\Temp\{689404D2-1C94-44B3-9203-BEC5594FDA7A}\
Loading extended custom action library
C:\DOCUME~1\sbrodie\LOCALS~1\Temp\{689404D2-1C94-44B3-9203-BEC5594FDA7A}\sql
cax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{689404D2-1C94-44B3-9203-BEC5594FDA7A}
Starting custom action SetPropSQLMSDEInstalled
FindSet for ProductCode <{689404D2-1C94-44B3-9203-BEC5594FDA7A}> returned 2
Setting SQLMSDEInstalled by MsiSetProperty returned 0
Setting SQLMSDESelected by MsiSetProperty returned 0
End SetPropSQLMSDEInstalled
Action ended 8:35:55:
SetPropSQLMSDEInstalled.2D02443E_7002_4C0B_ABC9_EA B2C064397B. Return value
1.
MSI (s) (2C:08): Doing action:
RestoreSetupParams.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B
Action start 8:35:55:
RestoreSetupParams.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B.
MSI (s) (2C:08): Creating MSIHANDLE (59) of type 790542 for thread 3592
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{689404D2-1C94-44B3-9203-BEC5594FDA7A}
Entering Function MyMsiEvaluateCondition
MsiEvaluateCondition for SQLMSDEInstalled returned TRUE
End Function MyMsiEvaluateCondition
Error reading setup parameters
Action ended 8:35:55:
RestoreSetupParams.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B. Return value 3.
Action ended 8:35:55: INSTALL. Return value 3.
MSI (s) (2C:08): Note: 1: 2262 2: Control 3: -2147287038
Property(S): UpgradeCode = {421A321C-2214-4713-B3EB-253F2FBCCE49}
Property(S): SqlDataDir = C:\DMSF
Property(S): SqlProgramDir = C:\Program Files\Microsoft SQL Server\
Property(S): SqlInstanceName = DMSF
Property(S): SqlSa...
Property(S): VersionNT = 501
Property(S): ALLUSERS = 1
Property(S): ARPNOMODIFY = 1
Property(S): DefaultUIFont = Tahoma8
Property(S): INSTALLLEVEL = 3
Property(S): LIMITUI = 1
Property(S): Manufacturer = Microsoft Corporation
Property(S): ProductCode = {689404D2-1C94-44B3-9203-BEC5594FDA7A}
Property(S): ProductLanguage = 1033
Property(S): ProductName = Microsoft SQL Server Desktop Engine
Property(S): ProductVersion = 8.00.761
Property(S): MsiHiddenProperties = SqlSa...
Property(S): ProgramFilesFolder.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B =
C:\Program Files\
Property(S): StartupFolder.2D02443E_7002_4C0B_ABC9_EAB2C064397B =
C:\Documents and Settings\All Users\Start Menu\Programs\Startup\
Property(S): SystemFolder.2D02443E_7002_4C0B_ABC9_EAB2C064397B =
C:\WINDOWS\System32\
Property(S): SQLVersion.2D02443E_7002_4C0B_ABC9_EAB2C064397B = 8.00.194
Property(S): SQLMSDEInstalled = 1
Property(S): SQLExitCode.2D02443E_7002_4C0B_ABC9_EAB2C064397B = 1603
Regards
Shane Brodie
"Shane Brodie" <sbrodie@.deorkit.com> wrote in message
news:u5BCBXJIEHA.4052@.TK2MSFTNGP12.phx.gbl...
> I have been developing an application that uses MSDE 2000 as it's
database.
> In the process of testing/debugging my installation, I have run into an
> interesting and very frustrating problem. MSDE now completely refuses to
> install anymore! I cannot get the installer to install either as part of
my
> installer package using the MSDEBootstrap release candidate "or" by
running
> the MSDE setup from the command line.
>
You may want to try a manual removal of the SQL Server 2000 Desktop database
(MSDE), reboot then re-install.
http://www.support.microsoft.com/?id=320873
Steve
|||Thanks Steve:
Been there ... done that ... got the t-shirt. Following is a part of my
daily blog at work:
...
Frustration day. Had a bunch of problems with MSDE and the release candidate
installer used to install the database as part of a VS.Net project. For
whatever reason, the installer is refusing to install MSDE on my machine
even after performing an in-place update of Windows XP, uninstalling and
re-installing SQL Server tools and another instance of MSDE I am running and
performing an exhaustive filesystem and registry "search and destroy
mission" to remove any existing references to my database instance. BTW:
It would be really ... nice ... if Microsoft would post expected release
dates of the final release of "release candidate" software(give or take 6
months ; ) ).
Existing newsgroup postings report similar problems and the log files
generated by the Windows Installer and Event Viewer are somewhat less than
informative ...
In the meantime, I have managed to install an instance of MS SQL Server
using the official SQL Server 2000 Personal Edition CD so that I can
continue development while I fight with this issue. I am following up on the
MS newsgroups and elsewhere to see if there are permanent work-arounds/fixes
for this problem.
...
As well installation fails whether I use the generated installation from my
VS.Net solution or if I perform a command-line install of MSDE2000a.
Sorry about the double post ... Outlook Express complained on the size of
the message plus log (and I assumed that it meant it did not send ...) and
then sent it anyways.
Regards
Shane Brodie
In the process of testing/debugging my installation, I have run into an
interesting and very frustrating problem. MSDE now completely refuses to
install anymore! I cannot get the installer to install either as part of my
installer package using the MSDEBootstrap release candidate "or" by running
the MSDE setup from the command line.
I tried attaching the verbose log from my last command-line attempt, but
this newsgroup blocks my message due to size constraints. If anyone can
provide me any insight into how to resolve this, it would be much
appreciated. The error generated by the install is the ambiguous error
1603. The portion of the log which seems to contain the location where
things are goofin up follows:
MSI (s) (2C:08): Doing action:
SetPropSQLMSDEInstalled.2D02443E_7002_4C0B_ABC9_EA B2C064397B
Action start 8:35:54:
SetPropSQLMSDEInstalled.2D02443E_7002_4C0B_ABC9_EA B2C064397B.
MSI (s) (2C:08): Creating MSIHANDLE (49) of type 790542 for thread 3592
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{689404D2-1C94-44B3-9203-BEC5594FDA7A}
TempFolder is
C:\DOCUME~1\sbrodie\LOCALS~1\Temp\{689404D2-1C94-44B3-9203-BEC5594FDA7A}\
Loading extended custom action library
C:\DOCUME~1\sbrodie\LOCALS~1\Temp\{689404D2-1C94-44B3-9203-BEC5594FDA7A}\sql
cax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{689404D2-1C94-44B3-9203-BEC5594FDA7A}
Starting custom action SetPropSQLMSDEInstalled
FindSet for ProductCode <{689404D2-1C94-44B3-9203-BEC5594FDA7A}> returned 2
Setting SQLMSDEInstalled by MsiSetProperty returned 0
Setting SQLMSDESelected by MsiSetProperty returned 0
End SetPropSQLMSDEInstalled
Action ended 8:35:55:
SetPropSQLMSDEInstalled.2D02443E_7002_4C0B_ABC9_EA B2C064397B. Return value
1.
MSI (s) (2C:08): Doing action:
RestoreSetupParams.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B
Action start 8:35:55:
RestoreSetupParams.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B.
MSI (s) (2C:08): Creating MSIHANDLE (59) of type 790542 for thread 3592
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{689404D2-1C94-44B3-9203-BEC5594FDA7A}
Entering Function MyMsiEvaluateCondition
MsiEvaluateCondition for SQLMSDEInstalled returned TRUE
End Function MyMsiEvaluateCondition
Error reading setup parameters
Action ended 8:35:55:
RestoreSetupParams.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B. Return value 3.
Action ended 8:35:55: INSTALL. Return value 3.
MSI (s) (2C:08): Note: 1: 2262 2: Control 3: -2147287038
Property(S): UpgradeCode = {421A321C-2214-4713-B3EB-253F2FBCCE49}
Property(S): SqlDataDir = C:\DMSF
Property(S): SqlProgramDir = C:\Program Files\Microsoft SQL Server\
Property(S): SqlInstanceName = DMSF
Property(S): SqlSa...
Property(S): VersionNT = 501
Property(S): ALLUSERS = 1
Property(S): ARPNOMODIFY = 1
Property(S): DefaultUIFont = Tahoma8
Property(S): INSTALLLEVEL = 3
Property(S): LIMITUI = 1
Property(S): Manufacturer = Microsoft Corporation
Property(S): ProductCode = {689404D2-1C94-44B3-9203-BEC5594FDA7A}
Property(S): ProductLanguage = 1033
Property(S): ProductName = Microsoft SQL Server Desktop Engine
Property(S): ProductVersion = 8.00.761
Property(S): MsiHiddenProperties = SqlSa...
Property(S): ProgramFilesFolder.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B =
C:\Program Files\
Property(S): StartupFolder.2D02443E_7002_4C0B_ABC9_EAB2C064397B =
C:\Documents and Settings\All Users\Start Menu\Programs\Startup\
Property(S): SystemFolder.2D02443E_7002_4C0B_ABC9_EAB2C064397B =
C:\WINDOWS\System32\
Property(S): SQLVersion.2D02443E_7002_4C0B_ABC9_EAB2C064397B = 8.00.194
Property(S): SQLMSDEInstalled = 1
Property(S): SQLExitCode.2D02443E_7002_4C0B_ABC9_EAB2C064397B = 1603
Regards
Shane Brodie
"Shane Brodie" <sbrodie@.deorkit.com> wrote in message
news:u5BCBXJIEHA.4052@.TK2MSFTNGP12.phx.gbl...
> I have been developing an application that uses MSDE 2000 as it's
database.
> In the process of testing/debugging my installation, I have run into an
> interesting and very frustrating problem. MSDE now completely refuses to
> install anymore! I cannot get the installer to install either as part of
my
> installer package using the MSDEBootstrap release candidate "or" by
running
> the MSDE setup from the command line.
>
You may want to try a manual removal of the SQL Server 2000 Desktop database
(MSDE), reboot then re-install.
http://www.support.microsoft.com/?id=320873
Steve
|||Thanks Steve:
Been there ... done that ... got the t-shirt. Following is a part of my
daily blog at work:
...
Frustration day. Had a bunch of problems with MSDE and the release candidate
installer used to install the database as part of a VS.Net project. For
whatever reason, the installer is refusing to install MSDE on my machine
even after performing an in-place update of Windows XP, uninstalling and
re-installing SQL Server tools and another instance of MSDE I am running and
performing an exhaustive filesystem and registry "search and destroy
mission" to remove any existing references to my database instance. BTW:
It would be really ... nice ... if Microsoft would post expected release
dates of the final release of "release candidate" software(give or take 6
months ; ) ).
Existing newsgroup postings report similar problems and the log files
generated by the Windows Installer and Event Viewer are somewhat less than
informative ...
In the meantime, I have managed to install an instance of MS SQL Server
using the official SQL Server 2000 Personal Edition CD so that I can
continue development while I fight with this issue. I am following up on the
MS newsgroups and elsewhere to see if there are permanent work-arounds/fixes
for this problem.
...
As well installation fails whether I use the generated installation from my
VS.Net solution or if I perform a command-line install of MSDE2000a.
Sorry about the double post ... Outlook Express complained on the size of
the message plus log (and I assumed that it meant it did not send ...) and
then sent it anyways.
Regards
Shane Brodie
MSDE 2000 does not run under Power User
Hi All,
I installed MSDE 2000 from my Office XP CD while logged in a
Administrator. I then applied SP 3 and HotPatch 815495. While logged
in as Administrator everything works fine.
However, when I log in as a Power User I have problems. MSDE seems to
load during the login process as I can see the icon in the taskbar.
But, when I try to load any program I get the MSDE 2000 installer
invoked. It goes through severl stages and I can see the progress bar
moving to the right. Once it gets all the way to the right it then
reverses itself and moves all the way back to the left. After the
installer dialogs are gone, showing no messages at all, the icon in
the taskbar is also gone.
How do I get MSDE 2000 to run correctly while logged in as a Power
User?
Thanks for any help,
Charles
hi Charles,
"Charles E Finkenbiner" <CharlesEF@.MailandNews.Com> ha scritto nel messaggio
news:d55b48cb.0409190449.732e1bb1@.posting.google.c om...
> Hi All,
> I installed MSDE 2000 from my Office XP CD while logged in a
> Administrator. I then applied SP 3 and HotPatch 815495. While logged
> in as Administrator everything works fine.
> However, when I log in as a Power User I have problems. MSDE seems to
> load during the login process as I can see the icon in the taskbar.
> But, when I try to load any program I get the MSDE 2000 installer
> invoked. It goes through severl stages and I can see the progress bar
> moving to the right. Once it gets all the way to the right it then
> reverses itself and moves all the way back to the left. After the
> installer dialogs are gone, showing no messages at all, the icon in
> the taskbar is also gone.
> How do I get MSDE 2000 to run correctly while logged in as a Power
> User?
I never used and installed the MSDE 2000 release that comes with Office XP,
but I'm quite sure it's the same package available for download from
Microsoft Web Site...
and MSDE has no installer if not the seutp.exe boostrap installer you can
usually find in the \MSDE folder of the Office CD, so no "repair" Windows
Intaller feature should be present ...
and I usually run MSDE when logged as power user or standard user.. with no
problem at all
the SQL Service is usually run in the contest of a local admin [or
LocalSystem, sometime :-( ]..
please verify MSDE is correctly running before executing your own
application(s) to verify it's not an MSDE problem...
open the control panel-> services ->MSSQLSSERVER and verify it's correctly
running...
execute oSQL.exe to connect or your preferred management application...
open with notepad the \Program Files\Microsoft SQL Server\MSSQL\Log\ERRORLOG
text file and search for errors, open the event viewer and search for SQL
Server related troubles...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea,
While logged in as a Power User services show MSSQLSERVER as started.
ERRORLOG shows errors binding to port 1433 but at the end it states
that SQLSERVER is listening on port 1433 and ready for connections.
The application event log show many MsiInstaller errors regarding
MSSQLSERVER. Registry keys missing, no permission to write to a file
in the Install directory, configuration failed.
I am just going to uninstall it and try over, again. I will post back
my results.
Thanks for your help,
Charles
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message news:<2r5mthF12sg5rU1@.uni-berlin.de>...
> hi Charles,
> "Charles E Finkenbiner" <CharlesEF@.MailandNews.Com> ha scritto nel messaggio
> news:d55b48cb.0409190449.732e1bb1@.posting.google.c om...
> I never used and installed the MSDE 2000 release that comes with Office XP,
> but I'm quite sure it's the same package available for download from
> Microsoft Web Site...
> and MSDE has no installer if not the seutp.exe boostrap installer you can
> usually find in the \MSDE folder of the Office CD, so no "repair" Windows
> Intaller feature should be present ...
> and I usually run MSDE when logged as power user or standard user.. with no
> problem at all
> the SQL Service is usually run in the contest of a local admin [or
> LocalSystem, sometime :-( ]..
> please verify MSDE is correctly running before executing your own
> application(s) to verify it's not an MSDE problem...
> open the control panel-> services ->MSSQLSSERVER and verify it's correctly
> running...
> execute oSQL.exe to connect or your preferred management application...
> open with notepad the \Program Files\Microsoft SQL Server\MSSQL\Log\ERRORLOG
> text file and search for errors, open the event viewer and search for SQL
> Server related troubles...
|||Hi,
OK, I give up. After trying many times I can not get SQL Desktop
Server installed to run under a Power User account. I have no trouble
running it as a member of the Administrator group. It has gotten to
the point that MsiInstaller locks up during the Power User
installation.
I have tried to install it while logged in as a Power User but the
installer states I do not have rights to install and exits.
Any other ideas you can supply?
Thanks for any help,
Charles
CharlesEF@.MailandNews.Com (Charles E Finkenbiner) wrote in message news:<d55b48cb.0409200014.30c832e6@.posting.google. com>...[vbcol=seagreen]
> Hi Andrea,
> While logged in as a Power User services show MSSQLSERVER as started.
> ERRORLOG shows errors binding to port 1433 but at the end it states
> that SQLSERVER is listening on port 1433 and ready for connections.
> The application event log show many MsiInstaller errors regarding
> MSSQLSERVER. Registry keys missing, no permission to write to a file
> in the Install directory, configuration failed.
> I am just going to uninstall it and try over, again. I will post back
> my results.
>
> Thanks for your help,
> Charles
> "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message news:<2r5mthF12sg5rU1@.uni-berlin.de>...
|||Hi,
Ok, I have some more information to pass along.
As I said before, when I login as Administrator (or any user in the
Administrator group) I have no problems what so ever. When I login as
a Power User MSDE appears to load without problems and I can see the
SQLManager icon in the taskbar. But, when I load a certain program
the MSDE installer kicks in and locks up (I have to End Task) and the
SQLManager icon disappears from the taskbar.
After the End Task I can still run SQL queries and they still work.
So, it appears that MSDE is still working even though the icon
disappears. The MSDE installer kicks in every time I load a certain
program (that I know of, so far) then locks up.
Is there a way for me to disable the MSDE installer? Some entry in
the Registry, perhaps?
Thanks for any help,
Charles
CharlesEF@.MailandNews.Com (Charles E Finkenbiner) wrote in message news:<d55b48cb.0409201329.f807f2b@.posting.google.c om>...[vbcol=seagreen]
> Hi,
> OK, I give up. After trying many times I can not get SQL Desktop
> Server installed to run under a Power User account. I have no trouble
> running it as a member of the Administrator group. It has gotten to
> the point that MsiInstaller locks up during the Power User
> installation.
> I have tried to install it while logged in as a Power User but the
> installer states I do not have rights to install and exits.
> Any other ideas you can supply?
>
> Thanks for any help,
> Charles
> CharlesEF@.MailandNews.Com (Charles E Finkenbiner) wrote in message news:<d55b48cb.0409200014.30c832e6@.posting.google. com>...
|||Hi,
Is there a way for me to disable the MSDE installer? Some entry in
the Registry, perhaps?
Thanks for any help,
Charles
|||CharlesEF@.MailandNews.Com (Charles E Finkenbiner) wrote in message news:<d55b48cb.0409221950.22e79cc4@.posting.google. com>...
> Hi,
> Is there a way for me to disable the MSDE installer? Some entry in
> the Registry, perhaps?
>
> Thanks for any help,
> Charles
Hi All,
I fixed my problem. I had to change permissions for the MSSQLSERVER
tree in the registry. Right or wrong, it worked for me. No more
stupid MSI installer.
Charles
I installed MSDE 2000 from my Office XP CD while logged in a
Administrator. I then applied SP 3 and HotPatch 815495. While logged
in as Administrator everything works fine.
However, when I log in as a Power User I have problems. MSDE seems to
load during the login process as I can see the icon in the taskbar.
But, when I try to load any program I get the MSDE 2000 installer
invoked. It goes through severl stages and I can see the progress bar
moving to the right. Once it gets all the way to the right it then
reverses itself and moves all the way back to the left. After the
installer dialogs are gone, showing no messages at all, the icon in
the taskbar is also gone.
How do I get MSDE 2000 to run correctly while logged in as a Power
User?
Thanks for any help,
Charles
hi Charles,
"Charles E Finkenbiner" <CharlesEF@.MailandNews.Com> ha scritto nel messaggio
news:d55b48cb.0409190449.732e1bb1@.posting.google.c om...
> Hi All,
> I installed MSDE 2000 from my Office XP CD while logged in a
> Administrator. I then applied SP 3 and HotPatch 815495. While logged
> in as Administrator everything works fine.
> However, when I log in as a Power User I have problems. MSDE seems to
> load during the login process as I can see the icon in the taskbar.
> But, when I try to load any program I get the MSDE 2000 installer
> invoked. It goes through severl stages and I can see the progress bar
> moving to the right. Once it gets all the way to the right it then
> reverses itself and moves all the way back to the left. After the
> installer dialogs are gone, showing no messages at all, the icon in
> the taskbar is also gone.
> How do I get MSDE 2000 to run correctly while logged in as a Power
> User?
I never used and installed the MSDE 2000 release that comes with Office XP,
but I'm quite sure it's the same package available for download from
Microsoft Web Site...
and MSDE has no installer if not the seutp.exe boostrap installer you can
usually find in the \MSDE folder of the Office CD, so no "repair" Windows
Intaller feature should be present ...
and I usually run MSDE when logged as power user or standard user.. with no
problem at all
the SQL Service is usually run in the contest of a local admin [or
LocalSystem, sometime :-( ]..
please verify MSDE is correctly running before executing your own
application(s) to verify it's not an MSDE problem...
open the control panel-> services ->MSSQLSSERVER and verify it's correctly
running...
execute oSQL.exe to connect or your preferred management application...
open with notepad the \Program Files\Microsoft SQL Server\MSSQL\Log\ERRORLOG
text file and search for errors, open the event viewer and search for SQL
Server related troubles...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea,
While logged in as a Power User services show MSSQLSERVER as started.
ERRORLOG shows errors binding to port 1433 but at the end it states
that SQLSERVER is listening on port 1433 and ready for connections.
The application event log show many MsiInstaller errors regarding
MSSQLSERVER. Registry keys missing, no permission to write to a file
in the Install directory, configuration failed.
I am just going to uninstall it and try over, again. I will post back
my results.
Thanks for your help,
Charles
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message news:<2r5mthF12sg5rU1@.uni-berlin.de>...
> hi Charles,
> "Charles E Finkenbiner" <CharlesEF@.MailandNews.Com> ha scritto nel messaggio
> news:d55b48cb.0409190449.732e1bb1@.posting.google.c om...
> I never used and installed the MSDE 2000 release that comes with Office XP,
> but I'm quite sure it's the same package available for download from
> Microsoft Web Site...
> and MSDE has no installer if not the seutp.exe boostrap installer you can
> usually find in the \MSDE folder of the Office CD, so no "repair" Windows
> Intaller feature should be present ...
> and I usually run MSDE when logged as power user or standard user.. with no
> problem at all
> the SQL Service is usually run in the contest of a local admin [or
> LocalSystem, sometime :-( ]..
> please verify MSDE is correctly running before executing your own
> application(s) to verify it's not an MSDE problem...
> open the control panel-> services ->MSSQLSSERVER and verify it's correctly
> running...
> execute oSQL.exe to connect or your preferred management application...
> open with notepad the \Program Files\Microsoft SQL Server\MSSQL\Log\ERRORLOG
> text file and search for errors, open the event viewer and search for SQL
> Server related troubles...
|||Hi,
OK, I give up. After trying many times I can not get SQL Desktop
Server installed to run under a Power User account. I have no trouble
running it as a member of the Administrator group. It has gotten to
the point that MsiInstaller locks up during the Power User
installation.
I have tried to install it while logged in as a Power User but the
installer states I do not have rights to install and exits.
Any other ideas you can supply?
Thanks for any help,
Charles
CharlesEF@.MailandNews.Com (Charles E Finkenbiner) wrote in message news:<d55b48cb.0409200014.30c832e6@.posting.google. com>...[vbcol=seagreen]
> Hi Andrea,
> While logged in as a Power User services show MSSQLSERVER as started.
> ERRORLOG shows errors binding to port 1433 but at the end it states
> that SQLSERVER is listening on port 1433 and ready for connections.
> The application event log show many MsiInstaller errors regarding
> MSSQLSERVER. Registry keys missing, no permission to write to a file
> in the Install directory, configuration failed.
> I am just going to uninstall it and try over, again. I will post back
> my results.
>
> Thanks for your help,
> Charles
> "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message news:<2r5mthF12sg5rU1@.uni-berlin.de>...
|||Hi,
Ok, I have some more information to pass along.
As I said before, when I login as Administrator (or any user in the
Administrator group) I have no problems what so ever. When I login as
a Power User MSDE appears to load without problems and I can see the
SQLManager icon in the taskbar. But, when I load a certain program
the MSDE installer kicks in and locks up (I have to End Task) and the
SQLManager icon disappears from the taskbar.
After the End Task I can still run SQL queries and they still work.
So, it appears that MSDE is still working even though the icon
disappears. The MSDE installer kicks in every time I load a certain
program (that I know of, so far) then locks up.
Is there a way for me to disable the MSDE installer? Some entry in
the Registry, perhaps?
Thanks for any help,
Charles
CharlesEF@.MailandNews.Com (Charles E Finkenbiner) wrote in message news:<d55b48cb.0409201329.f807f2b@.posting.google.c om>...[vbcol=seagreen]
> Hi,
> OK, I give up. After trying many times I can not get SQL Desktop
> Server installed to run under a Power User account. I have no trouble
> running it as a member of the Administrator group. It has gotten to
> the point that MsiInstaller locks up during the Power User
> installation.
> I have tried to install it while logged in as a Power User but the
> installer states I do not have rights to install and exits.
> Any other ideas you can supply?
>
> Thanks for any help,
> Charles
> CharlesEF@.MailandNews.Com (Charles E Finkenbiner) wrote in message news:<d55b48cb.0409200014.30c832e6@.posting.google. com>...
|||Hi,
Is there a way for me to disable the MSDE installer? Some entry in
the Registry, perhaps?
Thanks for any help,
Charles
|||CharlesEF@.MailandNews.Com (Charles E Finkenbiner) wrote in message news:<d55b48cb.0409221950.22e79cc4@.posting.google. com>...
> Hi,
> Is there a way for me to disable the MSDE installer? Some entry in
> the Registry, perhaps?
>
> Thanks for any help,
> Charles
Hi All,
I fixed my problem. I had to change permissions for the MSSQLSERVER
tree in the registry. Right or wrong, it worked for me. No more
stupid MSI installer.
Charles
Wednesday, March 21, 2012
MSDE 1.0 TO MSDE 2000 Release A
I've used MSDE 1.0 for a number of years.
Today I downloaded Release A with the intention of installing it, but when I
attempt to run Setup I get a dialog saying "The instance name specified is
invalid." What could be causing this?
Also... what impact will an installation of MSDE 2000 have on my existing
MSDE 1.0 databases? Is there a procedure I should be following?
Thanks in advance.
Nancy
hi Nancy,
"Nancy Lorieau" <NancyLorieau@.discussions.microsoft.com> ha scritto nel
messaggio news:81D8BF32-88C8-4F0C-AE24-0C8BCC213BC5@.microsoft.com...
> I've used MSDE 1.0 for a number of years.
> Today I downloaded Release A with the intention of installing it, but when
I
> attempt to run Setup I get a dialog saying "The instance name specified is
> invalid." What could be causing this?
>
personally I never "upgraded" MSDE 1.0 instance to MSDE 2000 ... I always
backedup the users database and restored them on the MSDE2000 new instance
after uninstalling MSDE 1.0.. but I had no reason to maintain the MSDE 1.0
instance at all...
anyway,
http://msdn.microsoft.com/library/de...stsql_84xl.asp
reports you have to add the
UPGRADE=1 UPGRADEUSER=username UPGRADEPWD=userpwd
commandline parameters to your call to the setup.exe bootstrap installer...
> Also... what impact will an installation of MSDE 2000 have on my existing
> MSDE 1.0 databases? Is there a procedure I should be following?
the users databases will be upgraded to MSDE 2000 level... you coul'd be
affected by cross database ownership chaining, which behaviour has been
changed... further info at
http://msdn.microsoft.com/library/de...onfig_8d7m.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Today I downloaded Release A with the intention of installing it, but when I
attempt to run Setup I get a dialog saying "The instance name specified is
invalid." What could be causing this?
Also... what impact will an installation of MSDE 2000 have on my existing
MSDE 1.0 databases? Is there a procedure I should be following?
Thanks in advance.
Nancy
hi Nancy,
"Nancy Lorieau" <NancyLorieau@.discussions.microsoft.com> ha scritto nel
messaggio news:81D8BF32-88C8-4F0C-AE24-0C8BCC213BC5@.microsoft.com...
> I've used MSDE 1.0 for a number of years.
> Today I downloaded Release A with the intention of installing it, but when
I
> attempt to run Setup I get a dialog saying "The instance name specified is
> invalid." What could be causing this?
>
personally I never "upgraded" MSDE 1.0 instance to MSDE 2000 ... I always
backedup the users database and restored them on the MSDE2000 new instance
after uninstalling MSDE 1.0.. but I had no reason to maintain the MSDE 1.0
instance at all...
anyway,
http://msdn.microsoft.com/library/de...stsql_84xl.asp
reports you have to add the
UPGRADE=1 UPGRADEUSER=username UPGRADEPWD=userpwd
commandline parameters to your call to the setup.exe bootstrap installer...
> Also... what impact will an installation of MSDE 2000 have on my existing
> MSDE 1.0 databases? Is there a procedure I should be following?
the users databases will be upgraded to MSDE 2000 level... you coul'd be
affected by cross database ownership chaining, which behaviour has been
changed... further info at
http://msdn.microsoft.com/library/de...onfig_8d7m.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
MSDE + JDBC SP3 - Run Together in WS
I have a java application running with JDK 1.3.1. I`d like connect this
application through the SQL DB ( MSDE + SQL Server 2000 Driver for JDBC
Service Pack 3, both are free ). Is it possible.
Txs in advance,
Jose R Castro / MCP W2K
| Thread-Topic: MSDE + JDBC SP3 - Run Together in WS
| thread-index: AcTXTYaW1R/kc6+DROSEIv2/byEYnw==
| X-WBNR-Posting-Host: 201.1.124.200
| From: "=?Utf-8?B?Sm9zZSBSIENhc3Rybw==?=" <Jose R
Castro@.discussions.microsoft.com>
| Subject: MSDE + JDBC SP3 - Run Together in WS
| Date: Tue, 30 Nov 2004 18:29:04 -0800
| Lines: 7
| Message-ID: <0EF992D0-735C-439E-B581-A6FA4464B99A@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.jdbcdriver
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.jdbcdriver:6519
| X-Tomcat-NG: microsoft.public.sqlserver.jdbcdriver
|
| I have a java application running with JDK 1.3.1. I`d like connect this
| application through the SQL DB ( MSDE + SQL Server 2000 Driver for JDBC
| Service Pack 3, both are free ). Is it possible.
| Txs in advance,
|
| Jose R Castro / MCP W2K
|
|
Yes, you can connect to MSDE from JDBC in the same way that you connect to
a full-blown instance of SQL Server..
Carb Simien, MCSE MCDBA MCAD
Microsoft Developer Support - Web Data
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
application through the SQL DB ( MSDE + SQL Server 2000 Driver for JDBC
Service Pack 3, both are free ). Is it possible.
Txs in advance,
Jose R Castro / MCP W2K
| Thread-Topic: MSDE + JDBC SP3 - Run Together in WS
| thread-index: AcTXTYaW1R/kc6+DROSEIv2/byEYnw==
| X-WBNR-Posting-Host: 201.1.124.200
| From: "=?Utf-8?B?Sm9zZSBSIENhc3Rybw==?=" <Jose R
Castro@.discussions.microsoft.com>
| Subject: MSDE + JDBC SP3 - Run Together in WS
| Date: Tue, 30 Nov 2004 18:29:04 -0800
| Lines: 7
| Message-ID: <0EF992D0-735C-439E-B581-A6FA4464B99A@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.jdbcdriver
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.jdbcdriver:6519
| X-Tomcat-NG: microsoft.public.sqlserver.jdbcdriver
|
| I have a java application running with JDK 1.3.1. I`d like connect this
| application through the SQL DB ( MSDE + SQL Server 2000 Driver for JDBC
| Service Pack 3, both are free ). Is it possible.
| Txs in advance,
|
| Jose R Castro / MCP W2K
|
|
Yes, you can connect to MSDE from JDBC in the same way that you connect to
a full-blown instance of SQL Server..
Carb Simien, MCSE MCDBA MCAD
Microsoft Developer Support - Web Data
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Monday, March 12, 2012
MSDE & SQL 7 running, backups fail
I have a W2K Server with SQL Server 7 and an instance of MSDE 2000 installed.
SQL Server 7 and MSDE 2000 both run OK together (I can make ODBC connections
to their databases from other clients, Enterprise Manager and dbamgr2k work)
and the MSDE 2000 backup jobs run successfully.
However, the SQL Server 7 maintenance jobs do not run successfully. SQL
Agent is running.
The same jobs DO run if MSDE 2000 is not running.
SQL Server connection is NT authentication.
SQL Agent Service startup account is system account.
SQL Agent SQLServer connection is Windows NT authentication.
MSDE connection is trusted NT authentication.
The Event log shows:
SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB
Maintenance Plan Test'' (0xA15AFA82EC43BD4FBA057E1ECA0E2E61) - Status: Failed
- Invoked on: 29/07/2005 15:22:23 - Message: The job failed. Unable to
determine if the owner (sa) of job DB Backup Job for DB Maintenance Plan 'DB
Maintenance Plan Test' has server access (reason: Unable to connect to server
- check SQL Server and SQL Server Agent errorlogs).
SQLAgent.OUT:
29/07/2005 15:21:32 - ! [298] SQLServer Error: 14, Invalid connection.
[SQLSTATE 08001]
29/07/2005 15:21:32 - ! [298] SQLServer Error: 14, ConnectionOpen (Invalid
Instance()). [SQLSTATE 01000]
29/07/2005 15:21:32 - ! [382] Logon to server '(local)' failed
(ConnCachePerfCounterValues)
29/07/2005 15:22:23 - ! [298] SQLServer Error: 14, Invalid connection.
[SQLSTATE 08001]
29/07/2005 15:22:23 - ! [298] SQLServer Error: 14, ConnectionOpen (Invalid
Instance()). [SQLSTATE 01000]
29/07/2005 15:22:23 - ! [382] Logon to server '(local)' failed
(ConnCachePerfCounterValues)
Interestingly, I have to start the services in a particular order - SQL
Server and SQL Server Agent start automatically with Windows. I then have to
manually start MSDE and MSDE Agent otherwise SQL Server Agent cannot start.
I have recreated the same problem on a second server.
Any ideas why my SQL Server 7 jobs will not run?
Has anyone else achieved this?
hi,
Swaffs wrote:
> I have a W2K Server with SQL Server 7 and an instance of MSDE 2000
> installed. SQL Server 7 and MSDE 2000 both run OK together (I can
> make ODBC connections to their databases from other clients,
> Enterprise Manager and dbamgr2k work) and the MSDE 2000 backup jobs
> run successfully.
> However, the SQL Server 7 maintenance jobs do not run successfully.
> SQL Agent is running.
> The same jobs DO run if MSDE 2000 is not running.
I've tried reproducing the problem as indicated, but it seems I'm more lucky
then you
on a virtual machine, where both SQL Server 7.0 Dev Edition sp4 and MSDE Rel
A (sp3a) and relative Agent are running under LocalSystem account...
searching fo your reported exceptions I only found problems related to the
account running the service, but this should not be the case as SQL Server
7.0 Agent runs ok when MSDE is not running...
but I'll keep searching..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks Andrea - after reading that you tried it with SP3a without any issues,
I installed the latest Service Pack for MSDE, rebooted and started the MSDE
services before the SQL Services and the SQL Agent jobs work fine now.
Amazing what a difference a weekend makes!
SQL Server 7 and MSDE 2000 both run OK together (I can make ODBC connections
to their databases from other clients, Enterprise Manager and dbamgr2k work)
and the MSDE 2000 backup jobs run successfully.
However, the SQL Server 7 maintenance jobs do not run successfully. SQL
Agent is running.
The same jobs DO run if MSDE 2000 is not running.
SQL Server connection is NT authentication.
SQL Agent Service startup account is system account.
SQL Agent SQLServer connection is Windows NT authentication.
MSDE connection is trusted NT authentication.
The Event log shows:
SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB
Maintenance Plan Test'' (0xA15AFA82EC43BD4FBA057E1ECA0E2E61) - Status: Failed
- Invoked on: 29/07/2005 15:22:23 - Message: The job failed. Unable to
determine if the owner (sa) of job DB Backup Job for DB Maintenance Plan 'DB
Maintenance Plan Test' has server access (reason: Unable to connect to server
- check SQL Server and SQL Server Agent errorlogs).
SQLAgent.OUT:
29/07/2005 15:21:32 - ! [298] SQLServer Error: 14, Invalid connection.
[SQLSTATE 08001]
29/07/2005 15:21:32 - ! [298] SQLServer Error: 14, ConnectionOpen (Invalid
Instance()). [SQLSTATE 01000]
29/07/2005 15:21:32 - ! [382] Logon to server '(local)' failed
(ConnCachePerfCounterValues)
29/07/2005 15:22:23 - ! [298] SQLServer Error: 14, Invalid connection.
[SQLSTATE 08001]
29/07/2005 15:22:23 - ! [298] SQLServer Error: 14, ConnectionOpen (Invalid
Instance()). [SQLSTATE 01000]
29/07/2005 15:22:23 - ! [382] Logon to server '(local)' failed
(ConnCachePerfCounterValues)
Interestingly, I have to start the services in a particular order - SQL
Server and SQL Server Agent start automatically with Windows. I then have to
manually start MSDE and MSDE Agent otherwise SQL Server Agent cannot start.
I have recreated the same problem on a second server.
Any ideas why my SQL Server 7 jobs will not run?
Has anyone else achieved this?
hi,
Swaffs wrote:
> I have a W2K Server with SQL Server 7 and an instance of MSDE 2000
> installed. SQL Server 7 and MSDE 2000 both run OK together (I can
> make ODBC connections to their databases from other clients,
> Enterprise Manager and dbamgr2k work) and the MSDE 2000 backup jobs
> run successfully.
> However, the SQL Server 7 maintenance jobs do not run successfully.
> SQL Agent is running.
> The same jobs DO run if MSDE 2000 is not running.
I've tried reproducing the problem as indicated, but it seems I'm more lucky
then you
on a virtual machine, where both SQL Server 7.0 Dev Edition sp4 and MSDE Rel
A (sp3a) and relative Agent are running under LocalSystem account...
searching fo your reported exceptions I only found problems related to the
account running the service, but this should not be the case as SQL Server
7.0 Agent runs ok when MSDE is not running...
but I'll keep searching..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks Andrea - after reading that you tried it with SP3a without any issues,
I installed the latest Service Pack for MSDE, rebooted and started the MSDE
services before the SQL Services and the SQL Agent jobs work fine now.
Amazing what a difference a weekend makes!
MSDE - Unknown Server
Hello,
I installed software called AutoAPP on a users desktop and this software
automatically installs MSDE (No idea what version). When run under the
administrator account everything is fine. When the user logs on under their
account (power user) SQL Icon is on the task bar, but it is blank \\ -
Unknown Server. I have to manually type in the laptop name in the server
field of the SQL Server Service Manager and then the arrow will go green.
Does anyone know why under Administrator account the server name is there,
but not under the users profile? It is annoying having to type in the
computer each time the computer reboots, giving the user Administrative
access to their computer is not really an option. Once the computer name is
entered under the user account everything seems to function normally.
Laptop is running Windows XP Pro SP1
Thank You.
hi John,
"John J. Rambone" <lgm_rambone@.remove.hotmail.com> ha scritto nel
messaggio news:uANQsnFuEHA.1472@.TK2MSFTNGP10.phx.gbl
> Hello,
> I installed software called AutoAPP on a users desktop and this
> software automatically installs MSDE (No idea what version). When
> run under the administrator account everything is fine. When the
> user logs on under their account (power user) SQL Icon is on the task
> bar, but it is blank \\ - Unknown Server. I have to manually type in
> the laptop name in the server field of the SQL Server Service Manager
> and then the arrow will go green. Does anyone know why under
> Administrator account the server name is there, but not under the
> users profile? It is annoying having to type in the computer each
> time the computer reboots, giving the user Administrative access to
> their computer is not really an option. Once the computer name is
> entered under the user account everything seems to function normally.
> Laptop is running Windows XP Pro SP1
is the Service Manager only that does not enlist the local server, or is the
MSDE service itself that is not running when logging as a power user?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||> is the Service Manager only that does not enlist the local server, or is
> the
> MSDE service itself that is not running when logging as a power user?
I uninstalled everything, but once I reinstall I will check under the
Services and Applications -> Services to make sure it is running. I'm
almost positive it is running and the Service manager does load on boot up,
but the circle will not have the green arrow. If I open the Service Manager
the drop down for the Server field will be empty. I type in the name of the
local comptuer i.e. laptop1 and it arrow goes green and the application can
access the database. It is just annoying to have to type in the computer
name each time. I will very 100% for sure if the service is running in the
next day or so, once I get a chance to work on the users laptop again.
Thanks You.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2u4493F26ob6nU1@.uni-berlin.de...
> hi John,
> "John J. Rambone" <lgm_rambone@.remove.hotmail.com> ha scritto nel
> messaggio news:uANQsnFuEHA.1472@.TK2MSFTNGP10.phx.gbl
>
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
I installed software called AutoAPP on a users desktop and this software
automatically installs MSDE (No idea what version). When run under the
administrator account everything is fine. When the user logs on under their
account (power user) SQL Icon is on the task bar, but it is blank \\ -
Unknown Server. I have to manually type in the laptop name in the server
field of the SQL Server Service Manager and then the arrow will go green.
Does anyone know why under Administrator account the server name is there,
but not under the users profile? It is annoying having to type in the
computer each time the computer reboots, giving the user Administrative
access to their computer is not really an option. Once the computer name is
entered under the user account everything seems to function normally.
Laptop is running Windows XP Pro SP1
Thank You.
hi John,
"John J. Rambone" <lgm_rambone@.remove.hotmail.com> ha scritto nel
messaggio news:uANQsnFuEHA.1472@.TK2MSFTNGP10.phx.gbl
> Hello,
> I installed software called AutoAPP on a users desktop and this
> software automatically installs MSDE (No idea what version). When
> run under the administrator account everything is fine. When the
> user logs on under their account (power user) SQL Icon is on the task
> bar, but it is blank \\ - Unknown Server. I have to manually type in
> the laptop name in the server field of the SQL Server Service Manager
> and then the arrow will go green. Does anyone know why under
> Administrator account the server name is there, but not under the
> users profile? It is annoying having to type in the computer each
> time the computer reboots, giving the user Administrative access to
> their computer is not really an option. Once the computer name is
> entered under the user account everything seems to function normally.
> Laptop is running Windows XP Pro SP1
is the Service Manager only that does not enlist the local server, or is the
MSDE service itself that is not running when logging as a power user?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||> is the Service Manager only that does not enlist the local server, or is
> the
> MSDE service itself that is not running when logging as a power user?
I uninstalled everything, but once I reinstall I will check under the
Services and Applications -> Services to make sure it is running. I'm
almost positive it is running and the Service manager does load on boot up,
but the circle will not have the green arrow. If I open the Service Manager
the drop down for the Server field will be empty. I type in the name of the
local comptuer i.e. laptop1 and it arrow goes green and the application can
access the database. It is just annoying to have to type in the computer
name each time. I will very 100% for sure if the service is running in the
next day or so, once I get a chance to work on the users laptop again.
Thanks You.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2u4493F26ob6nU1@.uni-berlin.de...
> hi John,
> "John J. Rambone" <lgm_rambone@.remove.hotmail.com> ha scritto nel
> messaggio news:uANQsnFuEHA.1472@.TK2MSFTNGP10.phx.gbl
>
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
Friday, March 9, 2012
MSDE - Job Scheduling and Stored Procedures
Can MSDE run stored procedures? Does MSDE have the same job scheduling features that SQL Standard and Enterprise Edition have?
SR
Yes and yes.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"SR" <mv2k_2003-news@.yahoo.com> wrote in message news:ALq0d.13990$QJ3.9851@.newssvr21.news.prodigy.c om...
Can MSDE run stored procedures? Does MSDE have the same job scheduling features that SQL Standard and Enterprise Edition have?
SR
|||yes and no.
The SQL Express does not have job scheduler on board.
regards
bav
SR
Yes and yes.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"SR" <mv2k_2003-news@.yahoo.com> wrote in message news:ALq0d.13990$QJ3.9851@.newssvr21.news.prodigy.c om...
Can MSDE run stored procedures? Does MSDE have the same job scheduling features that SQL Standard and Enterprise Edition have?
SR
|||yes and no.
The SQL Express does not have job scheduler on board.
regards
bav
Msde
Hi,
Can any one tell me where to get hold of MSDE and how to install it. Does it run on windows 98??.
Thanks in advanceThe following link will answer your questions:
MS Site (http://www.microsoft.com/SQL/techinfo/development/2000/MSDE2000.asp)
Can any one tell me where to get hold of MSDE and how to install it. Does it run on windows 98??.
Thanks in advanceThe following link will answer your questions:
MS Site (http://www.microsoft.com/SQL/techinfo/development/2000/MSDE2000.asp)
Wednesday, March 7, 2012
MSDE
I trying install MSDE 2000 for the first time on XP Sp2
When I try run setup it give error Instance name is invaild
only choice click ok. When I click it just goes away.
I now how do fix I just double clicking setup icon
Thanks for the help
hi Frank,
frank wrote:
> I trying install MSDE 2000 for the first time on XP Sp2
> When I try run setup it give error Instance name is invaild
> only choice click ok. When I click it just goes away.
> I now how do fix I just double clicking setup icon
>
> Thanks for the help
can you please post your command line you used to install MSDE?
MSDE must be installed using it's setup.exe boostrap installer, which
accepts (and requires) some parameters...
all usable parameters for installing a (somehow) customized MSDE are
available at
http://msdn.microsoft.com/library/de...stsql_84xl.asp
just for the case, I've just installed an MSDE named instance on a brand new
WinXP sp 2 machine...
I disabled the antivirus (it was Avast), checked "File & Printer Sharing"
was enabled, the "Server" service was running..
the LAN access was available through the subnetmask exception...
I installed a named instance like
setup.exe INSTANCENAME="MSDE" SAPWD=*** SECURITYMODE=SQL
DISABLENETWORKPROTOCOLS=0 /L*v "C:\MsdeLog.txt"
and that installed a named instance named "MSDE", allowing SQL Server
authenticated connections (mixed authentication), with support for remote
connections and logging the install process to C:\MsdeLog.txt, a text file
of about 2mb you can inspect for toubleshooting problems, searching for
RETURN VALUE 3
entries that denotate errors, where 10/20 lines before and/or after some
(somteime criptic) description of the problem is recoded... thi installation
worked as a charm... :D
after that I configured the Windows firewall defining an exception allowing
acces to the MSDE instance used TCP port and another exception for UDP 1434
port for the SQL Server Service Listener...
in order to configure XP sp2 for SQL Server connectivity you can ahave a
look at http://support.microsoft.com/default.aspx?kbid=841249
regards
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
When I try run setup it give error Instance name is invaild
only choice click ok. When I click it just goes away.
I now how do fix I just double clicking setup icon
Thanks for the help
hi Frank,
frank wrote:
> I trying install MSDE 2000 for the first time on XP Sp2
> When I try run setup it give error Instance name is invaild
> only choice click ok. When I click it just goes away.
> I now how do fix I just double clicking setup icon
>
> Thanks for the help
can you please post your command line you used to install MSDE?
MSDE must be installed using it's setup.exe boostrap installer, which
accepts (and requires) some parameters...
all usable parameters for installing a (somehow) customized MSDE are
available at
http://msdn.microsoft.com/library/de...stsql_84xl.asp
just for the case, I've just installed an MSDE named instance on a brand new
WinXP sp 2 machine...
I disabled the antivirus (it was Avast), checked "File & Printer Sharing"
was enabled, the "Server" service was running..
the LAN access was available through the subnetmask exception...
I installed a named instance like
setup.exe INSTANCENAME="MSDE" SAPWD=*** SECURITYMODE=SQL
DISABLENETWORKPROTOCOLS=0 /L*v "C:\MsdeLog.txt"
and that installed a named instance named "MSDE", allowing SQL Server
authenticated connections (mixed authentication), with support for remote
connections and logging the install process to C:\MsdeLog.txt, a text file
of about 2mb you can inspect for toubleshooting problems, searching for
RETURN VALUE 3
entries that denotate errors, where 10/20 lines before and/or after some
(somteime criptic) description of the problem is recoded... thi installation
worked as a charm... :D
after that I configured the Windows firewall defining an exception allowing
acces to the MSDE instance used TCP port and another exception for UDP 1434
port for the SQL Server Service Listener...
in order to configure XP sp2 for SQL Server connectivity you can ahave a
look at http://support.microsoft.com/default.aspx?kbid=841249
regards
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
msde
i have 2 computers 1 desktop dell the other a hp laptop both run windows xp
home , but only the laptop will show the sever running. I would like to get
the same on my desktop but i do not know how if someone could show me how to
set it up on desktop i would appreciate.
ty john myrick
hi John,
john m wrote:
> i have 2 computers 1 desktop dell the other a hp laptop both run
> windows xp home , but only the laptop will show the sever running. I
> would like to get the same on my desktop but i do not know how if
> someone could show me how to set it up on desktop i would appreciate.
what do you mean by "but only the laptop will show the sever running" ?
is the MSDE instance service not running or just not showing in the SQL
Server Service Manager?
(http://support.microsoft.com/default...b;EN-US;814132)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
home , but only the laptop will show the sever running. I would like to get
the same on my desktop but i do not know how if someone could show me how to
set it up on desktop i would appreciate.
ty john myrick
hi John,
john m wrote:
> i have 2 computers 1 desktop dell the other a hp laptop both run
> windows xp home , but only the laptop will show the sever running. I
> would like to get the same on my desktop but i do not know how if
> someone could show me how to set it up on desktop i would appreciate.
what do you mean by "but only the laptop will show the sever running" ?
is the MSDE instance service not running or just not showing in the SQL
Server Service Manager?
(http://support.microsoft.com/default...b;EN-US;814132)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Monday, February 20, 2012
MSDB Growing Weekly
Hello All.
We have a problem with our SQL Server it is a 4 processor 2 Gb RAM, 8 HD
72.2 SCSI Hot Plug Server
We run over this server OLTP (3 databases), and OLAP (4 databases)
processes, the server performs okey but we have this issue:
Our MSDB grows about 150% weekly the only "solution" we have found is to
stop restart services in order to get MSDB small againg.
We execute on a daily basis arround 22 big DTS from AS400 (Jd Edwards) to
get our OLAP solution updated, also a daily full backup is executed (to
disk) for all databases including master and msdb.
We have executed the following tip with no results.
[b]You can remove old backup and restore records from the MSDB database
by
running the sp_delete_backuphistory stored procedure, like this
USE msdb
EXEC sp_delete_backuphistory '01/01/00'[/b]
If anyone have had this solved with a better solution instead of stopping
restarting services Ill be very gratefull at you.!!!
RegardsChristian,
Are the DTS packages updated often? These and their many versions are stored
in msdb. Look at sysdtspackages table. If you do not delete the previous
version and keep adding new versions this will fill msdb.
Chris Wood
Alberta Department of Energy
CANADA
"Christian A. Tello" <ctello@.oiecuador.com.ec> wrote in message
news:uZNZVJ%23GEHA.2416@.TK2MSFTNGP12.phx.gbl...
> Hello All.
> We have a problem with our SQL Server it is a 4 processor 2 Gb RAM, 8 HD
> 72.2 SCSI Hot Plug Server
> We run over this server OLTP (3 databases), and OLAP (4 databases)
> processes, the server performs okey but we have this issue:
> Our MSDB grows about 150% weekly the only "solution" we have found is to
> stop restart services in order to get MSDB small againg.
> We execute on a daily basis arround 22 big DTS from AS400 (Jd Edwards) to
> get our OLAP solution updated, also a daily full backup is executed (to
> disk) for all databases including master and msdb.
> We have executed the following tip with no results.
> [b]You can remove old backup and restore records from the MSDB databas
e by
> running the sp_delete_backuphistory stored procedure, like this
> USE msdb
> EXEC sp_delete_backuphistory '01/01/00'[/b]
>
> If anyone have had this solved with a better solution instead of stopping
> restarting services Ill be very gratefull at you.!!!
> Regards
>|||Thanks Chris
In fact we did that 8 or 9 weeks ago we deleted all versions. We modify
the certain DTS 4 times a month. At this time we have 94 rows within the
sysdtspackages table. We have 28 DTSs.
Any other ideas?
Thanks again
****************************************
Christian,
Are the DTS packages updated often? These and their many versions are
stored
in msdb. Look at sysdtspackages table. If you do not delete the previous
version and keep adding new versions this will fill msdb.
Chris Wood
Alberta Department of Energy
CANADA
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!
We have a problem with our SQL Server it is a 4 processor 2 Gb RAM, 8 HD
72.2 SCSI Hot Plug Server
We run over this server OLTP (3 databases), and OLAP (4 databases)
processes, the server performs okey but we have this issue:
Our MSDB grows about 150% weekly the only "solution" we have found is to
stop restart services in order to get MSDB small againg.
We execute on a daily basis arround 22 big DTS from AS400 (Jd Edwards) to
get our OLAP solution updated, also a daily full backup is executed (to
disk) for all databases including master and msdb.
We have executed the following tip with no results.
[b]You can remove old backup and restore records from the MSDB database
by
running the sp_delete_backuphistory stored procedure, like this
USE msdb
EXEC sp_delete_backuphistory '01/01/00'[/b]
If anyone have had this solved with a better solution instead of stopping
restarting services Ill be very gratefull at you.!!!
RegardsChristian,
Are the DTS packages updated often? These and their many versions are stored
in msdb. Look at sysdtspackages table. If you do not delete the previous
version and keep adding new versions this will fill msdb.
Chris Wood
Alberta Department of Energy
CANADA
"Christian A. Tello" <ctello@.oiecuador.com.ec> wrote in message
news:uZNZVJ%23GEHA.2416@.TK2MSFTNGP12.phx.gbl...
> Hello All.
> We have a problem with our SQL Server it is a 4 processor 2 Gb RAM, 8 HD
> 72.2 SCSI Hot Plug Server
> We run over this server OLTP (3 databases), and OLAP (4 databases)
> processes, the server performs okey but we have this issue:
> Our MSDB grows about 150% weekly the only "solution" we have found is to
> stop restart services in order to get MSDB small againg.
> We execute on a daily basis arround 22 big DTS from AS400 (Jd Edwards) to
> get our OLAP solution updated, also a daily full backup is executed (to
> disk) for all databases including master and msdb.
> We have executed the following tip with no results.
> [b]You can remove old backup and restore records from the MSDB databas
e by
> running the sp_delete_backuphistory stored procedure, like this
> USE msdb
> EXEC sp_delete_backuphistory '01/01/00'[/b]
>
> If anyone have had this solved with a better solution instead of stopping
> restarting services Ill be very gratefull at you.!!!
> Regards
>|||Thanks Chris
In fact we did that 8 or 9 weeks ago we deleted all versions. We modify
the certain DTS 4 times a month. At this time we have 94 rows within the
sysdtspackages table. We have 28 DTSs.
Any other ideas?
Thanks again
****************************************
Christian,
Are the DTS packages updated often? These and their many versions are
stored
in msdb. Look at sysdtspackages table. If you do not delete the previous
version and keep adding new versions this will fill msdb.
Chris Wood
Alberta Department of Energy
CANADA
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!
MSDB Growing Weekly
Hello All.
We have a problem with our SQL Server it is a 4 processor 2 Gb RAM, 8 HD
72.2 SCSI Hot Plug Server
We run over this server OLTP (3 databases), and OLAP (4 databases)
processes, the server performs okey but we have this issue:
Our MSDB grows about 150% weekly the only "solution" we have found is to
stop restart services in order to get MSDB small againg.
We execute on a daily basis arround 22 big DTS from AS400 (Jd Edwards) to
get our OLAP solution updated, also a daily full backup is executed (to
disk) for all databases including master and msdb.
We have executed the following tip with no results.
You can remove old backup and restore records from the MSDB database by
running the sp_delete_backuphistory stored procedure, like this
USE msdb
EXEC sp_delete_backuphistory '01/01/00'
If anyone have had this solved with a better solution instead of stopping
restarting services Ill be very gratefull at you.!!!
Regards
Christian,
Are the DTS packages updated often? These and their many versions are stored
in msdb. Look at sysdtspackages table. If you do not delete the previous
version and keep adding new versions this will fill msdb.
Chris Wood
Alberta Department of Energy
CANADA
"Christian A. Tello" <ctello@.oiecuador.com.ec> wrote in message
news:uZNZVJ%23GEHA.2416@.TK2MSFTNGP12.phx.gbl...
> Hello All.
> We have a problem with our SQL Server it is a 4 processor 2 Gb RAM, 8 HD
> 72.2 SCSI Hot Plug Server
> We run over this server OLTP (3 databases), and OLAP (4 databases)
> processes, the server performs okey but we have this issue:
> Our MSDB grows about 150% weekly the only "solution" we have found is to
> stop restart services in order to get MSDB small againg.
> We execute on a daily basis arround 22 big DTS from AS400 (Jd Edwards) to
> get our OLAP solution updated, also a daily full backup is executed (to
> disk) for all databases including master and msdb.
> We have executed the following tip with no results.
> You can remove old backup and restore records from the MSDB database by
> running the sp_delete_backuphistory stored procedure, like this
> USE msdb
> EXEC sp_delete_backuphistory '01/01/00'
>
> If anyone have had this solved with a better solution instead of stopping
> restarting services Ill be very gratefull at you.!!!
> Regards
>
We have a problem with our SQL Server it is a 4 processor 2 Gb RAM, 8 HD
72.2 SCSI Hot Plug Server
We run over this server OLTP (3 databases), and OLAP (4 databases)
processes, the server performs okey but we have this issue:
Our MSDB grows about 150% weekly the only "solution" we have found is to
stop restart services in order to get MSDB small againg.
We execute on a daily basis arround 22 big DTS from AS400 (Jd Edwards) to
get our OLAP solution updated, also a daily full backup is executed (to
disk) for all databases including master and msdb.
We have executed the following tip with no results.
You can remove old backup and restore records from the MSDB database by
running the sp_delete_backuphistory stored procedure, like this
USE msdb
EXEC sp_delete_backuphistory '01/01/00'
If anyone have had this solved with a better solution instead of stopping
restarting services Ill be very gratefull at you.!!!
Regards
Christian,
Are the DTS packages updated often? These and their many versions are stored
in msdb. Look at sysdtspackages table. If you do not delete the previous
version and keep adding new versions this will fill msdb.
Chris Wood
Alberta Department of Energy
CANADA
"Christian A. Tello" <ctello@.oiecuador.com.ec> wrote in message
news:uZNZVJ%23GEHA.2416@.TK2MSFTNGP12.phx.gbl...
> Hello All.
> We have a problem with our SQL Server it is a 4 processor 2 Gb RAM, 8 HD
> 72.2 SCSI Hot Plug Server
> We run over this server OLTP (3 databases), and OLAP (4 databases)
> processes, the server performs okey but we have this issue:
> Our MSDB grows about 150% weekly the only "solution" we have found is to
> stop restart services in order to get MSDB small againg.
> We execute on a daily basis arround 22 big DTS from AS400 (Jd Edwards) to
> get our OLAP solution updated, also a daily full backup is executed (to
> disk) for all databases including master and msdb.
> We have executed the following tip with no results.
> You can remove old backup and restore records from the MSDB database by
> running the sp_delete_backuphistory stored procedure, like this
> USE msdb
> EXEC sp_delete_backuphistory '01/01/00'
>
> If anyone have had this solved with a better solution instead of stopping
> restarting services Ill be very gratefull at you.!!!
> Regards
>
MSDB Backup Fails on SQL Server 7.0
I'm having the following problem with the backup I have running on our
SQL Server. I have it scheduled to run once a week and when I check
the event viewer I see the following:
SQL Server Scheduled Job 'msdb backup'
(0x1DA8D66C8D076D4D973B1AF97C122CA7) - Status: Failed - Invoked on:
8/13/2006 12:00:00 AM - Message: The job failed. The Job was invoked
by Schedule 4209 (Schedule 1). The last step to run was step 1 (Step
1).
Event ID: 208
The script I'm using for my backup is as follows:
BACKUP DATABASE [msdb] TO [H:\SQLServerBackUpNBR] WITH NOINIT ,
NOUNLOAD , NAME = N'msdb backup', SKIP , STATS = 10, NOFORMAT
DECLARE @.i INT
select @.i = position from msdb..backupset where database_name='msdb'and
type!='F' and backup_set_id=(select max(backup_set_id) from
msdb..backupset where database_name='msdb')
RESTORE VERIFYONLY FROM [H:\SQLServerBackUpNBR] WITH FILE = @.iCan you post the Error / message from the step 1: of this job. That
probability gives more info. regarding the failure.
-Saravanan
"Creative" <GraberJ@.gmail.com> wrote in message
news:1155651035.260790.231840@.i42g2000cwa.googlegroups.com...
> I'm having the following problem with the backup I have running on our
> SQL Server. I have it scheduled to run once a week and when I check
> the event viewer I see the following:
> SQL Server Scheduled Job 'msdb backup'
> (0x1DA8D66C8D076D4D973B1AF97C122CA7) - Status: Failed - Invoked on:
> 8/13/2006 12:00:00 AM - Message: The job failed. The Job was invoked
> by Schedule 4209 (Schedule 1). The last step to run was step 1 (Step
> 1).
> Event ID: 208
> The script I'm using for my backup is as follows:
> BACKUP DATABASE [msdb] TO [H:\SQLServerBackUpNBR] WITH NOINIT ,
> NOUNLOAD , NAME = N'msdb backup', SKIP , STATS = 10, NOFORMAT
> DECLARE @.i INT
> select @.i = position from msdb..backupset where database_name='msdb'and
> type!='F' and backup_set_id=(select max(backup_set_id) from
> msdb..backupset where database_name='msdb')
> RESTORE VERIFYONLY FROM [H:\SQLServerBackUpNBR] WITH FILE = @.i
>|||Are you referring to within SQL Server? Sorry I'm a little new at
troubleshooting SQL Server and I'm not sure where the error message is
you're looking for. All I can find is the one in the Event Viewer that
I posted below and the other is when I view Job History I see "The job
failed. The Job was invoked by Schedule 4209 (Schedule 1). The last
step to run was step 1 (Step 1)." which tells me nothing.
If this isn't what you wanted please tell me where to find what you are
referring to.
Thanks
Saravanan Palanivelu wrote:
> Can you post the Error / message from the step 1: of this job. That
> probability gives more info. regarding the failure.
>
> -Saravanan
>
> "Creative" <GraberJ@.gmail.com> wrote in message
> news:1155651035.260790.231840@.i42g2000cwa.googlegroups.com...
> > I'm having the following problem with the backup I have running on our
> > SQL Server. I have it scheduled to run once a week and when I check
> > the event viewer I see the following:
> >
> > SQL Server Scheduled Job 'msdb backup'
> > (0x1DA8D66C8D076D4D973B1AF97C122CA7) - Status: Failed - Invoked on:
> > 8/13/2006 12:00:00 AM - Message: The job failed. The Job was invoked
> > by Schedule 4209 (Schedule 1). The last step to run was step 1 (Step
> > 1).
> >
> > Event ID: 208
> >
> > The script I'm using for my backup is as follows:
> >
> > BACKUP DATABASE [msdb] TO [H:\SQLServerBackUpNBR] WITH NOINIT ,
> > NOUNLOAD , NAME = N'msdb backup', SKIP , STATS = 10, NOFORMAT
> > DECLARE @.i INT
> > select @.i = position from msdb..backupset where database_name='msdb'and
> > type!='F' and backup_set_id=(select max(backup_set_id) from
> > msdb..backupset where database_name='msdb')
> > RESTORE VERIFYONLY FROM [H:\SQLServerBackUpNBR] WITH FILE = @.i
> >|||Ok here is the error message from the Job History File. Any
suggestions would be appreciated.
No entry in sysdevices for backup device 'H:\SQLServerBackUpNBR'.
Update sysdevices and rerun statement. [SQLSTATE 42000] (Error 3206)
Backup or restore operation terminating abnormally. [SQLSTATE 42000]
(Error 3013) Associated statement is not prepared [SQLSTATE HY007]
(Error 0) No entry in sysdevices for backup device
'H:\SQLServerBackUpNBR'. Update sysdevices and rerun statement.
[SQLSTATE 42000] (Error 3206) Backup or restore operation terminating
abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
Creative wrote:
> Are you referring to within SQL Server? Sorry I'm a little new at
> troubleshooting SQL Server and I'm not sure where the error message is
> you're looking for. All I can find is the one in the Event Viewer that
> I posted below and the other is when I view Job History I see "The job
> failed. The Job was invoked by Schedule 4209 (Schedule 1). The last
> step to run was step 1 (Step 1)." which tells me nothing.
> If this isn't what you wanted please tell me where to find what you are
> referring to.
> Thanks
>
> Saravanan Palanivelu wrote:
> > Can you post the Error / message from the step 1: of this job. That
> > probability gives more info. regarding the failure.
> >
> >
> >
> > -Saravanan
> >
> >
> >
> > "Creative" <GraberJ@.gmail.com> wrote in message
> > news:1155651035.260790.231840@.i42g2000cwa.googlegroups.com...
> > > I'm having the following problem with the backup I have running on our
> > > SQL Server. I have it scheduled to run once a week and when I check
> > > the event viewer I see the following:
> > >
> > > SQL Server Scheduled Job 'msdb backup'
> > > (0x1DA8D66C8D076D4D973B1AF97C122CA7) - Status: Failed - Invoked on:
> > > 8/13/2006 12:00:00 AM - Message: The job failed. The Job was invoked
> > > by Schedule 4209 (Schedule 1). The last step to run was step 1 (Step
> > > 1).
> > >
> > > Event ID: 208
> > >
> > > The script I'm using for my backup is as follows:
> > >
> > > BACKUP DATABASE [msdb] TO [H:\SQLServerBackUpNBR] WITH NOINIT ,
> > > NOUNLOAD , NAME = N'msdb backup', SKIP , STATS = 10, NOFORMAT
> > > DECLARE @.i INT
> > > select @.i = position from msdb..backupset where database_name='msdb'and
> > > type!='F' and backup_set_id=(select max(backup_set_id) from
> > > msdb..backupset where database_name='msdb')
> > > RESTORE VERIFYONLY FROM [H:\SQLServerBackUpNBR] WITH FILE = @.i
> > >
SQL Server. I have it scheduled to run once a week and when I check
the event viewer I see the following:
SQL Server Scheduled Job 'msdb backup'
(0x1DA8D66C8D076D4D973B1AF97C122CA7) - Status: Failed - Invoked on:
8/13/2006 12:00:00 AM - Message: The job failed. The Job was invoked
by Schedule 4209 (Schedule 1). The last step to run was step 1 (Step
1).
Event ID: 208
The script I'm using for my backup is as follows:
BACKUP DATABASE [msdb] TO [H:\SQLServerBackUpNBR] WITH NOINIT ,
NOUNLOAD , NAME = N'msdb backup', SKIP , STATS = 10, NOFORMAT
DECLARE @.i INT
select @.i = position from msdb..backupset where database_name='msdb'and
type!='F' and backup_set_id=(select max(backup_set_id) from
msdb..backupset where database_name='msdb')
RESTORE VERIFYONLY FROM [H:\SQLServerBackUpNBR] WITH FILE = @.iCan you post the Error / message from the step 1: of this job. That
probability gives more info. regarding the failure.
-Saravanan
"Creative" <GraberJ@.gmail.com> wrote in message
news:1155651035.260790.231840@.i42g2000cwa.googlegroups.com...
> I'm having the following problem with the backup I have running on our
> SQL Server. I have it scheduled to run once a week and when I check
> the event viewer I see the following:
> SQL Server Scheduled Job 'msdb backup'
> (0x1DA8D66C8D076D4D973B1AF97C122CA7) - Status: Failed - Invoked on:
> 8/13/2006 12:00:00 AM - Message: The job failed. The Job was invoked
> by Schedule 4209 (Schedule 1). The last step to run was step 1 (Step
> 1).
> Event ID: 208
> The script I'm using for my backup is as follows:
> BACKUP DATABASE [msdb] TO [H:\SQLServerBackUpNBR] WITH NOINIT ,
> NOUNLOAD , NAME = N'msdb backup', SKIP , STATS = 10, NOFORMAT
> DECLARE @.i INT
> select @.i = position from msdb..backupset where database_name='msdb'and
> type!='F' and backup_set_id=(select max(backup_set_id) from
> msdb..backupset where database_name='msdb')
> RESTORE VERIFYONLY FROM [H:\SQLServerBackUpNBR] WITH FILE = @.i
>|||Are you referring to within SQL Server? Sorry I'm a little new at
troubleshooting SQL Server and I'm not sure where the error message is
you're looking for. All I can find is the one in the Event Viewer that
I posted below and the other is when I view Job History I see "The job
failed. The Job was invoked by Schedule 4209 (Schedule 1). The last
step to run was step 1 (Step 1)." which tells me nothing.
If this isn't what you wanted please tell me where to find what you are
referring to.
Thanks
Saravanan Palanivelu wrote:
> Can you post the Error / message from the step 1: of this job. That
> probability gives more info. regarding the failure.
>
> -Saravanan
>
> "Creative" <GraberJ@.gmail.com> wrote in message
> news:1155651035.260790.231840@.i42g2000cwa.googlegroups.com...
> > I'm having the following problem with the backup I have running on our
> > SQL Server. I have it scheduled to run once a week and when I check
> > the event viewer I see the following:
> >
> > SQL Server Scheduled Job 'msdb backup'
> > (0x1DA8D66C8D076D4D973B1AF97C122CA7) - Status: Failed - Invoked on:
> > 8/13/2006 12:00:00 AM - Message: The job failed. The Job was invoked
> > by Schedule 4209 (Schedule 1). The last step to run was step 1 (Step
> > 1).
> >
> > Event ID: 208
> >
> > The script I'm using for my backup is as follows:
> >
> > BACKUP DATABASE [msdb] TO [H:\SQLServerBackUpNBR] WITH NOINIT ,
> > NOUNLOAD , NAME = N'msdb backup', SKIP , STATS = 10, NOFORMAT
> > DECLARE @.i INT
> > select @.i = position from msdb..backupset where database_name='msdb'and
> > type!='F' and backup_set_id=(select max(backup_set_id) from
> > msdb..backupset where database_name='msdb')
> > RESTORE VERIFYONLY FROM [H:\SQLServerBackUpNBR] WITH FILE = @.i
> >|||Ok here is the error message from the Job History File. Any
suggestions would be appreciated.
No entry in sysdevices for backup device 'H:\SQLServerBackUpNBR'.
Update sysdevices and rerun statement. [SQLSTATE 42000] (Error 3206)
Backup or restore operation terminating abnormally. [SQLSTATE 42000]
(Error 3013) Associated statement is not prepared [SQLSTATE HY007]
(Error 0) No entry in sysdevices for backup device
'H:\SQLServerBackUpNBR'. Update sysdevices and rerun statement.
[SQLSTATE 42000] (Error 3206) Backup or restore operation terminating
abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
Creative wrote:
> Are you referring to within SQL Server? Sorry I'm a little new at
> troubleshooting SQL Server and I'm not sure where the error message is
> you're looking for. All I can find is the one in the Event Viewer that
> I posted below and the other is when I view Job History I see "The job
> failed. The Job was invoked by Schedule 4209 (Schedule 1). The last
> step to run was step 1 (Step 1)." which tells me nothing.
> If this isn't what you wanted please tell me where to find what you are
> referring to.
> Thanks
>
> Saravanan Palanivelu wrote:
> > Can you post the Error / message from the step 1: of this job. That
> > probability gives more info. regarding the failure.
> >
> >
> >
> > -Saravanan
> >
> >
> >
> > "Creative" <GraberJ@.gmail.com> wrote in message
> > news:1155651035.260790.231840@.i42g2000cwa.googlegroups.com...
> > > I'm having the following problem with the backup I have running on our
> > > SQL Server. I have it scheduled to run once a week and when I check
> > > the event viewer I see the following:
> > >
> > > SQL Server Scheduled Job 'msdb backup'
> > > (0x1DA8D66C8D076D4D973B1AF97C122CA7) - Status: Failed - Invoked on:
> > > 8/13/2006 12:00:00 AM - Message: The job failed. The Job was invoked
> > > by Schedule 4209 (Schedule 1). The last step to run was step 1 (Step
> > > 1).
> > >
> > > Event ID: 208
> > >
> > > The script I'm using for my backup is as follows:
> > >
> > > BACKUP DATABASE [msdb] TO [H:\SQLServerBackUpNBR] WITH NOINIT ,
> > > NOUNLOAD , NAME = N'msdb backup', SKIP , STATS = 10, NOFORMAT
> > > DECLARE @.i INT
> > > select @.i = position from msdb..backupset where database_name='msdb'and
> > > type!='F' and backup_set_id=(select max(backup_set_id) from
> > > msdb..backupset where database_name='msdb')
> > > RESTORE VERIFYONLY FROM [H:\SQLServerBackUpNBR] WITH FILE = @.i
> > >
MSDB Backup Fails on SQL Server 7.0
I'm having the following problem with the backup I have running on our
SQL Server. I have it scheduled to run once a week and when I check
the event viewer I see the following:
SQL Server Scheduled Job 'msdb backup'
(0x1DA8D66C8D076D4D973B1AF97C122CA7) - Status: Failed - Invoked on:
8/13/2006 12:00:00 AM - Message: The job failed. The Job was invoked
by Schedule 4209 (Schedule 1). The last step to run was step 1 (Step
1).
Event ID: 208
The script I'm using for my backup is as follows:
BACKUP DATABASE [msdb] TO [H:\SQLServerBackUpNBR] WITH NOINIT ,
NOUNLOAD , NAME = N'msdb backup', SKIP , STATS = 10, NOFORMAT
DECLARE @.i INT
select @.i = position from msdb..backupset where database_name='msdb'and
type!='F' and backup_set_id=(select max(backup_set_id) from
msdb..backupset where database_name='msdb')
RESTORE VERIFYONLY FROM [H:\SQLServerBackUpNBR] WITH FILE = @.iCan you post the Error / message from the step 1: of this job. That
probability gives more info. regarding the failure.
-Saravanan
"Creative" <GraberJ@.gmail.com> wrote in message
news:1155651035.260790.231840@.i42g2000cwa.googlegroups.com...
> I'm having the following problem with the backup I have running on our
> SQL Server. I have it scheduled to run once a week and when I check
> the event viewer I see the following:
> SQL Server Scheduled Job 'msdb backup'
> (0x1DA8D66C8D076D4D973B1AF97C122CA7) - Status: Failed - Invoked on:
> 8/13/2006 12:00:00 AM - Message: The job failed. The Job was invoked
> by Schedule 4209 (Schedule 1). The last step to run was step 1 (Step
> 1).
> Event ID: 208
> The script I'm using for my backup is as follows:
> BACKUP DATABASE [msdb] TO [H:\SQLServerBackUpNBR] WITH NOINIT ,
> NOUNLOAD , NAME = N'msdb backup', SKIP , STATS = 10, NOFORMAT
> DECLARE @.i INT
> select @.i = position from msdb..backupset where database_name='msdb'and
> type!='F' and backup_set_id=(select max(backup_set_id) from
> msdb..backupset where database_name='msdb')
> RESTORE VERIFYONLY FROM [H:\SQLServerBackUpNBR] WITH FILE = @.i
>|||Are you referring to within SQL Server? Sorry I'm a little new at
troubleshooting SQL Server and I'm not sure where the error message is
you're looking for. All I can find is the one in the Event Viewer that
I posted below and the other is when I view Job History I see "The job
failed. The Job was invoked by Schedule 4209 (Schedule 1). The last
step to run was step 1 (Step 1)." which tells me nothing.
If this isn't what you wanted please tell me where to find what you are
referring to.
Thanks
Saravanan Palanivelu wrote:[vbcol=seagreen]
> Can you post the Error / message from the step 1: of this job. That
> probability gives more info. regarding the failure.
>
> -Saravanan
>
> "Creative" <GraberJ@.gmail.com> wrote in message
> news:1155651035.260790.231840@.i42g2000cwa.googlegroups.com...|||Ok here is the error message from the Job History File. Any
suggestions would be appreciated.
No entry in sysdevices for backup device 'H:\SQLServerBackUpNBR'.
Update sysdevices and rerun statement. [SQLSTATE 42000] (Error 3206)
Backup or restore operation terminating abnormally. [SQLSTATE 42000]
(Error 3013) Associated statement is not prepared [SQLSTATE HY007]
(Error 0) No entry in sysdevices for backup device
'H:\SQLServerBackUpNBR'. Update sysdevices and rerun statement.
[SQLSTATE 42000] (Error 3206) Backup or restore operation terminating
abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
Creative wrote:[vbcol=seagreen]
> Are you referring to within SQL Server? Sorry I'm a little new at
> troubleshooting SQL Server and I'm not sure where the error message is
> you're looking for. All I can find is the one in the Event Viewer that
> I posted below and the other is when I view Job History I see "The job
> failed. The Job was invoked by Schedule 4209 (Schedule 1). The last
> step to run was step 1 (Step 1)." which tells me nothing.
> If this isn't what you wanted please tell me where to find what you are
> referring to.
> Thanks
>
> Saravanan Palanivelu wrote:
SQL Server. I have it scheduled to run once a week and when I check
the event viewer I see the following:
SQL Server Scheduled Job 'msdb backup'
(0x1DA8D66C8D076D4D973B1AF97C122CA7) - Status: Failed - Invoked on:
8/13/2006 12:00:00 AM - Message: The job failed. The Job was invoked
by Schedule 4209 (Schedule 1). The last step to run was step 1 (Step
1).
Event ID: 208
The script I'm using for my backup is as follows:
BACKUP DATABASE [msdb] TO [H:\SQLServerBackUpNBR] WITH NOINIT ,
NOUNLOAD , NAME = N'msdb backup', SKIP , STATS = 10, NOFORMAT
DECLARE @.i INT
select @.i = position from msdb..backupset where database_name='msdb'and
type!='F' and backup_set_id=(select max(backup_set_id) from
msdb..backupset where database_name='msdb')
RESTORE VERIFYONLY FROM [H:\SQLServerBackUpNBR] WITH FILE = @.iCan you post the Error / message from the step 1: of this job. That
probability gives more info. regarding the failure.
-Saravanan
"Creative" <GraberJ@.gmail.com> wrote in message
news:1155651035.260790.231840@.i42g2000cwa.googlegroups.com...
> I'm having the following problem with the backup I have running on our
> SQL Server. I have it scheduled to run once a week and when I check
> the event viewer I see the following:
> SQL Server Scheduled Job 'msdb backup'
> (0x1DA8D66C8D076D4D973B1AF97C122CA7) - Status: Failed - Invoked on:
> 8/13/2006 12:00:00 AM - Message: The job failed. The Job was invoked
> by Schedule 4209 (Schedule 1). The last step to run was step 1 (Step
> 1).
> Event ID: 208
> The script I'm using for my backup is as follows:
> BACKUP DATABASE [msdb] TO [H:\SQLServerBackUpNBR] WITH NOINIT ,
> NOUNLOAD , NAME = N'msdb backup', SKIP , STATS = 10, NOFORMAT
> DECLARE @.i INT
> select @.i = position from msdb..backupset where database_name='msdb'and
> type!='F' and backup_set_id=(select max(backup_set_id) from
> msdb..backupset where database_name='msdb')
> RESTORE VERIFYONLY FROM [H:\SQLServerBackUpNBR] WITH FILE = @.i
>|||Are you referring to within SQL Server? Sorry I'm a little new at
troubleshooting SQL Server and I'm not sure where the error message is
you're looking for. All I can find is the one in the Event Viewer that
I posted below and the other is when I view Job History I see "The job
failed. The Job was invoked by Schedule 4209 (Schedule 1). The last
step to run was step 1 (Step 1)." which tells me nothing.
If this isn't what you wanted please tell me where to find what you are
referring to.
Thanks
Saravanan Palanivelu wrote:[vbcol=seagreen]
> Can you post the Error / message from the step 1: of this job. That
> probability gives more info. regarding the failure.
>
> -Saravanan
>
> "Creative" <GraberJ@.gmail.com> wrote in message
> news:1155651035.260790.231840@.i42g2000cwa.googlegroups.com...|||Ok here is the error message from the Job History File. Any
suggestions would be appreciated.
No entry in sysdevices for backup device 'H:\SQLServerBackUpNBR'.
Update sysdevices and rerun statement. [SQLSTATE 42000] (Error 3206)
Backup or restore operation terminating abnormally. [SQLSTATE 42000]
(Error 3013) Associated statement is not prepared [SQLSTATE HY007]
(Error 0) No entry in sysdevices for backup device
'H:\SQLServerBackUpNBR'. Update sysdevices and rerun statement.
[SQLSTATE 42000] (Error 3206) Backup or restore operation terminating
abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
Creative wrote:[vbcol=seagreen]
> Are you referring to within SQL Server? Sorry I'm a little new at
> troubleshooting SQL Server and I'm not sure where the error message is
> you're looking for. All I can find is the one in the Event Viewer that
> I posted below and the other is when I view Job History I see "The job
> failed. The Job was invoked by Schedule 4209 (Schedule 1). The last
> step to run was step 1 (Step 1)." which tells me nothing.
> If this isn't what you wanted please tell me where to find what you are
> referring to.
> Thanks
>
> Saravanan Palanivelu wrote:
MSDB and PUBS Databases
We are running SQL 2000 Enterprise Edition on Windows 2003 Standard Server.
We setup a SQL backup to run under SQL. We got the messages in the report.
It said "backup cannot be performed on database 'msdb'. This subtask is
ignored." and "Backup cannot be performed on database 'pubs'. This subtask
is ignored". Is it necessary to backup msdb and pubs databases? Thanks.Hi Diane
My guess is that this error is occurring when you try to back up the
transaction log of these databases, as they are in simple mode and the log
cannot be backed up.
Pubs is a sample database used in the documentation examples, and can be
easily rebuilt. It should never need to be backed up at all. MSDB should be
backed up so you can restore information about your tasks, jobs, alerts and
backup history. But you may be backing up the full database already and it
may only be the log backup that is failing.
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:utYsaWJOGHA.2472@.TK2MSFTNGP11.phx.gbl...
> We are running SQL 2000 Enterprise Edition on Windows 2003 Standard
> Server. We setup a SQL backup to run under SQL. We got the messages in
> the report. It said "backup cannot be performed on database 'msdb'. This
> subtask is ignored." and "Backup cannot be performed on database 'pubs'.
> This subtask is ignored". Is it necessary to backup msdb and pubs
> databases? Thanks.
>|||MSDB stores all you job as well as replication information, so backin
this up can save you lot of time in a disastery case. Pubs is jut a
sample database, if you want to you can leave this out, as you can
download the creation script somewhere on the MSDN space of microsoft.
HTH, Jens Suessmeyer.|||Thank you very much, Kalen for your prompt response.
Under Database Maintenance, a complete backup runs once a week and
transaction backup runs everyday. You are right. The error message comes
from the transaction log history. Do you suggest that I ignore the error
messages since I have a complete backup runs every week? I will uncheck the
backup for the PUBS database.
Thanks.
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:eyN$1mJOGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Hi Diane
> My guess is that this error is occurring when you try to back up the
> transaction log of these databases, as they are in simple mode and the log
> cannot be backed up.
> Pubs is a sample database used in the documentation examples, and can be
> easily rebuilt. It should never need to be backed up at all. MSDB should
> be backed up so you can restore information about your tasks, jobs, alerts
> and backup history. But you may be backing up the full database already
> and it may only be the log backup that is failing.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.solidqualitylearning.com
>
> "Diane Walker" <ett9300@.yahoo.com> wrote in message
> news:utYsaWJOGHA.2472@.TK2MSFTNGP11.phx.gbl...
>
>|||Thanks for your prompt response, Jens. I just unchecked the backup for the
PUBS database. Thanks.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1140713647.322715.266680@.g47g2000cwa.googlegroups.com...
> MSDB stores all you job as well as replication information, so backin
> this up can save you lot of time in a disastery case. Pubs is jut a
> sample database, if you want to you can leave this out, as you can
> download the creation script somewhere on the MSDN space of microsoft.
> HTH, Jens Suessmeyer.
>
We setup a SQL backup to run under SQL. We got the messages in the report.
It said "backup cannot be performed on database 'msdb'. This subtask is
ignored." and "Backup cannot be performed on database 'pubs'. This subtask
is ignored". Is it necessary to backup msdb and pubs databases? Thanks.Hi Diane
My guess is that this error is occurring when you try to back up the
transaction log of these databases, as they are in simple mode and the log
cannot be backed up.
Pubs is a sample database used in the documentation examples, and can be
easily rebuilt. It should never need to be backed up at all. MSDB should be
backed up so you can restore information about your tasks, jobs, alerts and
backup history. But you may be backing up the full database already and it
may only be the log backup that is failing.
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:utYsaWJOGHA.2472@.TK2MSFTNGP11.phx.gbl...
> We are running SQL 2000 Enterprise Edition on Windows 2003 Standard
> Server. We setup a SQL backup to run under SQL. We got the messages in
> the report. It said "backup cannot be performed on database 'msdb'. This
> subtask is ignored." and "Backup cannot be performed on database 'pubs'.
> This subtask is ignored". Is it necessary to backup msdb and pubs
> databases? Thanks.
>|||MSDB stores all you job as well as replication information, so backin
this up can save you lot of time in a disastery case. Pubs is jut a
sample database, if you want to you can leave this out, as you can
download the creation script somewhere on the MSDN space of microsoft.
HTH, Jens Suessmeyer.|||Thank you very much, Kalen for your prompt response.
Under Database Maintenance, a complete backup runs once a week and
transaction backup runs everyday. You are right. The error message comes
from the transaction log history. Do you suggest that I ignore the error
messages since I have a complete backup runs every week? I will uncheck the
backup for the PUBS database.
Thanks.
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:eyN$1mJOGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Hi Diane
> My guess is that this error is occurring when you try to back up the
> transaction log of these databases, as they are in simple mode and the log
> cannot be backed up.
> Pubs is a sample database used in the documentation examples, and can be
> easily rebuilt. It should never need to be backed up at all. MSDB should
> be backed up so you can restore information about your tasks, jobs, alerts
> and backup history. But you may be backing up the full database already
> and it may only be the log backup that is failing.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.solidqualitylearning.com
>
> "Diane Walker" <ett9300@.yahoo.com> wrote in message
> news:utYsaWJOGHA.2472@.TK2MSFTNGP11.phx.gbl...
>
>|||Thanks for your prompt response, Jens. I just unchecked the backup for the
PUBS database. Thanks.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1140713647.322715.266680@.g47g2000cwa.googlegroups.com...
> MSDB stores all you job as well as replication information, so backin
> this up can save you lot of time in a disastery case. Pubs is jut a
> sample database, if you want to you can leave this out, as you can
> download the creation script somewhere on the MSDN space of microsoft.
> HTH, Jens Suessmeyer.
>
MSDB and PUBS Databases
We are running SQL 2000 Enterprise Edition on Windows 2003 Standard Server.
We setup a SQL backup to run under SQL. We got the messages in the report.
It said "backup cannot be performed on database 'msdb'. This subtask is
ignored." and "Backup cannot be performed on database 'pubs'. This subtask
is ignored". Is it necessary to backup msdb and pubs databases? Thanks.
Hi Diane
My guess is that this error is occurring when you try to back up the
transaction log of these databases, as they are in simple mode and the log
cannot be backed up.
Pubs is a sample database used in the documentation examples, and can be
easily rebuilt. It should never need to be backed up at all. MSDB should be
backed up so you can restore information about your tasks, jobs, alerts and
backup history. But you may be backing up the full database already and it
may only be the log backup that is failing.
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:utYsaWJOGHA.2472@.TK2MSFTNGP11.phx.gbl...
> We are running SQL 2000 Enterprise Edition on Windows 2003 Standard
> Server. We setup a SQL backup to run under SQL. We got the messages in
> the report. It said "backup cannot be performed on database 'msdb'. This
> subtask is ignored." and "Backup cannot be performed on database 'pubs'.
> This subtask is ignored". Is it necessary to backup msdb and pubs
> databases? Thanks.
>
|||MSDB stores all you job as well as replication information, so backin
this up can save you lot of time in a disastery case. Pubs is jut a
sample database, if you want to you can leave this out, as you can
download the creation script somewhere on the MSDN space of microsoft.
HTH, Jens Suessmeyer.
|||Thank you very much, Kalen for your prompt response.
Under Database Maintenance, a complete backup runs once a week and
transaction backup runs everyday. You are right. The error message comes
from the transaction log history. Do you suggest that I ignore the error
messages since I have a complete backup runs every week? I will uncheck the
backup for the PUBS database.
Thanks.
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:eyN$1mJOGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Hi Diane
> My guess is that this error is occurring when you try to back up the
> transaction log of these databases, as they are in simple mode and the log
> cannot be backed up.
> Pubs is a sample database used in the documentation examples, and can be
> easily rebuilt. It should never need to be backed up at all. MSDB should
> be backed up so you can restore information about your tasks, jobs, alerts
> and backup history. But you may be backing up the full database already
> and it may only be the log backup that is failing.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.solidqualitylearning.com
>
> "Diane Walker" <ett9300@.yahoo.com> wrote in message
> news:utYsaWJOGHA.2472@.TK2MSFTNGP11.phx.gbl...
>
>
|||Thanks for your prompt response, Jens. I just unchecked the backup for the
PUBS database. Thanks.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1140713647.322715.266680@.g47g2000cwa.googlegr oups.com...
> MSDB stores all you job as well as replication information, so backin
> this up can save you lot of time in a disastery case. Pubs is jut a
> sample database, if you want to you can leave this out, as you can
> download the creation script somewhere on the MSDN space of microsoft.
> HTH, Jens Suessmeyer.
>
We setup a SQL backup to run under SQL. We got the messages in the report.
It said "backup cannot be performed on database 'msdb'. This subtask is
ignored." and "Backup cannot be performed on database 'pubs'. This subtask
is ignored". Is it necessary to backup msdb and pubs databases? Thanks.
Hi Diane
My guess is that this error is occurring when you try to back up the
transaction log of these databases, as they are in simple mode and the log
cannot be backed up.
Pubs is a sample database used in the documentation examples, and can be
easily rebuilt. It should never need to be backed up at all. MSDB should be
backed up so you can restore information about your tasks, jobs, alerts and
backup history. But you may be backing up the full database already and it
may only be the log backup that is failing.
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:utYsaWJOGHA.2472@.TK2MSFTNGP11.phx.gbl...
> We are running SQL 2000 Enterprise Edition on Windows 2003 Standard
> Server. We setup a SQL backup to run under SQL. We got the messages in
> the report. It said "backup cannot be performed on database 'msdb'. This
> subtask is ignored." and "Backup cannot be performed on database 'pubs'.
> This subtask is ignored". Is it necessary to backup msdb and pubs
> databases? Thanks.
>
|||MSDB stores all you job as well as replication information, so backin
this up can save you lot of time in a disastery case. Pubs is jut a
sample database, if you want to you can leave this out, as you can
download the creation script somewhere on the MSDN space of microsoft.
HTH, Jens Suessmeyer.
|||Thank you very much, Kalen for your prompt response.
Under Database Maintenance, a complete backup runs once a week and
transaction backup runs everyday. You are right. The error message comes
from the transaction log history. Do you suggest that I ignore the error
messages since I have a complete backup runs every week? I will uncheck the
backup for the PUBS database.
Thanks.
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:eyN$1mJOGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Hi Diane
> My guess is that this error is occurring when you try to back up the
> transaction log of these databases, as they are in simple mode and the log
> cannot be backed up.
> Pubs is a sample database used in the documentation examples, and can be
> easily rebuilt. It should never need to be backed up at all. MSDB should
> be backed up so you can restore information about your tasks, jobs, alerts
> and backup history. But you may be backing up the full database already
> and it may only be the log backup that is failing.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.solidqualitylearning.com
>
> "Diane Walker" <ett9300@.yahoo.com> wrote in message
> news:utYsaWJOGHA.2472@.TK2MSFTNGP11.phx.gbl...
>
>
|||Thanks for your prompt response, Jens. I just unchecked the backup for the
PUBS database. Thanks.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1140713647.322715.266680@.g47g2000cwa.googlegr oups.com...
> MSDB stores all you job as well as replication information, so backin
> this up can save you lot of time in a disastery case. Pubs is jut a
> sample database, if you want to you can leave this out, as you can
> download the creation script somewhere on the MSDN space of microsoft.
> HTH, Jens Suessmeyer.
>
MSDB and PUBS Databases
We are running SQL 2000 Enterprise Edition on Windows 2003 Standard Server.
We setup a SQL backup to run under SQL. We got the messages in the report.
It said "backup cannot be performed on database 'msdb'. This subtask is
ignored." and "Backup cannot be performed on database 'pubs'. This subtask
is ignored". Is it necessary to backup msdb and pubs databases? Thanks.MSDB stores all you job as well as replication information, so backin
this up can save you lot of time in a disastery case. Pubs is jut a
sample database, if you want to you can leave this out, as you can
download the creation script somewhere on the MSDN space of microsoft.
HTH, Jens Suessmeyer.|||Hi Diane
My guess is that this error is occurring when you try to back up the
transaction log of these databases, as they are in simple mode and the log
cannot be backed up.
Pubs is a sample database used in the documentation examples, and can be
easily rebuilt. It should never need to be backed up at all. MSDB should be
backed up so you can restore information about your tasks, jobs, alerts and
backup history. But you may be backing up the full database already and it
may only be the log backup that is failing.
--
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:utYsaWJOGHA.2472@.TK2MSFTNGP11.phx.gbl...
> We are running SQL 2000 Enterprise Edition on Windows 2003 Standard
> Server. We setup a SQL backup to run under SQL. We got the messages in
> the report. It said "backup cannot be performed on database 'msdb'. This
> subtask is ignored." and "Backup cannot be performed on database 'pubs'.
> This subtask is ignored". Is it necessary to backup msdb and pubs
> databases? Thanks.
>|||Thank you very much, Kalen for your prompt response.
Under Database Maintenance, a complete backup runs once a week and
transaction backup runs everyday. You are right. The error message comes
from the transaction log history. Do you suggest that I ignore the error
messages since I have a complete backup runs every week? I will uncheck the
backup for the PUBS database.
Thanks.
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:eyN$1mJOGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Hi Diane
> My guess is that this error is occurring when you try to back up the
> transaction log of these databases, as they are in simple mode and the log
> cannot be backed up.
> Pubs is a sample database used in the documentation examples, and can be
> easily rebuilt. It should never need to be backed up at all. MSDB should
> be backed up so you can restore information about your tasks, jobs, alerts
> and backup history. But you may be backing up the full database already
> and it may only be the log backup that is failing.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.solidqualitylearning.com
>
> "Diane Walker" <ett9300@.yahoo.com> wrote in message
> news:utYsaWJOGHA.2472@.TK2MSFTNGP11.phx.gbl...
>> We are running SQL 2000 Enterprise Edition on Windows 2003 Standard
>> Server. We setup a SQL backup to run under SQL. We got the messages in
>> the report. It said "backup cannot be performed on database 'msdb'. This
>> subtask is ignored." and "Backup cannot be performed on database 'pubs'.
>> This subtask is ignored". Is it necessary to backup msdb and pubs
>> databases? Thanks.
>>
>
>|||Thanks for your prompt response, Jens. I just unchecked the backup for the
PUBS database. Thanks.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1140713647.322715.266680@.g47g2000cwa.googlegroups.com...
> MSDB stores all you job as well as replication information, so backin
> this up can save you lot of time in a disastery case. Pubs is jut a
> sample database, if you want to you can leave this out, as you can
> download the creation script somewhere on the MSDN space of microsoft.
> HTH, Jens Suessmeyer.
>
We setup a SQL backup to run under SQL. We got the messages in the report.
It said "backup cannot be performed on database 'msdb'. This subtask is
ignored." and "Backup cannot be performed on database 'pubs'. This subtask
is ignored". Is it necessary to backup msdb and pubs databases? Thanks.MSDB stores all you job as well as replication information, so backin
this up can save you lot of time in a disastery case. Pubs is jut a
sample database, if you want to you can leave this out, as you can
download the creation script somewhere on the MSDN space of microsoft.
HTH, Jens Suessmeyer.|||Hi Diane
My guess is that this error is occurring when you try to back up the
transaction log of these databases, as they are in simple mode and the log
cannot be backed up.
Pubs is a sample database used in the documentation examples, and can be
easily rebuilt. It should never need to be backed up at all. MSDB should be
backed up so you can restore information about your tasks, jobs, alerts and
backup history. But you may be backing up the full database already and it
may only be the log backup that is failing.
--
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:utYsaWJOGHA.2472@.TK2MSFTNGP11.phx.gbl...
> We are running SQL 2000 Enterprise Edition on Windows 2003 Standard
> Server. We setup a SQL backup to run under SQL. We got the messages in
> the report. It said "backup cannot be performed on database 'msdb'. This
> subtask is ignored." and "Backup cannot be performed on database 'pubs'.
> This subtask is ignored". Is it necessary to backup msdb and pubs
> databases? Thanks.
>|||Thank you very much, Kalen for your prompt response.
Under Database Maintenance, a complete backup runs once a week and
transaction backup runs everyday. You are right. The error message comes
from the transaction log history. Do you suggest that I ignore the error
messages since I have a complete backup runs every week? I will uncheck the
backup for the PUBS database.
Thanks.
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:eyN$1mJOGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Hi Diane
> My guess is that this error is occurring when you try to back up the
> transaction log of these databases, as they are in simple mode and the log
> cannot be backed up.
> Pubs is a sample database used in the documentation examples, and can be
> easily rebuilt. It should never need to be backed up at all. MSDB should
> be backed up so you can restore information about your tasks, jobs, alerts
> and backup history. But you may be backing up the full database already
> and it may only be the log backup that is failing.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.solidqualitylearning.com
>
> "Diane Walker" <ett9300@.yahoo.com> wrote in message
> news:utYsaWJOGHA.2472@.TK2MSFTNGP11.phx.gbl...
>> We are running SQL 2000 Enterprise Edition on Windows 2003 Standard
>> Server. We setup a SQL backup to run under SQL. We got the messages in
>> the report. It said "backup cannot be performed on database 'msdb'. This
>> subtask is ignored." and "Backup cannot be performed on database 'pubs'.
>> This subtask is ignored". Is it necessary to backup msdb and pubs
>> databases? Thanks.
>>
>
>|||Thanks for your prompt response, Jens. I just unchecked the backup for the
PUBS database. Thanks.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1140713647.322715.266680@.g47g2000cwa.googlegroups.com...
> MSDB stores all you job as well as replication information, so backin
> this up can save you lot of time in a disastery case. Pubs is jut a
> sample database, if you want to you can leave this out, as you can
> download the creation script somewhere on the MSDN space of microsoft.
> HTH, Jens Suessmeyer.
>
Subscribe to:
Posts (Atom)