I don't agree with the statement that shrinking a large log file will take much time and you should use backup log <databasename> with no_log.

Log file has a different structure...

here is the link which write the same wording which you have used carolwood.Thanks but pls. share your expierences\ queries rather than the exact copy of sentences for source....

1.yes you can do mirroring with replication . but there are certain points to remember for implementing this pls. read out the below link prior to implement the same.

Hi,

So far as certification is concerned. first you have to make up your mind like for which version of SQL SERVER you want to get certified.

1. SQL SERVER 2000

2....

Hi,

You have created a Table variable which is always tempary in nature all TEmp tables and variables stay in Tempdb database and all are sessional in nature. i mean...

Hi,

So far i could understand your problem . it is related with executed a job using by creating a Database role. You want that the member of that role should...

Yes , this is exactly what i suspected.

See as You mentioned Your Total number of Connections are >3000. But Max worked Threads is set to 400 Only. I would suggest...

Hi ,

It seems like your database became unresponsive at that time because the CPU utilisation % was very low. But After analysing the Error Msg I would need a...