Thanks you OPC.Three and Paul Ross.

Thanks for all the responses.

Question1 - Why is this so difficult or cumbersome to do using the operating system? I think this is a common task that is required by...

Thanks Perry. I have another question related to adding the SP for the SQL Server 2008 R2 Client Tools.

For SQL Server 2008 R2 SP 1, I have found the following...

One database is 12 GBs...

Nicholas Cain (6/4/2012)

---

You need to be aware that running a restore verifyonly does not actually confirm you have a good backup, you can only do that with a full database...

Lynn,

Sorry for misrepresenting your name. My mistake. Thanks for your support. And I hope these examples work the same for you and they did me. It appears if the test...

Lynn Pettis (3/19/2012)

---

If the production database, MyDB, resides in F:\SQLData on the production server and you restore the backup of this database to a test server without using the MOVE...

Thanks for the responses. I still do not think I need the MOVE option for what I am trying to verify. Please read below to see if I am correct.

Steve,...

SSCOACH<

I have two servers a test and production server. The backup was taken on the production server. The backup is being restored on the test server. (I really don't think...

SSCOACH,

"You will need to use both the MOVE and REPLACE if you want the database files in the same location on the test server. "

My concern is I do not...

Thanks SSCrazy. BTW, can this type of script be ran/scheduled using a Job Step within a SQL Server Job? For example, ActiveX Script, CmdExec, Transact-SQL, etc. How would I set...

Thanks for the article and the suggestions to remove the truncate log and shrink log commands. I have more information which should make the DB Maintenance and Backup Tasks simplier....

Thanks SSCarpal.

I understand the DBCC REINDEX is causing the log growth but I thought the "BACKUP LOG TestDB WITH TRUNCATE_ONLY;" and "DBCC SHRINKFILE (TestDB_log, 50);" commands would reduce the size...

Thanks for the response.

FYI, I not doing this on a production server. I am just curious if it would work or work the same as a true Detach/Copy/Attach or backup/restore?

Thanks...

Ravikanth, what are you talking about bringing offline/online? I just want to stop/start the sql services for a particular Named Intance without affecting other Instances. The network group does not...