Question about Log Shipping: Secondary non-writable?

Hi, i think i'm just getting confused with all the reading. I have 2
servers, A is live and B is doing nothing. I want to create some kind
of warm standby so I looked at replication and log shipping. Repl
seems to be kinda messy so i think i will go with log shipping.
Database is around 2gigs and i can live with an interval of around
1/hr log ship.
Now my question is i read somewhere it says the databse on the second
server is read only...non writable? So what happens if i need to
failover and make the secondary server live? Is it then only readable
but unwritable? What good is that? Any ideas?>...or i just got it
wrong?The secondary is unwriteable as long as you are shipping logs. Once you
take it live, it becomes he 'real' database server and starts servicing
requests. Note that I am answering your questions on a conceptual level, if
you want the technical details of HOW that happens, that is for a follow-up
question.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"slycat" <slycat@.consultant.com> wrote in message
news:dec83278.0411091807.15bb247a@.posting.google.com...
> Hi, i think i'm just getting confused with all the reading. I have 2
> servers, A is live and B is doing nothing. I want to create some kind
> of warm standby so I looked at replication and log shipping. Repl
> seems to be kinda messy so i think i will go with log shipping.
> Database is around 2gigs and i can live with an interval of around
> 1/hr log ship.
> Now my question is i read somewhere it says the databse on the second
> server is read only...non writable? So what happens if i need to
> failover and make the secondary server live? Is it then only readable
> but unwritable? What good is that? Any ideas?>...or i just got it
> wrong?|||There is a great section in SQL Books on Line which describes in detail, how
to make a secondary database primary... including how to get the logins to
match... Search for Log shipping ...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"slycat" <slycat@.consultant.com> wrote in message
news:dec83278.0411091807.15bb247a@.posting.google.com...
> Hi, i think i'm just getting confused with all the reading. I have 2
> servers, A is live and B is doing nothing. I want to create some kind
> of warm standby so I looked at replication and log shipping. Repl
> seems to be kinda messy so i think i will go with log shipping.
> Database is around 2gigs and i can live with an interval of around
> 1/hr log ship.
> Now my question is i read somewhere it says the databse on the second
> server is read only...non writable? So what happens if i need to
> failover and make the secondary server live? Is it then only readable
> but unwritable? What good is that? Any ideas?>...or i just got it
> wrong?|||Log Shipping in SQL Server 2000, Part 1
http://www.winnetmag.com/Article/Ar...3056/23056.html
Log Shipping in SQL Server 2000, Part 2
http://www.winnetmag.com/Article/Ar...3230/23230.html
/Sukhdev