Just want to add, when you restore, you get the same free space back on the restored Db.

SQL error log should tell you which SQL account was used to run it.

How are you creating your database? is it using script or from SSMS

if it is using script ( Create database db1 ) then it still places data and log...

Shared folders can be directly accessed for restore operations as long as the account used should have rights on shared folder but the data and log files on the restored...

Shouldn't manually...

Can we have the update query and its query plan to check if it can be improved.

Is there any other error message that is shown in the error log just before this message.

Can you also enable profiler to trace any query executing sp_reset_connection / or...

If i understand you correctly you want to update the rows with status value equal to 6 with row with status value equal to 2. Then you may try

update...

Starting from sql server 2k8 username passwords are to be keyed in as anonymous authentication is disabled. Not too sure abt 3 time prompt.

are there any memory related errors on SQL error log?

What is the SQL Patch version?

Do you have perfmon or memory monitoring enabled. Does it always failover when the memory is...

Yes. 'Preferably' additional msdtc and cluster group.

New instance needs

* Dedicated IP address or SQL

* Dedicated ip address for msdtc

* Dedicated Virtual Name for SQL instance

* Dedicated Shared disks for Data and root directories

* Dedicated shared disk...

Opening the topic again as I have doubt.

Assume,I perform a quick latest filegroup restore ,bring the database online and then transactions are issued against the partial database. After few days,...

Thanks for clarifying 🙂

Just to add, Primary file group is not busy as it contains only meta data. Few selects and very very rare write activity.