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...

Rambler (10/29/2010)

---

Hi. I have a table that has a column which contains names of all databases on the server.

How can I find out transaction log name for every database in...

There are loads of threads on how to do this, if you'd care to search for them. You need to do something like this (not tested):

WITH MyWords AS (

SELECT

ROW_NUMBER()...

Doug

Please supply table DDL and sample data, and then we will be able to provide a tested solution.

Thanks

John

Why not just do it like this:

SELECT * FROM employees

WHERE emp_city = @city

AND emp_department = @department

AND emp_name = @name

I recommend that you read this:

http://www.sommarskog.se/dynamic_sql.html

John