error 8985

Hi folks,
When I shrink database, the system raise error 8985: Could not locate file 'databasename_dat' in sysfiles.
Does anyone has experience to solve this error...?
thanks
Sjaiful BahriThis typically means that you've had a device (disk drive) go offline. There is rarely any way to recover unless you can either bring the device back online or restore a backup to another disk.

-PatP

Error 70038 on install Solved!

Hi all

I packaged .Net Framework & Sql Express with my setup project. When I attempt to install it on an XP (with SP2) system .Net Framework installs fine. The Sql Express gets about 25% of the way through then fails. Here's the content of the log file:

The following properties have been set:
Property: [AdminUser] = true {boolean}
Property: [ProcessorArchitecture] = Intel {string}
Property: [VersionNT] = 5.1.2 {version}
Running checks for package '.NET Framework 2.0', phase BuildList
Running external check with command line "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\dotnetfx\dotnetchk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'DotNetInstalled'
Reading value 'Version' of registry key 'HKLM\Software\Microsoft\Internet Explorer'
Read string value '6.0.2900.2180'
Setting value '6.0.2900.2180 {string}' for property 'IEVersion'
The following properties have been set for package '.NET Framework 2.0':
Property: [DotNetInstalled] = 1 {int}
Property: [IEVersion] = 6.0.2900.2180 {string}
Running checks for command 'dotnetfx\instmsia.exe'
Result of running operator 'ValueExists' on property 'VersionNT': true
Result of checks for command 'dotnetfx\instmsia.exe' is 'Bypass'
Running checks for command 'dotnetfx\WindowsInstaller-KB893803-v2-x86.exe'
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.0.3': false
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '3.0': true
Result of checks for command 'dotnetfx\WindowsInstaller-KB893803-v2-x86.exe' is 'Bypass'
Running checks for command 'dotnetfx\dotnetfx.exe'
Result of running operator 'ValueNotEqualTo' on property 'DotNetInstalled' and value '0': true
Result of checks for command 'dotnetfx\dotnetfx.exe' is 'Bypass'
'.NET Framework 2.0' RunCheck result: No Install Needed
Running checks for package 'SQL Server 2005 Express Edition', phase BuildList
Running external check with command line "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\SqlExpressChk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'SQLExpressInstalled'
The following properties have been set for package 'SQL Server 2005 Express Edition':
Property: [SQLExpressInstalled] = 1 {int}
Running checks for command 'SqlExpress\sqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionNT' and value '5.1': true
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Bypass'
Running checks for command 'SqlExpress\sqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1': false
Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1.2': false
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Install'
'SQL Server 2005 Express Edition' RunCheck result: Install Needed
EULA for components 'SQL Server 2005 Express Edition' was accepted.
Copying files to temporary directory "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\"
Copying from '\\.host\Shared Folders\G-CDRW\MovieCollection Setup\Debug\SqlExpress\sqlexpr32.exe' to 'C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\sqlexpr32.exe'
Running checks for package 'SQL Server 2005 Express Edition', phase BeforePackage
Running external check with command line "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\SqlExpressChk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'SQLExpressInstalled'
The following properties have been set for package 'SQL Server 2005 Express Edition':
Property: [SQLExpressInstalled] = 1 {int}
Running checks for command 'SqlExpress\sqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1': false
Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1.2': false
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Install'
'SQL Server 2005 Express Edition' RunCheck result: Install Needed
Verifying file integrity of C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\sqlexpr32.exe
WinVerifyTrust returned 0
File trusted
Installing using command line '"C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\sqlexpr32.exe" -q /norebootchk /qn reboot=ReallySuppress addlocal=all instancename=SQLEXPRESS SQLAUTOSTART=1'
Process exited with code 70038
Status of package 'SQL Server 2005 Express Edition' after install is 'InstallFailed'

--

Any ideas?

TIA

Gary

Hi Gary,

I got the same error today on my Win XP SP2 workstation. An update for the MSI installer to Version 3.1 helped. After that, SQLexpress could be installed correctly.

Have a nice day

Ralf.

|||Hi Ralf

Thanks for your posting. Works beautifully!

Gary|||

I also got the same error,

I see in the log

Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionNT' and value '5.1': true
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Bypass'
Running checks for command 'SqlExpress\sqlexpr32.exe'

In the package.xml file it states that:

<BypassIf Property="VersionNT" Compare="VersionGreaterThanOrEqualTo" Value="5.1"/>

Should this be there? Why would we bypass sql installation if VersionNT is >= 5.1?

Error 70038 on install Solved!

Hi all

I packaged .Net Framework & Sql Express with my setup project. When I attempt to install it on an XP (with SP2) system .Net Framework installs fine. The Sql Express gets about 25% of the way through then fails. Here's the content of the log file:

The following properties have been set:
Property: [AdminUser] = true {boolean}
Property: [ProcessorArchitecture] = Intel {string}
Property: [VersionNT] = 5.1.2 {version}
Running checks for package '.NET Framework 2.0', phase BuildList
Running external check with command line "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\dotnetfx\dotnetchk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'DotNetInstalled'
Reading value 'Version' of registry key 'HKLM\Software\Microsoft\Internet Explorer'
Read string value '6.0.2900.2180'
Setting value '6.0.2900.2180 {string}' for property 'IEVersion'
The following properties have been set for package '.NET Framework 2.0':
Property: [DotNetInstalled] = 1 {int}
Property: [IEVersion] = 6.0.2900.2180 {string}
Running checks for command 'dotnetfx\instmsia.exe'
Result of running operator 'ValueExists' on property 'VersionNT': true
Result of checks for command 'dotnetfx\instmsia.exe' is 'Bypass'
Running checks for command 'dotnetfx\WindowsInstaller-KB893803-v2-x86.exe'
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.0.3': false
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '3.0': true
Result of checks for command 'dotnetfx\WindowsInstaller-KB893803-v2-x86.exe' is 'Bypass'
Running checks for command 'dotnetfx\dotnetfx.exe'
Result of running operator 'ValueNotEqualTo' on property 'DotNetInstalled' and value '0': true
Result of checks for command 'dotnetfx\dotnetfx.exe' is 'Bypass'
'.NET Framework 2.0' RunCheck result: No Install Needed
Running checks for package 'SQL Server 2005 Express Edition', phase BuildList
Running external check with command line "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\SqlExpressChk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'SQLExpressInstalled'
The following properties have been set for package 'SQL Server 2005 Express Edition':
Property: [SQLExpressInstalled] = 1 {int}
Running checks for command 'SqlExpress\sqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionNT' and value '5.1': true
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Bypass'
Running checks for command 'SqlExpress\sqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1': false
Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1.2': false
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Install'
'SQL Server 2005 Express Edition' RunCheck result: Install Needed
EULA for components 'SQL Server 2005 Express Edition' was accepted.
Copying files to temporary directory "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\"
Copying from '\\.host\Shared Folders\G-CDRW\MovieCollection Setup\Debug\SqlExpress\sqlexpr32.exe' to 'C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\sqlexpr32.exe'
Running checks for package 'SQL Server 2005 Express Edition', phase BeforePackage
Running external check with command line "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\SqlExpressChk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'SQLExpressInstalled'
The following properties have been set for package 'SQL Server 2005 Express Edition':
Property: [SQLExpressInstalled] = 1 {int}
Running checks for command 'SqlExpress\sqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1': false
Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1.2': false
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Install'
'SQL Server 2005 Express Edition' RunCheck result: Install Needed
Verifying file integrity of C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\sqlexpr32.exe
WinVerifyTrust returned 0
File trusted
Installing using command line '"C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\sqlexpr32.exe" -q /norebootchk /qn reboot=ReallySuppress addlocal=all instancename=SQLEXPRESS SQLAUTOSTART=1'
Process exited with code 70038
Status of package 'SQL Server 2005 Express Edition' after install is 'InstallFailed'

--

Any ideas?

TIA

Gary

Hi Gary,

I got the same error today on my Win XP SP2 workstation. An update for the MSI installer to Version 3.1 helped. After that, SQLexpress could be installed correctly.

Have a nice day

Ralf.

|||Hi Ralf

Thanks for your posting. Works beautifully!

Gary|||

I also got the same error,

I see in the log

Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionNT' and value '5.1': true
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Bypass'
Running checks for command 'SqlExpress\sqlexpr32.exe'

In the package.xml file it states that:

<BypassIf Property="VersionNT" Compare="VersionGreaterThanOrEqualTo" Value="5.1"/>

Should this be there? Why would we bypass sql installation if VersionNT is >= 5.1?

Error 70038 on install

Hi all

I packaged .Net Framework & Sql Express with my setup project. When I attempt to install it on an XP (with SP2) system .Net Framework installs fine. The Sql Express gets about 25% of the way through then fails. Here's the content of the log file:

The following properties have been set:
Property: [AdminUser] = true {boolean}
Property: [ProcessorArchitecture] = Intel {string}
Property: [VersionNT] = 5.1.2 {version}
Running checks for package '.NET Framework 2.0', phase BuildList
Running external check with command line "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\dotnetfx\dotnetchk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'DotNetInstalled'
Reading value 'Version' of registry key 'HKLM\Software\Microsoft\Internet Explorer'
Read string value '6.0.2900.2180'
Setting value '6.0.2900.2180 {string}' for property 'IEVersion'
The following properties have been set for package '.NET Framework 2.0':
Property: [DotNetInstalled] = 1 {int}
Property: [IEVersion] = 6.0.2900.2180 {string}
Running checks for command 'dotnetfx\instmsia.exe'
Result of running operator 'ValueExists' on property 'VersionNT': true
Result of checks for command 'dotnetfx\instmsia.exe' is 'Bypass'
Running checks for command 'dotnetfx\WindowsInstaller-KB893803-v2-x86.exe'
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.0.3': false
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '3.0': true
Result of checks for command 'dotnetfx\WindowsInstaller-KB893803-v2-x86.exe' is 'Bypass'
Running checks for command 'dotnetfx\dotnetfx.exe'
Result of running operator 'ValueNotEqualTo' on property 'DotNetInstalled' and value '0': true
Result of checks for command 'dotnetfx\dotnetfx.exe' is 'Bypass'
'.NET Framework 2.0' RunCheck result: No Install Needed
Running checks for package 'SQL Server 2005 Express Edition', phase BuildList
Running external check with command line "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\SqlExpressChk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'SQLExpressInstalled'
The following properties have been set for package 'SQL Server 2005 Express Edition':
Property: [SQLExpressInstalled] = 1 {int}
Running checks for command 'SqlExpress\sqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionNT' and value '5.1': true
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Bypass'
Running checks for command 'SqlExpress\sqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1': false
Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1.2': false
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Install'
'SQL Server 2005 Express Edition' RunCheck result: Install Needed
EULA for components 'SQL Server 2005 Express Edition' was accepted.
Copying files to temporary directory "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\"
Copying from '\\.host\Shared Folders\G-CDRW\MovieCollection Setup\Debug\SqlExpress\sqlexpr32.exe' to 'C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\sqlexpr32.exe'
Running checks for package 'SQL Server 2005 Express Edition', phase BeforePackage
Running external check with command line "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\SqlExpressChk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'SQLExpressInstalled'
The following properties have been set for package 'SQL Server 2005 Express Edition':
Property: [SQLExpressInstalled] = 1 {int}
Running checks for command 'SqlExpress\sqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1': false
Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1.2': false
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Install'
'SQL Server 2005 Express Edition' RunCheck result: Install Needed
Verifying file integrity of C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\sqlexpr32.exe
WinVerifyTrust returned 0
File trusted
Installing using command line '"C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\sqlexpr32.exe" -q /norebootchk /qn reboot=ReallySuppress addlocal=all instancename=SQLEXPRESS SQLAUTOSTART=1'
Process exited with code 70038
Status of package 'SQL Server 2005 Express Edition' after install is 'InstallFailed'

--

Any ideas?

TIA

Gary

Hi Gary,

I got the same error today on my Win XP SP2 workstation. An update for the MSI installer to Version 3.1 helped. After that, SQLexpress could be installed correctly.

Have a nice day

Ralf.

|||Hi Ralf

Thanks for your posting. Works beautifully!

Gary|||

I also got the same error,

I see in the log

Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionNT' and value '5.1': true
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Bypass'
Running checks for command 'SqlExpress\sqlexpr32.exe'

In the package.xml file it states that:

<BypassIf Property="VersionNT" Compare="VersionGreaterThanOrEqualTo" Value="5.1"/>

Should this be there? Why would we bypass sql installation if VersionNT is >= 5.1?

Error 5123: CREATE FILE encountered operating system error 32

I'm moving a database from Server A to Server B. When I tried to restore
from the .BAK file in Enterprise Manager I got an error message about "Device
activation error. The physical filename...maybe incorrect. File...cannot be
restored to...Use WITH MOVE to identify a valid location for the file."
So I tried to restore from Query Analyzer with...
RESTORE FILELISTONLY
FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
RESTORE DATABASE USQL_Data
FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
WITH NORECOVERY,
MOVE 'usql_data' TO 'C:\Dennis\FY2004.mdf',
MOVE 'usql_log' TO 'C:\Dennis\FY2004.ldf'
The 2 files are physically restored as named in the MOVE statement. In
Enterprise Manager the restored database name does not show up in the console
root. I tried to attach the restored database but get an error message
"Error 5123: CREATE FILE encountered operating system error 32..."
What do I need to do to use the restored database in Enterprise Manager?
Dennis
> The 2 files are physically restored as named in the MOVE statement. In
> Enterprise Manager the restored database name does not show up in the console
> root.
Are you saying that the restore executed without error message but you didn't see the database in
EM? If so, it is most likely that you need to do refresh in EM to see the database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dennis" <Dennis@.discussions.microsoft.com> wrote in message
news:A47A4F39-4343-4BBE-AC3B-65CEBD957D6A@.microsoft.com...
> I'm moving a database from Server A to Server B. When I tried to restore
> from the .BAK file in Enterprise Manager I got an error message about "Device
> activation error. The physical filename...maybe incorrect. File...cannot be
> restored to...Use WITH MOVE to identify a valid location for the file."
> So I tried to restore from Query Analyzer with...
> RESTORE FILELISTONLY
> FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
> RESTORE DATABASE USQL_Data
> FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
> WITH NORECOVERY,
> MOVE 'usql_data' TO 'C:\Dennis\FY2004.mdf',
> MOVE 'usql_log' TO 'C:\Dennis\FY2004.ldf'
> The 2 files are physically restored as named in the MOVE statement. In
> Enterprise Manager the restored database name does not show up in the console
> root. I tried to attach the restored database but get an error message
> "Error 5123: CREATE FILE encountered operating system error 32..."
> What do I need to do to use the restored database in Enterprise Manager?
> --
> Dennis
|||Yes. The restore executed without error from Query Analyzer, but the
database didn't show up in EM console root after the restore. I tried a
refresh. Still didn't show up. I did get the restore to work through EM
since my first post. I copied and pasted the path from Windows Explorer
rather than typing it and it worked.
Dennis
"Tibor Karaszi" wrote:

> Are you saying that the restore executed without error message but you didn't see the database in
> EM? If so, it is most likely that you need to do refresh in EM to see the database.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Dennis" <Dennis@.discussions.microsoft.com> wrote in message
> news:A47A4F39-4343-4BBE-AC3B-65CEBD957D6A@.microsoft.com...
>
>

Error 5123: CREATE FILE encountered operating system error 32

I'm moving a database from Server A to Server B. When I tried to restore
from the .BAK file in Enterprise Manager I got an error message about "Devic
e
activation error. The physical filename...maybe incorrect. File...cannot b
e
restored to...Use WITH MOVE to identify a valid location for the file."
So I tried to restore from Query Analyzer with...
RESTORE FILELISTONLY
FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
RESTORE DATABASE USQL_Data
FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
WITH NORECOVERY,
MOVE 'usql_data' TO 'C:\Dennis\FY2004.mdf',
MOVE 'usql_log' TO 'C:\Dennis\FY2004.ldf'
The 2 files are physically restored as named in the MOVE statement. In
Enterprise Manager the restored database name does not show up in the consol
e
root. I tried to attach the restored database but get an error message
"Error 5123: CREATE FILE encountered operating system error 32..."
What do I need to do to use the restored database in Enterprise Manager?
Dennis> The 2 files are physically restored as named in the MOVE statement. In
> Enterprise Manager the restored database name does not show up in the cons
ole
> root.
Are you saying that the restore executed without error message but you didn'
t see the database in
EM? If so, it is most likely that you need to do refresh in EM to see the da
tabase.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dennis" <Dennis@.discussions.microsoft.com> wrote in message
news:A47A4F39-4343-4BBE-AC3B-65CEBD957D6A@.microsoft.com...
> I'm moving a database from Server A to Server B. When I tried to restore
> from the .BAK file in Enterprise Manager I got an error message about "Dev
ice
> activation error. The physical filename...maybe incorrect. File...cannot
be
> restored to...Use WITH MOVE to identify a valid location for the file."
> So I tried to restore from Query Analyzer with...
> RESTORE FILELISTONLY
> FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
> RESTORE DATABASE USQL_Data
> FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
> WITH NORECOVERY,
> MOVE 'usql_data' TO 'C:\Dennis\FY2004.mdf',
> MOVE 'usql_log' TO 'C:\Dennis\FY2004.ldf'
> The 2 files are physically restored as named in the MOVE statement. In
> Enterprise Manager the restored database name does not show up in the cons
ole
> root. I tried to attach the restored database but get an error message
> "Error 5123: CREATE FILE encountered operating system error 32..."
> What do I need to do to use the restored database in Enterprise Manager?
> --
> Dennis|||Yes. The restore executed without error from Query Analyzer, but the
database didn't show up in EM console root after the restore. I tried a
refresh. Still didn't show up. I did get the restore to work through EM
since my first post. I copied and pasted the path from Windows Explorer
rather than typing it and it worked.
--
Dennis
"Tibor Karaszi" wrote:

> Are you saying that the restore executed without error message but you did
n't see the database in
> EM? If so, it is most likely that you need to do refresh in EM to see the
database.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Dennis" <Dennis@.discussions.microsoft.com> wrote in message
> news:A47A4F39-4343-4BBE-AC3B-65CEBD957D6A@.microsoft.com...
>
>

Error 5123: CREATE FILE encountered operating system error 32

I'm moving a database from Server A to Server B. When I tried to restore
from the .BAK file in Enterprise Manager I got an error message about "Device
activation error. The physical filename...maybe incorrect. File...cannot be
restored to...Use WITH MOVE to identify a valid location for the file."
So I tried to restore from Query Analyzer with...
RESTORE FILELISTONLY
FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
RESTORE DATABASE USQL_Data
FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
WITH NORECOVERY,
MOVE 'usql_data' TO 'C:\Dennis\FY2004.mdf',
MOVE 'usql_log' TO 'C:\Dennis\FY2004.ldf'
The 2 files are physically restored as named in the MOVE statement. In
Enterprise Manager the restored database name does not show up in the console
root. I tried to attach the restored database but get an error message
"Error 5123: CREATE FILE encountered operating system error 32..."
What do I need to do to use the restored database in Enterprise Manager?
--
Dennis> The 2 files are physically restored as named in the MOVE statement. In
> Enterprise Manager the restored database name does not show up in the console
> root.
Are you saying that the restore executed without error message but you didn't see the database in
EM? If so, it is most likely that you need to do refresh in EM to see the database.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dennis" <Dennis@.discussions.microsoft.com> wrote in message
news:A47A4F39-4343-4BBE-AC3B-65CEBD957D6A@.microsoft.com...
> I'm moving a database from Server A to Server B. When I tried to restore
> from the .BAK file in Enterprise Manager I got an error message about "Device
> activation error. The physical filename...maybe incorrect. File...cannot be
> restored to...Use WITH MOVE to identify a valid location for the file."
> So I tried to restore from Query Analyzer with...
> RESTORE FILELISTONLY
> FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
> RESTORE DATABASE USQL_Data
> FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
> WITH NORECOVERY,
> MOVE 'usql_data' TO 'C:\Dennis\FY2004.mdf',
> MOVE 'usql_log' TO 'C:\Dennis\FY2004.ldf'
> The 2 files are physically restored as named in the MOVE statement. In
> Enterprise Manager the restored database name does not show up in the console
> root. I tried to attach the restored database but get an error message
> "Error 5123: CREATE FILE encountered operating system error 32..."
> What do I need to do to use the restored database in Enterprise Manager?
> --
> Dennis|||Yes. The restore executed without error from Query Analyzer, but the
database didn't show up in EM console root after the restore. I tried a
refresh. Still didn't show up. I did get the restore to work through EM
since my first post. I copied and pasted the path from Windows Explorer
rather than typing it and it worked.
--
Dennis
"Tibor Karaszi" wrote:
> > The 2 files are physically restored as named in the MOVE statement. In
> > Enterprise Manager the restored database name does not show up in the console
> > root.
> Are you saying that the restore executed without error message but you didn't see the database in
> EM? If so, it is most likely that you need to do refresh in EM to see the database.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Dennis" <Dennis@.discussions.microsoft.com> wrote in message
> news:A47A4F39-4343-4BBE-AC3B-65CEBD957D6A@.microsoft.com...
> > I'm moving a database from Server A to Server B. When I tried to restore
> > from the .BAK file in Enterprise Manager I got an error message about "Device
> > activation error. The physical filename...maybe incorrect. File...cannot be
> > restored to...Use WITH MOVE to identify a valid location for the file."
> >
> > So I tried to restore from Query Analyzer with...
> > RESTORE FILELISTONLY
> > FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
> >
> > RESTORE DATABASE USQL_Data
> > FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
> > WITH NORECOVERY,
> > MOVE 'usql_data' TO 'C:\Dennis\FY2004.mdf',
> > MOVE 'usql_log' TO 'C:\Dennis\FY2004.ldf'
> >
> > The 2 files are physically restored as named in the MOVE statement. In
> > Enterprise Manager the restored database name does not show up in the console
> > root. I tried to attach the restored database but get an error message
> > "Error 5123: CREATE FILE encountered operating system error 32..."
> >
> > What do I need to do to use the restored database in Enterprise Manager?
> >
> > --
> > Dennis
>
>

Error 5123 Operating System Error 32 on attaching a database

I have SQL Server loaded on my standalone laptop. I tried
to attach a database( xxx.MDF) and got an error as above.
How do I resolve this ?In your sp_attach_db statement, make sure the path to the
mdf, ldf files is correct.
Also, make sure the SQL Server service account has
permissions to the path, files that you are attaching.
-Sue
On Wed, 25 Feb 2004 10:19:26 -0800, "Kishore Kapadia"
<kishore_kapadia@.peoplesoft.com> wrote:

>I have SQL Server loaded on my standalone laptop. I tried
>to attach a database( xxx.MDF) and got an error as above.
>How do I resolve this ?

Error 435 bringing resource online?

Hi All,
I hope this is not a FAQ. I have a 2-node Windows Server 2003 cluster, with
SQL Server 2000 SP3a. This is a development system, and is actually
implemented using VMware (though I don't think that is relevant).
Occasionally when moving the SQL Server group, I get random failures of SQL
Server, Agent, or Fulltext. Going through cluster.log, I find entries like
the following:
000002d4.0000020c::2005/03/10-05:56:37.490 ERR SQL Server <SQL Server>:
[sqsrvres] StartResourceService: Failed to start MSSQLSERVER service.
CurrentState: 1
000002d4.0000020c::2005/03/10-05:56:37.490 ERR SQL Server <SQL Server>:
[sqsrvres] OnlineThread: ResUtilsStartResourceService failed (status 435)
000002d4.0000020c::2005/03/10-05:56:37.505 ERR SQL Server <SQL Server>:
[sqsrvres] OnlineThread: Error 435 bringing resource online.
and
000002d4.00000cf0::2005/03/10-06:09:52.281 ERR <Unknown Resource>:
[sqsrvres] StartResourceService: Failed to start SQLSERVERAGENT service.
CurrentState: 1
000002d4.00000cf0::2005/03/10-06:09:52.281 ERR SQL Server Agent <SQL Server
Agent>: [sqagtres] OnlineThread: ResUtilsStartResourceService failed (status
435)
000002d4.00000cf0::2005/03/10-06:09:52.281 ERR SQL Server Agent <SQL Server
Agent>: [sqagtres] OnlineThread: Error 435 bringing resource online.
Any ideas as to what is going wrong? Could this be network-related?
Many thanks,
John.
John wrote:
> Hi All,
> I hope this is not a FAQ. I have a 2-node Windows Server 2003 cluster, with
> SQL Server 2000 SP3a. This is a development system, and is actually
> implemented using VMware (though I don't think that is relevant).
It could be relevant. Workstation 4.x does too much disk caching so disk
corruption will occur, on the quorum disk for example. VMWare GSX 3 is
fine a long as you add disk.locking="FALSE" and scsi0.sharedBus="virtual"
Hans
|||Thanks for the response. Yes, I am using VMware Workstation 4.5 - that may
be an issue.
Is there a way of finding out exactly what error 435 means? It does not
seem to be a standard error code; "net helpmsg" does not help.
Thanks,
John.
"Hans de Bruin" wrote:

> John wrote:
> It could be relevant. Workstation 4.x does too much disk caching so disk
> corruption will occur, on the quorum disk for example. VMWare GSX 3 is
> fine a long as you add disk.locking="FALSE" and scsi0.sharedBus="virtual"
> --
> Hans
>
|||John wrote:
> Thanks for the response. Yes, I am using VMware Workstation 4.5 - that may
> be an issue.
> Is there a way of finding out exactly what error 435 means? It does not
> seem to be a standard error code; "net helpmsg" does not help.
>
Cluster service can't bring the resources online. Check the windows event
log and the sql log files to find out why. When that does not help, run a
dos box as the sql service account an start sql from the command line (not
net start but the sqlserver.exe).
If you really want to cluster with vmware either use a single node cluster
or use iscsi drives. I have got an out of date site which describes this:
http://eratosthenes.xs4all.nl/wmwarecluster/ .
Hans
|||What was the fix for this? I am having the same exact issue.

Quote:

Originally posted by Hansde Bruin
John wrote:
> Thanks for the response. Yes, I am using VMware Workstation 4.5 - that may
> be an issue.
> Is there a way of finding out exactly what error 435 means? It does not
> seem to be a standard error code; "net helpmsg" does not help.
>
Cluster service can't bring the resources online. Check the windows event
log and the sql log files to find out why. When that does not help, run a
dos box as the sql service account an start sql from the command line (not
net start but the sqlserver.exe).
If you really want to cluster with vmware either use a single node cluster
or use iscsi drives. I have got an out of date site which describes this:
http://eratosthenes.xs4all.nl/wmwarecluster/ .
Hans

ERROR 3628 Floating point error

Our system just started receiving an error on the
optimization phase of backup maintenance plan. This is
during index rebuild.
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3628:
[Microsoft][ODBC SQL Server Driver][SQL Server]A floating
point exception occurred in the user process. Current
transaction is canceled.
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC
execution completed. If DBCC printed error messages,
contact your system administrator.
This system is Sql2k SP3. I have found a couple of hits on
floating point errors, but nothing directly related to
index rebuilds.
Any ideas?The first thing I'd do is to check if the database is clean using DBCC
CHECKDB and DBCC CHECKCATALOG.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Judy" <jranson@.harris.com> wrote in message
news:015a01c3be88$b4c5afb0$a401280a@.phx.gbl...
> Our system just started receiving an error on the
> optimization phase of backup maintenance plan. This is
> during index rebuild.
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3628:
> [Microsoft][ODBC SQL Server Driver][SQL Server]A floating
> point exception occurred in the user process. Current
> transaction is canceled.
> [Microsoft][ODBC SQL Server Driver][SQL Server]DBCC
> execution completed. If DBCC printed error messages,
> contact your system administrator.
> This system is Sql2k SP3. I have found a couple of hits on
> floating point errors, but nothing directly related to
> index rebuilds.
> Any ideas?

Error 3: the system cannot find the specified path

Installed SQL Server 2000 Enterprise trial a week ago on XP Pro. Installed new Seagate 80G HD; used Seagate's utility to copy old C: to new drive as new boot drive. All seems to work fine, except, when booting up, SQL server doesn't start. When I try to start it manually I get the following:

Could not start SQLSERVER service on the local computer. Error 3: the system cannot find the specified path.

1. What could be wrong?

2. How do I fix it?

If you are starting via the service, look at services.msc and see what path is pointed to for sqlservr.exe. Check if the file exists at this location. Is this error coming from SQL Server or the OS?

|||

I saw nothing in services.msc relating to sql. In fact, the file is dated 8/4/2004. I didn't install SQL until about a week ago. [[NOTE, FYI: I also posted this question in the 'SQL Server Data Access' forum, but no solution there yet, either]]. If I try to manually start SQL Server, the first message just states it's unable to find the path specified. When I click OK, the next message title bar reads 'SQL Server Service Manager', and the message reads, "An error 3 - (The system cannot find the path specified.

) occured while performing this service operation on the MSSQLServer service."

If you're referring to the properties in Services, MSSQLServer, properties, the path is "C:\PROGRA~1\MICROS~4\MSSQL\binn\sqlservr.exe"

If I navigate to C:\Program Files\Microsoft SQL Server\MSSQL\Binn, I can double-click sqlservr.exe and a dos window opens up, etc., but it doesn' t seem to do anything related to the icon in my status bar, which still shows not started. If I enter the ..~ path above into the command prompt, I get the same "The system cannot find the path specified". Looks like I need to change the path to mssql server, but how do I do that?

|||

Services.msc is the MMC Services extension. It is an dll that will be loaded and run by MMC.

Change to that path in a cmd.exe window, and run sqlservr.exe -c. It should log to the console and ERRORLOG the error message. You can also try to track the file is searching for with filemon (www.sysinternals.com tool).

|||

SQLServer need somewehree a starting point, there for the path to the master mdf is coded in the registry with the appropiate start parameter. The service gathers this information at start up to find the "valid mointing point" for the master database. The key normally is located on the node

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\Parameters

Changing this is sort of critical, so you better save your registry key first to restore it, if something unexpectly happens.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

||| Actually, I found that yesterday; changed two path settings in the registry, and that fixed it. Apparently, when I duplicated the hard drive, it somehow used the DOS ~ naming conventions. Once I changed back to the named path, all seemed to work fine. Thanks to all who replied to my question.|||

I just ran into the same problem after I migrate (duplicate) the server to another server. I checked the properties under service of mssqlserver and it displayed the shortname. I went into the registry and made modification to a few places under HKLM\system\currentcontrolset....\service\mssqlserver and changed the imagepath parameter to point to the proper long name E:\progam files\microsoft sql server\mssql\binn\sqlsrver.exe. Then I was able to start SQL Server. The properties of SQLserver agent is using the long name so it does not have a problem.

I don't understand why it did not work. I checked the old server and it was using the short name and it worked. I checked some other SQL servers and they all displayed the short name and they have no problem. I thought the system should be able to recognize the short name automatically.

It seems that this problem is only happening on this server.

Any idea?

Thanks.

Error 3: the system cannot find the specified path

Installed SQL Server 2000 Enterprise trial a week ago on XP Pro. Installed new Seagate 80G HD; used Seagate's utility to copy old C: to new drive as new boot drive. All seems to work fine, except, when booting up, SQL server doesn't start. When I try to start it manually I get the following:

Could not start SQLSERVER service on the local computer. Error 3: the system cannot find the specified path.

1. What could be wrong?

2. How do I fix it?

If you are starting via the service, look at services.msc and see what path is pointed to for sqlservr.exe. Check if the file exists at this location. Is this error coming from SQL Server or the OS?

|||

I saw nothing in services.msc relating to sql. In fact, the file is dated 8/4/2004. I didn't install SQL until about a week ago. [[NOTE, FYI: I also posted this question in the 'SQL Server Data Access' forum, but no solution there yet, either]]. If I try to manually start SQL Server, the first message just states it's unable to find the path specified. When I click OK, the next message title bar reads 'SQL Server Service Manager', and the message reads, "An error 3 - (The system cannot find the path specified.

) occured while performing this service operation on the MSSQLServer service."

If you're referring to the properties in Services, MSSQLServer, properties, the path is "C:\PROGRA~1\MICROS~4\MSSQL\binn\sqlservr.exe"

If I navigate to C:\Program Files\Microsoft SQL Server\MSSQL\Binn, I can double-click sqlservr.exe and a dos window opens up, etc., but it doesn' t seem to do anything related to the icon in my status bar, which still shows not started. If I enter the ..~ path above into the command prompt, I get the same "The system cannot find the path specified". Looks like I need to change the path to mssql server, but how do I do that?

|||

Services.msc is the MMC Services extension. It is an dll that will be loaded and run by MMC.

Change to that path in a cmd.exe window, and run sqlservr.exe -c. It should log to the console and ERRORLOG the error message. You can also try to track the file is searching for with filemon (www.sysinternals.com tool).

|||

SQLServer need somewehree a starting point, there for the path to the master mdf is coded in the registry with the appropiate start parameter. The service gathers this information at start up to find the "valid mointing point" for the master database. The key normally is located on the node

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\Parameters

Changing this is sort of critical, so you better save your registry key first to restore it, if something unexpectly happens.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

||| Actually, I found that yesterday; changed two path settings in the registry, and that fixed it. Apparently, when I duplicated the hard drive, it somehow used the DOS ~ naming conventions. Once I changed back to the named path, all seemed to work fine. Thanks to all who replied to my question.|||

I just ran into the same problem after I migrate (duplicate) the server to another server. I checked the properties under service of mssqlserver and it displayed the shortname. I went into the registry and made modification to a few places under HKLM\system\currentcontrolset....\service\mssqlserver and changed the imagepath parameter to point to the proper long name E:\progam files\microsoft sql server\mssql\binn\sqlsrver.exe. Then I was able to start SQL Server. The properties of SQLserver agent is using the long name so it does not have a problem.

I don't understand why it did not work. I checked the old server and it was using the short name and it worked. I checked some other SQL servers and they all displayed the short name and they have no problem. I thought the system should be able to recognize the short name automatically.

It seems that this problem is only happening on this server.

Any idea?

Thanks.

ERROR 229: SELECT permission denied on object sysobjects, database ....

Hi,

I granted all the rights on the database to the user (db_owner, public, db_datawriter, etc...) However, I didn't grant the "System Administrators" role. I also specifically granted the select on those tables (sysobjects and sysindexes) for the user and checked through sp_helprotect sysobjects command whether there are no specific revokes for for that user.

However, the user is still getting the below error while trying to expand the "Tables" view in the Enterprise Manager.

ERROR 229: SELECT permission denied on object 'sysobjects', database 'My_test', owner 'dbo', SELECT permission denied on object 'sysindexes', database 'My_test', owner 'dbo'.

Also, the user claims that he cant seem to do anything with the database, he cant view any objects, and, when he goes to Query Analyzer, if he tries to run a SELECT query on a table (that he know that this table exists), he gets this error:



SELECT permission denied on object 'tblBillingTrans', database 'My_Test', owner 'dbo'.

Any help would be greatly appreciated!
Thanks,
AllaPlease disregard this question... I granted the db_denydatareader option... :p

Error 22029 on maint jobs

OK this is a new error on me.

I have a SQL server 2000 on Windows Server 2003.

I have setup a Maint plan that backs up the user and system databases
and the transaction Logs on my user databases.

Does optimises and integrity checks on those databases as well.
I am not attempting to repair any minor problems.
I am not performing integrity checks before backing up the database
and transaction logs.

All of the databases that I am doing a transaction log backup on have
recovery mode of full.

When the jobs run they fail instantly with error code 22029.
Sqlmaint.exe failed to run. This was working up until the end of the
day on the Thursday before Good Friday. (last week) The transaction
log backup ran fine at 4:00 PM the same job failed at 8:00 PM. No
changes were made to the server during that time.
Another issue that started at the same time. I have a web page used to
grab data from a text file export and pull it into an AS400. I use
this server to house the DTS packages and stored procedures that the
process needs. I suddenly quit working when the jobs quit running.

We are in a mixed enviroment with most clients on AD and this server
and most others still in a NT 4 domain. We have been like this for at
least 3 months and everything has worked fine. I setup the various
users and systems the way the need to be, to work.

Originally the SQL Agent was running as a generic NT 4 Domain user with
local administrator rights to the local box and server role of system
administrator. The MSSQLSERVER and DTC services were running as the
built in system account.

Everything was happy then it broke.

When I reboot the server the jobs and the website work fine. Then
after a period of time that I have not figured out yet, but more than
15 minutes and less than 2 hours. Everything quits working.

I have changed all the services to run as a domain admin with SQL
system adminsitrator server role. Still same thing.

I have changed all the services to run as the built in system account.
Still same thing.

I run the sqlmaint from command line with the switches that I am using
in the maint jobs and it runs fine.

I have run dbcc checkdb on all the databases and they are fine.

The DTS packages and the stored procedures used by the website run fine
from with in Query analyzer.

Any help you can provide would be greatly appreciated.

Hi

I don′t know i this might help, but we experienced the exact same symptoms. And it started around the date you mentioned.

In our case we had a job that made a backup of 'All databases'. However we had 2 detached databases on our server, when I deleted those the job ran without errors!

Good luck

Error 21776

Hi all,
When I try to delete one of database on SQL Server 7.0. System generates this error saying that database name was not found sysdatabase table and I manually checked it in database, it was really not there. Any one who can give me solution to this?If you have backup - restore it, if not - try to attach database files - otherwise - just remember in future to do backups.

Error 208: Invalid object name 'syspublications'

Hi!
Before reinstalling sql server and restoring old system databases I
forgot to delete and replication that was no longer needed. Now,
Expired Subscriptions Clean Up job fails with the following error:
Error 208: Invalid object name 'syspublications'. I don't need this
replication and would like to delete that completed but everytime I
try I get the same error message.
Please advise how can I delete all manually.
Thank you,
T.
Hi
Have you checked out http://tinyurl.com/33ls84
John
"tolcis" wrote:

> Hi!
> Before reinstalling sql server and restoring old system databases I
> forgot to delete and replication that was no longer needed. Now,
> Expired Subscriptions Clean Up job fails with the following error:
> Error 208: Invalid object name 'syspublications'. I don't need this
> replication and would like to delete that completed but everytime I
> try I get the same error message.
> Please advise how can I delete all manually.
> Thank you,
> T.
>

Error 208: Invalid object name 'syspublications'

Hi!
Before reinstalling sql server and restoring old system databases I
forgot to delete and replication that was no longer needed. Now,
Expired Subscriptions Clean Up job fails with the following error:
Error 208: Invalid object name 'syspublications'. I don't need this
replication and would like to delete that completed but everytime I
try I get the same error message.
Please advise how can I delete all manually.
Thank you,
T.Hi
Have you checked out http://tinyurl.com/33ls84
John
"tolcis" wrote:
> Hi!
> Before reinstalling sql server and restoring old system databases I
> forgot to delete and replication that was no longer needed. Now,
> Expired Subscriptions Clean Up job fails with the following error:
> Error 208: Invalid object name 'syspublications'. I don't need this
> replication and would like to delete that completed but everytime I
> try I get the same error message.
> Please advise how can I delete all manually.
> Thank you,
> T.
>

Error 208: Invaild object name msdb.dbo.MSdistpublishers

Recently my msdb database became corrupt so I had to reinstall SQL Server 7.0. In doing so new system databases were created. I was able to restore all databases and system databases from backups except for the msdb database (unfortunately my backup overwrote the good database before I realized there was a problem). Because of this I have lost publication and subscriber info from my distribution tables that resided in the old msdb database.

What I would like to do is delete all references to previous publications and subscribers and create them all over again. But it does not allow me to create new or delete old publishers or subscribers. I get this and other errors...

Error 208: Invaild object name 'msdb.dbo.MSdistpublishers'

There is in fact no MSdistpublishers table in msdb because it is a new db. Can anyone help me reverse out of this?

Thanks in advance.

SteveIn future make sure to have regular backups for SYSTEM databases too.

I suggest to delete the replication and recreate it freshly which will re-enable the task. Make sure to check all jobs and tasks are scheduled properly after the MSDB restore.

Refer to SQL error log for any information.