1. Do backup and restore.

2. copy database

Can you post here how did you resolved it then that would help others in case of same error message.

I have similar requirement before in my environment and I tried setting up CDC as I'm having SQL Server 2008 r2 but din't work really as it is a...

The server instance was started using minimal configuration startup option (-f). Starting an instance of SQL Server with minimal configuration places the server in single-user mode automatically. After the server...

Wher do you want to use it?

Switching the recovery model will break up your log backups chain....

I found a useful link in SSC itself related to this topic by Steve Jones [/url]

This script generates the script to drop users only for the users who don't own a schema.

It would have been better if it can generate like that too. I'll try...

Sean Lange (8/11/2011)

---

Daryl AZ (8/11/2011)

---

Create a function that takes a comma delimited sting and returns a two column table. (ID, LookupValue)

Select yada

FROM MyTable

Left Join fnc_tableFromString(@argMyString) theName ON myTable.name =...

I agree,So pagefile usage can be an indication to the memory bottleneck? just curious..

Step1:

Find who is consuming the memory currently?

SELECT mg.granted_memory_kb, mg.session_id, t.text,...

Don't we have to look on the page file? to check how much page file is utilizing.

Occurs while the checkpoint task is waiting for the next checkpoint request. In this case we can issue the manual checkpoint so that if there is any...

Can you post the sample query that doing insert?

you said the query is running for long, so did you check the wait_type on what it is waiting for? like...

Oh Okey , i'm sorry then