No need to set auto-shrink. As Ray Mond says, it can cause more harm than good.

If you backup your Transaction Logs frequently enough that is typically adequate to stave off...

What error are you getting?

In SQL 2005 you can backup to a network location. You just have to make sure that the account running the SQL Server Agent has the appropriate level of rights...

Out databases use a ton of Clustered Indices. It would be really handy to exclude the Indexes in favor of just holding onto the code that creates the Indices to...

Not quite enough to go on here. In 2005 maintenance plans, you have to...

All of the stuff everyone else has posted is spot on, but I've never gotten it to work to my satisfaction. Here's what I do.

1) Take a full backup of...

So the directory is perceived as invalid.

If you use the IP address of the server, that would be independent of DNS.

Some things to try, RDP to a Server as the...

Hmm, this is a head scratcher to say the least.

Okay, so now I have to stop outside the box and look at this again.

So the message says that the account...

Jason,

I'm a nervous nelly when it comes to database backups. You are right, only the last file is really necessary to backup to Tivoli, but what happens if the file...

For kicks and grins (a.k.a. troubleshooting purposes) try adding that file server to the hosts file and see if that works. If it does, then perhaps SQL Server is misinterpreting...

When you setup the alias name was that done in DNS so that everyone would be able to find this file server as the alias or was this only completed...

The only time I have seen an error message like this, that is one with an IP Address in the file path, is when the backup media was a NAS....

Gail is right. It's really difficult to know what to do if the source of the file is unknown. :w00t:

Since it is a *.dat file, it's not likely to be...

Here is what I do

1) Open SQL Profiler

2) Determine the counters that you need

**In my case I usually start with a blank template and add...

If you are restoring it to a different Server, then I would expect the replication to be dropped.

Is there replication setup on the Server where Sales runs the reports from?...