Glad it worked out.

SQLDTS.com has lots of info about DTS packages. I would start there.

http://www.sqldts.com/204.aspx

You can use DTSBackup from the site also to convert packages to structured storage files.

http://www.sqldts.com/242.aspx

Create a job on your main SQL 2005 server with an Operating system(cmdExec) job step and use SQLCMD. For example:

SQLCMD -E -S SERVER\SQLEXPRESS -Q"BACKUP DATABASE <dbname> TO DISK = 'C:\dbname.bak'"

Dan Guzman - Not the MVP (8/20/2010)

---

So....

Why not just fail over to the secondary full time, so that you can upgrade the primary offline. If all goes well, fail...

That should work as long as the transaction log on the principal is large enough to hold all the transactions during the upgrade.

You could do a backup and restore from the physical to the virtual machine or you can do a detach and attach. Either way should work fine. I prefer backup...

You need to add trace flag 845 as a startup trace flag in order to use lock pages in memory for SQL 2005 Standard.

Yes, the secondary database's index in...

Dan Guzman - Not the MVP (8/19/2010)

---

So, this example is only intended for fail implementations? You plan on reverting back to mirroring when the implementation is complete?

Or, did you...

The reason for disabling the restore transaction log job on the secondary was given in the 3rd paragraph of the article.

"Once we convert the mirrored database to a log shipped...

You may have to delete the mirroring endpoint as well if there are no databases mirrored. There are various other internal tasks to SQL Server that use Service Broker also....

Is it possible that SQL was not setup on the default port of 1433? In that case, you would need to connect using <SERVERNAME>,<PORT#>

Is it a named instance? Connect using...

Have you tried running sp_removedbreplication on database "B" once it was restored to server "B"?

http://msdn.microsoft.com/en-us/library/ms188734.aspx

I haven't had any issue connection to SQL 2008 R2 using SSMS 2005 or 2008. However, the 2008 features are not available when using SSMS 2005 to connect.

Why not install...

Enable filestream, remove the filestream file from the database files, remove the filestream filegroup, and disable filestream again. That should solve your issue.