i'd suggest u use standby mode always, u'll be able to use the database of ur secondary server... In norecovery mode, your db wont be available until you put...

pls reply to

http://www.sqlservercentral.com/Forums/Topic639230-24-1.aspx?Update=1

andy.brown (1/19/2009)

---

I suspect I'm screwed but would like to explain this problem in case I've missed something.

Setup is SQL2000, Full recovery model, complete backup every Saturday morning, transaction log backups...

to the distribution database to be more specific.

Gaurav (1/8/2009)

---

1. I created the Publisher at the main server and subscribers on the 3 SQL servers (pull operation). Now when I synchronize for the first time subscriber data gets...

Thank You 🙂

Simple solution. Thanks Barry.

If your partitioned tables exist in different file/filegroup, you may want to take file/filegroup backups containing last 2 years data.

use ISNULL

select isnull(people.last,'') + ',' +isnull(people.first,'') + ', ' + isnull(address.street ,'')+ ', ' + isnull(address.city,'') + ', ' + isnull(address.zipcode,'') as info

Case will not look for succeeding WHEN clauses once any of the WHEN clauses satisfies to true.

you may want to write multiple Case statements with different sequence of WHEN clauses...

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=98337

this link has similar issue reported and suggests restarting the server resolved the issue. can u try that out?

Hard Disk speed - read/write speed on the hard disk (depends on RPM, number of heads, spindles)

CPU speed - your processor's speed (measured in Ghz)

HDD speed matters as you'd do...

you can disable the referential integrity constraints, move all data from other database and then enable the constraint.

You will need to take the tail log backup (if you are able to take) of the primary database, copy this log backup on the secondary database. Restore this log...

You are welcome :).