model db

Hello,
Question.. why would the model db transaction log be growing and getting ful
l? No new activity such as adding new databases or user defined data has occ
urred.
Thanks!!There's always some activity in the log, like checkpointing etc. Shouldn't b
e much but over a long time
perhaps...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"nupee" <nupee@.discussions.microsoft.com> wrote in message
news:601B4E8D-7FC8-40BD-B9CD-215260441284@.microsoft.com...
> Hello,
> Question.. why would the model db transaction log be growing and getting full? No
new activity such as
adding new databases or user defined data has occurred.
> Thanks!!|||Hi,
As Tibor mentioned the growth will be very minimal, can you check the growth
by executing the below procedure during the growth situation
DBCC SQLPERF(LOGSPACE)
Thanks
Hari
MCDBA
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OdP34WuXEHA.1764@.TK2MSFTNGP10.phx.gbl...
> There's always some activity in the log, like checkpointing etc. Shouldn't
be much but over a long time
> perhaps...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "nupee" <nupee@.discussions.microsoft.com> wrote in message
> news:601B4E8D-7FC8-40BD-B9CD-215260441284@.microsoft.com...
full? No new activity such as[vbcol=seagreen]
> adding new databases or user defined data has occurred.
>

model db

Hello,
Question.. why would the model db transaction log be growing and getting full? No new activity such as adding new databases or user defined data has occurred.
Thanks!!There's always some activity in the log, like checkpointing etc. Shouldn't be much but over a long time
perhaps...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"nupee" <nupee@.discussions.microsoft.com> wrote in message
news:601B4E8D-7FC8-40BD-B9CD-215260441284@.microsoft.com...
> Hello,
> Question.. why would the model db transaction log be growing and getting full? No new activity such as
adding new databases or user defined data has occurred.
> Thanks!!|||Hi,
As Tibor mentioned the growth will be very minimal, can you check the growth
by executing the below procedure during the growth situation
DBCC SQLPERF(LOGSPACE)
Thanks
Hari
MCDBA
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OdP34WuXEHA.1764@.TK2MSFTNGP10.phx.gbl...
> There's always some activity in the log, like checkpointing etc. Shouldn't
be much but over a long time
> perhaps...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "nupee" <nupee@.discussions.microsoft.com> wrote in message
> news:601B4E8D-7FC8-40BD-B9CD-215260441284@.microsoft.com...
> > Hello,
> >
> > Question.. why would the model db transaction log be growing and getting
full? No new activity such as
> adding new databases or user defined data has occurred.
> >
> > Thanks!!
>

model db

Hello,
Question.. why would the model db transaction log be growing and getting full? No new activity such as adding new databases or user defined data has occurred.
Thanks!!
There's always some activity in the log, like checkpointing etc. Shouldn't be much but over a long time
perhaps...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"nupee" <nupee@.discussions.microsoft.com> wrote in message
news:601B4E8D-7FC8-40BD-B9CD-215260441284@.microsoft.com...
> Hello,
> Question.. why would the model db transaction log be growing and getting full? No new activity such as
adding new databases or user defined data has occurred.
> Thanks!!
|||Hi,
As Tibor mentioned the growth will be very minimal, can you check the growth
by executing the below procedure during the growth situation
DBCC SQLPERF(LOGSPACE)
Thanks
Hari
MCDBA
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OdP34WuXEHA.1764@.TK2MSFTNGP10.phx.gbl...
> There's always some activity in the log, like checkpointing etc. Shouldn't
be much but over a long time[vbcol=seagreen]
> perhaps...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "nupee" <nupee@.discussions.microsoft.com> wrote in message
> news:601B4E8D-7FC8-40BD-B9CD-215260441284@.microsoft.com...
full? No new activity such as
> adding new databases or user defined data has occurred.
>
sql

Missing Log - Suspect Datanbase - HELP!

A customer called me and said they ran the disk out of space, rebooted the
machine and the activity log is complaining about the database log being
already in use, and being out of disk. The database is in suspect mode, and
the database log is MIA!
Any ideas'
Thanks
RichardTry looking into system procs,
sp_add_data_file_recover_suspect_db and sp_add_log_file_recover_suspect_db
in books online
Thanks
"Richard Douglass" wrote:
> A customer called me and said they ran the disk out of space, rebooted the
> machine and the activity log is complaining about the database log being
> already in use, and being out of disk. The database is in suspect mode, and
> the database log is MIA!
> Any ideas'
> Thanks
> Richard
>
>|||Richard
http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
"Richard Douglass" <RDouglass@.arisinc.com> wrote in message
news:OfDesPeVHHA.1000@.TK2MSFTNGP05.phx.gbl...
>A customer called me and said they ran the disk out of space, rebooted the
>machine and the activity log is complaining about the database log being
>already in use, and being out of disk. The database is in suspect mode,
>and the database log is MIA!
> Any ideas'
> Thanks
> Richard
>

Missing Log - Suspect Datanbase - HELP!

A customer called me and said they ran the disk out of space, rebooted the
machine and the activity log is complaining about the database log being
already in use, and being out of disk. The database is in suspect mode, and
the database log is MIA!
Any ideas'
Thanks
RichardTry looking into system procs,
sp_add_data_file_recover_suspect_db and sp_add_log_file_recover_suspect_db
in books online
Thanks
"Richard Douglass" wrote:

> A customer called me and said they ran the disk out of space, rebooted the
> machine and the activity log is complaining about the database log being
> already in use, and being out of disk. The database is in suspect mode, a
nd
> the database log is MIA!
> Any ideas'
> Thanks
> Richard
>
>|||Richard
http://www.karaszi.com/SQLServer/in..._suspect_db.asp
"Richard Douglass" <RDouglass@.arisinc.com> wrote in message
news:OfDesPeVHHA.1000@.TK2MSFTNGP05.phx.gbl...
>A customer called me and said they ran the disk out of space, rebooted the
>machine and the activity log is complaining about the database log being
>already in use, and being out of disk. The database is in suspect mode,
>and the database log is MIA!
> Any ideas'
> Thanks
> Richard
>