Forgot about that, always catches me out, something so simple

your not confusing the default mail profile in the actual database mail configuration page for the mail profile sql agent is using are you?

in excel you can give it a connection which connects to sql and runs a query, this can be saved and refreshed with up to date data as and when...

there is no best way to fail back as they are both the same in essence

either setup logshipping again and then fail over again, then setup logshipping again

or

backup secondary, restore...

you need to look further back, find out why the full text catalogs went offline

yep i got that too

you could take a look at ssis, to export data overnight from SQL to excel files, or use excel and embed a query into the spreadsheet so it can be...

rocky (2/23/2012)

---

In looking at results from 'select * from msdb.dbo.sysmail_account' I do see the display name for another count is what's showing in the FROM: of the notification email. ...

you would want to bring the DB's online so you will have to issue a command to each DB with the WITH RECOVERY statement and then resolve any issues with...

are you extracting the data from DB1 to DB2? or just out into a report direct from the base tables?

also take a look at sp_msforeachtable

e.g

sp_msforeachtable 'exec sp_spaceused [?]'

that link is good tells you the cause and how to work around it

you need to read the error log, either the SQL error log or the windows error log...

take a look for the performance dashboard reports for SQL 2005

also on a side note, this is the 2008 section, you will get the...

full text catalogs are not tables, they are usually stored on their own filegroup

so as the error states take a look through your error log to find when the filegroups...

what information do you want, how big a table is in terms of its storage?

there are the reports at db level which gives that kind of information

right click a DB,...