Checkout this script from Adam Jorgensen to do a more manual version rather than the GUI version as the standard edition doesn't support it.

http://www.sqlservercentral.com/scripts/Replication/31544/%5B/url%5D

There are other scripts out there on...

Does your SMTP gateway have security enabled that would limit the IP's that would be able to connect and send mail?

Here's a pretty good Microsoft article as regards how to implement http://support.microsoft.com/kb/314515

Forgot to ask if you were running the Enterprise Edition of SQL 2000.

Have you considered log shipping?

It will put you easily within the window.

Match the logins and sids on the new machine.

Backup your existing databases.

Restore on the far side with no recovery.

Setup...

I'm not sure about the media family error, but you can restore SQL 7.0 to SQL 2005.

I wouldn't even have IIS, FTP, HTTP SMTP installed.

Not having them there doesn't impact anything, unless you need to host an ftp site, run a website or have your server...

Let's say you have a backup of DB_NotGood at e:\db_notgood.bak.

If you perform a select name, filename from DB_NotGood.dbo.sysfiles it shows

name filename

NotGood_Data d:\mssqlotgood.mdf

NotGood_Log d:\mssqlotgood.ldf

...

SAN SNAP is amazing.

Behind the scenes there is a mirror of the data sitting on disk that is synchronized with the disk (EMC used to call it a BCV, others...

If disk caching is enabled within the OS it is possible that data is not flushed from the cache down to the disk prior to it going offline. SQL believes...

Not sure if this is best practice or not, but I usually put that resource on the same cluster group as the quorum and have them share the same drive....

Looks like your MSDTC is going offline it shows a physical disk failure.

Where does that resource live?

Is this a majority node set cluster? Or a regular failover cluster, with a quorum drive?

SQL Error 5125 not good

File '%ls' appears to have been truncated by the operating system. Expected size is %I64d KB but actual size is %I64d KB.

Any way you could attach a screencap of the cluster group and the resource information? Or even just copy the pertinent details?

Or do you mean flat file as in just the files?

You could stop SQL Server, then copy the mdf, ndf, ldf files, or detach the databases and then reattach afterwards,...