I am in the process of translating Access 97 Databases into SQL, and working
through many very complex interrelated queries which work fine in Access. On
translating many queries all work fine apart from when I get to the top leve
l
query which effectively nests many level of queries. On trying to display
this top level view I get the horrible
Server: Msg 3628, Level 16, State 1, Line 1
A floating point exception occurred in the user process. Current transaction
is canceled.
Now I have tried to narrow the problem down, even removed any floating point
datatypes from the view but I still get the problem.
I now have a view which works if I join 3 tables but on trying to join 4
tables gives the exception. It does not matter which table I miss out...
Am I hitting some limit of SQL which does not exist in Access 97? Or is
these a nasty bug floating around which cannot handle nested views of a
certain level...
Could some clever person please could come back to this posting urgently
with when there will be another fix for this problem, or email me at
getalifestyle@.easyget.bizHi
The fix as described in
http://support.microsoft.com/defaul...kb;en-us;892840 is not
included in SP4, so you need to get a seperate hotfix for it from Microsoft.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Steve Giergiel" wrote:
> I am in the process of translating Access 97 Databases into SQL, and worki
ng
> through many very complex interrelated queries which work fine in Access.
On
> translating many queries all work fine apart from when I get to the top le
vel
> query which effectively nests many level of queries. On trying to display
> this top level view I get the horrible
> Server: Msg 3628, Level 16, State 1, Line 1
> A floating point exception occurred in the user process. Current transacti
on
> is canceled.
> Now I have tried to narrow the problem down, even removed any floating poi
nt
> datatypes from the view but I still get the problem.
> I now have a view which works if I join 3 tables but on trying to join 4
> tables gives the exception. It does not matter which table I miss out...
> Am I hitting some limit of SQL which does not exist in Access 97? Or is
> these a nasty bug floating around which cannot handle nested views of a
> certain level...
> Could some clever person please could come back to this posting urgently
> with when there will be another fix for this problem, or email me at
> getalifestyle@.easyget.biz
>|||Hi
Can you please post the SQL Script here, so that we can try to give u a
solution
best Regards,
Chandra
http://www.SQLResource.com/
http://chanduas.blogspot.com/
---
*** Sent via Developersdex http://www.examnotes.net ***
2012年3月21日星期三
Flat File Backup Failed *suddenly*
OS: Win2K Server SP4
DB: SQL Server 2000 SP3a
I have a database that has a1.1GB LDF file and a 380MB MDF file
I have a database maintenanec plan set up to do full database backup (i.e.
not differential) of all non-system databases including this database in
question.
The backup to d:\MSSQL\BACKUP (with a sub directory for each DB) has been
working fine since the server was set up 6 months ago. Suddently, the
backup stopped working on Saturday (the Friday backup is successful and no
one was in the office on Saturday, to rule out any system changes that could
have trigger this).
Observations
*1) The error logged in the error log file is :
2004-08-21 21:25:14.07 spid60 BackupDiskFile::OpenMedia: Backup device
'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408212125.BAK' failed to open.
Operating system error = 32(error not found).
2004-08-21 21:25:14.20 backup BACKUP failed to complete the command
BACKUP DATABASE [YJBLive] TO DISK = N'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408212125.BAK' WITH INIT , NOUNLOAD
, NOSKIP , STATS = 10, NOFORMAT
*2) If I change the job to just do the backup without verify, then the job
completes, but
*2.1) Normally, the BAK file used to be 3xxMB large, but now the BAK file
which only succeeded in backing up without verifying is 1xxMB large
*3) The Job History indicates
Executed as user: WEBSERVER\SQLServer. sqlmaint.exe failed. [SQLSTATE 42000]
(Error 22029). The step failed.
The job failed. The Job was invoked by Schedule 2 (Schedule 1). The last
step to run was step 1 (Step 1).
*4) The backup file appear corrupted:
*4.1) If I look at the Maintenance Plan history, I found:
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft][ODBC SQL
Server Driver][SQL Server]Cannot open backup device
'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408231407.BAK'. Device error or device
off-line. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE is
terminating abnormally.
*4.2) If I try to restore this (corrupted) 1xxMB BAK file to another DB, it
doesn't work. After the popup to say restore has completed, Enterprise
Manager shows the database as grey with "(Loading)" appended to the database
name (even after 5mins)
*) The user group Everyone has full permission on d:\MSSQL\BACKUP
SOS !! Why is my backup suddenly failing and how could I resolve this?
Note it is only this database whose backup are failing since Saturday (e.g.
I have a DB which has a 3.8GB LDF file which backup with no problems!)Also, DBCC CheckDB, DBCC CheckFileGroup, DBCC CheckIdent reveal no errors|||Seems like SQL Server 2000 likes SQL Client to use TCP/IP (when doing
backups), but Microsoft Content Management Server 2002 SP1A likes Named
Pipes for MCMS Server Side Site Deployment Object export to work properly!
I am faced with a big dilemma!
See
http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+(complete)+FAQ.htm#B01B7B38-C97A-4935-8957-DC346719CE9B
I have been experiencing frequest "General network Error"s, when I use
Server side SDO to export the CMS repository (as a backup, before importing
a SDO file from another test server). This article recommends the use of
Named Pipes in preference over TCP/IP for SQL Client Network settings.
However, there has been some recent failures in SQL Server Flat file backup
(SQL SErver maintenance plan to do full backup all application databases
with verify). Invesigation reveal (quite consistently) that the flat file
backup of the MCMS 2002 SP1A database will always fail when Named Pipes to
use. As soon as SQL Client is changed to use TCP/IP, backup function as
expectd. The error that are logged when Named pipes are used as follows
*1) The error logged in the error log file is :
2004-08-21 21:25:14.07 spid60 BackupDiskFile::OpenMedia: Backup device
'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408212125.BAK' failed to open.
Operating system error = 32(error not found).
2004-08-21 21:25:14.20 backup BACKUP failed to complete the command
BACKUP DATABASE [YJBLive] TO DISK =N'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408212125.BAK' WITH INIT , NOUNLOAD
, NOSKIP , STATS = 10, NOFORMAT
*2) If I change the job to just do the backup without verify, then the job
completes, but
*2.1) Normally, the BAK file used to be 3xxMB large, but now the BAK file
which only succeeded in backing up without verifying is 1xxMB large
*3) The Job History indicates
Executed as user: WEBSERVER\SQLServer. sqlmaint.exe failed. [SQLSTATE 42000]
(Error 22029). The step failed.
The job failed. The Job was invoked by Schedule 2 (Schedule 1). The last
step to run was step 1 (Step 1).
*4) The backup file appear corrupted:
*4.1) If I look at the Maintenance Plan history, I found:
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft][ODBC SQL
Server Driver][SQL Server]Cannot open backup device
'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408231407.BAK'. Device error or device
off-line. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE is
terminating abnormally.
*4.2) If I try to restore this (corrupted) 1xxMB BAK file to another DB, it
doesn't work. After the popup to say restore has completed, Enterprise
Manager shows the database as grey with "(Loading)" appended to the database
name (even after 5mins)
*5) The user group Everyone has full permission on d:\MSSQL\BACKUP
*6) DBCC CheckDB, DBCC CheckFileGroup, DBCC CheckIdent reveal no errors
So, I am really stuck here, could some SQL Server / MCMS expert help me out
here! If I use Named Pipes, SQL Backup is not going to work. If I use
TCP/IP, then my MCMS export/import would not work most of the time!|||Hi Patrick,
1) MCMS likes all protocols if SP1 or SP1a are installed
2) creating an ALIAS in SQL tools for the different application would allow
to configure the protocols for all apps individually.
Cheers,
Stefan.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
MCMS FAQ:
http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+(complete)+FAQ.htm
MCMS Blog: http://blogs.msdn.com/stefan_gossner/category/4983.aspx
MCMS Sample Code:
http://www.gotdotnet.com/community/usersamples/Default.aspx?ProductDropDownList=Content+Management+Server
MCMS Whitepapers and other docs:
http://blogs.msdn.com/stefan_gossner/archive/2003/12/07/41859.aspx
--
"Patrick" <patl@.reply.newsgroup.msn.com> wrote in message
news:esccSyRiEHA.2908@.TK2MSFTNGP10.phx.gbl...
> Seems like SQL Server 2000 likes SQL Client to use TCP/IP (when doing
> backups), but Microsoft Content Management Server 2002 SP1A likes Named
> Pipes for MCMS Server Side Site Deployment Object export to work properly!
> I am faced with a big dilemma!
> See
>
http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+(complete)+FAQ.htm#B01B7B38-C97A-4935-8957-DC346719CE9B
> I have been experiencing frequest "General network Error"s, when I use
> Server side SDO to export the CMS repository (as a backup, before
importing
> a SDO file from another test server). This article recommends the use of
> Named Pipes in preference over TCP/IP for SQL Client Network settings.
> However, there has been some recent failures in SQL Server Flat file
backup
> (SQL SErver maintenance plan to do full backup all application databases
> with verify). Invesigation reveal (quite consistently) that the flat file
> backup of the MCMS 2002 SP1A database will always fail when Named Pipes to
> use. As soon as SQL Client is changed to use TCP/IP, backup function as
> expectd. The error that are logged when Named pipes are used as follows
> *1) The error logged in the error log file is :
> 2004-08-21 21:25:14.07 spid60 BackupDiskFile::OpenMedia: Backup device
> 'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408212125.BAK' failed to open.
> Operating system error = 32(error not found).
> 2004-08-21 21:25:14.20 backup BACKUP failed to complete the command
> BACKUP DATABASE [YJBLive] TO DISK => N'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408212125.BAK' WITH INIT ,
NOUNLOAD
> , NOSKIP , STATS = 10, NOFORMAT
>
> *2) If I change the job to just do the backup without verify, then the job
> completes, but
> *2.1) Normally, the BAK file used to be 3xxMB large, but now the BAK file
> which only succeeded in backing up without verifying is 1xxMB large
> *3) The Job History indicates
> Executed as user: WEBSERVER\SQLServer. sqlmaint.exe failed. [SQLSTATE
42000]
> (Error 22029). The step failed.
> The job failed. The Job was invoked by Schedule 2 (Schedule 1). The last
> step to run was step 1 (Step 1).
> *4) The backup file appear corrupted:
> *4.1) If I look at the Maintenance Plan history, I found:
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft][ODBC
SQL
> Server Driver][SQL Server]Cannot open backup device
> 'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408231407.BAK'. Device error or
device
> off-line. See the SQL Server error log for more details.
> [Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE is
> terminating abnormally.
> *4.2) If I try to restore this (corrupted) 1xxMB BAK file to another DB,
it
> doesn't work. After the popup to say restore has completed, Enterprise
> Manager shows the database as grey with "(Loading)" appended to the
database
> name (even after 5mins)
> *5) The user group Everyone has full permission on d:\MSSQL\BACKUP
> *6) DBCC CheckDB, DBCC CheckFileGroup, DBCC CheckIdent reveal no errors
> So, I am really stuck here, could some SQL Server / MCMS expert help me
out
> here! If I use Named Pipes, SQL Backup is not going to work. If I use
> TCP/IP, then my MCMS export/import would not work most of the time!
>|||Thanks stefan,
Can I just check if the FAQ in regards to "General Network Error" when using
server side SDO to do export/import apply to MCMS2002 with SP1A (the CD
comes with SP1A) or not? If not, could you suggest any other remedies? I
have tried all the remedies listed in the FAQ at
http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+(complete)+FAQ.htm#B01B7B38-C97A-4935-8957-DC346719CE9B
and still we are getting quite frequent "General Network Error" when
performing export on a repository (whose SQL DB is 1GB ish and whose SDO
file is 80MB). e.g. timeouts/maxium request size are much larger than that
required already!!
"Stefan [MSFT]" <stefang@.online.microsoft.com> wrote in message
news:elC3D2RiEHA.396@.TK2MSFTNGP12.phx.gbl...
> Hi Patrick,
> 1) MCMS likes all protocols if SP1 or SP1a are installed
> 2) creating an ALIAS in SQL tools for the different application would
allow
> to configure the protocols for all apps individually.
> Cheers,
> Stefan.
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> MCMS FAQ:
>
http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+(complete)+FAQ.htm
> MCMS Blog: http://blogs.msdn.com/stefan_gossner/category/4983.aspx
> MCMS Sample Code:
>
http://www.gotdotnet.com/community/usersamples/Default.aspx?ProductDropDownList=Content+Management+Server
> MCMS Whitepapers and other docs:
> http://blogs.msdn.com/stefan_gossner/archive/2003/12/07/41859.aspx
> --
>
> "Patrick" <patl@.reply.newsgroup.msn.com> wrote in message
> news:esccSyRiEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > Seems like SQL Server 2000 likes SQL Client to use TCP/IP (when doing
> > backups), but Microsoft Content Management Server 2002 SP1A likes Named
> > Pipes for MCMS Server Side Site Deployment Object export to work
properly!
> > I am faced with a big dilemma!
> >
> > See
> >
>
http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+(complete)+FAQ.htm#B01B7B38-C97A-4935-8957-DC346719CE9B
> >
> > I have been experiencing frequest "General network Error"s, when I use
> > Server side SDO to export the CMS repository (as a backup, before
> importing
> > a SDO file from another test server). This article recommends the use
of
> > Named Pipes in preference over TCP/IP for SQL Client Network settings.
> >
> > However, there has been some recent failures in SQL Server Flat file
> backup
> > (SQL SErver maintenance plan to do full backup all application databases
> > with verify). Invesigation reveal (quite consistently) that the flat
file
> > backup of the MCMS 2002 SP1A database will always fail when Named Pipes
to
> > use. As soon as SQL Client is changed to use TCP/IP, backup function as
> > expectd. The error that are logged when Named pipes are used as follows
> > *1) The error logged in the error log file is :
> > 2004-08-21 21:25:14.07 spid60 BackupDiskFile::OpenMedia: Backup
device
> > 'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408212125.BAK' failed to open.
> > Operating system error = 32(error not found).
> > 2004-08-21 21:25:14.20 backup BACKUP failed to complete the command
> > BACKUP DATABASE [YJBLive] TO DISK => > N'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408212125.BAK' WITH INIT ,
> NOUNLOAD
> > , NOSKIP , STATS = 10, NOFORMAT
> >
> >
> > *2) If I change the job to just do the backup without verify, then the
job
> > completes, but
> > *2.1) Normally, the BAK file used to be 3xxMB large, but now the BAK
file
> > which only succeeded in backing up without verifying is 1xxMB large
> >
> > *3) The Job History indicates
> > Executed as user: WEBSERVER\SQLServer. sqlmaint.exe failed. [SQLSTATE
> 42000]
> > (Error 22029). The step failed.
> > The job failed. The Job was invoked by Schedule 2 (Schedule 1). The
last
> > step to run was step 1 (Step 1).
> >
> > *4) The backup file appear corrupted:
> > *4.1) If I look at the Maintenance Plan history, I found:
> > [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft][ODBC
> SQL
> > Server Driver][SQL Server]Cannot open backup device
> > 'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408231407.BAK'. Device error or
> device
> > off-line. See the SQL Server error log for more details.
> > [Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE is
> > terminating abnormally.
> > *4.2) If I try to restore this (corrupted) 1xxMB BAK file to another DB,
> it
> > doesn't work. After the popup to say restore has completed, Enterprise
> > Manager shows the database as grey with "(Loading)" appended to the
> database
> > name (even after 5mins)
> >
> > *5) The user group Everyone has full permission on d:\MSSQL\BACKUP
> >
> > *6) DBCC CheckDB, DBCC CheckFileGroup, DBCC CheckIdent reveal no errors
> >
> > So, I am really stuck here, could some SQL Server / MCMS expert help me
> out
> > here! If I use Named Pipes, SQL Backup is not going to work. If I use
> > TCP/IP, then my MCMS export/import would not work most of the time!
> >
> >
>|||Hi Patrick,
you should surely test if using named pipes solves the problem or not. We
had customers indicating that this solved their problem even after SP1a -
although we assume that the problem was related to their network
architecture as we haven't been able to repro this inhouse.
Using an ALIAS allows to do this easily without affecting any other
applications.
From my understanding backup should work with all protocols - so this
sounds as if there are indeed problems with your network architecture. You
should follow up on this in an SQL related newsgroup.
Cheers,
Stefan.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
MCMS FAQ:
http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+(complete)+FAQ.htm
MCMS Blog: http://blogs.msdn.com/stefan_gossner/category/4983.aspx
MCMS Sample Code:
http://www.gotdotnet.com/community/usersamples/Default.aspx?ProductDropDownList=Content+Management+Server
MCMS Whitepapers and other docs:
http://blogs.msdn.com/stefan_gossner/archive/2003/12/07/41859.aspx
--
"Patrick" <patl@.reply.newsgroup.msn.com> wrote in message
news:eG8LodbiEHA.3608@.TK2MSFTNGP09.phx.gbl...
> Thanks stefan,
> Can I just check if the FAQ in regards to "General Network Error" when
using
> server side SDO to do export/import apply to MCMS2002 with SP1A (the CD
> comes with SP1A) or not? If not, could you suggest any other remedies? I
> have tried all the remedies listed in the FAQ at
>
http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+(complete)+FAQ.htm#B01B7B38-C97A-4935-8957-DC346719CE9B
> and still we are getting quite frequent "General Network Error" when
> performing export on a repository (whose SQL DB is 1GB ish and whose SDO
> file is 80MB). e.g. timeouts/maxium request size are much larger than
that
> required already!!
> "Stefan [MSFT]" <stefang@.online.microsoft.com> wrote in message
> news:elC3D2RiEHA.396@.TK2MSFTNGP12.phx.gbl...
> > Hi Patrick,
> >
> > 1) MCMS likes all protocols if SP1 or SP1a are installed
> > 2) creating an ALIAS in SQL tools for the different application would
> allow
> > to configure the protocols for all apps individually.
> >
> > Cheers,
> > Stefan.
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > MCMS FAQ:
> >
>
http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+(complete)+FAQ.htm
> > MCMS Blog: http://blogs.msdn.com/stefan_gossner/category/4983.aspx
> > MCMS Sample Code:
> >
>
http://www.gotdotnet.com/community/usersamples/Default.aspx?ProductDropDownList=Content+Management+Server
> > MCMS Whitepapers and other docs:
> > http://blogs.msdn.com/stefan_gossner/archive/2003/12/07/41859.aspx
> > --
> >
> >
> > "Patrick" <patl@.reply.newsgroup.msn.com> wrote in message
> > news:esccSyRiEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > > Seems like SQL Server 2000 likes SQL Client to use TCP/IP (when doing
> > > backups), but Microsoft Content Management Server 2002 SP1A likes
Named
> > > Pipes for MCMS Server Side Site Deployment Object export to work
> properly!
> > > I am faced with a big dilemma!
> > >
> > > See
> > >
> >
>
http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+(complete)+FAQ.htm#B01B7B38-C97A-4935-8957-DC346719CE9B
> > >
> > > I have been experiencing frequest "General network Error"s, when I use
> > > Server side SDO to export the CMS repository (as a backup, before
> > importing
> > > a SDO file from another test server). This article recommends the use
> of
> > > Named Pipes in preference over TCP/IP for SQL Client Network settings.
> > >
> > > However, there has been some recent failures in SQL Server Flat file
> > backup
> > > (SQL SErver maintenance plan to do full backup all application
databases
> > > with verify). Invesigation reveal (quite consistently) that the flat
> file
> > > backup of the MCMS 2002 SP1A database will always fail when Named
Pipes
> to
> > > use. As soon as SQL Client is changed to use TCP/IP, backup function
as
> > > expectd. The error that are logged when Named pipes are used as
follows
> > > *1) The error logged in the error log file is :
> > > 2004-08-21 21:25:14.07 spid60 BackupDiskFile::OpenMedia: Backup
> device
> > > 'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408212125.BAK' failed to open.
> > > Operating system error = 32(error not found).
> > > 2004-08-21 21:25:14.20 backup BACKUP failed to complete the command
> > > BACKUP DATABASE [YJBLive] TO DISK => > > N'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408212125.BAK' WITH INIT ,
> > NOUNLOAD
> > > , NOSKIP , STATS = 10, NOFORMAT
> > >
> > >
> > > *2) If I change the job to just do the backup without verify, then the
> job
> > > completes, but
> > > *2.1) Normally, the BAK file used to be 3xxMB large, but now the BAK
> file
> > > which only succeeded in backing up without verifying is 1xxMB large
> > >
> > > *3) The Job History indicates
> > > Executed as user: WEBSERVER\SQLServer. sqlmaint.exe failed. [SQLSTATE
> > 42000]
> > > (Error 22029). The step failed.
> > > The job failed. The Job was invoked by Schedule 2 (Schedule 1). The
> last
> > > step to run was step 1 (Step 1).
> > >
> > > *4) The backup file appear corrupted:
> > > *4.1) If I look at the Maintenance Plan history, I found:
> > > [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201:
[Microsoft][ODBC
> > SQL
> > > Server Driver][SQL Server]Cannot open backup device
> > > 'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408231407.BAK'. Device error or
> > device
> > > off-line. See the SQL Server error log for more details.
> > > [Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE is
> > > terminating abnormally.
> > > *4.2) If I try to restore this (corrupted) 1xxMB BAK file to another
DB,
> > it
> > > doesn't work. After the popup to say restore has completed,
Enterprise
> > > Manager shows the database as grey with "(Loading)" appended to the
> > database
> > > name (even after 5mins)
> > >
> > > *5) The user group Everyone has full permission on d:\MSSQL\BACKUP
> > >
> > > *6) DBCC CheckDB, DBCC CheckFileGroup, DBCC CheckIdent reveal no
errors
> > >
> > > So, I am really stuck here, could some SQL Server / MCMS expert help
me
> > out
> > > here! If I use Named Pipes, SQL Backup is not going to work. If I
use
> > > TCP/IP, then my MCMS export/import would not work most of the time!
> > >
> > >
> >
> >
>|||Actually:
1) Tests reveal that we cannot consistently prove whether Server side SDO
export/import would work with TCP/IP or Named-pipes
2) Tests reveal that Flat file backups
2.1) for the MCMS 2002 SP1A Repository consistently fail when SQL Client
Network utility is set to use Named Pipes.
2.2) For other databases (including a 3GB database, as opposed to a mere 1GB
MCMS SQL DB) all works with named pipes
3) The SQL Server, IIS and CMS are all on the same box! So, named pipes
should be using (I believe) the internal kernel, which is meant to be super
fast?
"Stefan [MSFT]" <stefang@.online.microsoft.com> wrote in message
news:evymkDciEHA.4020@.TK2MSFTNGP10.phx.gbl...
> Hi Patrick,
> you should surely test if using named pipes solves the problem or not. We
> had customers indicating that this solved their problem even after SP1a -
> although we assume that the problem was related to their network
> architecture as we haven't been able to repro this inhouse.
> Using an ALIAS allows to do this easily without affecting any other
> applications.
> From my understanding backup should work with all protocols - so this
> sounds as if there are indeed problems with your network architecture. You
> should follow up on this in an SQL related newsgroup.
> Cheers,
> Stefan.
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> MCMS FAQ:
>
http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+(complete)+FAQ.htm
> MCMS Blog: http://blogs.msdn.com/stefan_gossner/category/4983.aspx
> MCMS Sample Code:
>
http://www.gotdotnet.com/community/usersamples/Default.aspx?ProductDropDownList=Content+Management+Server
> MCMS Whitepapers and other docs:
> http://blogs.msdn.com/stefan_gossner/archive/2003/12/07/41859.aspx
> --
>
> "Patrick" <patl@.reply.newsgroup.msn.com> wrote in message
> news:eG8LodbiEHA.3608@.TK2MSFTNGP09.phx.gbl...
> > Thanks stefan,
> > Can I just check if the FAQ in regards to "General Network Error" when
> using
> > server side SDO to do export/import apply to MCMS2002 with SP1A (the CD
> > comes with SP1A) or not? If not, could you suggest any other remedies?
I
> > have tried all the remedies listed in the FAQ at
> >
>
http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+(complete)+FAQ.htm#B01B7B38-C97A-4935-8957-DC346719CE9B
> > and still we are getting quite frequent "General Network Error" when
> > performing export on a repository (whose SQL DB is 1GB ish and whose SDO
> > file is 80MB). e.g. timeouts/maxium request size are much larger than
> that
> > required already!!
> >
> > "Stefan [MSFT]" <stefang@.online.microsoft.com> wrote in message
> > news:elC3D2RiEHA.396@.TK2MSFTNGP12.phx.gbl...
> > > Hi Patrick,
> > >
> > > 1) MCMS likes all protocols if SP1 or SP1a are installed
> > > 2) creating an ALIAS in SQL tools for the different application would
> > allow
> > > to configure the protocols for all apps individually.
> > >
> > > Cheers,
> > > Stefan.
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > MCMS FAQ:
> > >
> >
>
http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+(complete)+FAQ.htm
> > > MCMS Blog: http://blogs.msdn.com/stefan_gossner/category/4983.aspx
> > > MCMS Sample Code:
> > >
> >
>
http://www.gotdotnet.com/community/usersamples/Default.aspx?ProductDropDownList=Content+Management+Server
> > > MCMS Whitepapers and other docs:
> > > http://blogs.msdn.com/stefan_gossner/archive/2003/12/07/41859.aspx
> > > --
> > >
> > >
> > > "Patrick" <patl@.reply.newsgroup.msn.com> wrote in message
> > > news:esccSyRiEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > > > Seems like SQL Server 2000 likes SQL Client to use TCP/IP (when
doing
> > > > backups), but Microsoft Content Management Server 2002 SP1A likes
> Named
> > > > Pipes for MCMS Server Side Site Deployment Object export to work
> > properly!
> > > > I am faced with a big dilemma!
> > > >
> > > > See
> > > >
> > >
> >
>
http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+(complete)+FAQ.htm#B01B7B38-C97A-4935-8957-DC346719CE9B
> > > >
> > > > I have been experiencing frequest "General network Error"s, when I
use
> > > > Server side SDO to export the CMS repository (as a backup, before
> > > importing
> > > > a SDO file from another test server). This article recommends the
use
> > of
> > > > Named Pipes in preference over TCP/IP for SQL Client Network
settings.
> > > >
> > > > However, there has been some recent failures in SQL Server Flat file
> > > backup
> > > > (SQL SErver maintenance plan to do full backup all application
> databases
> > > > with verify). Invesigation reveal (quite consistently) that the
flat
> > file
> > > > backup of the MCMS 2002 SP1A database will always fail when Named
> Pipes
> > to
> > > > use. As soon as SQL Client is changed to use TCP/IP, backup
function
> as
> > > > expectd. The error that are logged when Named pipes are used as
> follows
> > > > *1) The error logged in the error log file is :
> > > > 2004-08-21 21:25:14.07 spid60 BackupDiskFile::OpenMedia: Backup
> > device
> > > > 'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408212125.BAK' failed to open.
> > > > Operating system error = 32(error not found).
> > > > 2004-08-21 21:25:14.20 backup BACKUP failed to complete the
command
> > > > BACKUP DATABASE [YJBLive] TO DISK => > > > N'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408212125.BAK' WITH INIT ,
> > > NOUNLOAD
> > > > , NOSKIP , STATS = 10, NOFORMAT
> > > >
> > > >
> > > > *2) If I change the job to just do the backup without verify, then
the
> > job
> > > > completes, but
> > > > *2.1) Normally, the BAK file used to be 3xxMB large, but now the BAK
> > file
> > > > which only succeeded in backing up without verifying is 1xxMB large
> > > >
> > > > *3) The Job History indicates
> > > > Executed as user: WEBSERVER\SQLServer. sqlmaint.exe failed.
[SQLSTATE
> > > 42000]
> > > > (Error 22029). The step failed.
> > > > The job failed. The Job was invoked by Schedule 2 (Schedule 1).
The
> > last
> > > > step to run was step 1 (Step 1).
> > > >
> > > > *4) The backup file appear corrupted:
> > > > *4.1) If I look at the Maintenance Plan history, I found:
> > > > [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201:
> [Microsoft][ODBC
> > > SQL
> > > > Server Driver][SQL Server]Cannot open backup device
> > > > 'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408231407.BAK'. Device error or
> > > device
> > > > off-line. See the SQL Server error log for more details.
> > > > [Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE is
> > > > terminating abnormally.
> > > > *4.2) If I try to restore this (corrupted) 1xxMB BAK file to another
> DB,
> > > it
> > > > doesn't work. After the popup to say restore has completed,
> Enterprise
> > > > Manager shows the database as grey with "(Loading)" appended to the
> > > database
> > > > name (even after 5mins)
> > > >
> > > > *5) The user group Everyone has full permission on d:\MSSQL\BACKUP
> > > >
> > > > *6) DBCC CheckDB, DBCC CheckFileGroup, DBCC CheckIdent reveal no
> errors
> > > >
> > > > So, I am really stuck here, could some SQL Server / MCMS expert help
> me
> > > out
> > > > here! If I use Named Pipes, SQL Backup is not going to work. If I
> use
> > > > TCP/IP, then my MCMS export/import would not work most of the time!
> > > >
> > > >
> > >
> > >
> >
> >
>sql
DB: SQL Server 2000 SP3a
I have a database that has a1.1GB LDF file and a 380MB MDF file
I have a database maintenanec plan set up to do full database backup (i.e.
not differential) of all non-system databases including this database in
question.
The backup to d:\MSSQL\BACKUP (with a sub directory for each DB) has been
working fine since the server was set up 6 months ago. Suddently, the
backup stopped working on Saturday (the Friday backup is successful and no
one was in the office on Saturday, to rule out any system changes that could
have trigger this).
Observations
*1) The error logged in the error log file is :
2004-08-21 21:25:14.07 spid60 BackupDiskFile::OpenMedia: Backup device
'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408212125.BAK' failed to open.
Operating system error = 32(error not found).
2004-08-21 21:25:14.20 backup BACKUP failed to complete the command
BACKUP DATABASE [YJBLive] TO DISK = N'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408212125.BAK' WITH INIT , NOUNLOAD
, NOSKIP , STATS = 10, NOFORMAT
*2) If I change the job to just do the backup without verify, then the job
completes, but
*2.1) Normally, the BAK file used to be 3xxMB large, but now the BAK file
which only succeeded in backing up without verifying is 1xxMB large
*3) The Job History indicates
Executed as user: WEBSERVER\SQLServer. sqlmaint.exe failed. [SQLSTATE 42000]
(Error 22029). The step failed.
The job failed. The Job was invoked by Schedule 2 (Schedule 1). The last
step to run was step 1 (Step 1).
*4) The backup file appear corrupted:
*4.1) If I look at the Maintenance Plan history, I found:
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft][ODBC SQL
Server Driver][SQL Server]Cannot open backup device
'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408231407.BAK'. Device error or device
off-line. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE is
terminating abnormally.
*4.2) If I try to restore this (corrupted) 1xxMB BAK file to another DB, it
doesn't work. After the popup to say restore has completed, Enterprise
Manager shows the database as grey with "(Loading)" appended to the database
name (even after 5mins)
*) The user group Everyone has full permission on d:\MSSQL\BACKUP
SOS !! Why is my backup suddenly failing and how could I resolve this?
Note it is only this database whose backup are failing since Saturday (e.g.
I have a DB which has a 3.8GB LDF file which backup with no problems!)Also, DBCC CheckDB, DBCC CheckFileGroup, DBCC CheckIdent reveal no errors|||Seems like SQL Server 2000 likes SQL Client to use TCP/IP (when doing
backups), but Microsoft Content Management Server 2002 SP1A likes Named
Pipes for MCMS Server Side Site Deployment Object export to work properly!
I am faced with a big dilemma!
See
http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+(complete)+FAQ.htm#B01B7B38-C97A-4935-8957-DC346719CE9B
I have been experiencing frequest "General network Error"s, when I use
Server side SDO to export the CMS repository (as a backup, before importing
a SDO file from another test server). This article recommends the use of
Named Pipes in preference over TCP/IP for SQL Client Network settings.
However, there has been some recent failures in SQL Server Flat file backup
(SQL SErver maintenance plan to do full backup all application databases
with verify). Invesigation reveal (quite consistently) that the flat file
backup of the MCMS 2002 SP1A database will always fail when Named Pipes to
use. As soon as SQL Client is changed to use TCP/IP, backup function as
expectd. The error that are logged when Named pipes are used as follows
*1) The error logged in the error log file is :
2004-08-21 21:25:14.07 spid60 BackupDiskFile::OpenMedia: Backup device
'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408212125.BAK' failed to open.
Operating system error = 32(error not found).
2004-08-21 21:25:14.20 backup BACKUP failed to complete the command
BACKUP DATABASE [YJBLive] TO DISK =N'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408212125.BAK' WITH INIT , NOUNLOAD
, NOSKIP , STATS = 10, NOFORMAT
*2) If I change the job to just do the backup without verify, then the job
completes, but
*2.1) Normally, the BAK file used to be 3xxMB large, but now the BAK file
which only succeeded in backing up without verifying is 1xxMB large
*3) The Job History indicates
Executed as user: WEBSERVER\SQLServer. sqlmaint.exe failed. [SQLSTATE 42000]
(Error 22029). The step failed.
The job failed. The Job was invoked by Schedule 2 (Schedule 1). The last
step to run was step 1 (Step 1).
*4) The backup file appear corrupted:
*4.1) If I look at the Maintenance Plan history, I found:
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft][ODBC SQL
Server Driver][SQL Server]Cannot open backup device
'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408231407.BAK'. Device error or device
off-line. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE is
terminating abnormally.
*4.2) If I try to restore this (corrupted) 1xxMB BAK file to another DB, it
doesn't work. After the popup to say restore has completed, Enterprise
Manager shows the database as grey with "(Loading)" appended to the database
name (even after 5mins)
*5) The user group Everyone has full permission on d:\MSSQL\BACKUP
*6) DBCC CheckDB, DBCC CheckFileGroup, DBCC CheckIdent reveal no errors
So, I am really stuck here, could some SQL Server / MCMS expert help me out
here! If I use Named Pipes, SQL Backup is not going to work. If I use
TCP/IP, then my MCMS export/import would not work most of the time!|||Hi Patrick,
1) MCMS likes all protocols if SP1 or SP1a are installed
2) creating an ALIAS in SQL tools for the different application would allow
to configure the protocols for all apps individually.
Cheers,
Stefan.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
MCMS FAQ:
http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+(complete)+FAQ.htm
MCMS Blog: http://blogs.msdn.com/stefan_gossner/category/4983.aspx
MCMS Sample Code:
http://www.gotdotnet.com/community/usersamples/Default.aspx?ProductDropDownList=Content+Management+Server
MCMS Whitepapers and other docs:
http://blogs.msdn.com/stefan_gossner/archive/2003/12/07/41859.aspx
--
"Patrick" <patl@.reply.newsgroup.msn.com> wrote in message
news:esccSyRiEHA.2908@.TK2MSFTNGP10.phx.gbl...
> Seems like SQL Server 2000 likes SQL Client to use TCP/IP (when doing
> backups), but Microsoft Content Management Server 2002 SP1A likes Named
> Pipes for MCMS Server Side Site Deployment Object export to work properly!
> I am faced with a big dilemma!
> See
>
http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+(complete)+FAQ.htm#B01B7B38-C97A-4935-8957-DC346719CE9B
> I have been experiencing frequest "General network Error"s, when I use
> Server side SDO to export the CMS repository (as a backup, before
importing
> a SDO file from another test server). This article recommends the use of
> Named Pipes in preference over TCP/IP for SQL Client Network settings.
> However, there has been some recent failures in SQL Server Flat file
backup
> (SQL SErver maintenance plan to do full backup all application databases
> with verify). Invesigation reveal (quite consistently) that the flat file
> backup of the MCMS 2002 SP1A database will always fail when Named Pipes to
> use. As soon as SQL Client is changed to use TCP/IP, backup function as
> expectd. The error that are logged when Named pipes are used as follows
> *1) The error logged in the error log file is :
> 2004-08-21 21:25:14.07 spid60 BackupDiskFile::OpenMedia: Backup device
> 'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408212125.BAK' failed to open.
> Operating system error = 32(error not found).
> 2004-08-21 21:25:14.20 backup BACKUP failed to complete the command
> BACKUP DATABASE [YJBLive] TO DISK => N'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408212125.BAK' WITH INIT ,
NOUNLOAD
> , NOSKIP , STATS = 10, NOFORMAT
>
> *2) If I change the job to just do the backup without verify, then the job
> completes, but
> *2.1) Normally, the BAK file used to be 3xxMB large, but now the BAK file
> which only succeeded in backing up without verifying is 1xxMB large
> *3) The Job History indicates
> Executed as user: WEBSERVER\SQLServer. sqlmaint.exe failed. [SQLSTATE
42000]
> (Error 22029). The step failed.
> The job failed. The Job was invoked by Schedule 2 (Schedule 1). The last
> step to run was step 1 (Step 1).
> *4) The backup file appear corrupted:
> *4.1) If I look at the Maintenance Plan history, I found:
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft][ODBC
SQL
> Server Driver][SQL Server]Cannot open backup device
> 'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408231407.BAK'. Device error or
device
> off-line. See the SQL Server error log for more details.
> [Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE is
> terminating abnormally.
> *4.2) If I try to restore this (corrupted) 1xxMB BAK file to another DB,
it
> doesn't work. After the popup to say restore has completed, Enterprise
> Manager shows the database as grey with "(Loading)" appended to the
database
> name (even after 5mins)
> *5) The user group Everyone has full permission on d:\MSSQL\BACKUP
> *6) DBCC CheckDB, DBCC CheckFileGroup, DBCC CheckIdent reveal no errors
> So, I am really stuck here, could some SQL Server / MCMS expert help me
out
> here! If I use Named Pipes, SQL Backup is not going to work. If I use
> TCP/IP, then my MCMS export/import would not work most of the time!
>|||Thanks stefan,
Can I just check if the FAQ in regards to "General Network Error" when using
server side SDO to do export/import apply to MCMS2002 with SP1A (the CD
comes with SP1A) or not? If not, could you suggest any other remedies? I
have tried all the remedies listed in the FAQ at
http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+(complete)+FAQ.htm#B01B7B38-C97A-4935-8957-DC346719CE9B
and still we are getting quite frequent "General Network Error" when
performing export on a repository (whose SQL DB is 1GB ish and whose SDO
file is 80MB). e.g. timeouts/maxium request size are much larger than that
required already!!
"Stefan [MSFT]" <stefang@.online.microsoft.com> wrote in message
news:elC3D2RiEHA.396@.TK2MSFTNGP12.phx.gbl...
> Hi Patrick,
> 1) MCMS likes all protocols if SP1 or SP1a are installed
> 2) creating an ALIAS in SQL tools for the different application would
allow
> to configure the protocols for all apps individually.
> Cheers,
> Stefan.
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> MCMS FAQ:
>
http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+(complete)+FAQ.htm
> MCMS Blog: http://blogs.msdn.com/stefan_gossner/category/4983.aspx
> MCMS Sample Code:
>
http://www.gotdotnet.com/community/usersamples/Default.aspx?ProductDropDownList=Content+Management+Server
> MCMS Whitepapers and other docs:
> http://blogs.msdn.com/stefan_gossner/archive/2003/12/07/41859.aspx
> --
>
> "Patrick" <patl@.reply.newsgroup.msn.com> wrote in message
> news:esccSyRiEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > Seems like SQL Server 2000 likes SQL Client to use TCP/IP (when doing
> > backups), but Microsoft Content Management Server 2002 SP1A likes Named
> > Pipes for MCMS Server Side Site Deployment Object export to work
properly!
> > I am faced with a big dilemma!
> >
> > See
> >
>
http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+(complete)+FAQ.htm#B01B7B38-C97A-4935-8957-DC346719CE9B
> >
> > I have been experiencing frequest "General network Error"s, when I use
> > Server side SDO to export the CMS repository (as a backup, before
> importing
> > a SDO file from another test server). This article recommends the use
of
> > Named Pipes in preference over TCP/IP for SQL Client Network settings.
> >
> > However, there has been some recent failures in SQL Server Flat file
> backup
> > (SQL SErver maintenance plan to do full backup all application databases
> > with verify). Invesigation reveal (quite consistently) that the flat
file
> > backup of the MCMS 2002 SP1A database will always fail when Named Pipes
to
> > use. As soon as SQL Client is changed to use TCP/IP, backup function as
> > expectd. The error that are logged when Named pipes are used as follows
> > *1) The error logged in the error log file is :
> > 2004-08-21 21:25:14.07 spid60 BackupDiskFile::OpenMedia: Backup
device
> > 'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408212125.BAK' failed to open.
> > Operating system error = 32(error not found).
> > 2004-08-21 21:25:14.20 backup BACKUP failed to complete the command
> > BACKUP DATABASE [YJBLive] TO DISK => > N'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408212125.BAK' WITH INIT ,
> NOUNLOAD
> > , NOSKIP , STATS = 10, NOFORMAT
> >
> >
> > *2) If I change the job to just do the backup without verify, then the
job
> > completes, but
> > *2.1) Normally, the BAK file used to be 3xxMB large, but now the BAK
file
> > which only succeeded in backing up without verifying is 1xxMB large
> >
> > *3) The Job History indicates
> > Executed as user: WEBSERVER\SQLServer. sqlmaint.exe failed. [SQLSTATE
> 42000]
> > (Error 22029). The step failed.
> > The job failed. The Job was invoked by Schedule 2 (Schedule 1). The
last
> > step to run was step 1 (Step 1).
> >
> > *4) The backup file appear corrupted:
> > *4.1) If I look at the Maintenance Plan history, I found:
> > [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft][ODBC
> SQL
> > Server Driver][SQL Server]Cannot open backup device
> > 'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408231407.BAK'. Device error or
> device
> > off-line. See the SQL Server error log for more details.
> > [Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE is
> > terminating abnormally.
> > *4.2) If I try to restore this (corrupted) 1xxMB BAK file to another DB,
> it
> > doesn't work. After the popup to say restore has completed, Enterprise
> > Manager shows the database as grey with "(Loading)" appended to the
> database
> > name (even after 5mins)
> >
> > *5) The user group Everyone has full permission on d:\MSSQL\BACKUP
> >
> > *6) DBCC CheckDB, DBCC CheckFileGroup, DBCC CheckIdent reveal no errors
> >
> > So, I am really stuck here, could some SQL Server / MCMS expert help me
> out
> > here! If I use Named Pipes, SQL Backup is not going to work. If I use
> > TCP/IP, then my MCMS export/import would not work most of the time!
> >
> >
>|||Hi Patrick,
you should surely test if using named pipes solves the problem or not. We
had customers indicating that this solved their problem even after SP1a -
although we assume that the problem was related to their network
architecture as we haven't been able to repro this inhouse.
Using an ALIAS allows to do this easily without affecting any other
applications.
From my understanding backup should work with all protocols - so this
sounds as if there are indeed problems with your network architecture. You
should follow up on this in an SQL related newsgroup.
Cheers,
Stefan.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
MCMS FAQ:
http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+(complete)+FAQ.htm
MCMS Blog: http://blogs.msdn.com/stefan_gossner/category/4983.aspx
MCMS Sample Code:
http://www.gotdotnet.com/community/usersamples/Default.aspx?ProductDropDownList=Content+Management+Server
MCMS Whitepapers and other docs:
http://blogs.msdn.com/stefan_gossner/archive/2003/12/07/41859.aspx
--
"Patrick" <patl@.reply.newsgroup.msn.com> wrote in message
news:eG8LodbiEHA.3608@.TK2MSFTNGP09.phx.gbl...
> Thanks stefan,
> Can I just check if the FAQ in regards to "General Network Error" when
using
> server side SDO to do export/import apply to MCMS2002 with SP1A (the CD
> comes with SP1A) or not? If not, could you suggest any other remedies? I
> have tried all the remedies listed in the FAQ at
>
http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+(complete)+FAQ.htm#B01B7B38-C97A-4935-8957-DC346719CE9B
> and still we are getting quite frequent "General Network Error" when
> performing export on a repository (whose SQL DB is 1GB ish and whose SDO
> file is 80MB). e.g. timeouts/maxium request size are much larger than
that
> required already!!
> "Stefan [MSFT]" <stefang@.online.microsoft.com> wrote in message
> news:elC3D2RiEHA.396@.TK2MSFTNGP12.phx.gbl...
> > Hi Patrick,
> >
> > 1) MCMS likes all protocols if SP1 or SP1a are installed
> > 2) creating an ALIAS in SQL tools for the different application would
> allow
> > to configure the protocols for all apps individually.
> >
> > Cheers,
> > Stefan.
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > MCMS FAQ:
> >
>
http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+(complete)+FAQ.htm
> > MCMS Blog: http://blogs.msdn.com/stefan_gossner/category/4983.aspx
> > MCMS Sample Code:
> >
>
http://www.gotdotnet.com/community/usersamples/Default.aspx?ProductDropDownList=Content+Management+Server
> > MCMS Whitepapers and other docs:
> > http://blogs.msdn.com/stefan_gossner/archive/2003/12/07/41859.aspx
> > --
> >
> >
> > "Patrick" <patl@.reply.newsgroup.msn.com> wrote in message
> > news:esccSyRiEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > > Seems like SQL Server 2000 likes SQL Client to use TCP/IP (when doing
> > > backups), but Microsoft Content Management Server 2002 SP1A likes
Named
> > > Pipes for MCMS Server Side Site Deployment Object export to work
> properly!
> > > I am faced with a big dilemma!
> > >
> > > See
> > >
> >
>
http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+(complete)+FAQ.htm#B01B7B38-C97A-4935-8957-DC346719CE9B
> > >
> > > I have been experiencing frequest "General network Error"s, when I use
> > > Server side SDO to export the CMS repository (as a backup, before
> > importing
> > > a SDO file from another test server). This article recommends the use
> of
> > > Named Pipes in preference over TCP/IP for SQL Client Network settings.
> > >
> > > However, there has been some recent failures in SQL Server Flat file
> > backup
> > > (SQL SErver maintenance plan to do full backup all application
databases
> > > with verify). Invesigation reveal (quite consistently) that the flat
> file
> > > backup of the MCMS 2002 SP1A database will always fail when Named
Pipes
> to
> > > use. As soon as SQL Client is changed to use TCP/IP, backup function
as
> > > expectd. The error that are logged when Named pipes are used as
follows
> > > *1) The error logged in the error log file is :
> > > 2004-08-21 21:25:14.07 spid60 BackupDiskFile::OpenMedia: Backup
> device
> > > 'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408212125.BAK' failed to open.
> > > Operating system error = 32(error not found).
> > > 2004-08-21 21:25:14.20 backup BACKUP failed to complete the command
> > > BACKUP DATABASE [YJBLive] TO DISK => > > N'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408212125.BAK' WITH INIT ,
> > NOUNLOAD
> > > , NOSKIP , STATS = 10, NOFORMAT
> > >
> > >
> > > *2) If I change the job to just do the backup without verify, then the
> job
> > > completes, but
> > > *2.1) Normally, the BAK file used to be 3xxMB large, but now the BAK
> file
> > > which only succeeded in backing up without verifying is 1xxMB large
> > >
> > > *3) The Job History indicates
> > > Executed as user: WEBSERVER\SQLServer. sqlmaint.exe failed. [SQLSTATE
> > 42000]
> > > (Error 22029). The step failed.
> > > The job failed. The Job was invoked by Schedule 2 (Schedule 1). The
> last
> > > step to run was step 1 (Step 1).
> > >
> > > *4) The backup file appear corrupted:
> > > *4.1) If I look at the Maintenance Plan history, I found:
> > > [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201:
[Microsoft][ODBC
> > SQL
> > > Server Driver][SQL Server]Cannot open backup device
> > > 'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408231407.BAK'. Device error or
> > device
> > > off-line. See the SQL Server error log for more details.
> > > [Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE is
> > > terminating abnormally.
> > > *4.2) If I try to restore this (corrupted) 1xxMB BAK file to another
DB,
> > it
> > > doesn't work. After the popup to say restore has completed,
Enterprise
> > > Manager shows the database as grey with "(Loading)" appended to the
> > database
> > > name (even after 5mins)
> > >
> > > *5) The user group Everyone has full permission on d:\MSSQL\BACKUP
> > >
> > > *6) DBCC CheckDB, DBCC CheckFileGroup, DBCC CheckIdent reveal no
errors
> > >
> > > So, I am really stuck here, could some SQL Server / MCMS expert help
me
> > out
> > > here! If I use Named Pipes, SQL Backup is not going to work. If I
use
> > > TCP/IP, then my MCMS export/import would not work most of the time!
> > >
> > >
> >
> >
>|||Actually:
1) Tests reveal that we cannot consistently prove whether Server side SDO
export/import would work with TCP/IP or Named-pipes
2) Tests reveal that Flat file backups
2.1) for the MCMS 2002 SP1A Repository consistently fail when SQL Client
Network utility is set to use Named Pipes.
2.2) For other databases (including a 3GB database, as opposed to a mere 1GB
MCMS SQL DB) all works with named pipes
3) The SQL Server, IIS and CMS are all on the same box! So, named pipes
should be using (I believe) the internal kernel, which is meant to be super
fast?
"Stefan [MSFT]" <stefang@.online.microsoft.com> wrote in message
news:evymkDciEHA.4020@.TK2MSFTNGP10.phx.gbl...
> Hi Patrick,
> you should surely test if using named pipes solves the problem or not. We
> had customers indicating that this solved their problem even after SP1a -
> although we assume that the problem was related to their network
> architecture as we haven't been able to repro this inhouse.
> Using an ALIAS allows to do this easily without affecting any other
> applications.
> From my understanding backup should work with all protocols - so this
> sounds as if there are indeed problems with your network architecture. You
> should follow up on this in an SQL related newsgroup.
> Cheers,
> Stefan.
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> MCMS FAQ:
>
http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+(complete)+FAQ.htm
> MCMS Blog: http://blogs.msdn.com/stefan_gossner/category/4983.aspx
> MCMS Sample Code:
>
http://www.gotdotnet.com/community/usersamples/Default.aspx?ProductDropDownList=Content+Management+Server
> MCMS Whitepapers and other docs:
> http://blogs.msdn.com/stefan_gossner/archive/2003/12/07/41859.aspx
> --
>
> "Patrick" <patl@.reply.newsgroup.msn.com> wrote in message
> news:eG8LodbiEHA.3608@.TK2MSFTNGP09.phx.gbl...
> > Thanks stefan,
> > Can I just check if the FAQ in regards to "General Network Error" when
> using
> > server side SDO to do export/import apply to MCMS2002 with SP1A (the CD
> > comes with SP1A) or not? If not, could you suggest any other remedies?
I
> > have tried all the remedies listed in the FAQ at
> >
>
http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+(complete)+FAQ.htm#B01B7B38-C97A-4935-8957-DC346719CE9B
> > and still we are getting quite frequent "General Network Error" when
> > performing export on a repository (whose SQL DB is 1GB ish and whose SDO
> > file is 80MB). e.g. timeouts/maxium request size are much larger than
> that
> > required already!!
> >
> > "Stefan [MSFT]" <stefang@.online.microsoft.com> wrote in message
> > news:elC3D2RiEHA.396@.TK2MSFTNGP12.phx.gbl...
> > > Hi Patrick,
> > >
> > > 1) MCMS likes all protocols if SP1 or SP1a are installed
> > > 2) creating an ALIAS in SQL tools for the different application would
> > allow
> > > to configure the protocols for all apps individually.
> > >
> > > Cheers,
> > > Stefan.
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > MCMS FAQ:
> > >
> >
>
http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+(complete)+FAQ.htm
> > > MCMS Blog: http://blogs.msdn.com/stefan_gossner/category/4983.aspx
> > > MCMS Sample Code:
> > >
> >
>
http://www.gotdotnet.com/community/usersamples/Default.aspx?ProductDropDownList=Content+Management+Server
> > > MCMS Whitepapers and other docs:
> > > http://blogs.msdn.com/stefan_gossner/archive/2003/12/07/41859.aspx
> > > --
> > >
> > >
> > > "Patrick" <patl@.reply.newsgroup.msn.com> wrote in message
> > > news:esccSyRiEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > > > Seems like SQL Server 2000 likes SQL Client to use TCP/IP (when
doing
> > > > backups), but Microsoft Content Management Server 2002 SP1A likes
> Named
> > > > Pipes for MCMS Server Side Site Deployment Object export to work
> > properly!
> > > > I am faced with a big dilemma!
> > > >
> > > > See
> > > >
> > >
> >
>
http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+(complete)+FAQ.htm#B01B7B38-C97A-4935-8957-DC346719CE9B
> > > >
> > > > I have been experiencing frequest "General network Error"s, when I
use
> > > > Server side SDO to export the CMS repository (as a backup, before
> > > importing
> > > > a SDO file from another test server). This article recommends the
use
> > of
> > > > Named Pipes in preference over TCP/IP for SQL Client Network
settings.
> > > >
> > > > However, there has been some recent failures in SQL Server Flat file
> > > backup
> > > > (SQL SErver maintenance plan to do full backup all application
> databases
> > > > with verify). Invesigation reveal (quite consistently) that the
flat
> > file
> > > > backup of the MCMS 2002 SP1A database will always fail when Named
> Pipes
> > to
> > > > use. As soon as SQL Client is changed to use TCP/IP, backup
function
> as
> > > > expectd. The error that are logged when Named pipes are used as
> follows
> > > > *1) The error logged in the error log file is :
> > > > 2004-08-21 21:25:14.07 spid60 BackupDiskFile::OpenMedia: Backup
> > device
> > > > 'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408212125.BAK' failed to open.
> > > > Operating system error = 32(error not found).
> > > > 2004-08-21 21:25:14.20 backup BACKUP failed to complete the
command
> > > > BACKUP DATABASE [YJBLive] TO DISK => > > > N'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408212125.BAK' WITH INIT ,
> > > NOUNLOAD
> > > > , NOSKIP , STATS = 10, NOFORMAT
> > > >
> > > >
> > > > *2) If I change the job to just do the backup without verify, then
the
> > job
> > > > completes, but
> > > > *2.1) Normally, the BAK file used to be 3xxMB large, but now the BAK
> > file
> > > > which only succeeded in backing up without verifying is 1xxMB large
> > > >
> > > > *3) The Job History indicates
> > > > Executed as user: WEBSERVER\SQLServer. sqlmaint.exe failed.
[SQLSTATE
> > > 42000]
> > > > (Error 22029). The step failed.
> > > > The job failed. The Job was invoked by Schedule 2 (Schedule 1).
The
> > last
> > > > step to run was step 1 (Step 1).
> > > >
> > > > *4) The backup file appear corrupted:
> > > > *4.1) If I look at the Maintenance Plan history, I found:
> > > > [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201:
> [Microsoft][ODBC
> > > SQL
> > > > Server Driver][SQL Server]Cannot open backup device
> > > > 'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408231407.BAK'. Device error or
> > > device
> > > > off-line. See the SQL Server error log for more details.
> > > > [Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE is
> > > > terminating abnormally.
> > > > *4.2) If I try to restore this (corrupted) 1xxMB BAK file to another
> DB,
> > > it
> > > > doesn't work. After the popup to say restore has completed,
> Enterprise
> > > > Manager shows the database as grey with "(Loading)" appended to the
> > > database
> > > > name (even after 5mins)
> > > >
> > > > *5) The user group Everyone has full permission on d:\MSSQL\BACKUP
> > > >
> > > > *6) DBCC CheckDB, DBCC CheckFileGroup, DBCC CheckIdent reveal no
> errors
> > > >
> > > > So, I am really stuck here, could some SQL Server / MCMS expert help
> me
> > > out
> > > > here! If I use Named Pipes, SQL Backup is not going to work. If I
> use
> > > > TCP/IP, then my MCMS export/import would not work most of the time!
> > > >
> > > >
> > >
> > >
> >
> >
>sql
Flat File Backup Failed *suddenly*
OS: Win2K Server SP4
DB: SQL Server 2000 SP3a
I have a database that has a1.1GB LDF file and a 380MB MDF file
I have a database maintenanec plan set up to do full database backup (i.e.
not differential) of all non-system databases including this database in
question.
The backup to d:\MSSQL\BACKUP (with a sub directory for each DB) has been
working fine since the server was set up 6 months ago. Suddently, the
backup stopped working on Saturday (the Friday backup is successful and no
one was in the office on Saturday, to rule out any system changes that could
have trigger this).
Observations
*1) The error logged in the error log file is :
2004-08-21 21:25:14.07 spid60 BackupDiskFile::OpenMedia: Backup device
'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408212125.BAK' failed to open.
Operating system error = 32(error not found).
2004-08-21 21:25:14.20 backup BACKUP failed to complete the command
BACKUP DATABASE [YJBLive] TO DISK = N'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408212125.BAK' WITH INIT , NOUNLOAD
, NOSKIP , STATS = 10, NOFORMAT
*2) If I change the job to just do the backup without verify, then the job
completes, but
*2.1) Normally, the BAK file used to be 3xxMB large, but now the BAK file
which only succeeded in backing up without verifying is 1xxMB large
*3) The Job History indicates
Executed as user: WEBSERVER\SQLServer. sqlmaint.exe failed. [SQLSTATE 42000]
(Error 22029). The step failed.
The job failed. The Job was invoked by Schedule 2 (Schedule 1). The last
step to run was step 1 (Step 1).
*4) The backup file appear corrupted:
*4.1) If I look at the Maintenance Plan history, I found:
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft][ODBC SQL
Server Driver][SQL Server]Cannot open backup device
'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408231407.BAK'. Device error or device
off-line. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE is
terminating abnormally.
*4.2) If I try to restore this (corrupted) 1xxMB BAK file to another DB, it
doesn't work. After the popup to say restore has completed, Enterprise
Manager shows the database as grey with "(Loading)" appended to the database
name (even after 5mins)
*) The user group Everyone has full permission on d:\MSSQL\BACKUP
SOS !! Why is my backup suddenly failing and how could I resolve this?
Note it is only this database whose backup are failing since Saturday (e.g.
I have a DB which has a 3.8GB LDF file which backup with no problems!)Hi Patrick,
I have noticed you make another new thread in this newsgroup. MSFT Stefan
had added a reply to you. I will continue monitor and follow up if
necessary in that thread until it is resolved.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Stefan says it's a SQL Server issue, so replying here.
Effectively, full flat file backup (to D:\ drive using a SQL Server 2000
SP3a maintenance plan) of all application database except for the Microsoft
Content Management Server(MCMS) 2002 SP1A repository works regardless of
whether Client Network utility is set to use TCP/IP or named pipes, but for
this MCMS2002 SP1A Repository, backup only works when TCP/IP is used.
When Veritas Backup Exec 9.1 for windows server with SQL Agent is used to
backup the databases, the databases could be backed up regardless of the SQL
client settings.
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:55NG3fYiEHA.2408@.cpmsftngxa10.phx.gbl...
> Hi Patrick,
> I have noticed you make another new thread in this newsgroup. MSFT Stefan
> had added a reply to you. I will continue monitor and follow up if
> necessary in that thread until it is resolved.
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Microsoft Developer Community Support
> ---
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi Patrick,
From your descriptions, I understood that your encounter backup failure
issue. Have I understood you? If there is anything I misunderstood, please
feel free to let me know.
Based on my scope, I think the following document might help on your issue.
FIX: General network error when you try to back up or restore a SQL Server
database on a computer that is running Windows Server 2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;827452
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi Patrick,
I would like to follow up on this issue and see if any progress has been
made. I haven't heard from you in 2 days, were you able to check my reply?
Should you have any questions, please feel free to post here.
Looking forward to your reply!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
DB: SQL Server 2000 SP3a
I have a database that has a1.1GB LDF file and a 380MB MDF file
I have a database maintenanec plan set up to do full database backup (i.e.
not differential) of all non-system databases including this database in
question.
The backup to d:\MSSQL\BACKUP (with a sub directory for each DB) has been
working fine since the server was set up 6 months ago. Suddently, the
backup stopped working on Saturday (the Friday backup is successful and no
one was in the office on Saturday, to rule out any system changes that could
have trigger this).
Observations
*1) The error logged in the error log file is :
2004-08-21 21:25:14.07 spid60 BackupDiskFile::OpenMedia: Backup device
'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408212125.BAK' failed to open.
Operating system error = 32(error not found).
2004-08-21 21:25:14.20 backup BACKUP failed to complete the command
BACKUP DATABASE [YJBLive] TO DISK = N'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408212125.BAK' WITH INIT , NOUNLOAD
, NOSKIP , STATS = 10, NOFORMAT
*2) If I change the job to just do the backup without verify, then the job
completes, but
*2.1) Normally, the BAK file used to be 3xxMB large, but now the BAK file
which only succeeded in backing up without verifying is 1xxMB large
*3) The Job History indicates
Executed as user: WEBSERVER\SQLServer. sqlmaint.exe failed. [SQLSTATE 42000]
(Error 22029). The step failed.
The job failed. The Job was invoked by Schedule 2 (Schedule 1). The last
step to run was step 1 (Step 1).
*4) The backup file appear corrupted:
*4.1) If I look at the Maintenance Plan history, I found:
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft][ODBC SQL
Server Driver][SQL Server]Cannot open backup device
'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408231407.BAK'. Device error or device
off-line. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE is
terminating abnormally.
*4.2) If I try to restore this (corrupted) 1xxMB BAK file to another DB, it
doesn't work. After the popup to say restore has completed, Enterprise
Manager shows the database as grey with "(Loading)" appended to the database
name (even after 5mins)
*) The user group Everyone has full permission on d:\MSSQL\BACKUP
SOS !! Why is my backup suddenly failing and how could I resolve this?
Note it is only this database whose backup are failing since Saturday (e.g.
I have a DB which has a 3.8GB LDF file which backup with no problems!)Hi Patrick,
I have noticed you make another new thread in this newsgroup. MSFT Stefan
had added a reply to you. I will continue monitor and follow up if
necessary in that thread until it is resolved.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Stefan says it's a SQL Server issue, so replying here.
Effectively, full flat file backup (to D:\ drive using a SQL Server 2000
SP3a maintenance plan) of all application database except for the Microsoft
Content Management Server(MCMS) 2002 SP1A repository works regardless of
whether Client Network utility is set to use TCP/IP or named pipes, but for
this MCMS2002 SP1A Repository, backup only works when TCP/IP is used.
When Veritas Backup Exec 9.1 for windows server with SQL Agent is used to
backup the databases, the databases could be backed up regardless of the SQL
client settings.
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:55NG3fYiEHA.2408@.cpmsftngxa10.phx.gbl...
> Hi Patrick,
> I have noticed you make another new thread in this newsgroup. MSFT Stefan
> had added a reply to you. I will continue monitor and follow up if
> necessary in that thread until it is resolved.
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Microsoft Developer Community Support
> ---
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi Patrick,
From your descriptions, I understood that your encounter backup failure
issue. Have I understood you? If there is anything I misunderstood, please
feel free to let me know.
Based on my scope, I think the following document might help on your issue.
FIX: General network error when you try to back up or restore a SQL Server
database on a computer that is running Windows Server 2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;827452
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi Patrick,
I would like to follow up on this issue and see if any progress has been
made. I haven't heard from you in 2 days, were you able to check my reply?
Should you have any questions, please feel free to post here.
Looking forward to your reply!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
2012年3月11日星期日
FIX: Differential database backups... Article ID: 892923
Just wondering if this fix is included in SP4 and if not, do we apply the
fix after SP4 or before SP4...
Thanks...
FIX: Differential database backups may not contain database changes in the
Page Free Space (PFS) pages in SQL Server 2000
Article ID:892923
Last Review:March 9, 2005
Revision:1.0
From the version number, it seems like it is included. However, it is
best to call Microsoft PSS to verify.
Yih-Yoon Lee
E-mail: yihyoon@.gmail.com
BATMAN wrote:
> Just wondering if this fix is included in SP4 and if not, do we apply the
> fix after SP4 or before SP4...
> Thanks...
> FIX: Differential database backups may not contain database changes in the
> Page Free Space (PFS) pages in SQL Server 2000
> Article ID:892923
> Last Review:March 9, 2005
> Revision:1.0
>
fix after SP4 or before SP4...
Thanks...
FIX: Differential database backups may not contain database changes in the
Page Free Space (PFS) pages in SQL Server 2000
Article ID:892923
Last Review:March 9, 2005
Revision:1.0
From the version number, it seems like it is included. However, it is
best to call Microsoft PSS to verify.
Yih-Yoon Lee
E-mail: yihyoon@.gmail.com
BATMAN wrote:
> Just wondering if this fix is included in SP4 and if not, do we apply the
> fix after SP4 or before SP4...
> Thanks...
> FIX: Differential database backups may not contain database changes in the
> Page Free Space (PFS) pages in SQL Server 2000
> Article ID:892923
> Last Review:March 9, 2005
> Revision:1.0
>
FIX: Differential database backups... Article ID: 892923
Just wondering if this fix is included in SP4 and if not, do we apply the
fix after SP4 or before SP4...
Thanks...
---
FIX: Differential database backups may not contain database changes in the
Page Free Space (PFS) pages in SQL Server 2000
Article ID: 892923
Last Review: March 9, 2005
Revision: 1.0
---From the version number, it seems like it is included. However, it is
best to call Microsoft PSS to verify.
Yih-Yoon Lee
E-mail: yihyoon@.gmail.com
BATMAN wrote:
> Just wondering if this fix is included in SP4 and if not, do we apply the
> fix after SP4 or before SP4...
> Thanks...
> ---
> FIX: Differential database backups may not contain database changes in the
> Page Free Space (PFS) pages in SQL Server 2000
> Article ID: 892923
> Last Review: March 9, 2005
> Revision: 1.0
> ---
>
fix after SP4 or before SP4...
Thanks...
---
FIX: Differential database backups may not contain database changes in the
Page Free Space (PFS) pages in SQL Server 2000
Article ID: 892923
Last Review: March 9, 2005
Revision: 1.0
---From the version number, it seems like it is included. However, it is
best to call Microsoft PSS to verify.
Yih-Yoon Lee
E-mail: yihyoon@.gmail.com
BATMAN wrote:
> Just wondering if this fix is included in SP4 and if not, do we apply the
> fix after SP4 or before SP4...
> Thanks...
> ---
> FIX: Differential database backups may not contain database changes in the
> Page Free Space (PFS) pages in SQL Server 2000
> Article ID: 892923
> Last Review: March 9, 2005
> Revision: 1.0
> ---
>
FIX: Differential database backups... Article ID: 892923
Just wondering if this fix is included in SP4 and if not, do we apply the
fix after SP4 or before SP4...
Thanks...
---
FIX: Differential database backups may not contain database changes in the
Page Free Space (PFS) pages in SQL Server 2000
Article ID: 892923
Last Review: March 9, 2005
Revision: 1.0
---From the version number, it seems like it is included. However, it is
best to call Microsoft PSS to verify.
Yih-Yoon Lee
E-mail: yihyoon@.gmail.com
BATMAN wrote:
> Just wondering if this fix is included in SP4 and if not, do we apply the
> fix after SP4 or before SP4...
> Thanks...
> ---
> FIX: Differential database backups may not contain database changes in the
> Page Free Space (PFS) pages in SQL Server 2000
> Article ID: 892923
> Last Review: March 9, 2005
> Revision: 1.0
> ---
>
fix after SP4 or before SP4...
Thanks...
---
FIX: Differential database backups may not contain database changes in the
Page Free Space (PFS) pages in SQL Server 2000
Article ID: 892923
Last Review: March 9, 2005
Revision: 1.0
---From the version number, it seems like it is included. However, it is
best to call Microsoft PSS to verify.
Yih-Yoon Lee
E-mail: yihyoon@.gmail.com
BATMAN wrote:
> Just wondering if this fix is included in SP4 and if not, do we apply the
> fix after SP4 or before SP4...
> Thanks...
> ---
> FIX: Differential database backups may not contain database changes in the
> Page Free Space (PFS) pages in SQL Server 2000
> Article ID: 892923
> Last Review: March 9, 2005
> Revision: 1.0
> ---
>
FIX: AWE and SQL Server 2000 SP4 (899761)
FIX: Not all memory is available when AWE is enabled on a computer that is
running a 32-bit version of SQL Server 2000 SP4 (899761)
http://www.microsoft.com/downloads/details.aspx?familyid=7c407047-3f1f-48b8-9e4c-dc32875e1961&displaylang=en
This issue only impacts customers with more than 2GB of memory (available
only with the Enterprise, Developer and Evaluation editions) where AWE has
been enabled and more than half of the total system memory is being
allocated to a single SQL Server instance.
Customers with this configuration should apply this hotfix after upgrading
to SQL Server 2000 Service Pack 4.
KB 899761 http://support.microsoft.com/default.aspx?scid=KB;en-us;899761
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.orgThanks Jasper.
Is there any central resouce for sql server hot fixes?
Paul
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:%23VwCMVMdFHA.412@.tk2msftngp13.phx.gbl...
> FIX: Not all memory is available when AWE is enabled on a computer that is
> running a 32-bit version of SQL Server 2000 SP4 (899761)
> http://www.microsoft.com/downloads/details.aspx?familyid=7c407047-3f1f-48b8-9e4c-dc32875e1961&displaylang=en
> This issue only impacts customers with more than 2GB of memory (available
> only with the Enterprise, Developer and Evaluation editions) where AWE has
> been enabled and more than half of the total system memory is being
> allocated to a single SQL Server instance.
> Customers with this configuration should apply this hotfix after upgrading
> to SQL Server 2000 Service Pack 4.
> KB 899761 http://support.microsoft.com/default.aspx?scid=KB;en-us;899761
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>|||Hi
For a list, you can find it here.
http://www.aspfaq.com/show.asp?id=2160
For some reason, it has not been updated to the latest fixes yet.
Cheers
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Paul Cahill" <nospam@.hotmail.com> wrote in message
news:Oyu$31QdFHA.1684@.TK2MSFTNGP09.phx.gbl...
> Thanks Jasper.
> Is there any central resouce for sql server hot fixes?
> Paul
> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
> news:%23VwCMVMdFHA.412@.tk2msftngp13.phx.gbl...
>> FIX: Not all memory is available when AWE is enabled on a computer that
>> is running a 32-bit version of SQL Server 2000 SP4 (899761)
>> http://www.microsoft.com/downloads/details.aspx?familyid=7c407047-3f1f-48b8-9e4c-dc32875e1961&displaylang=en
>> This issue only impacts customers with more than 2GB of memory (available
>> only with the Enterprise, Developer and Evaluation editions) where AWE
>> has been enabled and more than half of the total system memory is being
>> allocated to a single SQL Server instance.
>> Customers with this configuration should apply this hotfix after
>> upgrading to SQL Server 2000 Service Pack 4.
>> KB 899761 http://support.microsoft.com/default.aspx?scid=KB;en-us;899761
>> --
>> HTH
>> Jasper Smith (SQL Server MVP)
>> http://www.sqldbatips.com
>> I support PASS - the definitive, global
>> community for SQL Server professionals -
>> http://www.sqlpass.org
>>
>|||Thanks Mike.
Paul
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:euYYVbRdFHA.1384@.TK2MSFTNGP09.phx.gbl...
> Hi
> For a list, you can find it here.
> http://www.aspfaq.com/show.asp?id=2160
> For some reason, it has not been updated to the latest fixes yet.
> Cheers
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Paul Cahill" <nospam@.hotmail.com> wrote in message
> news:Oyu$31QdFHA.1684@.TK2MSFTNGP09.phx.gbl...
>> Thanks Jasper.
>> Is there any central resouce for sql server hot fixes?
>> Paul
>> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
>> news:%23VwCMVMdFHA.412@.tk2msftngp13.phx.gbl...
>> FIX: Not all memory is available when AWE is enabled on a computer that
>> is running a 32-bit version of SQL Server 2000 SP4 (899761)
>> http://www.microsoft.com/downloads/details.aspx?familyid=7c407047-3f1f-48b8-9e4c-dc32875e1961&displaylang=en
>> This issue only impacts customers with more than 2GB of memory
>> (available only with the Enterprise, Developer and Evaluation editions)
>> where AWE has been enabled and more than half of the total system memory
>> is being allocated to a single SQL Server instance.
>> Customers with this configuration should apply this hotfix after
>> upgrading to SQL Server 2000 Service Pack 4.
>> KB 899761 http://support.microsoft.com/default.aspx?scid=KB;en-us;899761
>> --
>> HTH
>> Jasper Smith (SQL Server MVP)
>> http://www.sqldbatips.com
>> I support PASS - the definitive, global
>> community for SQL Server professionals -
>> http://www.sqlpass.org
>>
>>
>|||Mike Epprecht (SQL MVP) wrote:
> For a list, you can find it here:
> http://www.aspfaq.com/show.asp=AD?id=3D2160
> For some reason, it has not been updated to the latest fixes yet.
An updated list, containing only the build numbers for SQL Server 2000,
can be found at:
http://www.aspfaq.com/sql2000builds.asp
Razvan
running a 32-bit version of SQL Server 2000 SP4 (899761)
http://www.microsoft.com/downloads/details.aspx?familyid=7c407047-3f1f-48b8-9e4c-dc32875e1961&displaylang=en
This issue only impacts customers with more than 2GB of memory (available
only with the Enterprise, Developer and Evaluation editions) where AWE has
been enabled and more than half of the total system memory is being
allocated to a single SQL Server instance.
Customers with this configuration should apply this hotfix after upgrading
to SQL Server 2000 Service Pack 4.
KB 899761 http://support.microsoft.com/default.aspx?scid=KB;en-us;899761
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.orgThanks Jasper.
Is there any central resouce for sql server hot fixes?
Paul
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:%23VwCMVMdFHA.412@.tk2msftngp13.phx.gbl...
> FIX: Not all memory is available when AWE is enabled on a computer that is
> running a 32-bit version of SQL Server 2000 SP4 (899761)
> http://www.microsoft.com/downloads/details.aspx?familyid=7c407047-3f1f-48b8-9e4c-dc32875e1961&displaylang=en
> This issue only impacts customers with more than 2GB of memory (available
> only with the Enterprise, Developer and Evaluation editions) where AWE has
> been enabled and more than half of the total system memory is being
> allocated to a single SQL Server instance.
> Customers with this configuration should apply this hotfix after upgrading
> to SQL Server 2000 Service Pack 4.
> KB 899761 http://support.microsoft.com/default.aspx?scid=KB;en-us;899761
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>|||Hi
For a list, you can find it here.
http://www.aspfaq.com/show.asp?id=2160
For some reason, it has not been updated to the latest fixes yet.
Cheers
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Paul Cahill" <nospam@.hotmail.com> wrote in message
news:Oyu$31QdFHA.1684@.TK2MSFTNGP09.phx.gbl...
> Thanks Jasper.
> Is there any central resouce for sql server hot fixes?
> Paul
> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
> news:%23VwCMVMdFHA.412@.tk2msftngp13.phx.gbl...
>> FIX: Not all memory is available when AWE is enabled on a computer that
>> is running a 32-bit version of SQL Server 2000 SP4 (899761)
>> http://www.microsoft.com/downloads/details.aspx?familyid=7c407047-3f1f-48b8-9e4c-dc32875e1961&displaylang=en
>> This issue only impacts customers with more than 2GB of memory (available
>> only with the Enterprise, Developer and Evaluation editions) where AWE
>> has been enabled and more than half of the total system memory is being
>> allocated to a single SQL Server instance.
>> Customers with this configuration should apply this hotfix after
>> upgrading to SQL Server 2000 Service Pack 4.
>> KB 899761 http://support.microsoft.com/default.aspx?scid=KB;en-us;899761
>> --
>> HTH
>> Jasper Smith (SQL Server MVP)
>> http://www.sqldbatips.com
>> I support PASS - the definitive, global
>> community for SQL Server professionals -
>> http://www.sqlpass.org
>>
>|||Thanks Mike.
Paul
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:euYYVbRdFHA.1384@.TK2MSFTNGP09.phx.gbl...
> Hi
> For a list, you can find it here.
> http://www.aspfaq.com/show.asp?id=2160
> For some reason, it has not been updated to the latest fixes yet.
> Cheers
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Paul Cahill" <nospam@.hotmail.com> wrote in message
> news:Oyu$31QdFHA.1684@.TK2MSFTNGP09.phx.gbl...
>> Thanks Jasper.
>> Is there any central resouce for sql server hot fixes?
>> Paul
>> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
>> news:%23VwCMVMdFHA.412@.tk2msftngp13.phx.gbl...
>> FIX: Not all memory is available when AWE is enabled on a computer that
>> is running a 32-bit version of SQL Server 2000 SP4 (899761)
>> http://www.microsoft.com/downloads/details.aspx?familyid=7c407047-3f1f-48b8-9e4c-dc32875e1961&displaylang=en
>> This issue only impacts customers with more than 2GB of memory
>> (available only with the Enterprise, Developer and Evaluation editions)
>> where AWE has been enabled and more than half of the total system memory
>> is being allocated to a single SQL Server instance.
>> Customers with this configuration should apply this hotfix after
>> upgrading to SQL Server 2000 Service Pack 4.
>> KB 899761 http://support.microsoft.com/default.aspx?scid=KB;en-us;899761
>> --
>> HTH
>> Jasper Smith (SQL Server MVP)
>> http://www.sqldbatips.com
>> I support PASS - the definitive, global
>> community for SQL Server professionals -
>> http://www.sqlpass.org
>>
>>
>|||Mike Epprecht (SQL MVP) wrote:
> For a list, you can find it here:
> http://www.aspfaq.com/show.asp=AD?id=3D2160
> For some reason, it has not been updated to the latest fixes yet.
An updated list, containing only the build numbers for SQL Server 2000,
can be found at:
http://www.aspfaq.com/sql2000builds.asp
Razvan
订阅：
博文 (Atom)