I'm getting the following messages repeatedly (several times a minute) in
the sql server logs:
Starting up database 'Northwind'.
Analysis of database 'Northwind' (6) is 100% complete (approximately 0 more
seconds)
I don't see this behaviour in any of our other servers. What would cause
this?
Thanks,
DrewAutoclose set to "on" would be one possiblity.
Keith
"Drew" <Drew@.discussions.microsoft.com> wrote in message
news:976BC816-3DF2-47D5-B41F-7ED65096C37A@.microsoft.com...
> I'm getting the following messages repeatedly (several times a minute) in
> the sql server logs:
> Starting up database 'Northwind'.
> Analysis of database 'Northwind' (6) is 100% complete (approximately 0
more
> seconds)
> I don't see this behaviour in any of our other servers. What would cause
> this?
> Thanks,
> Drew
Showing posts with label logs. Show all posts
Showing posts with label logs. Show all posts
Monday, March 12, 2012
Repeated message in SQL Server Logs
I'm getting the following messages repeatedly (several times a minute) in
the sql server logs:
Starting up database 'Northwind'.
Analysis of database 'Northwind' (6) is 100% complete (approximately 0 more
seconds)
I don't see this behaviour in any of our other servers. What would cause
this?
Thanks,
Drew
Autoclose set to "on" would be one possiblity.
Keith
"Drew" <Drew@.discussions.microsoft.com> wrote in message
news:976BC816-3DF2-47D5-B41F-7ED65096C37A@.microsoft.com...
> I'm getting the following messages repeatedly (several times a minute) in
> the sql server logs:
> Starting up database 'Northwind'.
> Analysis of database 'Northwind' (6) is 100% complete (approximately 0
more
> seconds)
> I don't see this behaviour in any of our other servers. What would cause
> this?
> Thanks,
> Drew
the sql server logs:
Starting up database 'Northwind'.
Analysis of database 'Northwind' (6) is 100% complete (approximately 0 more
seconds)
I don't see this behaviour in any of our other servers. What would cause
this?
Thanks,
Drew
Autoclose set to "on" would be one possiblity.
Keith
"Drew" <Drew@.discussions.microsoft.com> wrote in message
news:976BC816-3DF2-47D5-B41F-7ED65096C37A@.microsoft.com...
> I'm getting the following messages repeatedly (several times a minute) in
> the sql server logs:
> Starting up database 'Northwind'.
> Analysis of database 'Northwind' (6) is 100% complete (approximately 0
more
> seconds)
> I don't see this behaviour in any of our other servers. What would cause
> this?
> Thanks,
> Drew
Repeated message in SQL Server Logs
I'm getting the following messages repeatedly (several times a minute) in
the sql server logs:
Starting up database 'Northwind'.
Analysis of database 'Northwind' (6) is 100% complete (approximately 0 more
seconds)
I don't see this behaviour in any of our other servers. What would cause
this?
Thanks,
DrewAutoclose set to "on" would be one possiblity.
Keith
"Drew" <Drew@.discussions.microsoft.com> wrote in message
news:976BC816-3DF2-47D5-B41F-7ED65096C37A@.microsoft.com...
> I'm getting the following messages repeatedly (several times a minute) in
> the sql server logs:
> Starting up database 'Northwind'.
> Analysis of database 'Northwind' (6) is 100% complete (approximately 0
more
> seconds)
> I don't see this behaviour in any of our other servers. What would cause
> this?
> Thanks,
> Drew
the sql server logs:
Starting up database 'Northwind'.
Analysis of database 'Northwind' (6) is 100% complete (approximately 0 more
seconds)
I don't see this behaviour in any of our other servers. What would cause
this?
Thanks,
DrewAutoclose set to "on" would be one possiblity.
Keith
"Drew" <Drew@.discussions.microsoft.com> wrote in message
news:976BC816-3DF2-47D5-B41F-7ED65096C37A@.microsoft.com...
> I'm getting the following messages repeatedly (several times a minute) in
> the sql server logs:
> Starting up database 'Northwind'.
> Analysis of database 'Northwind' (6) is 100% complete (approximately 0
more
> seconds)
> I don't see this behaviour in any of our other servers. What would cause
> this?
> Thanks,
> Drew
Repeated "starting up database" in SQL Server log
I am seeing this in my SQL server logs.
Starting up database 'myDatabase'.
Starting up database 'myDatabase'.
Starting up database 'myDatabase'.
Starting up database 'myDatabase'.
You likely have the database set to auto-close.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Prabhash Shrestha" <Prabhash Shrestha@.discussions.microsoft.com> wrote in
message news:F267E7FA-DFF9-4BCD-BC7D-7D4B9647827A@.microsoft.com...
> I am seeing this in my SQL server logs.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
>
>
>
|||Your database must be set to autoclose. It is one of the options that you
can turn on and off.
Most people will recommend that autoclose be disabled
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\tsq
lref.chm::/ts_aa-az_4e5h.htm
ALTER DATABASE foo SET AUTO_CLOSE OFF
Keith
"Prabhash Shrestha" <Prabhash Shrestha@.discussions.microsoft.com> wrote in
message news:F267E7FA-DFF9-4BCD-BC7D-7D4B9647827A@.microsoft.com...
> I am seeing this in my SQL server logs.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
>
>
>
|||Hi
Uncheck Auto Close option of the database
"Prabhash Shrestha" <Prabhash Shrestha@.discussions.microsoft.com> wrote in
message news:F267E7FA-DFF9-4BCD-BC7D-7D4B9647827A@.microsoft.com...
> I am seeing this in my SQL server logs.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
>
>
>
Starting up database 'myDatabase'.
Starting up database 'myDatabase'.
Starting up database 'myDatabase'.
Starting up database 'myDatabase'.
You likely have the database set to auto-close.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Prabhash Shrestha" <Prabhash Shrestha@.discussions.microsoft.com> wrote in
message news:F267E7FA-DFF9-4BCD-BC7D-7D4B9647827A@.microsoft.com...
> I am seeing this in my SQL server logs.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
>
>
>
|||Your database must be set to autoclose. It is one of the options that you
can turn on and off.
Most people will recommend that autoclose be disabled
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\tsq
lref.chm::/ts_aa-az_4e5h.htm
ALTER DATABASE foo SET AUTO_CLOSE OFF
Keith
"Prabhash Shrestha" <Prabhash Shrestha@.discussions.microsoft.com> wrote in
message news:F267E7FA-DFF9-4BCD-BC7D-7D4B9647827A@.microsoft.com...
> I am seeing this in my SQL server logs.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
>
>
>
|||Hi
Uncheck Auto Close option of the database
"Prabhash Shrestha" <Prabhash Shrestha@.discussions.microsoft.com> wrote in
message news:F267E7FA-DFF9-4BCD-BC7D-7D4B9647827A@.microsoft.com...
> I am seeing this in my SQL server logs.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
>
>
>
Repeated "starting up database" in SQL Server log
I am seeing this in my SQL server logs.
Starting up database 'myDatabase'.
Starting up database 'myDatabase'.
Starting up database 'myDatabase'.
Starting up database 'myDatabase'.You likely have the database set to auto-close.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Prabhash Shrestha" <Prabhash Shrestha@.discussions.microsoft.com> wrote in
message news:F267E7FA-DFF9-4BCD-BC7D-7D4B9647827A@.microsoft.com...
> I am seeing this in my SQL server logs.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
>
>
>|||Your database must be set to autoclose. It is one of the options that you
can turn on and off.
Most people will recommend that autoclose be disabled
mk:@.MSITStore:C:\Program%20Files\Microso
ft%20SQL%20Server\80\Tools\Books\tsq
lref.chm::/ts_aa-az_4e5h.htm
ALTER DATABASE foo SET AUTO_CLOSE OFF
Keith
"Prabhash Shrestha" <Prabhash Shrestha@.discussions.microsoft.com> wrote in
message news:F267E7FA-DFF9-4BCD-BC7D-7D4B9647827A@.microsoft.com...
> I am seeing this in my SQL server logs.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
>
>
>|||Hi
Uncheck Auto Close option of the database
"Prabhash Shrestha" <Prabhash Shrestha@.discussions.microsoft.com> wrote in
message news:F267E7FA-DFF9-4BCD-BC7D-7D4B9647827A@.microsoft.com...
> I am seeing this in my SQL server logs.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
>
>
>
Starting up database 'myDatabase'.
Starting up database 'myDatabase'.
Starting up database 'myDatabase'.
Starting up database 'myDatabase'.You likely have the database set to auto-close.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Prabhash Shrestha" <Prabhash Shrestha@.discussions.microsoft.com> wrote in
message news:F267E7FA-DFF9-4BCD-BC7D-7D4B9647827A@.microsoft.com...
> I am seeing this in my SQL server logs.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
>
>
>|||Your database must be set to autoclose. It is one of the options that you
can turn on and off.
Most people will recommend that autoclose be disabled
mk:@.MSITStore:C:\Program%20Files\Microso
ft%20SQL%20Server\80\Tools\Books\tsq
lref.chm::/ts_aa-az_4e5h.htm
ALTER DATABASE foo SET AUTO_CLOSE OFF
Keith
"Prabhash Shrestha" <Prabhash Shrestha@.discussions.microsoft.com> wrote in
message news:F267E7FA-DFF9-4BCD-BC7D-7D4B9647827A@.microsoft.com...
> I am seeing this in my SQL server logs.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
>
>
>|||Hi
Uncheck Auto Close option of the database
"Prabhash Shrestha" <Prabhash Shrestha@.discussions.microsoft.com> wrote in
message news:F267E7FA-DFF9-4BCD-BC7D-7D4B9647827A@.microsoft.com...
> I am seeing this in my SQL server logs.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
>
>
>
Repeated "starting up database" in SQL Server log
I am seeing this in my SQL server logs.
Starting up database 'myDatabase'.
Starting up database 'myDatabase'.
Starting up database 'myDatabase'.
Starting up database 'myDatabase'.You likely have the database set to auto-close.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Prabhash Shrestha" <Prabhash Shrestha@.discussions.microsoft.com> wrote in
message news:F267E7FA-DFF9-4BCD-BC7D-7D4B9647827A@.microsoft.com...
> I am seeing this in my SQL server logs.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
>
>
>|||Your database must be set to autoclose. It is one of the options that you
can turn on and off.
Most people will recommend that autoclose be disabled
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\tsq
lref.chm::/ts_aa-az_4e5h.htm
ALTER DATABASE foo SET AUTO_CLOSE OFF
--
Keith
"Prabhash Shrestha" <Prabhash Shrestha@.discussions.microsoft.com> wrote in
message news:F267E7FA-DFF9-4BCD-BC7D-7D4B9647827A@.microsoft.com...
> I am seeing this in my SQL server logs.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
>
>
>|||Hi
Uncheck Auto Close option of the database
"Prabhash Shrestha" <Prabhash Shrestha@.discussions.microsoft.com> wrote in
message news:F267E7FA-DFF9-4BCD-BC7D-7D4B9647827A@.microsoft.com...
> I am seeing this in my SQL server logs.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
>
>
>
Starting up database 'myDatabase'.
Starting up database 'myDatabase'.
Starting up database 'myDatabase'.
Starting up database 'myDatabase'.You likely have the database set to auto-close.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Prabhash Shrestha" <Prabhash Shrestha@.discussions.microsoft.com> wrote in
message news:F267E7FA-DFF9-4BCD-BC7D-7D4B9647827A@.microsoft.com...
> I am seeing this in my SQL server logs.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
>
>
>|||Your database must be set to autoclose. It is one of the options that you
can turn on and off.
Most people will recommend that autoclose be disabled
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\tsq
lref.chm::/ts_aa-az_4e5h.htm
ALTER DATABASE foo SET AUTO_CLOSE OFF
--
Keith
"Prabhash Shrestha" <Prabhash Shrestha@.discussions.microsoft.com> wrote in
message news:F267E7FA-DFF9-4BCD-BC7D-7D4B9647827A@.microsoft.com...
> I am seeing this in my SQL server logs.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
>
>
>|||Hi
Uncheck Auto Close option of the database
"Prabhash Shrestha" <Prabhash Shrestha@.discussions.microsoft.com> wrote in
message news:F267E7FA-DFF9-4BCD-BC7D-7D4B9647827A@.microsoft.com...
> I am seeing this in my SQL server logs.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
>
>
>
Wednesday, March 7, 2012
Repair database that grew over 2 GB
Because of a configuration error by field engineer who didn't check the
error logs before leaving, an error logging table in an MSDE database has
made it grow to 2GB in a couple of days.
The result is that the database status became "suspect" (I had to connect
through enterprise manager to see that) and it can no longer be opened.
At the same time, I noticed that the $&*$##% has renamed the computer after
installing MSDE and initializing the database, despite my urging him never
to do so: as a result the backup schedule that's created along with the
database was no longer executed, the last backup dates from last April
instead of a few hours before it stopped working.
Needless to say that the customer is very happy.
Now I think I made an additional error by trying to detach and re-attach
the database: MSDE won't even re-attach it anymore, with an error "the
primary file group is full".
Is there a way to force MSDE to load it anyway so the extraneous data can
be deleted?
Can the file be attached to a full SQL server, the runaway table purged
there, and then re-attached to MSDE?
Sorry, it seems I clicked 'Reply' in stead of 'new post' by mistake.
error logs before leaving, an error logging table in an MSDE database has
made it grow to 2GB in a couple of days.
The result is that the database status became "suspect" (I had to connect
through enterprise manager to see that) and it can no longer be opened.
At the same time, I noticed that the $&*$##% has renamed the computer after
installing MSDE and initializing the database, despite my urging him never
to do so: as a result the backup schedule that's created along with the
database was no longer executed, the last backup dates from last April
instead of a few hours before it stopped working.
Needless to say that the customer is very happy.
Now I think I made an additional error by trying to detach and re-attach
the database: MSDE won't even re-attach it anymore, with an error "the
primary file group is full".
Is there a way to force MSDE to load it anyway so the extraneous data can
be deleted?
Can the file be attached to a full SQL server, the runaway table purged
there, and then re-attached to MSDE?
Sorry, it seems I clicked 'Reply' in stead of 'new post' by mistake.
Repair database that grew over 2 GB
Because of a configuration error by field engineer who didn't check the
error logs before leaving, an error logging table in an MSDE database has
made it grow to 2GB in a couple of days.
The result is that the database status became "suspect" (I had to connect
through enterprise manager to see that) and it can no longer be opened.
At the same time, I noticed that the $&*$##% has renamed the computer after
installing MSDE and initializing the database, despite my urging him never
to do so: as a result the backup schedule that's created along with the
database was no longer executed, the last backup dates from last April
instead of a few hours before it stopped working.
Needless to say that the customer is very happy.
Now I think I made an additional error by trying to detach and re-attach
the database: MSDE won't even re-attach it anymore, with an error "the
primary file group is full".
Is there a way to force MSDE to load it anyway so the extraneous data can
be deleted?
Can the file be attached to a full SQL server, the runaway table purged
there, and then re-attached to MSDE?
On Tue, 28 Dec 2004 12:14:46 +0100, Lucvdv <replace_name@.null.net> wrote:
> Because of a configuration error by field engineer who didn't check the
> error logs before leaving, an error logging table in an MSDE database has
> made it grow to 2GB in a couple of days.
I just tried to recreate the problem on a test machine: the .mdf file grew
to 1869 MB (1.82 GB), then it stopped with "PRIMARY file group full", but
the database remains accessible, only inserts fail.
In the problem case, the .mdf file was slightly over 2 GB (2.03GB or so, I
don't remember exactly.)
Is there an explanation for this?
|||On Tue, 28 Dec 2004 12:14:46 +0100, Lucvdv <replace_name@.null.net> wrote:
> Can the file be attached to a full SQL server, the runaway table purged
> there, and then re-attached to MSDE?
Relief all around: after copying and attaching the database to a full SQL
Server, shrinking it there and then moving it back to MSDE, everything is
up and running again.
|||hi,
"Lucvdv" <replace_name@.null.net> ha scritto nel messaggio
news:ivf2t0ln44sb9r9ll8ucnknidv4pg4ppad@.4ax.com
> ...
> Can the file be attached to a full SQL server, the runaway table
> purged there, and then re-attached to MSDE?
yes... you can get the mdf (+ ndf if present) + ldf database files set,
take them to your office, purge the "extra" data and shrink the database
data file(s) to a size allowed by MSDE..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||On Tue, 28 Dec 2004 17:12:37 +0100, "Andrea Montanari"
<andrea.sqlDMO@.virgilio.it> wrote:
> hi,
> "Lucvdv" <replace_name@.null.net> ha scritto nel messaggio
> news:ivf2t0ln44sb9r9ll8ucnknidv4pg4ppad@.4ax.com
> yes... you can get the mdf (+ ndf if present) + ldf database files set,
> take them to your office, purge the "extra" data and shrink the database
> data file(s) to a size allowed by MSDE..
Thanks. I had tried and found that it worked shortly before you replied.
I tried to repeat it on a test machine later, but couldn't make the .mdf
grow above 2GB: all inserts started failing when the final file grow step
had to be done. It actually stopped around 1850 MB with % growth steps, it
refused to go closer to 2G until I changed that to 5MB fixed increments,
and then it stopped at 2044 MB.
The database remained usable, I could detach and attach it, only inserts
failed.
Yet in the problem case it was 2.03GB or something like that (slightly
above 2GB anyway), and MSDE refused to use it any further.
Do you have an idea how that might have happened?
I also noticed when I changed the file growth settings from % to fixed
size, that the change didn't take effect until I had detached and
re-attached the database (rebooting or restarting the service would
probably have done it too, what I mean is that inserts didn't start working
again by just changing the setting).
Is that something known?
|||hi Lucvdv,
"Lucvdv" <replace_name@.null.net> ha scritto nel messaggio
news:94r4t0p6bvclndb2l8gjuhogmd9ho8hq00@.4ax.com
> ...
> I tried to repeat it on a test machine later, but couldn't make the
> .mdf grow above 2GB: all inserts started failing when the final file
> grow step had to be done. It actually stopped around 1850 MB with %
> growth steps, it refused to go closer to 2G until I changed that to
> 5MB fixed increments, and then it stopped at 2044 MB.
> The database remained usable, I could detach and attach it, only
> inserts failed.
> Yet in the problem case it was 2.03GB or something like that (slightly
> above 2GB anyway), and MSDE refused to use it any further.
> Do you have an idea how that might have happened?
>
> I also noticed when I changed the file growth settings from % to fixed
> size, that the change didn't take effect until I had detached and
> re-attached the database (rebooting or restarting the service would
> probably have done it too, what I mean is that inserts didn't start
> working again by just changing the setting).
> Is that something known?
AFAIK the Storage engine should throw an exception when the 2gb limit is
reached, but should not set the db in suspect mode... this is what I've been
always told, as I never pushed MSDE to that upper limit :D ...
and this is the very first time I hear about growth setting affect such a
behaviour.. will try investigating this...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
error logs before leaving, an error logging table in an MSDE database has
made it grow to 2GB in a couple of days.
The result is that the database status became "suspect" (I had to connect
through enterprise manager to see that) and it can no longer be opened.
At the same time, I noticed that the $&*$##% has renamed the computer after
installing MSDE and initializing the database, despite my urging him never
to do so: as a result the backup schedule that's created along with the
database was no longer executed, the last backup dates from last April
instead of a few hours before it stopped working.
Needless to say that the customer is very happy.
Now I think I made an additional error by trying to detach and re-attach
the database: MSDE won't even re-attach it anymore, with an error "the
primary file group is full".
Is there a way to force MSDE to load it anyway so the extraneous data can
be deleted?
Can the file be attached to a full SQL server, the runaway table purged
there, and then re-attached to MSDE?
On Tue, 28 Dec 2004 12:14:46 +0100, Lucvdv <replace_name@.null.net> wrote:
> Because of a configuration error by field engineer who didn't check the
> error logs before leaving, an error logging table in an MSDE database has
> made it grow to 2GB in a couple of days.
I just tried to recreate the problem on a test machine: the .mdf file grew
to 1869 MB (1.82 GB), then it stopped with "PRIMARY file group full", but
the database remains accessible, only inserts fail.
In the problem case, the .mdf file was slightly over 2 GB (2.03GB or so, I
don't remember exactly.)
Is there an explanation for this?
|||On Tue, 28 Dec 2004 12:14:46 +0100, Lucvdv <replace_name@.null.net> wrote:
> Can the file be attached to a full SQL server, the runaway table purged
> there, and then re-attached to MSDE?
Relief all around: after copying and attaching the database to a full SQL
Server, shrinking it there and then moving it back to MSDE, everything is
up and running again.
|||hi,
"Lucvdv" <replace_name@.null.net> ha scritto nel messaggio
news:ivf2t0ln44sb9r9ll8ucnknidv4pg4ppad@.4ax.com
> ...
> Can the file be attached to a full SQL server, the runaway table
> purged there, and then re-attached to MSDE?
yes... you can get the mdf (+ ndf if present) + ldf database files set,
take them to your office, purge the "extra" data and shrink the database
data file(s) to a size allowed by MSDE..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||On Tue, 28 Dec 2004 17:12:37 +0100, "Andrea Montanari"
<andrea.sqlDMO@.virgilio.it> wrote:
> hi,
> "Lucvdv" <replace_name@.null.net> ha scritto nel messaggio
> news:ivf2t0ln44sb9r9ll8ucnknidv4pg4ppad@.4ax.com
> yes... you can get the mdf (+ ndf if present) + ldf database files set,
> take them to your office, purge the "extra" data and shrink the database
> data file(s) to a size allowed by MSDE..
Thanks. I had tried and found that it worked shortly before you replied.
I tried to repeat it on a test machine later, but couldn't make the .mdf
grow above 2GB: all inserts started failing when the final file grow step
had to be done. It actually stopped around 1850 MB with % growth steps, it
refused to go closer to 2G until I changed that to 5MB fixed increments,
and then it stopped at 2044 MB.
The database remained usable, I could detach and attach it, only inserts
failed.
Yet in the problem case it was 2.03GB or something like that (slightly
above 2GB anyway), and MSDE refused to use it any further.
Do you have an idea how that might have happened?
I also noticed when I changed the file growth settings from % to fixed
size, that the change didn't take effect until I had detached and
re-attached the database (rebooting or restarting the service would
probably have done it too, what I mean is that inserts didn't start working
again by just changing the setting).
Is that something known?
|||hi Lucvdv,
"Lucvdv" <replace_name@.null.net> ha scritto nel messaggio
news:94r4t0p6bvclndb2l8gjuhogmd9ho8hq00@.4ax.com
> ...
> I tried to repeat it on a test machine later, but couldn't make the
> .mdf grow above 2GB: all inserts started failing when the final file
> grow step had to be done. It actually stopped around 1850 MB with %
> growth steps, it refused to go closer to 2G until I changed that to
> 5MB fixed increments, and then it stopped at 2044 MB.
> The database remained usable, I could detach and attach it, only
> inserts failed.
> Yet in the problem case it was 2.03GB or something like that (slightly
> above 2GB anyway), and MSDE refused to use it any further.
> Do you have an idea how that might have happened?
>
> I also noticed when I changed the file growth settings from % to fixed
> size, that the change didn't take effect until I had detached and
> re-attached the database (rebooting or restarting the service would
> probably have done it too, what I mean is that inserts didn't start
> working again by just changing the setting).
> Is that something known?
AFAIK the Storage engine should throw an exception when the 2gb limit is
reached, but should not set the db in suspect mode... this is what I've been
always told, as I never pushed MSDE to that upper limit :D ...
and this is the very first time I hear about growth setting affect such a
behaviour.. will try investigating this...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Saturday, February 25, 2012
Reorganization and logs
I have a db maintenance plan set up that reorganizes my data once a week. I
noticed that the SQL Server Log does not indicate that this has run.
However, if I use the option to 'Write report to a text file in directory:',
a .txt file is created that indicates the reorganization has run. Why does
this not show up in the SQL Server Log as my reindexing and backups do? I'm
running SQL 2000.
The backups really shouldn't be in there either in my opinion. The log is
mainly for error info and a successful backup can be found in the job
history. If you want to know if and when it ran you can check the Job
History and the MP history.
Andrew J. Kelly SQL MVP
"Roger" <Roger@.discussions.microsoft.com> wrote in message
news:B604E4EE-8C77-4B5D-8B05-EBFC42BE0023@.microsoft.com...
> I have a db maintenance plan set up that reorganizes my data once a week.
I
> noticed that the SQL Server Log does not indicate that this has run.
> However, if I use the option to 'Write report to a text file in
directory:',
> a .txt file is created that indicates the reorganization has run. Why
does
> this not show up in the SQL Server Log as my reindexing and backups do?
I'm
> running SQL 2000.
noticed that the SQL Server Log does not indicate that this has run.
However, if I use the option to 'Write report to a text file in directory:',
a .txt file is created that indicates the reorganization has run. Why does
this not show up in the SQL Server Log as my reindexing and backups do? I'm
running SQL 2000.
The backups really shouldn't be in there either in my opinion. The log is
mainly for error info and a successful backup can be found in the job
history. If you want to know if and when it ran you can check the Job
History and the MP history.
Andrew J. Kelly SQL MVP
"Roger" <Roger@.discussions.microsoft.com> wrote in message
news:B604E4EE-8C77-4B5D-8B05-EBFC42BE0023@.microsoft.com...
> I have a db maintenance plan set up that reorganizes my data once a week.
I
> noticed that the SQL Server Log does not indicate that this has run.
> However, if I use the option to 'Write report to a text file in
directory:',
> a .txt file is created that indicates the reorganization has run. Why
does
> this not show up in the SQL Server Log as my reindexing and backups do?
I'm
> running SQL 2000.
Labels:
database,
indicate,
inoticed,
log,
logs,
maintenance,
microsoft,
mysql,
oracle,
plan,
reorganization,
reorganizes,
server,
sql
Subscribe to:
Posts (Atom)