We used to use Litespeed for back up and restore. But when our Main DB (Server) passed away, we could not use the old license. We had to take new...

It can still work even if you have network problems. Just like some of the FTP software works, even when the net gets busy or gets disconnected, when it connects...

If you were able to restore after copying the files, then you can forget about the issue I stated. Hidden files can be viewed using the option in Explorer to...

Error points to Not enough Disk space. Is there by any chance your page file set up there? Since it is a hidden file, you might not see it and...

You can use SQLCMD to do that.

As per BOL

Many sqlcmd options can be controlled in a script by using the setvar command. In the following example, the script test.sql...

Which version are you using? SQL 2000 or SQL 2005?

If 2005, in the publication wizard, when it reaches the snapshot agent section, make sure you have both the Create Snapshot...

Thanks Noel. I will be doing the Restart late night tonight.

About the memory leak, it was actually one stupid Stored Proc that had no SET NOCOUNT ON. (I missed...

He insulted all of you.... :hehe:

I am not a top poster... So I must be a good guy in his books....:P

That makes me Happy...Yippieeeee!!!!

Yes, it can be set up with out Sanpshot. You just have to know for sure that the data is in Synch. When you set up the replication, there is...

I was planning to do it tomorrow morning. I usually dont do anything on the server in the evening time. Always in the morning. I will post how it went...

DBBC FREEPROCCACHE will clear the Query plans. But not the Buffer cache. I am thinking more like DBCC DROPCLEANBUFFERS. This will clean out the buffers. I think it is the...

That has already been added. Thats the first thing I id. But by that time, the Damage had already been done. Now I need to get out of that position.

Add me to the list of Curious.

"Curiosity killed the cat" they say..:)

Look up Transaction log back up and warm stand by and see if that will suit your purpose.

Like the previous person stated, this is not going to Mitigate your problem. Even if you are going to set up replication, You will have to set up the...