Backup and Restore

You need to decide how you want users to connect and check how your server is setup.  Change auth mode of SQL Server to "Mixed Mode"

This battle is going to continue.  I manage two Qmail servers and I tell you keeping it up to date with the latest spam filter software as well as making...

Its probably best you script everything out before hand and then just run them during your maintaince window.  I did a similar migration a couple of years ago with a...

Do you have more than one instance running on the server? If yes - make sure you are enabling TCP/IP for the right instance

Also Try -   In Server Network Utility...

http://vyaskn.tripod.com/iq.htm

Yes - that is correct.  You need to talk to your network guys and add another domain controler in the mix. 

 I am suprised SQL 2005 did not have any issues. ...

First of all make sure all protocals are enabled in SQL Server 2005.

Then see if you can telnet from the remote server to the DB server using ports 1433/1434.  Try...

This will only return data if any jobs failed

HTH,

You are correct - if the DB was not shutdown cleanly - it will not work.  I guess the only way is:

1. Rename database.mdf to old_database.mdf

2. Create New Database...

In QA - for the current DB execute:

sp_helprolemember

it will give you information for all members and their roles in the current DB

See BOL for sp_attach_single_file_db

Also See if you can detach the DB and then try and attach but do not specify trans log when you attach it just specify the mdf and the...

Go to the object in EM and right click on it and see properties and then permissions - you should be able to view it there

I hate using SQL Mail on Prod DB servers - I use Wsendmail or Blat from a remote machine to accomplish most of these tasks

Correct - you have to have Windows Adv server/SQL ENT to be able to use Mem above 2GB.