One problem I had with BackupExec is the limited functionality when doing restores. For instance, I had a large production database, with several data files. For example Data1.mdf on the...

I use this to show me when the last Full, Diff & Log backups were (or weren't):

SELECT B.name as Database_Name,

ISNULL(STR(ABS(DATEDIFF(day, GetDate(),MAX(backup_finish_date)))), 'NEVER') as DaysSinceLastBackup,

ISNULL(Convert(char(19), MAX(backup_finish_date), 100), 'NEVER') as...

I searched the Googles and found this:

http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=60&threadid=42175&enterthread=y

Such as recovering databases when there are no backups.

You don't need any special tools if you have good backup procedures in place. If you have a Full backup, and if your database is in FULL RECOVERY mode, and...

I think that did it, thanks. I had put a double quote in their twice, but should have put just one.

The Administrator needs to add a Windows account (preferable) or SQL account and give it permissions, as Florian mentioned.

Make a DNS entry to route all traffic from your old server to your new server. Then if you miss changing anything, it will still work. You can fix connections...

maybe Upgrade Advisor tool would have caught that ? Not sure

There's nothing in the BOL index for dm_*. Any idea why not ? The MSDN website has info though:

http://msdn.microsoft.com/en-us/library/ms188754(SQL.90).aspx

Adiga (3/1/2009)

---

I think this snip should help you.

SELECT A.NAME,B.TOTAL_ELAPSED_TIME/60000 AS [Running Time],

B.ESTIMATED_COMPLETION_TIME/60000 AS [Remaining],

B.PERCENT_COMPLETE as [%],(SELECT TEXT FROM sys.dm_exec_sql_text(B.SQL_HANDLE))AS COMMAND FROM

MASTER..SYSDATABASES A, sys.dm_exec_requests B

WHERE A.DBID=B.DATABASE_ID AND B.COMMAND LIKE '%RESTORE%'...

I wish I could .... I'd know a lot more...

Maybe someone backed up with a third party...

I did an "in place" upgrade in place at my previous job and it was very easy. Now I'm doing "side-by_side" because we're moving to new hardware at the same...

You can script the job in 2000, then paste & run the script in 2005.