Wednesday, March 28, 2012

model4IDR

Hi all,
In my database log, I found some messages related to model4IDR all the time:
Recovery is checkpointing database 'model4IDR' (10)
Starting up database 'model4IDR'.
Database restored: Database: model4IDR, creation date(time):
2000/08/06(01:40:52), first LSN: 4:493:1, last LSN: 4:495:1, number of dump
devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE:
{'RESTORE{5a9ced55-98fe-44a4-9287-e37f3ccb76e8}'}).
Bypassing recovery for database 'model4IDR' because it is marked IN LOAD.
What is happening? how can I get rid of them?
Thanks a lot.Hi
http://groups.google.com.au/group/microsoft.public.sqlserver.server/browse_thread/thread/cc817ce7eb893674/0449d6c6a3518895?q=model4IDR&rnum=2&hl=en#0449d6c6a3518895
You asked the question on 5 July and it was answered.
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Catelin Wang" <CatelinWang@.discussions.microsoft.com> wrote in message
news:D00D2C17-B580-4F9F-B642-E1AD97B79094@.microsoft.com...
> Hi all,
> In my database log, I found some messages related to model4IDR all the
> time:
> Recovery is checkpointing database 'model4IDR' (10)
> Starting up database 'model4IDR'.
> Database restored: Database: model4IDR, creation date(time):
> 2000/08/06(01:40:52), first LSN: 4:493:1, last LSN: 4:495:1, number of
> dump
> devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE:
> {'RESTORE{5a9ced55-98fe-44a4-9287-e37f3ccb76e8}'}).
> Bypassing recovery for database 'model4IDR' because it is marked IN LOAD.
> What is happening? how can I get rid of them?
> Thanks a lot.|||Thanks for the reply.
I did ask NT admin & they had a sencond instance for Back Exec installed on
the same computer, but thye did not know how the model4IDR databse stays
there. Is there a way I can get rid of the database, it may uses the server
resources.
Thanks a lot.
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> http://groups.google.com.au/group/microsoft.public.sqlserver.server/browse_thread/thread/cc817ce7eb893674/0449d6c6a3518895?q=model4IDR&rnum=2&hl=en#0449d6c6a3518895
> You asked the question on 5 July and it was answered.
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Catelin Wang" <CatelinWang@.discussions.microsoft.com> wrote in message
> news:D00D2C17-B580-4F9F-B642-E1AD97B79094@.microsoft.com...
> > Hi all,
> >
> > In my database log, I found some messages related to model4IDR all the
> > time:
> > Recovery is checkpointing database 'model4IDR' (10)
> > Starting up database 'model4IDR'.
> > Database restored: Database: model4IDR, creation date(time):
> > 2000/08/06(01:40:52), first LSN: 4:493:1, last LSN: 4:495:1, number of
> > dump
> > devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE:
> > {'RESTORE{5a9ced55-98fe-44a4-9287-e37f3ccb76e8}'}).
> > Bypassing recovery for database 'model4IDR' because it is marked IN LOAD.
> >
> > What is happening? how can I get rid of them?
> >
> > Thanks a lot.
>
>|||Hi All,
i am having a similar issues when trying to RESTORE a database backup on
NAMED instance of CLustered Server.
Here is the situation:
we have three-node cluser (Windows 2003/Sql2000) when I try to resore a
database backup on 2nd instance (virtual server/named instance) I get the
database in (LOADING). I can successfully restore same database backup on
first instance (virtual server/default instance).
Any help would be greatly appreciated.
kamal.
"Catelin Wang" wrote:
> Hi all,
> In my database log, I found some messages related to model4IDR all the time:
> Recovery is checkpointing database 'model4IDR' (10)
> Starting up database 'model4IDR'.
> Database restored: Database: model4IDR, creation date(time):
> 2000/08/06(01:40:52), first LSN: 4:493:1, last LSN: 4:495:1, number of dump
> devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE:
> {'RESTORE{5a9ced55-98fe-44a4-9287-e37f3ccb76e8}'}).
> Bypassing recovery for database 'model4IDR' because it is marked IN LOAD.
> What is happening? how can I get rid of them?
> Thanks a lot.

No comments:

Post a Comment