Also instead of DBREINDEX try INDEXDEFRAG and do it more often and may fit you needs betetr. Otherwise you will need to swap to a simple recovery model and stop...

Also if you want it based n 90 days old you may want to use CONVERT(CHAR,GETDATE(),101) to base it on the midnight value otherwise > 90 will be based on...

Quick way as long as you have capcity for the files is to do

EXEC sp_MSForEachDB '

BACKUP DATABASE

TO DISK = ''D:\Backups\?Full.bak'' --Set you drive and path here.

WITH

INIT,

NAME...

Well, I did get a chance to look at alternate ways of getting the same type of results with the query you gave and found no improvement that I can...

Unfortunately due to the fact SET SHOWPLAN_ALL is required to execute in it's own batch it effectively prevents doing this. However if you are not wanting to write a seperate...

Do you have type of field that would stamp a new date or as robert suggestions you can flag on the Oracle side to let you know the data has...

I know you stated you logged in with SQL Agent account and can see the files, but did you run the package to see what was happening. Also, make sure...

I believe this is the KB Article Allen is referring to

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q304101

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

One way to get the screen message from ISQL is to > to a text file.

Ex.

isql -S local -E -Q "DBCC SHOWCONTIG..." > c:\SHOWCONTIGFORDB.txt

on in the case of SHOWCONTIG use...

Same thing here I recently had to drop 150000 rows in 4 different tables and that is when the queries with the NOLOCK hint got this error. Either you will...

No if you set truncate on checkpoint on it will not be able to make backups. Have you done any bcp or other bulk type transactions on this database? If...

If this is happening on all the I am betting on name resolution which you can fix normally by adding the alias and IP address to the client network utility....

Which database? And is it set to truncate log on checkpoint.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

I have not seen any benchmark on this and you might want to see if the company you are looking at has anything specific (probably will try to get you...

Acutally I just got this the other day and previously to that. The best way to find out exactly what it is barking about is to look in Windows Event...