What do you mean?

Database can be restored using copy-only full and copy-only...

It is very hard to remember all the error codes. If you paste or upload the errors, it would be much easier and helpful.

Refer @

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/4265278f-8d0e-4cf3-87db-ed9b037e6cc3/error-14258-cannot-perform-this-operation-while-sqlserveragent-is-starting-try-again-later

I think similar...

Not able to understand! your question is ambiguity.

No! Non-clustered indexes will use only the clustered index keys. Unless otherwise explicitly you created the non-clustered index on the new filegroup, it won't be created there. Non-clustered indexes will...

Very well described! Thank you.

Yes - I mean Virtual memory only! On a thinking that Microsoft recommends to keep the page file from 1.5 to 2 times of physical memory(in my case it is...

Hi - As Gail stated, it is very difficult to say which is the culprit, without completely knowing your system.

Few things that can be checked - total physical memory, RAID...

I hope you mean - if there is any difference in the transaction log file, for the DB on which replication has NOT been configured, and for the one on...

rajeshn29.dba (7/20/2013)

---

Hi All

1.In mirroring If I add data file in primary server will it reflect in mirror server or not?

If yes can you pls explain me?

2.In transactional replication if we...

What is that SP all about?

Run dbcc sqlperf(logspace) to find out the log file usage of dbs

Refer the Errorlog (xp_readerrorlog) to find the error logged.

LS can be configured in two ways (i) No-recovery mode (No one can access the database)

(ii) Standby/ Readonly mode (Users will be able to access the database - main purpose...

Wah! Thank you Simon, John and Andrew.

Sorry - Update statistics is not required for Index Rebuild, automatically it will be updated. Please refer the below link. I have pasted the specific content below:

http://msdn.microsoft.com/en-us/library/ms190397.aspx

After Maintenance...

sp_helpindex <objectname> will help you

Hi - You can use Resource Governor. But I would recommend to find why cpu usage is high during backup rather than solving it temporarily/ restricting it to certain percentage...