onlo (11/10/2008)

---

Do I need to keep the initial backup copy of the Primary database all the time ? Or it can be deleted once the log shipping has been started...

EdVassie (11/10/2008)

---

There is no performance or data integrity gain to be made if the databases are moved, so leave them in their default locations.

A lot of installations make extensive use...

if the monitor server is doing only that - monitoring log shipping , then it uses very little resources and could sit on a very low spec machine.

log shipping itself...

if you want to use profiler to identify the code within a stored proc running slowly you will need to trace event SP:stmtcompleted under stored procedures as well

its certainly a good idea to have a database for your own use to store your code in and any data you might use as a part of your day...

yep, I was right, run setup and it will prompt you to upgrade. them sp_dropserver and sp_addserver.

see http://www.delphifaq.com/faq/databases/mssql/f579.shtml

what did we do before the internet? 🙂

Its been a long time but I seem to remember if you change the server name with SQL V7 you have to run setup again and then update the...

resource database needs to be where master database is or upgrades will fail.

do not bother to sperate system databases data and log files there is no point, they are not...

I'd definitely go with log shipping as well. Its a more recognized high availability solution. I see replication as more for scale-out, where you want data distributed and available in...

Ouch! a 13 point hit on my QOD average. that will teach me to to be tempted to answer questions on overblown american traditions.

you hang stockings on your mantle for...

I'd leave them all on the D drive, simplest , neatest, and least effort.

Ken Powers (10/30/2008)

---

Do you keep them on the same disk as the operating system and program files, or do you keep them somewhere else?

In a perfect world, separated. Certainly separate...

Ken,

I think Ed was saying keep master and resources in ORIGINAL location, not necessarily DEFAULT location. During the install if you go into advanced options, you...

use a cursor (there I said it) or a loop to trawl through you biggest table one row at a time, updating something, If thats not slow enough on its...

I am surprised at how often I see threads where SQL has been installed and then the system databases moved immediately afterwards, why not get the install to place...