No as I know.

Depends on the migration strategy, SQL Server needs to be stopped and restarted at some checkpoints (before/after data transfer).

Set SQL Server services Start Mode to manual instead of auto during...

command prompt> xcopy foldera folderb /T /E

command prompt> xcopy /? --- for more options

Drop then create again.

drop proc[edure] [owner.]procedure_name

[, [owner.]procedure_name] ...

"Transact-SQL® User’s Guide"

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc32300_1250/html/sqlug/title.htm&toc=/com.sybase.help.ase_12.5/toc.xml

use SQL Server 2005 Best Practices Analyzer tool to get more recommendations.

http://www.microsoft.com/downloads/details.aspx?FamilyId=da0531e4-e94c-4991-82fa-f0e3fbd05e63&displaylang=en

Good input. I was looking for these kinds of information.

Webcast is also a good place to go. http://www.microsoft.com/events/series/technetsqlserver2008.aspx?tab=webcasts

"If SQL Server Agent is currently configured to use the System account, you'll see a dialog box prompting you to configure the agent to use a domain account... "

Yes. For details: http://msdn2.microsoft.com/en-us/library/ms143241.aspx

An early post: http://www.sqlservercentral.com/Forums/Topic272472-291-1.aspx

DBA just needs to bring database online when your SA says go ahead. This means bring SQL services online from cluster administrator tool. Of course, make sure all...

Is this the one? http://www.microsoft.com/learning/syllabi/en-us/2796bfinal.mspx#FindTraining

Go the bottom and select the location. There are quite a few around GTA.

I personally like learningtree.ca, but they do not have enough...

I do not know the version of your BackupExec. Here is a link for your reference.

http://seer.entsupport.symantec.com/docs/285757.htm

"Security and database access"

BackupExec admin guide should have seurity...

Is it supposed to have a tail-log backup immediately after the accident?

Check books online “Performing a Complete Database Restore (Full Recovery Model)”.

Additional thoughts to prevent it happening again:

Why could Navision...

Ask them for the support documentation and service level they provide for support. If no documentation, what kind of product will be?

Do you have your own database/server/application policy, standard...

one more: Cause and Resolution of Replication Errors

http://technet.microsoft.com/en-us/library/ms152467.aspx

Have you figured out yet? Hope this may help.

http://technet.microsoft.com/en-us/library/ms151757.aspx