Thank you gila sir,

file names are different that is the problem.

now its working fine.

Dear,

In my laptop only one drive is there i.e C:

still it has 120 gb free space in that drive.

Thank you,

here are the errors

2012-02-13 14:27:39.42 spid10s Starting up database 'model'.

2012-02-13 14:27:39.42 spid6s Server name is 'MADDUKURI-PC\PROD'. This is an informational message only. No user action is required.

2012-02-13 14:27:39.45 spid10s Error:...

Hi Gila Sir,

2012-02-13 14:27:38.76 Server Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64)

Mar 29 2009 10:11:52

Copyright (c) 1988-2008 Microsoft Corporation

Enterprise Evaluation Edition (64-bit)...

Iam learning the sql server administration.For practice purpose i was moving the model db to other place.

Here are the steps i was followed

1)using the alter database command changed the file...

thank you sir.

Thank you lowell

Thats very good explanation.I have one more doubt plz.

iam assuming i have maintaining 140 servers in that 60 prod.total 100 db's are there in prod.now my doubt is how these...

thank you for answer.I have one doubt.

users are connecting to prod and then some modifications are done in prod databases.

how to maintain same data in test environment?

thank you for your help

Thank you Gail Shaw. 🙂

Now my db is in suspect mode.I Just followed your steps.

Hi,

I have created database and enter the values in to that table.

and also perform the explicit transaction after that in another window i wrote the below steps

SHUTDOWN WITH NOWAIT;

GO

but server...

Thank you for your help.

Let me try now on my local machine.

thank you for your help

And i have one more doubt.

Is there any option to use to find blocking with out profiler?

Thank you,