I have seen this message in Windows event log after restarting database.
3450:
Recovery of database 'IMAX_INV_Mgmt' (5) is 0% complete.
(approximately 2152 more seconds) (Phase 2 of 3)
Question is:
What are these three phases.
Thx,
MohI'm not entirely certain about all 3 but there are at least 2 steps in a
recovery (whether a restore or a DB startup) and they are the
roll-forward and the roll-back. The roll-forward is "redoing" committed
transactions (they may have been written to the transaction log, as this
always happens first, but not yet written to the data file(s)). If the
server is shutdown properly, then this phase will should be very short,
if not non-existent. The roll-back phase is "undoing" transactions that
had not been committed at the recovery point (so at the point the server
was shut down there may have been some transactions in progress that
hadn't been committed yet). These 2 phases will put the data in a
consistent state as at the recovery point.
I'm guessing the 3rd stage in the startup recovery would be bringing the
database "online" so it will accept user connections (in a RESTORE
process the very 1st phase (before roll-forward and then roll-back) is
the data copy phase but this wouldn't be necessary for a startup
recovery because the data would already be in the data files). There's
a fairly good page about it in BOL: Understanding How Restore and
Recovery of Backups Work
<http://msdn2.microsoft.com/en-us/li...8SQL.90%29.aspx>
With SQL 2000 the database is unusable until the end of the roll-back
phase. With SQL 2005 the database is now usable after the end of the
roll-forward phase. From memory they coined this "fast recovery" or
something like that (Database Engine Availability Enhancements
<http://msdn2.microsoft.com/en-us/li...8SQL.90%29.aspx> ).
Hope this helps.
*mike hodgson*
http://sqlnerd.blogspot.com
Moh wrote:
>I have seen this message in Windows event log after restarting database.
>3450:
>Recovery of database 'IMAX_INV_Mgmt' (5) is 0% complete.
>(approximately 2152 more seconds) (Phase 2 of 3)
>Question is:
>What are these three phases.
>Thx,
>Moh
>|||Just a note that in SQL 2005 its only Enterprise edition that allows the dat
abase to be accessed before the rol back phase is complete.
--
Simon Sabin
SQL Server MVP
http://sqljunkies.com/weblog/simons
"Mike Hodgson" <e1minst3r@.gmail.com> wrote in message news:OJ64mwqYGHA.1016@.
TK2MSFTNGP03.phx.gbl...
I'm not entirely certain about all 3 but there are at least 2 steps in a rec
overy (whether a restore or a DB startup) and they are the roll-forward and
the roll-back. The roll-forward is "redoing" committed transactions (they m
ay have been written to the transaction log, as this always happens first, b
ut not yet written to the data file(s)). If the server is shutdown properly
, then this phase will should be very short, if not non-existent. The roll-
back phase is "undoing" transactions that had not been committed at the reco
very point (so at the point the server was shut down there may have been som
e transactions in progress that hadn't been committed yet). These 2 phases
will put the data in a consistent state as at the recovery point.
I'm guessing the 3rd stage in the startup recovery would be bringing the dat
abase "online" so it will accept user connections (in a RESTORE process the
very 1st phase (before roll-forward and then roll-back) is the data copy pha
se but this wouldn't be necessary for a startup recovery because the data wo
uld already be in the data files). There's a fairly good page about it in B
OL: Understanding How Restore and Recovery of Backups Work
With SQL 2000 the database is unusable until the end of the roll-back phase.
With SQL 2005 the database is now usable after the end of the roll-forward
phase. From memory they coined this "fast recovery" or something like that
(Database Engine Availability Enhancements).
Hope this helps.
mike hodgson
http://sqlnerd.blogspot.com
Moh wrote:
I have seen this message in Windows event log after restarting database.
3450:
Recovery of database 'IMAX_INV_Mgmt' (5) is 0% complete.
(approximately 2152 more seconds) (Phase 2 of 3)
Question is:
What are these three phases.
Thx,
Moh
Showing posts with label message. Show all posts
Showing posts with label message. Show all posts
Friday, March 30, 2012
Recovery phases
I have seen this message in Windows event log after restarting database.
3450:
Recovery of database 'IMAX_INV_Mgmt' (5) is 0% complete.
(approximately 2152 more seconds) (Phase 2 of 3)
Question is:
What are these three phases.
Thx,
MohThis is a multi-part message in MIME format.
--080209040300000504020608
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
I'm not entirely certain about all 3 but there are at least 2 steps in a
recovery (whether a restore or a DB startup) and they are the
roll-forward and the roll-back. The roll-forward is "redoing" committed
transactions (they may have been written to the transaction log, as this
always happens first, but not yet written to the data file(s)). If the
server is shutdown properly, then this phase will should be very short,
if not non-existent. The roll-back phase is "undoing" transactions that
had not been committed at the recovery point (so at the point the server
was shut down there may have been some transactions in progress that
hadn't been committed yet). These 2 phases will put the data in a
consistent state as at the recovery point.
I'm guessing the 3rd stage in the startup recovery would be bringing the
database "online" so it will accept user connections (in a RESTORE
process the very 1st phase (before roll-forward and then roll-back) is
the data copy phase but this wouldn't be necessary for a startup
recovery because the data would already be in the data files). There's
a fairly good page about it in BOL: Understanding How Restore and
Recovery of Backups Work
<http://msdn2.microsoft.com/en-us/library/ms191455%28SQL.90%29.aspx>
With SQL 2000 the database is unusable until the end of the roll-back
phase. With SQL 2005 the database is now usable after the end of the
roll-forward phase. From memory they coined this "fast recovery" or
something like that (Database Engine Availability Enhancements
<http://msdn2.microsoft.com/en-us/library/ms171001%28SQL.90%29.aspx>).
Hope this helps.
--
*mike hodgson*
http://sqlnerd.blogspot.com
Moh wrote:
>I have seen this message in Windows event log after restarting database.
>3450:
>Recovery of database 'IMAX_INV_Mgmt' (5) is 0% complete.
>(approximately 2152 more seconds) (Phase 2 of 3)
>Question is:
>What are these three phases.
>Thx,
>Moh
>
--080209040300000504020608
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>I'm not entirely certain about all 3 but there are at least 2 steps
in a recovery (whether a restore or a DB startup) and they are the
roll-forward and the roll-back. The roll-forward is "redoing"
committed transactions (they may have been written to the transaction
log, as this always happens first, but not yet written to the data
file(s)). If the server is shutdown properly, then this phase will
should be very short, if not non-existent. The roll-back phase is
"undoing" transactions that had not been committed at the recovery
point (so at the point the server was shut down there may have been
some transactions in progress that hadn't been committed yet). These 2
phases will put the data in a consistent state as at the recovery point.<br>
<br>
I'm guessing the 3rd stage in the startup recovery would be bringing
the database "online" so it will accept user connections (in a RESTORE
process the very 1st phase (before roll-forward and then roll-back) is
the data copy phase but this wouldn't be necessary for a startup
recovery because the data would already be in the data files). There's
a fairly good page about it in BOL: <a
href="http://links.10026.com/?link=Understanding">http://msdn2.microsoft.com/en-us/library/ms191455%28SQL.90%29.aspx">Understanding
How Restore and Recovery of Backups Work</a><br>
<br>
With SQL 2000 the database is unusable until the end of the roll-back
phase. With SQL 2005 the database is now usable after the end of the
roll-forward phase. From memory they coined this "fast recovery" or
something like that (<a
href="http://links.10026.com/?link=Database">http://msdn2.microsoft.com/en-us/library/ms171001%28SQL.90%29.aspx">Database
Engine Availability Enhancements</a>).<br>
<br>
Hope this helps.<br>
</tt>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font></span> <b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"><br>
<font face="Tahoma" size="2"><a href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a></font></span>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a></font></span>
</p>
</div>
<br>
<br>
Moh wrote:
<blockquote cite="mid8C953261-676E-41D5-80E7-4A2064EB9823@.microsoft.com"
type="cite">
<pre wrap="">I have seen this message in Windows event log after restarting database.
3450:
Recovery of database 'IMAX_INV_Mgmt' (5) is 0% complete.
(approximately 2152 more seconds) (Phase 2 of 3)
Question is:
What are these three phases.
Thx,
Moh
</pre>
</blockquote>
</body>
</html>
--080209040300000504020608--|||This is a multi-part message in MIME format.
--=_NextPart_000_00F1_01C662E8.12DAC620
Content-Type: text/plain;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Just a note that in SQL 2005 its only Enterprise edition that allows the =database to be accessed before the rol back phase is complete.
-- Simon Sabin
SQL Server MVP
http://sqljunkies.com/weblog/simons
"Mike Hodgson" <e1minst3r@.gmail.com> wrote in message =news:OJ64mwqYGHA.1016@.TK2MSFTNGP03.phx.gbl...
I'm not entirely certain about all 3 but there are at least 2 steps in =a recovery (whether a restore or a DB startup) and they are the =roll-forward and the roll-back. The roll-forward is "redoing" committed =transactions (they may have been written to the transaction log, as this =always happens first, but not yet written to the data file(s)). If the =server is shutdown properly, then this phase will should be very short, =if not non-existent. The roll-back phase is "undoing" transactions that =had not been committed at the recovery point (so at the point the server =was shut down there may have been some transactions in progress that =hadn't been committed yet). These 2 phases will put the data in a =consistent state as at the recovery point.
I'm guessing the 3rd stage in the startup recovery would be bringing =the database "online" so it will accept user connections (in a RESTORE =process the very 1st phase (before roll-forward and then roll-back) is =the data copy phase but this wouldn't be necessary for a startup =recovery because the data would already be in the data files). There's =a fairly good page about it in BOL: Understanding How Restore and =Recovery of Backups Work
With SQL 2000 the database is unusable until the end of the roll-back =phase. With SQL 2005 the database is now usable after the end of the =roll-forward phase. From memory they coined this "fast recovery" or =something like that (Database Engine Availability Enhancements).
Hope this helps.
--
mike hodgson
http://sqlnerd.blogspot.com=20
Moh wrote: I have seen this message in Windows event log after restarting database.
3450:
Recovery of database 'IMAX_INV_Mgmt' (5) is 0% complete.
(approximately 2152 more seconds) (Phase 2 of 3)
Question is:
What are these three phases.
Thx,
Moh
--=_NextPart_000_00F1_01C662E8.12DAC620
Content-Type: text/html;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Just a note that in SQL 2005 its only =Enterprise edition that allows the database to be accessed before the rol back =phase is complete.
-- Simon SabinSQL Server MVPhttp://sqljunkies.com/weblog/simons">http://sqljunkies.com/weblog=/simons
"Mike Hodgson" wrote =in message news:OJ64mwqYGHA.1016=@.TK2MSFTNGP03.phx.gbl...I'm not entirely certain about all 3 but there are at least 2 steps in a =recovery (whether a restore or a DB startup) and they are the roll-forward and =the roll-back. The roll-forward is "redoing" committed transactions =(they may have been written to the transaction log, as this always happens =first, but not yet written to the data file(s)). If the server is =shutdown properly, then this phase will should be very short, if not non-existent. The roll-back phase is "undoing" transactions that =had not been committed at the recovery point (so at the point the server was =shut down there may have been some transactions in progress that hadn't been =committed yet). These 2 phases will put the data in a consistent state as =at the recovery point.I'm guessing the 3rd stage in the startup =recovery would be bringing the database "online" so it will accept user =connections (in a RESTORE process the very 1st phase (before roll-forward and then =roll-back) is the data copy phase but this wouldn't be necessary for a startup =recovery because the data would already be in the data files). There's a =fairly good page about it in BOL: Understanding How Restore and Recovery of Backups WorkWith SQL 2000 the =database is unusable until the end of the roll-back phase. With SQL 2005 =the database is now usable after the end of the roll-forward phase. =From memory they coined this "fast recovery" or something like that (Database Engine Availability Enhancements).Hope this =helps.
--mike =hodgsonhttp://sqlnerd.blogspot.com Moh wrote: I have seen this message in Windows event =log after restarting database.
3450:
Recovery of database 'IMAX_INV_Mgmt' (5) is 0% complete.
(approximately 2152 more seconds) (Phase 2 of 3)
Question is:
What are these three phases.
Thx,
Moh
--=_NextPart_000_00F1_01C662E8.12DAC620--sql
3450:
Recovery of database 'IMAX_INV_Mgmt' (5) is 0% complete.
(approximately 2152 more seconds) (Phase 2 of 3)
Question is:
What are these three phases.
Thx,
MohThis is a multi-part message in MIME format.
--080209040300000504020608
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
I'm not entirely certain about all 3 but there are at least 2 steps in a
recovery (whether a restore or a DB startup) and they are the
roll-forward and the roll-back. The roll-forward is "redoing" committed
transactions (they may have been written to the transaction log, as this
always happens first, but not yet written to the data file(s)). If the
server is shutdown properly, then this phase will should be very short,
if not non-existent. The roll-back phase is "undoing" transactions that
had not been committed at the recovery point (so at the point the server
was shut down there may have been some transactions in progress that
hadn't been committed yet). These 2 phases will put the data in a
consistent state as at the recovery point.
I'm guessing the 3rd stage in the startup recovery would be bringing the
database "online" so it will accept user connections (in a RESTORE
process the very 1st phase (before roll-forward and then roll-back) is
the data copy phase but this wouldn't be necessary for a startup
recovery because the data would already be in the data files). There's
a fairly good page about it in BOL: Understanding How Restore and
Recovery of Backups Work
<http://msdn2.microsoft.com/en-us/library/ms191455%28SQL.90%29.aspx>
With SQL 2000 the database is unusable until the end of the roll-back
phase. With SQL 2005 the database is now usable after the end of the
roll-forward phase. From memory they coined this "fast recovery" or
something like that (Database Engine Availability Enhancements
<http://msdn2.microsoft.com/en-us/library/ms171001%28SQL.90%29.aspx>).
Hope this helps.
--
*mike hodgson*
http://sqlnerd.blogspot.com
Moh wrote:
>I have seen this message in Windows event log after restarting database.
>3450:
>Recovery of database 'IMAX_INV_Mgmt' (5) is 0% complete.
>(approximately 2152 more seconds) (Phase 2 of 3)
>Question is:
>What are these three phases.
>Thx,
>Moh
>
--080209040300000504020608
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>I'm not entirely certain about all 3 but there are at least 2 steps
in a recovery (whether a restore or a DB startup) and they are the
roll-forward and the roll-back. The roll-forward is "redoing"
committed transactions (they may have been written to the transaction
log, as this always happens first, but not yet written to the data
file(s)). If the server is shutdown properly, then this phase will
should be very short, if not non-existent. The roll-back phase is
"undoing" transactions that had not been committed at the recovery
point (so at the point the server was shut down there may have been
some transactions in progress that hadn't been committed yet). These 2
phases will put the data in a consistent state as at the recovery point.<br>
<br>
I'm guessing the 3rd stage in the startup recovery would be bringing
the database "online" so it will accept user connections (in a RESTORE
process the very 1st phase (before roll-forward and then roll-back) is
the data copy phase but this wouldn't be necessary for a startup
recovery because the data would already be in the data files). There's
a fairly good page about it in BOL: <a
href="http://links.10026.com/?link=Understanding">http://msdn2.microsoft.com/en-us/library/ms191455%28SQL.90%29.aspx">Understanding
How Restore and Recovery of Backups Work</a><br>
<br>
With SQL 2000 the database is unusable until the end of the roll-back
phase. With SQL 2005 the database is now usable after the end of the
roll-forward phase. From memory they coined this "fast recovery" or
something like that (<a
href="http://links.10026.com/?link=Database">http://msdn2.microsoft.com/en-us/library/ms171001%28SQL.90%29.aspx">Database
Engine Availability Enhancements</a>).<br>
<br>
Hope this helps.<br>
</tt>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font></span> <b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"><br>
<font face="Tahoma" size="2"><a href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a></font></span>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a></font></span>
</p>
</div>
<br>
<br>
Moh wrote:
<blockquote cite="mid8C953261-676E-41D5-80E7-4A2064EB9823@.microsoft.com"
type="cite">
<pre wrap="">I have seen this message in Windows event log after restarting database.
3450:
Recovery of database 'IMAX_INV_Mgmt' (5) is 0% complete.
(approximately 2152 more seconds) (Phase 2 of 3)
Question is:
What are these three phases.
Thx,
Moh
</pre>
</blockquote>
</body>
</html>
--080209040300000504020608--|||This is a multi-part message in MIME format.
--=_NextPart_000_00F1_01C662E8.12DAC620
Content-Type: text/plain;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Just a note that in SQL 2005 its only Enterprise edition that allows the =database to be accessed before the rol back phase is complete.
-- Simon Sabin
SQL Server MVP
http://sqljunkies.com/weblog/simons
"Mike Hodgson" <e1minst3r@.gmail.com> wrote in message =news:OJ64mwqYGHA.1016@.TK2MSFTNGP03.phx.gbl...
I'm not entirely certain about all 3 but there are at least 2 steps in =a recovery (whether a restore or a DB startup) and they are the =roll-forward and the roll-back. The roll-forward is "redoing" committed =transactions (they may have been written to the transaction log, as this =always happens first, but not yet written to the data file(s)). If the =server is shutdown properly, then this phase will should be very short, =if not non-existent. The roll-back phase is "undoing" transactions that =had not been committed at the recovery point (so at the point the server =was shut down there may have been some transactions in progress that =hadn't been committed yet). These 2 phases will put the data in a =consistent state as at the recovery point.
I'm guessing the 3rd stage in the startup recovery would be bringing =the database "online" so it will accept user connections (in a RESTORE =process the very 1st phase (before roll-forward and then roll-back) is =the data copy phase but this wouldn't be necessary for a startup =recovery because the data would already be in the data files). There's =a fairly good page about it in BOL: Understanding How Restore and =Recovery of Backups Work
With SQL 2000 the database is unusable until the end of the roll-back =phase. With SQL 2005 the database is now usable after the end of the =roll-forward phase. From memory they coined this "fast recovery" or =something like that (Database Engine Availability Enhancements).
Hope this helps.
--
mike hodgson
http://sqlnerd.blogspot.com=20
Moh wrote: I have seen this message in Windows event log after restarting database.
3450:
Recovery of database 'IMAX_INV_Mgmt' (5) is 0% complete.
(approximately 2152 more seconds) (Phase 2 of 3)
Question is:
What are these three phases.
Thx,
Moh
--=_NextPart_000_00F1_01C662E8.12DAC620
Content-Type: text/html;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Just a note that in SQL 2005 its only =Enterprise edition that allows the database to be accessed before the rol back =phase is complete.
-- Simon SabinSQL Server MVPhttp://sqljunkies.com/weblog/simons">http://sqljunkies.com/weblog=/simons
"Mike Hodgson"
--mike =hodgsonhttp://sqlnerd.blogspot.com Moh wrote: I have seen this message in Windows event =log after restarting database.
3450:
Recovery of database 'IMAX_INV_Mgmt' (5) is 0% complete.
(approximately 2152 more seconds) (Phase 2 of 3)
Question is:
What are these three phases.
Thx,
Moh
--=_NextPart_000_00F1_01C662E8.12DAC620--sql
Recovery of Database 'xxx' (Complete in 68,395 more seconds)
I'm having a problem with a SQL Server. Every time I stop and restart the
SQL Server service I get a message similar to this one. What do I have to
do to force checkpoints during the load process? ThanksP.S. - The message is coming up in the Application Event Log during the
recovery process after I start the server. I found a quote on the MS
Website stating I "may need to 'Troubleshoot the Recovery Process'", but I
can't find anything more specific than that. Can someone point me in the
right direction? Thanks
"Michael C#" <xyz@.yomomma.com> wrote in message
news:%23G$j92yKFHA.2284@.TK2MSFTNGP10.phx.gbl...
> I'm having a problem with a SQL Server. Every time I stop and restart the
> SQL Server service I get a message similar to this one. What do I have to
> do to force checkpoints during the load process? Thanks
>|||How is the data being loaded?
--
Simon Worth
Michael C# wrote:
> I'm having a problem with a SQL Server. Every time I stop and restart the
> SQL Server service I get a message similar to this one. What do I have to
> do to force checkpoints during the load process? Thanks
>|||On this particular box they're using Bulk Insert.
"Simon Worth" <REMOVEFIRST_simon.worth@.gmail.com> wrote in message
news:%23e3nP%23yKFHA.1284@.TK2MSFTNGP14.phx.gbl...
> How is the data being loaded?
> --
> Simon Worth
> Michael C# wrote:
>> I'm having a problem with a SQL Server. Every time I stop and restart
>> the SQL Server service I get a message similar to this one. What do I
>> have to do to force checkpoints during the load process? Thanks|||What is the relation between the load and stopping SQL Server? Also, have you change the recovery
interval setting with sp_configure?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Michael C#" <xyz@.yomomma.com> wrote in message news:ON8LT$yKFHA.1600@.TK2MSFTNGP10.phx.gbl...
> On this particular box they're using Bulk Insert.
> "Simon Worth" <REMOVEFIRST_simon.worth@.gmail.com> wrote in message
> news:%23e3nP%23yKFHA.1284@.TK2MSFTNGP14.phx.gbl...
>> How is the data being loaded?
>> --
>> Simon Worth
>> Michael C# wrote:
>> I'm having a problem with a SQL Server. Every time I stop and restart the SQL Server service I
>> get a message similar to this one. What do I have to do to force checkpoints during the load
>> process? Thanks
>|||Today was the first time we've stopped this SQL Server since we started
loading it. The load was completed. No, I haven't changed the recovery
interval; I'll take a look at it today. What setting would you recommend?
Thanks
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23IUlVr4KFHA.4032@.TK2MSFTNGP14.phx.gbl...
> What is the relation between the load and stopping SQL Server? Also, have
> you change the recovery interval setting with sp_configure?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Michael C#" <xyz@.yomomma.com> wrote in message
> news:ON8LT$yKFHA.1600@.TK2MSFTNGP10.phx.gbl...
>> On this particular box they're using Bulk Insert.
>> "Simon Worth" <REMOVEFIRST_simon.worth@.gmail.com> wrote in message
>> news:%23e3nP%23yKFHA.1284@.TK2MSFTNGP14.phx.gbl...
>> How is the data being loaded?
>> --
>> Simon Worth
>> Michael C# wrote:
>> I'm having a problem with a SQL Server. Every time I stop and restart
>> the SQL Server service I get a message similar to this one. What do I
>> have to do to force checkpoints during the load process? Thanks
>>
>
SQL Server service I get a message similar to this one. What do I have to
do to force checkpoints during the load process? ThanksP.S. - The message is coming up in the Application Event Log during the
recovery process after I start the server. I found a quote on the MS
Website stating I "may need to 'Troubleshoot the Recovery Process'", but I
can't find anything more specific than that. Can someone point me in the
right direction? Thanks
"Michael C#" <xyz@.yomomma.com> wrote in message
news:%23G$j92yKFHA.2284@.TK2MSFTNGP10.phx.gbl...
> I'm having a problem with a SQL Server. Every time I stop and restart the
> SQL Server service I get a message similar to this one. What do I have to
> do to force checkpoints during the load process? Thanks
>|||How is the data being loaded?
--
Simon Worth
Michael C# wrote:
> I'm having a problem with a SQL Server. Every time I stop and restart the
> SQL Server service I get a message similar to this one. What do I have to
> do to force checkpoints during the load process? Thanks
>|||On this particular box they're using Bulk Insert.
"Simon Worth" <REMOVEFIRST_simon.worth@.gmail.com> wrote in message
news:%23e3nP%23yKFHA.1284@.TK2MSFTNGP14.phx.gbl...
> How is the data being loaded?
> --
> Simon Worth
> Michael C# wrote:
>> I'm having a problem with a SQL Server. Every time I stop and restart
>> the SQL Server service I get a message similar to this one. What do I
>> have to do to force checkpoints during the load process? Thanks|||What is the relation between the load and stopping SQL Server? Also, have you change the recovery
interval setting with sp_configure?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Michael C#" <xyz@.yomomma.com> wrote in message news:ON8LT$yKFHA.1600@.TK2MSFTNGP10.phx.gbl...
> On this particular box they're using Bulk Insert.
> "Simon Worth" <REMOVEFIRST_simon.worth@.gmail.com> wrote in message
> news:%23e3nP%23yKFHA.1284@.TK2MSFTNGP14.phx.gbl...
>> How is the data being loaded?
>> --
>> Simon Worth
>> Michael C# wrote:
>> I'm having a problem with a SQL Server. Every time I stop and restart the SQL Server service I
>> get a message similar to this one. What do I have to do to force checkpoints during the load
>> process? Thanks
>|||Today was the first time we've stopped this SQL Server since we started
loading it. The load was completed. No, I haven't changed the recovery
interval; I'll take a look at it today. What setting would you recommend?
Thanks
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23IUlVr4KFHA.4032@.TK2MSFTNGP14.phx.gbl...
> What is the relation between the load and stopping SQL Server? Also, have
> you change the recovery interval setting with sp_configure?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Michael C#" <xyz@.yomomma.com> wrote in message
> news:ON8LT$yKFHA.1600@.TK2MSFTNGP10.phx.gbl...
>> On this particular box they're using Bulk Insert.
>> "Simon Worth" <REMOVEFIRST_simon.worth@.gmail.com> wrote in message
>> news:%23e3nP%23yKFHA.1284@.TK2MSFTNGP14.phx.gbl...
>> How is the data being loaded?
>> --
>> Simon Worth
>> Michael C# wrote:
>> I'm having a problem with a SQL Server. Every time I stop and restart
>> the SQL Server service I get a message similar to this one. What do I
>> have to do to force checkpoints during the load process? Thanks
>>
>
Recovery of Database 'xxx' (Complete in 68,395 more seconds)
I'm having a problem with a SQL Server. Every time I stop and restart the
SQL Server service I get a message similar to this one. What do I have to
do to force checkpoints during the load process? Thanks
P.S. - The message is coming up in the Application Event Log during the
recovery process after I start the server. I found a quote on the MS
Website stating I "may need to 'Troubleshoot the Recovery Process'", but I
can't find anything more specific than that. Can someone point me in the
right direction? Thanks
"Michael C#" <xyz@.yomomma.com> wrote in message
news:%23G$j92yKFHA.2284@.TK2MSFTNGP10.phx.gbl...
> I'm having a problem with a SQL Server. Every time I stop and restart the
> SQL Server service I get a message similar to this one. What do I have to
> do to force checkpoints during the load process? Thanks
>
|||How is the data being loaded?
Simon Worth
Michael C# wrote:
> I'm having a problem with a SQL Server. Every time I stop and restart the
> SQL Server service I get a message similar to this one. What do I have to
> do to force checkpoints during the load process? Thanks
>
|||On this particular box they're using Bulk Insert.
"Simon Worth" <REMOVEFIRST_simon.worth@.gmail.com> wrote in message
news:%23e3nP%23yKFHA.1284@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> How is the data being loaded?
> --
> Simon Worth
> Michael C# wrote:
|||What is the relation between the load and stopping SQL Server? Also, have you change the recovery
interval setting with sp_configure?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Michael C#" <xyz@.yomomma.com> wrote in message news:ON8LT$yKFHA.1600@.TK2MSFTNGP10.phx.gbl...
> On this particular box they're using Bulk Insert.
> "Simon Worth" <REMOVEFIRST_simon.worth@.gmail.com> wrote in message
> news:%23e3nP%23yKFHA.1284@.TK2MSFTNGP14.phx.gbl...
>
|||Today was the first time we've stopped this SQL Server since we started
loading it. The load was completed. No, I haven't changed the recovery
interval; I'll take a look at it today. What setting would you recommend?
Thanks
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23IUlVr4KFHA.4032@.TK2MSFTNGP14.phx.gbl...
> What is the relation between the load and stopping SQL Server? Also, have
> you change the recovery interval setting with sp_configure?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Michael C#" <xyz@.yomomma.com> wrote in message
> news:ON8LT$yKFHA.1600@.TK2MSFTNGP10.phx.gbl...
>
sql
SQL Server service I get a message similar to this one. What do I have to
do to force checkpoints during the load process? Thanks
P.S. - The message is coming up in the Application Event Log during the
recovery process after I start the server. I found a quote on the MS
Website stating I "may need to 'Troubleshoot the Recovery Process'", but I
can't find anything more specific than that. Can someone point me in the
right direction? Thanks
"Michael C#" <xyz@.yomomma.com> wrote in message
news:%23G$j92yKFHA.2284@.TK2MSFTNGP10.phx.gbl...
> I'm having a problem with a SQL Server. Every time I stop and restart the
> SQL Server service I get a message similar to this one. What do I have to
> do to force checkpoints during the load process? Thanks
>
|||How is the data being loaded?
Simon Worth
Michael C# wrote:
> I'm having a problem with a SQL Server. Every time I stop and restart the
> SQL Server service I get a message similar to this one. What do I have to
> do to force checkpoints during the load process? Thanks
>
|||On this particular box they're using Bulk Insert.
"Simon Worth" <REMOVEFIRST_simon.worth@.gmail.com> wrote in message
news:%23e3nP%23yKFHA.1284@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> How is the data being loaded?
> --
> Simon Worth
> Michael C# wrote:
|||What is the relation between the load and stopping SQL Server? Also, have you change the recovery
interval setting with sp_configure?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Michael C#" <xyz@.yomomma.com> wrote in message news:ON8LT$yKFHA.1600@.TK2MSFTNGP10.phx.gbl...
> On this particular box they're using Bulk Insert.
> "Simon Worth" <REMOVEFIRST_simon.worth@.gmail.com> wrote in message
> news:%23e3nP%23yKFHA.1284@.TK2MSFTNGP14.phx.gbl...
>
|||Today was the first time we've stopped this SQL Server since we started
loading it. The load was completed. No, I haven't changed the recovery
interval; I'll take a look at it today. What setting would you recommend?
Thanks
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23IUlVr4KFHA.4032@.TK2MSFTNGP14.phx.gbl...
> What is the relation between the load and stopping SQL Server? Also, have
> you change the recovery interval setting with sp_configure?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Michael C#" <xyz@.yomomma.com> wrote in message
> news:ON8LT$yKFHA.1600@.TK2MSFTNGP10.phx.gbl...
>
sql
Recovery of Database 'xxx' (Complete in 68,395 more seconds)
I'm having a problem with a SQL Server. Every time I stop and restart the
SQL Server service I get a message similar to this one. What do I have to
do to force checkpoints during the load process? ThanksP.S. - The message is coming up in the Application Event Log during the
recovery process after I start the server. I found a quote on the MS
Website stating I "may need to 'Troubleshoot the Recovery Process'", but I
can't find anything more specific than that. Can someone point me in the
right direction? Thanks
"Michael C#" <xyz@.yomomma.com> wrote in message
news:%23G$j92yKFHA.2284@.TK2MSFTNGP10.phx.gbl...
> I'm having a problem with a SQL Server. Every time I stop and restart the
> SQL Server service I get a message similar to this one. What do I have to
> do to force checkpoints during the load process? Thanks
>|||How is the data being loaded?
Simon Worth
Michael C# wrote:
> I'm having a problem with a SQL Server. Every time I stop and restart the
> SQL Server service I get a message similar to this one. What do I have to
> do to force checkpoints during the load process? Thanks
>|||On this particular box they're using Bulk Insert.
"Simon Worth" <REMOVEFIRST_simon.worth@.gmail.com> wrote in message
news:%23e3nP%23yKFHA.1284@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> How is the data being loaded?
> --
> Simon Worth
> Michael C# wrote:|||What is the relation between the load and stopping SQL Server? Also, have yo
u change the recovery
interval setting with sp_configure?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Michael C#" <xyz@.yomomma.com> wrote in message news:ON8LT$yKFHA.1600@.TK2MSFTNGP10.phx.gbl..
.
> On this particular box they're using Bulk Insert.
> "Simon Worth" <REMOVEFIRST_simon.worth@.gmail.com> wrote in message
> news:%23e3nP%23yKFHA.1284@.TK2MSFTNGP14.phx.gbl...
>|||Today was the first time we've stopped this SQL Server since we started
loading it. The load was completed. No, I haven't changed the recovery
interval; I'll take a look at it today. What setting would you recommend?
Thanks
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23IUlVr4KFHA.4032@.TK2MSFTNGP14.phx.gbl...
> What is the relation between the load and stopping SQL Server? Also, have
> you change the recovery interval setting with sp_configure?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Michael C#" <xyz@.yomomma.com> wrote in message
> news:ON8LT$yKFHA.1600@.TK2MSFTNGP10.phx.gbl...
>
SQL Server service I get a message similar to this one. What do I have to
do to force checkpoints during the load process? ThanksP.S. - The message is coming up in the Application Event Log during the
recovery process after I start the server. I found a quote on the MS
Website stating I "may need to 'Troubleshoot the Recovery Process'", but I
can't find anything more specific than that. Can someone point me in the
right direction? Thanks
"Michael C#" <xyz@.yomomma.com> wrote in message
news:%23G$j92yKFHA.2284@.TK2MSFTNGP10.phx.gbl...
> I'm having a problem with a SQL Server. Every time I stop and restart the
> SQL Server service I get a message similar to this one. What do I have to
> do to force checkpoints during the load process? Thanks
>|||How is the data being loaded?
Simon Worth
Michael C# wrote:
> I'm having a problem with a SQL Server. Every time I stop and restart the
> SQL Server service I get a message similar to this one. What do I have to
> do to force checkpoints during the load process? Thanks
>|||On this particular box they're using Bulk Insert.
"Simon Worth" <REMOVEFIRST_simon.worth@.gmail.com> wrote in message
news:%23e3nP%23yKFHA.1284@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> How is the data being loaded?
> --
> Simon Worth
> Michael C# wrote:|||What is the relation between the load and stopping SQL Server? Also, have yo
u change the recovery
interval setting with sp_configure?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Michael C#" <xyz@.yomomma.com> wrote in message news:ON8LT$yKFHA.1600@.TK2MSFTNGP10.phx.gbl..
.
> On this particular box they're using Bulk Insert.
> "Simon Worth" <REMOVEFIRST_simon.worth@.gmail.com> wrote in message
> news:%23e3nP%23yKFHA.1284@.TK2MSFTNGP14.phx.gbl...
>|||Today was the first time we've stopped this SQL Server since we started
loading it. The load was completed. No, I haven't changed the recovery
interval; I'll take a look at it today. What setting would you recommend?
Thanks
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23IUlVr4KFHA.4032@.TK2MSFTNGP14.phx.gbl...
> What is the relation between the load and stopping SQL Server? Also, have
> you change the recovery interval setting with sp_configure?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Michael C#" <xyz@.yomomma.com> wrote in message
> news:ON8LT$yKFHA.1600@.TK2MSFTNGP10.phx.gbl...
>
Wednesday, March 21, 2012
Recovering database
Sql Server 2000 on Win 2k:
I'm recieving the following message when trying to reattach a database file: "Error 823: I/O error 38(Reached the end of the file.) detected during last read at offset 0000000000000000 of file 'D:\MSSQL\Data\DbName_log.ldf'." The database came offline after a disk problem and it looks like the log file became corrupted. Any ideas on a way to restore this database from only the mdf files? Can you reattach a DB and recreate the log file?
My other idea was possible inserting into sysdatabases, putting the Db in 32768=emergency mode, and running DBCC CHECKDB? If that is even possible?
Any feedback will be greatly appreciated.
Thanks.The log file is corrupted. You need to create new log file for the database. The thing is that you will lose all the uncommitted transaction. use dbcc rebuild_log to create a new log file and reattach the db.
I'm recieving the following message when trying to reattach a database file: "Error 823: I/O error 38(Reached the end of the file.) detected during last read at offset 0000000000000000 of file 'D:\MSSQL\Data\DbName_log.ldf'." The database came offline after a disk problem and it looks like the log file became corrupted. Any ideas on a way to restore this database from only the mdf files? Can you reattach a DB and recreate the log file?
My other idea was possible inserting into sysdatabases, putting the Db in 32768=emergency mode, and running DBCC CHECKDB? If that is even possible?
Any feedback will be greatly appreciated.
Thanks.The log file is corrupted. You need to create new log file for the database. The thing is that you will lose all the uncommitted transaction. use dbcc rebuild_log to create a new log file and reattach the db.
Recover SQL Database from suspect status
Hi I'm trying to recover database from a suspect status but when I run this
command:
sp_resetstatus webc
sql return me this message:
Prior to updating sysdatabases entry for database 'webc', mode = 0 and
status = 1073741840 (status suspect_bit = 0).
No row in sysdatabases was updated because mode and status are already
correctly reset. No error and no changes made.
What is it= What can I do to recover DB?
Thanks.
--
--
Filippo MacchiHi
> No row in sysdatabases was updated because mode and status are already
> correctly reset. No error and no changes made.
Have you tried to restart SQL Server? Aren't you still available to see your
data?
It seems you have to set your database in emergency mode
update sysdatabases set status=32768 where name='your name'
"Azkaban" <azkaban74@.libero.it> wrote in message
news:uZL0MLWQEHA.556@.tk2msftngp13.phx.gbl...
> Hi I'm trying to recover database from a suspect status but when I run
this
> command:
> sp_resetstatus webc
> sql return me this message:
> Prior to updating sysdatabases entry for database 'webc', mode = 0 and
> status = 1073741840 (status suspect_bit = 0).
> No row in sysdatabases was updated because mode and status are already
> correctly reset. No error and no changes made.
> What is it= What can I do to recover DB?
> Thanks.
> --
> --
> Filippo Macchi
>|||Hi,
Stop and start the SQL server and try accessing the webc database
use webc
go
select * from sysobjects
If it still gives the error then go thru the below informations:-
Details:-
Suspect database may be due to below reasons.
1. MDF or LDF files may be used during the SQL Server service startup
2. LDF file might be corrupt or immediate power shutdown caused the LDF to
corrupt
3. MDF file - Page allocations issue
For the point 1.
Just Run sp_resetstatus <dbname> and restart SQL server (This you have done
already)
For the point 2. ( LDF file might be corrupt or immediate power shutdown
caused the LDF to corrupt)
a. Start SQL Server in emergency mode
Setting the database status to emergency mode tells SQL Server to skip
automatic recovery and lets you access the data.
To get your data, use this script:
Sp_configure "allow updates", 1
go
Reconfigure with override
GO
Update sysdatabases set status = 32768 where name = 'webc'
go
Sp_configure "allow updates", 0
go
Reconfigure with override
GO
You might be able to use bulk copy program (bcp), simple SELECT commands, or
use DTS to extract
your data while the database is in emergency mode.
After this database will be usable with out transaction log. AFter this
create a new database and use DTS to transfer objects and data
For point 3. Very critical error , try executing DBCC CHECKDB with
REPAIR_REBUILD option. If the problem is not rectified try
with restore from Backup or contact Microsoft support.
Thanks
Hari
MCDBA
"Azkaban" <azkaban74@.libero.it> wrote in message
news:uZL0MLWQEHA.556@.tk2msftngp13.phx.gbl...
> Hi I'm trying to recover database from a suspect status but when I run
this
> command:
> sp_resetstatus webc
> sql return me this message:
> Prior to updating sysdatabases entry for database 'webc', mode = 0 and
> status = 1073741840 (status suspect_bit = 0).
> No row in sysdatabases was updated because mode and status are already
> correctly reset. No error and no changes made.
> What is it= What can I do to recover DB?
> Thanks.
> --
> --
> Filippo Macchi
>|||I run the command and received this message, is it correct?:
Server: Msg 259, Level 16, State 2, Line 1
Ad hoc updates to system catalogs are not enabled. The system administrator
must reconfigure SQL Server to allow this.
"Uri Dimant" <urid@.iscar.co.il> ha scritto nel messaggio
news:uWWEfRWQEHA.3660@.tk2msftngp13.phx.gbl...
> Hi
> > No row in sysdatabases was updated because mode and status are already
> > correctly reset. No error and no changes made.
> Have you tried to restart SQL Server? Aren't you still available to see
your
> data?
> It seems you have to set your database in emergency mode
> update sysdatabases set status=32768 where name='your name'
>
> "Azkaban" <azkaban74@.libero.it> wrote in message
> news:uZL0MLWQEHA.556@.tk2msftngp13.phx.gbl...
> > Hi I'm trying to recover database from a suspect status but when I run
> this
> > command:
> >
> > sp_resetstatus webc
> >
> > sql return me this message:
> >
> > Prior to updating sysdatabases entry for database 'webc', mode = 0 and
> > status = 1073741840 (status suspect_bit = 0).
> > No row in sysdatabases was updated because mode and status are already
> > correctly reset. No error and no changes made.
> >
> > What is it= What can I do to recover DB?
> >
> > Thanks.
> >
> > --
> > --
> > Filippo Macchi
> >
> >
>|||Hi
Sp_configure "allow updates", 1
go
Reconfigure with override
go
Update sysdatabases set status = 32768 where name = 'yourname'
go
Sp_configure "allow updates", 0
go
Reconfigure with override
go
"Azkaban" <azkaban74@.libero.it> wrote in message
news:uyJxIXWQEHA.904@.TK2MSFTNGP12.phx.gbl...
> I run the command and received this message, is it correct?:
> Server: Msg 259, Level 16, State 2, Line 1
> Ad hoc updates to system catalogs are not enabled. The system
administrator
> must reconfigure SQL Server to allow this.
>
> "Uri Dimant" <urid@.iscar.co.il> ha scritto nel messaggio
> news:uWWEfRWQEHA.3660@.tk2msftngp13.phx.gbl...
> > Hi
> > > No row in sysdatabases was updated because mode and status are already
> > > correctly reset. No error and no changes made.
> > Have you tried to restart SQL Server? Aren't you still available to see
> your
> > data?
> >
> > It seems you have to set your database in emergency mode
> > update sysdatabases set status=32768 where name='your name'
> >
> >
> >
> > "Azkaban" <azkaban74@.libero.it> wrote in message
> > news:uZL0MLWQEHA.556@.tk2msftngp13.phx.gbl...
> > > Hi I'm trying to recover database from a suspect status but when I run
> > this
> > > command:
> > >
> > > sp_resetstatus webc
> > >
> > > sql return me this message:
> > >
> > > Prior to updating sysdatabases entry for database 'webc', mode = 0 and
> > > status = 1073741840 (status suspect_bit = 0).
> > > No row in sysdatabases was updated because mode and status are already
> > > correctly reset. No error and no changes made.
> > >
> > > What is it= What can I do to recover DB?
> > >
> > > Thanks.
> > >
> > > --
> > > --
> > > Filippo Macchi
> > >
> > >
> >
> >
>|||Hi,
Can you go thru the steps specified by me in the previous post. That
contains the detailed information on recovering from the suspect status.
Thanks
Hari
MCDBA
"Azkaban" <azkaban74@.libero.it> wrote in message
news:uyJxIXWQEHA.904@.TK2MSFTNGP12.phx.gbl...
> I run the command and received this message, is it correct?:
> Server: Msg 259, Level 16, State 2, Line 1
> Ad hoc updates to system catalogs are not enabled. The system
administrator
> must reconfigure SQL Server to allow this.
>
> "Uri Dimant" <urid@.iscar.co.il> ha scritto nel messaggio
> news:uWWEfRWQEHA.3660@.tk2msftngp13.phx.gbl...
> > Hi
> > > No row in sysdatabases was updated because mode and status are already
> > > correctly reset. No error and no changes made.
> > Have you tried to restart SQL Server? Aren't you still available to see
> your
> > data?
> >
> > It seems you have to set your database in emergency mode
> > update sysdatabases set status=32768 where name='your name'
> >
> >
> >
> > "Azkaban" <azkaban74@.libero.it> wrote in message
> > news:uZL0MLWQEHA.556@.tk2msftngp13.phx.gbl...
> > > Hi I'm trying to recover database from a suspect status but when I run
> > this
> > > command:
> > >
> > > sp_resetstatus webc
> > >
> > > sql return me this message:
> > >
> > > Prior to updating sysdatabases entry for database 'webc', mode = 0 and
> > > status = 1073741840 (status suspect_bit = 0).
> > > No row in sysdatabases was updated because mode and status are already
> > > correctly reset. No error and no changes made.
> > >
> > > What is it= What can I do to recover DB?
> > >
> > > Thanks.
> > >
> > > --
> > > --
> > > Filippo Macchi
> > >
> > >
> >
> >
>
command:
sp_resetstatus webc
sql return me this message:
Prior to updating sysdatabases entry for database 'webc', mode = 0 and
status = 1073741840 (status suspect_bit = 0).
No row in sysdatabases was updated because mode and status are already
correctly reset. No error and no changes made.
What is it= What can I do to recover DB?
Thanks.
--
--
Filippo MacchiHi
> No row in sysdatabases was updated because mode and status are already
> correctly reset. No error and no changes made.
Have you tried to restart SQL Server? Aren't you still available to see your
data?
It seems you have to set your database in emergency mode
update sysdatabases set status=32768 where name='your name'
"Azkaban" <azkaban74@.libero.it> wrote in message
news:uZL0MLWQEHA.556@.tk2msftngp13.phx.gbl...
> Hi I'm trying to recover database from a suspect status but when I run
this
> command:
> sp_resetstatus webc
> sql return me this message:
> Prior to updating sysdatabases entry for database 'webc', mode = 0 and
> status = 1073741840 (status suspect_bit = 0).
> No row in sysdatabases was updated because mode and status are already
> correctly reset. No error and no changes made.
> What is it= What can I do to recover DB?
> Thanks.
> --
> --
> Filippo Macchi
>|||Hi,
Stop and start the SQL server and try accessing the webc database
use webc
go
select * from sysobjects
If it still gives the error then go thru the below informations:-
Details:-
Suspect database may be due to below reasons.
1. MDF or LDF files may be used during the SQL Server service startup
2. LDF file might be corrupt or immediate power shutdown caused the LDF to
corrupt
3. MDF file - Page allocations issue
For the point 1.
Just Run sp_resetstatus <dbname> and restart SQL server (This you have done
already)
For the point 2. ( LDF file might be corrupt or immediate power shutdown
caused the LDF to corrupt)
a. Start SQL Server in emergency mode
Setting the database status to emergency mode tells SQL Server to skip
automatic recovery and lets you access the data.
To get your data, use this script:
Sp_configure "allow updates", 1
go
Reconfigure with override
GO
Update sysdatabases set status = 32768 where name = 'webc'
go
Sp_configure "allow updates", 0
go
Reconfigure with override
GO
You might be able to use bulk copy program (bcp), simple SELECT commands, or
use DTS to extract
your data while the database is in emergency mode.
After this database will be usable with out transaction log. AFter this
create a new database and use DTS to transfer objects and data
For point 3. Very critical error , try executing DBCC CHECKDB with
REPAIR_REBUILD option. If the problem is not rectified try
with restore from Backup or contact Microsoft support.
Thanks
Hari
MCDBA
"Azkaban" <azkaban74@.libero.it> wrote in message
news:uZL0MLWQEHA.556@.tk2msftngp13.phx.gbl...
> Hi I'm trying to recover database from a suspect status but when I run
this
> command:
> sp_resetstatus webc
> sql return me this message:
> Prior to updating sysdatabases entry for database 'webc', mode = 0 and
> status = 1073741840 (status suspect_bit = 0).
> No row in sysdatabases was updated because mode and status are already
> correctly reset. No error and no changes made.
> What is it= What can I do to recover DB?
> Thanks.
> --
> --
> Filippo Macchi
>|||I run the command and received this message, is it correct?:
Server: Msg 259, Level 16, State 2, Line 1
Ad hoc updates to system catalogs are not enabled. The system administrator
must reconfigure SQL Server to allow this.
"Uri Dimant" <urid@.iscar.co.il> ha scritto nel messaggio
news:uWWEfRWQEHA.3660@.tk2msftngp13.phx.gbl...
> Hi
> > No row in sysdatabases was updated because mode and status are already
> > correctly reset. No error and no changes made.
> Have you tried to restart SQL Server? Aren't you still available to see
your
> data?
> It seems you have to set your database in emergency mode
> update sysdatabases set status=32768 where name='your name'
>
> "Azkaban" <azkaban74@.libero.it> wrote in message
> news:uZL0MLWQEHA.556@.tk2msftngp13.phx.gbl...
> > Hi I'm trying to recover database from a suspect status but when I run
> this
> > command:
> >
> > sp_resetstatus webc
> >
> > sql return me this message:
> >
> > Prior to updating sysdatabases entry for database 'webc', mode = 0 and
> > status = 1073741840 (status suspect_bit = 0).
> > No row in sysdatabases was updated because mode and status are already
> > correctly reset. No error and no changes made.
> >
> > What is it= What can I do to recover DB?
> >
> > Thanks.
> >
> > --
> > --
> > Filippo Macchi
> >
> >
>|||Hi
Sp_configure "allow updates", 1
go
Reconfigure with override
go
Update sysdatabases set status = 32768 where name = 'yourname'
go
Sp_configure "allow updates", 0
go
Reconfigure with override
go
"Azkaban" <azkaban74@.libero.it> wrote in message
news:uyJxIXWQEHA.904@.TK2MSFTNGP12.phx.gbl...
> I run the command and received this message, is it correct?:
> Server: Msg 259, Level 16, State 2, Line 1
> Ad hoc updates to system catalogs are not enabled. The system
administrator
> must reconfigure SQL Server to allow this.
>
> "Uri Dimant" <urid@.iscar.co.il> ha scritto nel messaggio
> news:uWWEfRWQEHA.3660@.tk2msftngp13.phx.gbl...
> > Hi
> > > No row in sysdatabases was updated because mode and status are already
> > > correctly reset. No error and no changes made.
> > Have you tried to restart SQL Server? Aren't you still available to see
> your
> > data?
> >
> > It seems you have to set your database in emergency mode
> > update sysdatabases set status=32768 where name='your name'
> >
> >
> >
> > "Azkaban" <azkaban74@.libero.it> wrote in message
> > news:uZL0MLWQEHA.556@.tk2msftngp13.phx.gbl...
> > > Hi I'm trying to recover database from a suspect status but when I run
> > this
> > > command:
> > >
> > > sp_resetstatus webc
> > >
> > > sql return me this message:
> > >
> > > Prior to updating sysdatabases entry for database 'webc', mode = 0 and
> > > status = 1073741840 (status suspect_bit = 0).
> > > No row in sysdatabases was updated because mode and status are already
> > > correctly reset. No error and no changes made.
> > >
> > > What is it= What can I do to recover DB?
> > >
> > > Thanks.
> > >
> > > --
> > > --
> > > Filippo Macchi
> > >
> > >
> >
> >
>|||Hi,
Can you go thru the steps specified by me in the previous post. That
contains the detailed information on recovering from the suspect status.
Thanks
Hari
MCDBA
"Azkaban" <azkaban74@.libero.it> wrote in message
news:uyJxIXWQEHA.904@.TK2MSFTNGP12.phx.gbl...
> I run the command and received this message, is it correct?:
> Server: Msg 259, Level 16, State 2, Line 1
> Ad hoc updates to system catalogs are not enabled. The system
administrator
> must reconfigure SQL Server to allow this.
>
> "Uri Dimant" <urid@.iscar.co.il> ha scritto nel messaggio
> news:uWWEfRWQEHA.3660@.tk2msftngp13.phx.gbl...
> > Hi
> > > No row in sysdatabases was updated because mode and status are already
> > > correctly reset. No error and no changes made.
> > Have you tried to restart SQL Server? Aren't you still available to see
> your
> > data?
> >
> > It seems you have to set your database in emergency mode
> > update sysdatabases set status=32768 where name='your name'
> >
> >
> >
> > "Azkaban" <azkaban74@.libero.it> wrote in message
> > news:uZL0MLWQEHA.556@.tk2msftngp13.phx.gbl...
> > > Hi I'm trying to recover database from a suspect status but when I run
> > this
> > > command:
> > >
> > > sp_resetstatus webc
> > >
> > > sql return me this message:
> > >
> > > Prior to updating sysdatabases entry for database 'webc', mode = 0 and
> > > status = 1073741840 (status suspect_bit = 0).
> > > No row in sysdatabases was updated because mode and status are already
> > > correctly reset. No error and no changes made.
> > >
> > > What is it= What can I do to recover DB?
> > >
> > > Thanks.
> > >
> > > --
> > > --
> > > Filippo Macchi
> > >
> > >
> >
> >
>
Tuesday, March 20, 2012
Recover DB from c$
I am trying to restore a database. The backuo file is on c$. The restore
is not successful. The error message on the Event Viewer is "could not open
file."
Now if I move the backup file to d$, I can restore the db without any
problem.
I can restore other databases from c$ with the same permissions on the .bak
file.
?
Hi,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you will have to move backup data
files to disk D other than disk C to restore it successfully. If I have
misunderstood your concern, please feel free to point it out.
This is a really strange issue and would you please help me check the
following things?
1. Whether the Windows login user has administrator permission or it has
the permission to access all disk C and disk D files.
2. You restore the file from Enterprise Manager or Query Analyzer? Could
you let me know what the SQL error log say?
3. Please reconfirm the correct typed database name in Disk C
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/tec...rview/40010469
Others: https://partner.microsoft.com/US/tec...pportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
is not successful. The error message on the Event Viewer is "could not open
file."
Now if I move the backup file to d$, I can restore the db without any
problem.
I can restore other databases from c$ with the same permissions on the .bak
file.
?
Hi,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you will have to move backup data
files to disk D other than disk C to restore it successfully. If I have
misunderstood your concern, please feel free to point it out.
This is a really strange issue and would you please help me check the
following things?
1. Whether the Windows login user has administrator permission or it has
the permission to access all disk C and disk D files.
2. You restore the file from Enterprise Manager or Query Analyzer? Could
you let me know what the SQL error log say?
3. Please reconfirm the correct typed database name in Disk C
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/tec...rview/40010469
Others: https://partner.microsoft.com/US/tec...pportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
Recover DB from c$
I am trying to restore a database. The backuo file is on c$. The restore
is not successful. The error message on the Event Viewer is "could not open
file."
Now if I move the backup file to d$, I can restore the db without any
problem.
I can restore other databases from c$ with the same permissions on the .bak
file.
?Hi,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you will have to move backup data
files to disk D other than disk C to restore it successfully. If I have
misunderstood your concern, please feel free to point it out.
This is a really strange issue and would you please help me check the
following things?
1. Whether the Windows login user has administrator permission or it has
the permission to access all disk C and disk D files.
2. You restore the file from Enterprise Manager or Query Analyzer? Could
you let me know what the SQL error log say?
3. Please reconfirm the correct typed database name in Disk C
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
is not successful. The error message on the Event Viewer is "could not open
file."
Now if I move the backup file to d$, I can restore the db without any
problem.
I can restore other databases from c$ with the same permissions on the .bak
file.
?Hi,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you will have to move backup data
files to disk D other than disk C to restore it successfully. If I have
misunderstood your concern, please feel free to point it out.
This is a really strange issue and would you please help me check the
following things?
1. Whether the Windows login user has administrator permission or it has
the permission to access all disk C and disk D files.
2. You restore the file from Enterprise Manager or Query Analyzer? Could
you let me know what the SQL error log say?
3. Please reconfirm the correct typed database name in Disk C
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
Recover DB from c$
I am trying to restore a database. The backuo file is on c$. The restore
is not successful. The error message on the Event Viewer is "could not open
file."
Now if I move the backup file to d$, I can restore the db without any
problem.
I can restore other databases from c$ with the same permissions on the .bak
file.
?Hi,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you will have to move backup data
files to disk D other than disk C to restore it successfully. If I have
misunderstood your concern, please feel free to point it out.
This is a really strange issue and would you please help me check the
following things?
1. Whether the Windows login user has administrator permission or it has
the permission to access all disk C and disk D files.
2. You restore the file from Enterprise Manager or Query Analyzer? Could
you let me know what the SQL error log say?
3. Please reconfirm the correct typed database name in Disk C
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/te...erview/40010469
Others: https://partner.microsoft.com/US/te...upportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
is not successful. The error message on the Event Viewer is "could not open
file."
Now if I move the backup file to d$, I can restore the db without any
problem.
I can restore other databases from c$ with the same permissions on the .bak
file.
?Hi,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you will have to move backup data
files to disk D other than disk C to restore it successfully. If I have
misunderstood your concern, please feel free to point it out.
This is a really strange issue and would you please help me check the
following things?
1. Whether the Windows login user has administrator permission or it has
the permission to access all disk C and disk D files.
2. You restore the file from Enterprise Manager or Query Analyzer? Could
you let me know what the SQL error log say?
3. Please reconfirm the correct typed database name in Disk C
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/te...erview/40010469
Others: https://partner.microsoft.com/US/te...upportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
Wednesday, March 7, 2012
Recordset not updatable
I use MS Access Project to connect to MS-SQL 2000. Even though I login as owner of the database, I can't update my table with message 'Recordset is not updatable'
I have no problem updating through Enterprise Manager. Someone out there. Please help meAccess needs unique index to update a table. When linking SQL tables Access may ask you to select index columns. Select the number of columns needed for an "unique index"
I have no problem updating through Enterprise Manager. Someone out there. Please help meAccess needs unique index to update a table. When linking SQL tables Access may ask you to select index columns. Select the number of columns needed for an "unique index"
Recordset not updatable
I use MS Access Project to connect to MS-SQL 2000. Even though I login as owner of the database, I can't update my table with message 'Recordset is not updatable'.
I have no problem updating through Enterprise Manager. Someone out there. Please help me
Access needs unique index to update a table. When linking SQL tables Access may ask you to select index columns. Select the number of columns needed for an "unique index"
I have no problem updating through Enterprise Manager. Someone out there. Please help me
Access needs unique index to update a table. When linking SQL tables Access may ask you to select index columns. Select the number of columns needed for an "unique index"
Recordset not updatable
I use MS Access Project to connect to MS-SQL 2000. Even though I login as ow
ner of the database, I can't update my table with message 'Recordset is not
updatable'.
I have no problem updating through Enterprise Manager. Someone out there. Pl
ease help meAccess needs unique index to update a table. When linking SQL tables Access
may ask you to select index columns. Select the number of columns needed for
an "unique index"
ner of the database, I can't update my table with message 'Recordset is not
updatable'.
I have no problem updating through Enterprise Manager. Someone out there. Pl
ease help meAccess needs unique index to update a table. When linking SQL tables Access
may ask you to select index columns. Select the number of columns needed for
an "unique index"
Monday, February 20, 2012
RecordCount -1
This is a multi-part message in MIME format.
--=_NextPart_000_0057_01C44D4D.A2D86E10
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hello,
I am using the function below to get some values form database.
However for RecordCount it always returns -1.
Any clues hot to fix it?
Thx
YuriW
Function RunSQL (sConnection_String, sSQL_QUERY) Dim db_object Dim sSQL_string
'connection_string =3D "DSN=3DMagnetic;UID=3Dlaurel;PWD=3Duklever"
sSQL_string =3D sSQL_QUERY
' Create the conection object.
Set db_object =3D CreateObject("ADODB.Connection")
' or use this method if a DSN entry was created.
db_object.Open(sConnection_String)
' Get the recordset returned from a select query.
Set recordset =3D db_object.Execute(sSQL_string)
' Display the results of the query.
sOut =3D recordset.RecordCount
RunSQL =3D sOut
' Close the database connection.
db_object.Close
Set db_object =3D Nothing
End Function
--=_NextPart_000_0057_01C44D4D.A2D86E10
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hello,
I am using the function below to get some values form = database.
However for RecordCount it always returns -1.
Any clues hot to fix it?
Thx
YuriW
Function RunSQL (sConnection_String, sSQL_QUERY) Dim = db_object Dim sSQL_string 'connection_string =3D "DSN=3DMagnetic;UID=3Dlaurel;PWD=3Duklever" sSQL_string =3D sSQL_QUERY
' Create the conection object. Set db_object =3D CreateObject("ADODB.Connection")
' or use this method if a DSN entry was = created. db_object.Open(sConnection_String)
' Get the recordset returned from a select query. = Set recordset =3D db_object.Execute(sSQL_string)
' Display the results of the query.
sOut =3D recordset.RecordCount
RunSQL =3D sOut
' Close the database connection. = db_object.Close Set db_object =3D Nothing
End Function
</FONT></FONT>
--=_NextPart_000_0057_01C44D4D.A2D86E10--http://www.aspfaq.com/2193
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Yuri Weinstein (HotMail)" <yuriw_NOSPAM@.hotmail.com> wrote in message
news:7Mnxc.68469$yx3.34214@.newssvr29.news.prodigy.com...
Hello,
I am using the function below to get some values form database.
However for RecordCount it always returns -1.
Any clues hot to fix it?
Thx
YuriW
Function RunSQL (sConnection_String, sSQL_QUERY)
Dim db_object
Dim sSQL_string
'connection_string = "DSN=Magnetic;UID=laurel;PWD=uklever"
sSQL_string = sSQL_QUERY
' Create the conection object.
Set db_object = CreateObject("ADODB.Connection")
' or use this method if a DSN entry was created.
db_object.Open(sConnection_String)
' Get the recordset returned from a select query.
Set recordset = db_object.Execute(sSQL_string)
' Display the results of the query.
sOut = recordset.RecordCount
RunSQL = sOut
' Close the database connection.
db_object.Close
Set db_object = Nothing
End Function|||Thanks you. I am still not clear how to change the code in order to fix it?
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:eyU6tjYTEHA.3580@.TK2MSFTNGP09.phx.gbl...
> http://www.aspfaq.com/2193
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Yuri Weinstein (HotMail)" <yuriw_NOSPAM@.hotmail.com> wrote in message
> news:7Mnxc.68469$yx3.34214@.newssvr29.news.prodigy.com...
> Hello,
> I am using the function below to get some values form database.
> However for RecordCount it always returns -1.
> Any clues hot to fix it?
> Thx
> YuriW
> Function RunSQL (sConnection_String, sSQL_QUERY)
> Dim db_object
> Dim sSQL_string
> 'connection_string = "DSN=Magnetic;UID=laurel;PWD=uklever"
> sSQL_string = sSQL_QUERY
> ' Create the conection object.
> Set db_object = CreateObject("ADODB.Connection")
> ' or use this method if a DSN entry was created.
> db_object.Open(sConnection_String)
> ' Get the recordset returned from a select query.
> Set recordset = db_object.Execute(sSQL_string)
> ' Display the results of the query.
> sOut = recordset.RecordCount
> RunSQL = sOut
> ' Close the database connection.
> db_object.Close
> Set db_object = Nothing
> End Function
>|||Maybe you need to look at the article again?
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Yuri Weinstein (HotMail)" <yuriw_NOSPAM@.hotmail.com> wrote in message
news:dnoxc.68491$iR3.59055@.newssvr29.news.prodigy.com...
> Thanks you. I am still not clear how to change the code in order to fix
it?
>
> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:eyU6tjYTEHA.3580@.TK2MSFTNGP09.phx.gbl...
> > http://www.aspfaq.com/2193
> >
> > --
> > http://www.aspfaq.com/
> > (Reverse address to reply.)
> >
> >
> >
> >
> > "Yuri Weinstein (HotMail)" <yuriw_NOSPAM@.hotmail.com> wrote in message
> > news:7Mnxc.68469$yx3.34214@.newssvr29.news.prodigy.com...
> > Hello,
> > I am using the function below to get some values form database.
> > However for RecordCount it always returns -1.
> > Any clues hot to fix it?
> >
> > Thx
> > YuriW
> >
> > Function RunSQL (sConnection_String, sSQL_QUERY)
> > Dim db_object
> > Dim sSQL_string
> >
> > 'connection_string = "DSN=Magnetic;UID=laurel;PWD=uklever"
> > sSQL_string = sSQL_QUERY
> >
> > ' Create the conection object.
> > Set db_object = CreateObject("ADODB.Connection")
> >
> > ' or use this method if a DSN entry was created.
> > db_object.Open(sConnection_String)
> >
> > ' Get the recordset returned from a select query.
> > Set recordset = db_object.Execute(sSQL_string)
> >
> > ' Display the results of the query.
> >
> > sOut = recordset.RecordCount
> >
> > RunSQL = sOut
> >
> > ' Close the database connection.
> > db_object.Close
> > Set db_object = Nothing
> >
> > End Function
> >
> >
>|||This is a multi-part message in MIME format.
--=_NextPart_000_00C3_01C44D70.C4F36D60
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Recordcount is not supported with the default forward-only cursor. You =can try to set the type of cursor before you excute your SQL code.
"Yuri Weinstein (HotMail)" <yuriw_NOSPAM@.hotmail.com> wrote in message =news:7Mnxc.68469$yx3.34214@.newssvr29.news.prodigy.com...
Hello,
I am using the function below to get some values form database.
However for RecordCount it always returns -1.
Any clues hot to fix it?
Thx
YuriW
Function RunSQL (sConnection_String, sSQL_QUERY) Dim db_object Dim sSQL_string
'connection_string =3D "DSN=3DMagnetic;UID=3Dlaurel;PWD=3Duklever"
sSQL_string =3D sSQL_QUERY
' Create the conection object.
Set db_object =3D CreateObject("ADODB.Connection")
' or use this method if a DSN entry was created.
db_object.Open(sConnection_String)
' Get the recordset returned from a select query.
Set recordset =3D db_object.Execute(sSQL_string)
' Display the results of the query.
sOut =3D recordset.RecordCount
RunSQL =3D sOut
' Close the database connection.
db_object.Close
Set db_object =3D Nothing
End Function
--=_NextPart_000_00C3_01C44D70.C4F36D60
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Recordcount is not supported with the default forward-only cursor. =You can try to set the type of cursor before you excute your SQL code.
"Yuri Weinstein (HotMail)"= wrote in message news:7Mnxc=.68469$yx3.34214@.newssvr29.news.prodigy.com...
Hello,
I am using the function below to get some values form =database.
However for RecordCount it always returns -1.
Any clues hot to fix it?
Thx
YuriW
Function RunSQL (sConnection_String, sSQL_QUERY) Dim =db_object Dim sSQL_string 'connection_string =3D "DSN=3DMagnetic;UID=3Dlaurel;PWD=3Duklever" sSQL_string =3D sSQL_QUERY
' Create the conection object. Set db_object =3D = CreateObject("ADODB.Connection")
' or use this method if a DSN entry was =created. db_object.Open(sConnection_String)
' Get the recordset returned from a select =query. Set recordset =3D db_object.Execute(sSQL_string)
' Display the results of the query.
sOut =3D recordset.RecordCount
RunSQL =3D sOut
' Close the database connection. db_object.Close Set db_object =3D Nothing
End Function
--=_NextPart_000_00C3_01C44D70.C4F36D60--|||Got it, thx!
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:eyU6tjYTEHA.3580@.TK2MSFTNGP09.phx.gbl...
> http://www.aspfaq.com/2193
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Yuri Weinstein (HotMail)" <yuriw_NOSPAM@.hotmail.com> wrote in message
> news:7Mnxc.68469$yx3.34214@.newssvr29.news.prodigy.com...
> Hello,
> I am using the function below to get some values form database.
> However for RecordCount it always returns -1.
> Any clues hot to fix it?
> Thx
> YuriW
> Function RunSQL (sConnection_String, sSQL_QUERY)
> Dim db_object
> Dim sSQL_string
> 'connection_string = "DSN=Magnetic;UID=laurel;PWD=uklever"
> sSQL_string = sSQL_QUERY
> ' Create the conection object.
> Set db_object = CreateObject("ADODB.Connection")
> ' or use this method if a DSN entry was created.
> db_object.Open(sConnection_String)
> ' Get the recordset returned from a select query.
> Set recordset = db_object.Execute(sSQL_string)
> ' Display the results of the query.
> sOut = recordset.RecordCount
> RunSQL = sOut
> ' Close the database connection.
> db_object.Close
> Set db_object = Nothing
> End Function
>|||In "Display the results of the query" you should iterate through recordset
with MoveFirst/MoveNext. Add counter into this cycle
dim counter
counter = 0
rs.MoveFirst
while not rs.EOF
... display record
counter = counter + 1
rs.MoveNext
wend
'here counter contains number of records
//--
Regards,
Vassiliev V. V.
http://www-sharp.com -
Scripting/HTA/.Net Framework IDE
"Yuri Weinstein (HotMail)" <yuriw_NOSPAM@.hotmail.com> '?/'' ?
'' '?: news:7Mnxc.68469$yx3.34214@.newssvr29.news.prodigy.com...
Hello,
I am using the function below to get some values form database.
However for RecordCount it always returns -1.
Any clues hot to fix it?
Thx
YuriW
Function RunSQL (sConnection_String, sSQL_QUERY)
Dim db_object
Dim sSQL_string
'connection_string = "DSN=Magnetic;UID=laurel;PWD=uklever"
sSQL_string = sSQL_QUERY
' Create the conection object.
Set db_object = CreateObject("ADODB.Connection")
' or use this method if a DSN entry was created.
db_object.Open(sConnection_String)
' Get the recordset returned from a select query.
Set recordset = db_object.Execute(sSQL_string)
' Display the results of the query.
sOut = recordset.RecordCount
RunSQL = sOut
' Close the database connection.
db_object.Close
Set db_object = Nothing
End Function
--=_NextPart_000_0057_01C44D4D.A2D86E10
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hello,
I am using the function below to get some values form database.
However for RecordCount it always returns -1.
Any clues hot to fix it?
Thx
YuriW
Function RunSQL (sConnection_String, sSQL_QUERY) Dim db_object Dim sSQL_string
'connection_string =3D "DSN=3DMagnetic;UID=3Dlaurel;PWD=3Duklever"
sSQL_string =3D sSQL_QUERY
' Create the conection object.
Set db_object =3D CreateObject("ADODB.Connection")
' or use this method if a DSN entry was created.
db_object.Open(sConnection_String)
' Get the recordset returned from a select query.
Set recordset =3D db_object.Execute(sSQL_string)
' Display the results of the query.
sOut =3D recordset.RecordCount
RunSQL =3D sOut
' Close the database connection.
db_object.Close
Set db_object =3D Nothing
End Function
--=_NextPart_000_0057_01C44D4D.A2D86E10
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hello,
I am using the function below to get some values form = database.
However for RecordCount it always returns -1.
Any clues hot to fix it?
Thx
YuriW
Function RunSQL (sConnection_String, sSQL_QUERY) Dim = db_object Dim sSQL_string 'connection_string =3D "DSN=3DMagnetic;UID=3Dlaurel;PWD=3Duklever" sSQL_string =3D sSQL_QUERY
' Create the conection object. Set db_object =3D CreateObject("ADODB.Connection")
' or use this method if a DSN entry was = created. db_object.Open(sConnection_String)
' Get the recordset returned from a select query. = Set recordset =3D db_object.Execute(sSQL_string)
' Display the results of the query.
sOut =3D recordset.RecordCount
RunSQL =3D sOut
' Close the database connection. = db_object.Close Set db_object =3D Nothing
End Function
</FONT></FONT>
--=_NextPart_000_0057_01C44D4D.A2D86E10--http://www.aspfaq.com/2193
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Yuri Weinstein (HotMail)" <yuriw_NOSPAM@.hotmail.com> wrote in message
news:7Mnxc.68469$yx3.34214@.newssvr29.news.prodigy.com...
Hello,
I am using the function below to get some values form database.
However for RecordCount it always returns -1.
Any clues hot to fix it?
Thx
YuriW
Function RunSQL (sConnection_String, sSQL_QUERY)
Dim db_object
Dim sSQL_string
'connection_string = "DSN=Magnetic;UID=laurel;PWD=uklever"
sSQL_string = sSQL_QUERY
' Create the conection object.
Set db_object = CreateObject("ADODB.Connection")
' or use this method if a DSN entry was created.
db_object.Open(sConnection_String)
' Get the recordset returned from a select query.
Set recordset = db_object.Execute(sSQL_string)
' Display the results of the query.
sOut = recordset.RecordCount
RunSQL = sOut
' Close the database connection.
db_object.Close
Set db_object = Nothing
End Function|||Thanks you. I am still not clear how to change the code in order to fix it?
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:eyU6tjYTEHA.3580@.TK2MSFTNGP09.phx.gbl...
> http://www.aspfaq.com/2193
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Yuri Weinstein (HotMail)" <yuriw_NOSPAM@.hotmail.com> wrote in message
> news:7Mnxc.68469$yx3.34214@.newssvr29.news.prodigy.com...
> Hello,
> I am using the function below to get some values form database.
> However for RecordCount it always returns -1.
> Any clues hot to fix it?
> Thx
> YuriW
> Function RunSQL (sConnection_String, sSQL_QUERY)
> Dim db_object
> Dim sSQL_string
> 'connection_string = "DSN=Magnetic;UID=laurel;PWD=uklever"
> sSQL_string = sSQL_QUERY
> ' Create the conection object.
> Set db_object = CreateObject("ADODB.Connection")
> ' or use this method if a DSN entry was created.
> db_object.Open(sConnection_String)
> ' Get the recordset returned from a select query.
> Set recordset = db_object.Execute(sSQL_string)
> ' Display the results of the query.
> sOut = recordset.RecordCount
> RunSQL = sOut
> ' Close the database connection.
> db_object.Close
> Set db_object = Nothing
> End Function
>|||Maybe you need to look at the article again?
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Yuri Weinstein (HotMail)" <yuriw_NOSPAM@.hotmail.com> wrote in message
news:dnoxc.68491$iR3.59055@.newssvr29.news.prodigy.com...
> Thanks you. I am still not clear how to change the code in order to fix
it?
>
> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:eyU6tjYTEHA.3580@.TK2MSFTNGP09.phx.gbl...
> > http://www.aspfaq.com/2193
> >
> > --
> > http://www.aspfaq.com/
> > (Reverse address to reply.)
> >
> >
> >
> >
> > "Yuri Weinstein (HotMail)" <yuriw_NOSPAM@.hotmail.com> wrote in message
> > news:7Mnxc.68469$yx3.34214@.newssvr29.news.prodigy.com...
> > Hello,
> > I am using the function below to get some values form database.
> > However for RecordCount it always returns -1.
> > Any clues hot to fix it?
> >
> > Thx
> > YuriW
> >
> > Function RunSQL (sConnection_String, sSQL_QUERY)
> > Dim db_object
> > Dim sSQL_string
> >
> > 'connection_string = "DSN=Magnetic;UID=laurel;PWD=uklever"
> > sSQL_string = sSQL_QUERY
> >
> > ' Create the conection object.
> > Set db_object = CreateObject("ADODB.Connection")
> >
> > ' or use this method if a DSN entry was created.
> > db_object.Open(sConnection_String)
> >
> > ' Get the recordset returned from a select query.
> > Set recordset = db_object.Execute(sSQL_string)
> >
> > ' Display the results of the query.
> >
> > sOut = recordset.RecordCount
> >
> > RunSQL = sOut
> >
> > ' Close the database connection.
> > db_object.Close
> > Set db_object = Nothing
> >
> > End Function
> >
> >
>|||This is a multi-part message in MIME format.
--=_NextPart_000_00C3_01C44D70.C4F36D60
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Recordcount is not supported with the default forward-only cursor. You =can try to set the type of cursor before you excute your SQL code.
"Yuri Weinstein (HotMail)" <yuriw_NOSPAM@.hotmail.com> wrote in message =news:7Mnxc.68469$yx3.34214@.newssvr29.news.prodigy.com...
Hello,
I am using the function below to get some values form database.
However for RecordCount it always returns -1.
Any clues hot to fix it?
Thx
YuriW
Function RunSQL (sConnection_String, sSQL_QUERY) Dim db_object Dim sSQL_string
'connection_string =3D "DSN=3DMagnetic;UID=3Dlaurel;PWD=3Duklever"
sSQL_string =3D sSQL_QUERY
' Create the conection object.
Set db_object =3D CreateObject("ADODB.Connection")
' or use this method if a DSN entry was created.
db_object.Open(sConnection_String)
' Get the recordset returned from a select query.
Set recordset =3D db_object.Execute(sSQL_string)
' Display the results of the query.
sOut =3D recordset.RecordCount
RunSQL =3D sOut
' Close the database connection.
db_object.Close
Set db_object =3D Nothing
End Function
--=_NextPart_000_00C3_01C44D70.C4F36D60
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Recordcount is not supported with the default forward-only cursor. =You can try to set the type of cursor before you excute your SQL code.
"Yuri Weinstein (HotMail)"
Hello,
I am using the function below to get some values form =database.
However for RecordCount it always returns -1.
Any clues hot to fix it?
Thx
YuriW
Function RunSQL (sConnection_String, sSQL_QUERY) Dim =db_object Dim sSQL_string 'connection_string =3D "DSN=3DMagnetic;UID=3Dlaurel;PWD=3Duklever" sSQL_string =3D sSQL_QUERY
' Create the conection object. Set db_object =3D = CreateObject("ADODB.Connection")
' or use this method if a DSN entry was =created. db_object.Open(sConnection_String)
' Get the recordset returned from a select =query. Set recordset =3D db_object.Execute(sSQL_string)
' Display the results of the query.
sOut =3D recordset.RecordCount
RunSQL =3D sOut
' Close the database connection. db_object.Close Set db_object =3D Nothing
End Function
--=_NextPart_000_00C3_01C44D70.C4F36D60--|||Got it, thx!
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:eyU6tjYTEHA.3580@.TK2MSFTNGP09.phx.gbl...
> http://www.aspfaq.com/2193
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Yuri Weinstein (HotMail)" <yuriw_NOSPAM@.hotmail.com> wrote in message
> news:7Mnxc.68469$yx3.34214@.newssvr29.news.prodigy.com...
> Hello,
> I am using the function below to get some values form database.
> However for RecordCount it always returns -1.
> Any clues hot to fix it?
> Thx
> YuriW
> Function RunSQL (sConnection_String, sSQL_QUERY)
> Dim db_object
> Dim sSQL_string
> 'connection_string = "DSN=Magnetic;UID=laurel;PWD=uklever"
> sSQL_string = sSQL_QUERY
> ' Create the conection object.
> Set db_object = CreateObject("ADODB.Connection")
> ' or use this method if a DSN entry was created.
> db_object.Open(sConnection_String)
> ' Get the recordset returned from a select query.
> Set recordset = db_object.Execute(sSQL_string)
> ' Display the results of the query.
> sOut = recordset.RecordCount
> RunSQL = sOut
> ' Close the database connection.
> db_object.Close
> Set db_object = Nothing
> End Function
>|||In "Display the results of the query" you should iterate through recordset
with MoveFirst/MoveNext. Add counter into this cycle
dim counter
counter = 0
rs.MoveFirst
while not rs.EOF
... display record
counter = counter + 1
rs.MoveNext
wend
'here counter contains number of records
//--
Regards,
Vassiliev V. V.
http://www-sharp.com -
Scripting/HTA/.Net Framework IDE
"Yuri Weinstein (HotMail)" <yuriw_NOSPAM@.hotmail.com> '?/'' ?
'' '?: news:7Mnxc.68469$yx3.34214@.newssvr29.news.prodigy.com...
Hello,
I am using the function below to get some values form database.
However for RecordCount it always returns -1.
Any clues hot to fix it?
Thx
YuriW
Function RunSQL (sConnection_String, sSQL_QUERY)
Dim db_object
Dim sSQL_string
'connection_string = "DSN=Magnetic;UID=laurel;PWD=uklever"
sSQL_string = sSQL_QUERY
' Create the conection object.
Set db_object = CreateObject("ADODB.Connection")
' or use this method if a DSN entry was created.
db_object.Open(sConnection_String)
' Get the recordset returned from a select query.
Set recordset = db_object.Execute(sSQL_string)
' Display the results of the query.
sOut = recordset.RecordCount
RunSQL = sOut
' Close the database connection.
db_object.Close
Set db_object = Nothing
End Function
Record too long when exporting
Hi
when exporting data from a sql table, the process stops with the message 'record too long'. The table has about 45,000 records and I cannot isolate which row is causing the error. The export wizard gives a row number but that row in the table looks OK
Any ideas?
Eddie
Hi
What database is this being exported to?
John
"Eddie" <Eddie@.discussions.microsoft.com> wrote in message
news:B0A2509E-EE1D-471D-A48C-227EAA63C7C5@.microsoft.com...
> Hi
> when exporting data from a sql table, the process stops with the message
'record too long'. The table has about 45,000 records and I cannot isolate
which row is causing the error. The export wizard gives a row number but
that row in the table looks OK
> Any ideas?
> Eddie
|||sorry
the table is being exported to a microsoft access table
"John Bell" wrote:
> Hi
> What database is this being exported to?
> John
> "Eddie" <Eddie@.discussions.microsoft.com> wrote in message
> news:B0A2509E-EE1D-471D-A48C-227EAA63C7C5@.microsoft.com...
> 'record too long'. The table has about 45,000 records and I cannot isolate
> which row is causing the error. The export wizard gives a row number but
> that row in the table looks OK
>
>
|||sorry
the table is being exported to a microsoft access table
"John Bell" wrote:
> Hi
> What database is this being exported to?
> John
> "Eddie" <Eddie@.discussions.microsoft.com> wrote in message
> news:B0A2509E-EE1D-471D-A48C-227EAA63C7C5@.microsoft.com...
> 'record too long'. The table has about 45,000 records and I cannot isolate
> which row is causing the error. The export wizard gives a row number but
> that row in the table looks OK
>
>
|||Hi Eddie
I found this on Google!
"Maximum length for a record in Access is 2000 characters, or 255 fields,
whichever comes first."
Try using looking at
SELECT ISNULL(LEN(col1),0) + ISNULL(LEN(col2),0) + ... + ISNULL(LEN(coln),0)
FROM MyTable
John
"Eddie" <Eddie@.discussions.microsoft.com> wrote in message
news:B5205172-B503-4A43-85D8-DA6A5D59323B@.microsoft.com...[vbcol=seagreen]
> sorry
> the table is being exported to a microsoft access table
> "John Bell" wrote:
message[vbcol=seagreen]
isolate[vbcol=seagreen]
but[vbcol=seagreen]
when exporting data from a sql table, the process stops with the message 'record too long'. The table has about 45,000 records and I cannot isolate which row is causing the error. The export wizard gives a row number but that row in the table looks OK
Any ideas?
Eddie
Hi
What database is this being exported to?
John
"Eddie" <Eddie@.discussions.microsoft.com> wrote in message
news:B0A2509E-EE1D-471D-A48C-227EAA63C7C5@.microsoft.com...
> Hi
> when exporting data from a sql table, the process stops with the message
'record too long'. The table has about 45,000 records and I cannot isolate
which row is causing the error. The export wizard gives a row number but
that row in the table looks OK
> Any ideas?
> Eddie
|||sorry
the table is being exported to a microsoft access table
"John Bell" wrote:
> Hi
> What database is this being exported to?
> John
> "Eddie" <Eddie@.discussions.microsoft.com> wrote in message
> news:B0A2509E-EE1D-471D-A48C-227EAA63C7C5@.microsoft.com...
> 'record too long'. The table has about 45,000 records and I cannot isolate
> which row is causing the error. The export wizard gives a row number but
> that row in the table looks OK
>
>
|||sorry
the table is being exported to a microsoft access table
"John Bell" wrote:
> Hi
> What database is this being exported to?
> John
> "Eddie" <Eddie@.discussions.microsoft.com> wrote in message
> news:B0A2509E-EE1D-471D-A48C-227EAA63C7C5@.microsoft.com...
> 'record too long'. The table has about 45,000 records and I cannot isolate
> which row is causing the error. The export wizard gives a row number but
> that row in the table looks OK
>
>
|||Hi Eddie
I found this on Google!
"Maximum length for a record in Access is 2000 characters, or 255 fields,
whichever comes first."
Try using looking at
SELECT ISNULL(LEN(col1),0) + ISNULL(LEN(col2),0) + ... + ISNULL(LEN(coln),0)
FROM MyTable
John
"Eddie" <Eddie@.discussions.microsoft.com> wrote in message
news:B5205172-B503-4A43-85D8-DA6A5D59323B@.microsoft.com...[vbcol=seagreen]
> sorry
> the table is being exported to a microsoft access table
> "John Bell" wrote:
message[vbcol=seagreen]
isolate[vbcol=seagreen]
but[vbcol=seagreen]
Record too long when exporting
Hi
when exporting data from a sql table, the process stops with the message 're
cord too long'. The table has about 45,000 records and I cannot isolate whic
h row is causing the error. The export wizard gives a row number but that r
ow in the table looks OK
Any ideas?
EddieHi
What database is this being exported to?
John
"Eddie" <Eddie@.discussions.microsoft.com> wrote in message
news:B0A2509E-EE1D-471D-A48C-227EAA63C7C5@.microsoft.com...
> Hi
> when exporting data from a sql table, the process stops with the message
'record too long'. The table has about 45,000 records and I cannot isolate
which row is causing the error. The export wizard gives a row number but
that row in the table looks OK
> Any ideas?
> Eddie|||sorry
the table is being exported to a microsoft access table
"John Bell" wrote:
> Hi
> What database is this being exported to?
> John
> "Eddie" <Eddie@.discussions.microsoft.com> wrote in message
> news:B0A2509E-EE1D-471D-A48C-227EAA63C7C5@.microsoft.com...
> 'record too long'. The table has about 45,000 records and I cannot isolate
> which row is causing the error. The export wizard gives a row number but
> that row in the table looks OK
>
>|||sorry
the table is being exported to a microsoft access table
"John Bell" wrote:
> Hi
> What database is this being exported to?
> John
> "Eddie" <Eddie@.discussions.microsoft.com> wrote in message
> news:B0A2509E-EE1D-471D-A48C-227EAA63C7C5@.microsoft.com...
> 'record too long'. The table has about 45,000 records and I cannot isolate
> which row is causing the error. The export wizard gives a row number but
> that row in the table looks OK
>
>|||Hi Eddie
I found this on Google!
"Maximum length for a record in Access is 2000 characters, or 255 fields,
whichever comes first."
Try using looking at
SELECT ISNULL(LEN(col1),0) + ISNULL(LEN(col2),0) + ... + ISNULL(LEN(coln),0)
FROM MyTable
John
"Eddie" <Eddie@.discussions.microsoft.com> wrote in message
news:B5205172-B503-4A43-85D8-DA6A5D59323B@.microsoft.com...[vbcol=seagreen]
> sorry
> the table is being exported to a microsoft access table
> "John Bell" wrote:
>
message[vbcol=seagreen]
isolate[vbcol=seagreen]
but[vbcol=seagreen]
when exporting data from a sql table, the process stops with the message 're
cord too long'. The table has about 45,000 records and I cannot isolate whic
h row is causing the error. The export wizard gives a row number but that r
ow in the table looks OK
Any ideas?
EddieHi
What database is this being exported to?
John
"Eddie" <Eddie@.discussions.microsoft.com> wrote in message
news:B0A2509E-EE1D-471D-A48C-227EAA63C7C5@.microsoft.com...
> Hi
> when exporting data from a sql table, the process stops with the message
'record too long'. The table has about 45,000 records and I cannot isolate
which row is causing the error. The export wizard gives a row number but
that row in the table looks OK
> Any ideas?
> Eddie|||sorry
the table is being exported to a microsoft access table
"John Bell" wrote:
> Hi
> What database is this being exported to?
> John
> "Eddie" <Eddie@.discussions.microsoft.com> wrote in message
> news:B0A2509E-EE1D-471D-A48C-227EAA63C7C5@.microsoft.com...
> 'record too long'. The table has about 45,000 records and I cannot isolate
> which row is causing the error. The export wizard gives a row number but
> that row in the table looks OK
>
>|||sorry
the table is being exported to a microsoft access table
"John Bell" wrote:
> Hi
> What database is this being exported to?
> John
> "Eddie" <Eddie@.discussions.microsoft.com> wrote in message
> news:B0A2509E-EE1D-471D-A48C-227EAA63C7C5@.microsoft.com...
> 'record too long'. The table has about 45,000 records and I cannot isolate
> which row is causing the error. The export wizard gives a row number but
> that row in the table looks OK
>
>|||Hi Eddie
I found this on Google!
"Maximum length for a record in Access is 2000 characters, or 255 fields,
whichever comes first."
Try using looking at
SELECT ISNULL(LEN(col1),0) + ISNULL(LEN(col2),0) + ... + ISNULL(LEN(coln),0)
FROM MyTable
John
"Eddie" <Eddie@.discussions.microsoft.com> wrote in message
news:B5205172-B503-4A43-85D8-DA6A5D59323B@.microsoft.com...[vbcol=seagreen]
> sorry
> the table is being exported to a microsoft access table
> "John Bell" wrote:
>
message[vbcol=seagreen]
isolate[vbcol=seagreen]
but[vbcol=seagreen]
Subscribe to:
Posts (Atom)