you cannot load balance with mirroring.

We have a load balanced sharepoint farm here and each site has its own set of sharepoint databases.

how about setting up a SQLAgent alert?

If there is a failed login attempt that will write an error 18456 to the errorlog, you could alert on that and get it...

by default database are usually set to autogrow anyway. you may want to check this setting and confirm the growth factors are something sensible (50 - 100Mb usually good but...

being clustered certainly makes it more 'interesting'

the work I have done in this area was not on a cluster unfortunately. I can foresee problems with IP addresses, other than that...

yes I would say it is workable as a one off task, but the SQL installation would need to be identical.

If this is your DR process, when you do...

do you mean the \data directory, i.e the system databases? I see no point in copying anything else over, the install will put the rest in place for you.

Can you...

george sibbald (1/14/2010)

---

the replace option is there as a safety check to stop you accidently overwriting databases that don't fulfill these criteria. Only use replace if you are sure you...

If the databases name are the same, logical file names are the same and file locations are the same, SQL will presume the backup is for this database and allow...

backing up a database has no effect on performance. If you don't need frequent backups don't waste resources backing it up.

Just make sure you have got one you can...

check if the values match what?

Currently you are never populating @dbname,also specifying it as nvarchar(max) seems overkill, have you got database names that long?

This is an example where a...

r.pe (1/13/2010)

---

The old server I am moving away from has a default server collation of SQL_Latin1_General_CP1_CI_AS. I'm installing a x64 Enterprise flavor on this new hardware and the closest thing...

This blog would suggest qoutes have the potential to be misinterpreted and lead to errors:

http://msmvps.com/blogs/robfarley/archive/2009/12/29/apostrophes-around-column-aliases.aspx

At this point identify the exact query which consumes this CPU (if say you only have a stored proc execution at the moment). Check the health (ie fragmentation levels) of...

yes its cumulative. The last_batch time is also of interest as this is when the current process executing kicked off.

I thought installs were meant to be getting simpler!

🙂