Adding N only matters if you are going to have a unicode character in the string, such as a Chinese character. For the example you posted, you can safely...

Not specifically related to upgrading from 2000 to 2008, but great information about upgrading to 2008: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138230

Can't you instead setup a job on DB1 that searches for job failures on DB2 and then sends an email when it finds one?

Try this: http://www.mssqltips.com/tip.asp?tip=1395

Or these: http://www.google.com/search?hl=en&rlz=1C1GPMD_enUS313US313&q=ssis+import+data+dynamic+file+name&aq=f&aqi=&aql=&oq=&gs_rfai=

Mirroring only handles DML changes to the data. If the external application that was called from xp_cmdshell modifies any data, then that data is mirrored. All data changes...

bsegermeister, the process hasn't changed in Windows 2008 except we now use Failover Cluster Management instead of Cluster Administrator. Locate your cluster group in there after adding the cluster...

You should import your data into a staging table, and then move your data from the staging table to your actual table via T-SQL. With T-SQL, we can easily...

Here's what I've used in the past to move the logins between 2000 and 2005 (should work fine for 2008 too): http://www.windowsitpro.com/article/query-analyser/sql-server-login-transfer.aspx

And in case this helps someone else...

Your question is not clear.

Yes you can install the database engine as a non-clustered component. But it means it can't failover to the other node. I don't understand...

Yes that is true, but the OP is mentioning transaction log backups every 15 minutes so that's why we are focusing on that strategy.

Krishna Potlakayala (4/7/2009)

Incorporating differential backups into the plan...

Grinja (4/8/2009)

Out of interest sake, how do you go about verifying your backups?

I typically restore a backup and do a DBCC CHECKDB. My...