The crux of the problem is that the company hosting the database has sold the client on it. Technically we are at no legal responsibility to do anything or manage...

Hey everyone,

This thread has a long and storied history. I want to add this little tidbit of information.

One of the suggested changes is to disable the TCP Offload in Windows,...

For me, redunancy is important, but you are correct that your recovery is only as good as the backup files available. More copies of the file help to prevent loss,...

Steve,

Let me rephrase my previous post.

By Shared Drive Location, I meant to write backups to not to keep data or transaction logs on. In that case the safer bet is...

MD,

Have you had success with mapping a shared directory on another server?

What we do right now is backup to a local drive, then after the backup completes we run...

The funny part about setting the compatibility mode to 90 is that it completely defeats the purpose of installing 2008!

I found other ways to deal with my issue. I just...

EllieDBA (3/20/2009)

---

I am trying to convince one of our managers for more frequent transact log backups during the day or at night (currently I have a job that does it...

I've seen a large number of enterprises get sucked into these "SQL Agents" thinking that it will really help them out.

As already stated, I've not seen a recovery work...

Mark,

You make a good point. There is more in the MSDB that can assist in determining backups and all that. I also thought about pulling Maintenance Plan information into that...

I tried this on SQL 2005. It is a little crude, but should get you a good start on what you are looking for:

SELECT sysjobs.NAME, sysjobsteps.database_name, sysjobschedules.next_run_date AS "YYYYMMDDD", sysjobschedules.next_run_time...

Enjoyed the article, but like it if you would compare Intellesense to Redgate SQL Prompt.

I've used both and I admit that I am a bit biased when it comes...

Madhav,

If the tape drive is shared you should be able to write the backup to the other Server's device providing the account running the SQL Agent has rights to that...

Okay, I agree that a full database backup will also perform a truncation of the log. I did not intend to indicate that it does not.

The only time I would...

Perry Whittle (1/6/2009)[hr

under simple recovery the transaction log is automatically truncated at backup time. If you're only backing up once a week then that could be your issue. Make regular...

I'm not 100% sure if you are trying to encrypt all of your data or what you are looking for, but there is an encryption option available on the networking...