Have you read this article?

When you establish a distributor it automatically creates a distribution clean up job on the distributor to remove old data from the distribution database. That job is your friend. :)...

david_wendelken (12/3/2010)

---

I can get the DPM files across the wire (I already am, actually).

But that doesn't turn it automagically into a database that is ready to go as soon as...

Excellent! I'll be looking forward to the resolution.

Boy - chat would be nice right about now. 🙂

What was the error that you received? Let me know.

Sorry this is taking so long.

So I am assuming if you just try connecting to the server using the following that OSQL will not work?

D:\MSSQL\Binn>osql -SYourServer -E

If it does, can you run a query...

Can't you use DPM for this? From what I remember reading about this the amount transferred across the wire should be even smaller than log shipping.

YSLGuru (12/3/2010)

---

D:\MSSQL\Install\osql -E -n-1 -i D:\MSSQL\Install\instmsdb.sql -o C:\MyExecution.txt

I am not an OSQL guru so I may have misused it. Is osql.exe an executable that is picky about where it...

Have you tried moving the files before starting it with the trace flag?

This time of year - Handel's Messiah! Have to love this composition and you can really work with this in the background. I do have to say that I type...

This might be a bit simplistic but you could use the following query to show all databases that have no database backup in the msdb.dbo.backupset table which would then show...

That could be true. I haven't looked at the Apex stuff in a while so I can't really speak intelligently about that. Sorry...

Not sure about Quest or RedGate in this market. I do know that Idera has a solution that I recently reviewed a bit which seems to cover all that you...

You really have two options, and you will have to do some reading and testing. Please make sure that you read the link that I provided that covered replication topology...

mjkreddy1927 (8/25/2010)

---

HI Friends,

I have to move the existing SQL server to new powerfull server,

Can any one let me know the best practices how can i do that.

My existing sever is...