Yes. Try backing up to a local drive. If that works then you know your problem is with the network - permissions, communication, whatever. Check that the...

Pat

TRY...CATCH isn't available in SQL Server 2000.

John

In your sample results, the price is the same where the hotel is the same. But you can still group by the hotel name to show the minimum price...

It's because you've got more than one ResultID for each hotel. Does it matter which one you display? You can use GROUP BY and show the mininum or...

If you know that in a year's time your database is going to have grown by 100GB, then you may as well set the size to 120GB now. Keep...

Are you attempting to back up to a CD/DVD writer, by any chance?

John

Puneet

I've never seen that error before. If you have a support agreement with Quest, use it - you're paying for it, after all! Just e-mail support@quest.com.

John

This is true, but it gives more flexibilty if you create a...

Is there any reason for that? As I said before, I would recommend that you back up to a new file each time. That way, if any file...

mcavimal-736871 (11/9/2010)

---

hi John,

i am taking the Backup through maintance plan

and i always got the error as i maintion abobe ....

i also chage the owner of the job sa, not working...

You can't, unless you create a linked server...

The first thing to do is to set up a linked server object on one server, pointing at the other. The next thing to do is loop through all...

giles.clapham (11/9/2010)

---

Hi Paul,

I appreciate your comments and advice but just to clarify, and I'm open to being educated on this, my DBs are in Simple recovery they get backed up...

It's best to make each new backup to a new backup device (file). That way, you won't have contention for the use of that file. You say you're...

Rahul

I think the easiest way for you to do this is to use a third party tool such as Red Gate's SQL Compare. (I don't have any interest in...