A look in the options available in maintenance plans will give you a clue.

Core jobs would be backups (full, transaction, perhaps differential)

Integrity checks

Index defragmentation (either rebuilds or reorganise but not...

ta.bu.shi.da.yu (7/3/2009)

---

Swirl80 (6/15/2009)

---

so in an ideal world where your boss came in and said you can any sql server solution (including DR) you want, what would you go for? Load...

I think I would take this from the i/o perspective as that is the usual bottleneck , especially in an OLTP system where concurrency is paramount.

I am not sure what...

Swirl80 (6/17/2009)

---

has anyone on here had any experience of SAN replication?

what i'd like to have is 2 sites, each with its own load balanced (active/active) clustered environment and SAN...

exactly, they increase the chances of getting past the non-technical people who tend to do the initial screening. It ticks one of their boxes.

Niyala (7/2/2009)

---

Hi,

Thanks again. I was wondering if you could give me information or guidelines about how to failover. I have not witness. I have only the principal and the mirror....

sorry no. have you tried BOL - search on 'Setting Up Database Mirroring (Transact-SQL)'

Otherwise it looks like there is a problem with the server name or port.

have you tried the freetext function? that should return any word that contains the word 'red'

select * from addressinfo

where

freetext(address1,N'red')

Its not as precise as contains so you should compare results.

cheers Lynn.

steve jones, editor of this site, maintains the best list I know of. Search for SQL Build List, that should find it.

A cert shows that at least you have been prepared to sit down and put some study time in, which is a good sign you take your career seriously.

without the...

thanks guys for the feedback. If I use hyperbac it would be mostly on SQL 2005 and even some 2000 (all standard edition).

I will of course test this but as...

AlexSQLForums (7/1/2009)

---

rambilla4 (7/1/2009)

---

Can you point me...

else, set up just one via the GUI and then use the script option on the mirroring tab of properties to create the base script for you.

I think you are missing the grant connect statement to the endpoints.