modification in database one by one record

My problem is related to database and data.

I building a project in ASP.NET 2.0 with the help of VWD in which i have certain records and each record has

a unique id with it.Now my problem is that when a user wants to edit a certain record i want the user to enter

a record id for that record. Now if the record id matches any record in the database then that record should be

dislayed in another page with and edit option with it.

Check out this article:

http://asp.net/learn/dataaccess/default.aspx?tabid=63

Hope this helps,

Vivek

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/m...3518895

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
> 95" target="_blank">http://groups.google.com.au/group/m...35188
95
> 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,
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 tim
e:
> 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 dum
p
> 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.sql

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.

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/mi...d6c6 a3518895
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/mi...d6c6 a3518895
> 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,
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.