definitely, definitely backup the RS encryption Key

read this article about DR for SSRS

http://support.microsoft.com/kb/842425

personally I am not aware of such a tool and it sounds too removed from how SQL works for there to be one.

Various HA methods can give extra protection (log...

SQL does not guarantee rows are held in the same physical order as they were entered, so you would have to use an order by clause with an identity value.

The SQL transaction log is a sequential write log so no duplexing.

Best way to protect it is to back it up frequently and store on a raided drive to give...

this is usually done by tracking the size of the backup file over time. There are a number of scripts for this on this site alone.

an example

--see growth from backup...

If you ever find a magic wand let me know 😉

Main gotcha with SQLio is making sure the file sizes are large enough so it is not all done in...

Rob L-566658 (2/1/2010)

---

The information was collated, our test server was then aligned and the tests were run again - the difference was not showing as 20-30% gain :ermm: I did...

then you should be able to use alter database set partner failover. What error did you get?

It must be run from the principal and you must be in master when...

To those of you confused the OP edited his post after my request for something more specific.

thanks OP.

expect an entry from me next year!

then I can put on my CV 'nominated for exceptional DBA of the year'

🙂 😛 😉

GilaMonster (1/30/2010)

---

I can't speak about the 2008 one (which...

to help you we need a question to answer please.

Agreed, sp_helprevlogin has got to be one of the most useful scripts in a DBAs armoury, and the best way to migrate logins.

I wouldn't leave home without it.

🙂

was this a move to a SQL 2005 instance from a 2000 instance?

this might help

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

looks like asynchronous mirroring will also hold up replication when mirror is down, because it needs to hold onto the transactions to apply them to the mirror when...