• rajeshjaiswalraj (12/29/2012)


    My question was Is it possible to copy a resource database files when instance is ruining. if not why and yes then how to do simply copy and pest.

    So i am not able to find where are the file for resource database.

    Please reply 🙂

    Location and other important info: Resource Database (SQL Server 2008 R2)

    You can take a copy of the mdf and ldf files while the instance is running. Do some searches online and read about the topic. A backup buys you some coverage in the case of some very specific disaster scenarios, but not much.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato