Here's another:

SELECT substring(o.name,1,50) as 'Table Name',

ddps.row_count , used_page_count, (used_page_count * 8)/1024 as Mbytes--, *

FROM sys.indexes AS i

INNER JOIN sys.objects AS o ON i.OBJECT_ID = o.OBJECT_ID

INNER JOIN...

I have used Redgate & Idera and have been happy with both.

One problem I see with asking in a forum is that we may have experience with a product, but...

Perry Whittle (10/8/2011)

---

homebrew01 (9/8/2011)

---

I liked Idera's tool at my previous job, but now use Redgate backup which is ok too.

Most tools offer a free trial so you can try them...

Is there an advantage ? Gail's seems easier to read, and I think hers could be restarted where it left...

Can you use the "Import Data" wizard, then save it as an SSIS package at the end of the process ?

Thanks, I'll try that next time. I already gave up and created a new one from scratch.

deleted reply

Did you mean to post in an old, unrelated thread, rather than make a new thread about your question ?

Sorry, I don't know much about clustering.

Can you go straight to SP3 or SP4 while you're at it ? SP2 is old & buggy too.

I prefer to have individual files for evey backup event. It creates lots of files, but is easy to see what happened & when.

Curse you Ninja !!:-P

Duplicate thread.

Looks like Gail already answered this for you here:

http://www.sqlservercentral.com/Forums/Topic1173742-357-1.aspx

Edit, beaten by a few seconds :hehe:

Backing up a server is different than backup up SQL databases.

Also, if these are production databases, you...

SP2 is old. SPs are cumulative. I suggest going directly to SP4, or SP3 at the minimum.