Interesting article

I have RedGate Toolbelt, but sucks that SQL Backup is PER SERVER license so I don't have it installed on any server instance yet to try this technique

Any reason why you didn't choose "Log Shipping"?

1. It has easy UI feature in SQL Server as well (right-click, Log shipping)

2. It provides Log backup at set intervals (say 15...

I agree, those tasks should not be lumped together (despite that you see them on the same dialog window quite often)

You should separate into

Backup Maintenance - backup, clean old backup,...

thank you, Merry X'mas indeed

That was not obvious to me

object = An explorer to view and manage SQL Server 2005 server objects. ha ha

It was FUN!! but I want the answers too, missing 2 last words @@

or they skipped my mind for now.

•••••T

Across, 6 letters.

An explorer to view and manage SQL Server...

I wish I read this before doing the QotD, which implied I got it wrong

1st post here, woo hoo!

SQL Books Online (Sep 2007)

Moving User Databases

Quick 5 step quick solution. Moving the file is probably the longest step

1. Run the following...

Thanks for the replies first...though they don't quite answer my questions yet...

1. I can run remote stored procedure fine and obtain the results from local computer. However, my question is...