I was able to remove the ActiveX components and replace them with SQL tasks.  I keep the same...

Check out http://support.microsoft.com/default.aspx?scid=kb;en-us;833045

Check out http://www.sommarskog.se/error-handling-II.html 

The "with recovery" doesn't actually do a restore - it makes the database available for use.  When the database is in stand-by mode, it's read-only and "with recovery" sets it...

Here's what we use for a similar purpose...

 RESTORE DATABASE '<database name>'

 FROM DISK = '<backup name>'

 WITH STANDBY = '<uncommitted transaction file>'

contains the contents of data pages before uncommitted transactions...

In my organization, none of the practicing DBAs (I'm one of them) have any certification, but there are several developers who do have their certification but do not intend to follow...

We accomplish this by transferring full and log backups daily, and restoring them - setting up a "standby" server.  We've setup a dts package that pulls the files from...

Check out - I use it and it works well.

http://www.sqlservercentral.com/scripts/contributions/763.asp

We've also had a lot of problems where mail would suddenly stop working.  Generally, we would use xp_stopmail and then xp_startmail.  Then magically (when talking about SQL mail that...

I do restores on a daily basis. If another user is connected to the database - whether or not they are actively using it, the restore will fail. There's...

We also use Winrar to compress the full backup of 18G database. However, the newer version of PKZip does support compression of files over 4G.

Here is a sample of a trigger used to insert records into another database when the rptflag field is updated. We select the necessary information from inserted and place...

Hi, Ron. Just a quick note to let you know that you can restore SQL 7 backup to a SQL 2K database. We do it daily in our...

Thanks everyone. I've rescripted the restores to use the NORECOVERY and RECOVERY options along with setting the database to read-only once the restores are completed. I was worried...