Multiple SQL servers

Is there a way to have sql on 2 servers and have the info on server A get
copied to server B automatically say once a day?
also I would like to have the website automatically connect to server B if
it finds a problem with server A.
CheersKris,
Yes to both.You need to do a research on the below topics:
#1.Replication
#2.Failover Clustering
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Kris" <kris@.NOSPAMplanetsilicon.co.uk> wrote in message
news:c8e4pd$a78$1@.sparta.btinternet.com...
> Is there a way to have sql on 2 servers and have the info on server A get
> copied to server B automatically say once a day?
> also I would like to have the website automatically connect to server B if
> it finds a problem with server A.
> Cheers
>|||I would look into replication and failover clustering.
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Kris" <kris@.NOSPAMplanetsilicon.co.uk> wrote in message
news:c8e4pd$a78$1@.sparta.btinternet.com...
> Is there a way to have sql on 2 servers and have the info on server A get
> copied to server B automatically say once a day?
> also I would like to have the website automatically connect to server B if
> it finds a problem with server A.
> Cheers
>|||> Is there a way to have sql on 2 servers and have the info on server A get
> copied to server B automatically say once a day?
To add to the other responses, you can use log shipping or simple
backup/restore to copy a database between servers.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Kris" <kris@.NOSPAMplanetsilicon.co.uk> wrote in message
news:c8e4pd$a78$1@.sparta.btinternet.com...
> Is there a way to have sql on 2 servers and have the info on server A get
> copied to server B automatically say once a day?
> also I would like to have the website automatically connect to server B if
> it finds a problem with server A.
> Cheers
>