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.

Rajesh kasturi (2/24/2009)

---

DTS Migration:

By migrating the system databases you can't get the DTS packages in 2005, because 2005 you have SSIS.

Here you have to redesign complex DTS packages like...

GilaMonster (2/24/2009)

---

There's no...

Greg Charles (2/18/2009)

---

You either have to open each package in Enterprise Manager and save it to a file or use DTSBackup2000, a free download available from SQLDTS.com http://www.sqldts.com/242.aspx. The...