As long as SQL is cleanly shut down and the new drive has the same letter that should work a treat, done it myself a few times as part of...

Bru Medishetty (12/14/2011)

George, will it not fail as the physical database files exist and the rerun job cannot overwrite...

just add another subplan to your existing maintenance backup plan.

use .trn for the extension. You can use whatever you want but .trn is the industry standard.

In the restore sequence just...

nope.

you need to start another restore from the beginning, thats your only option.

you don't actually need to drop the database first

powershell.

anything on the BI side - SSIS, SSRS, SSAS

Kenneth, thanks for the article. couple of points: are you sure the SQL restart is necessary to get this working, and the error you will often see returned with the...

I didn't want to hijack warrens script but since we seem to be going down the route of providing alternatives and this thread could become a good source for people...

do you mean set to manual in the setup program?

Because you dont have to use it.

Jeff, I won't be able to get any sleep till you tell me you have the growth factor of the log file under control.

🙁

windows 2008 by any chance? If so Its the bloody stupid User Access controls, I would disable that feature.

Changing the ownership of the files should be the answer, on the...

that log...

I was first 🙂

Can any one chip in and make this guy feel more at ease, its the old log won't truncate because it thinks its replicating when it isn't issue.

http://www.sqlservercentral.com/Forums/Topic1216970-391-2.aspx?Update=1

nope, its a fairly well known fix for this issue.

using the wizard setting up replication is very simple, only go as far as setting up a publisher and article, keep...