The Witness server is required in High availability mode and you cannot change the witness server to become the principal or mirror server. The Witness server forms a quorum with...

You can make use of Database Publishing wizard to perform the same. There is an article about this which might benefit you,

http://sql-articles.com/index.php?page=articles/migrating_2005_2000.html

Check these links it also indicates regarding the order of maintenance tasks

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2744477&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2742440&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2736186&SiteID=1

- Deepak

Pravin,

All the required information is available in the link i gave above...you have the following topics listed in the link I provided...

Pravin, your scenario can be accomplished by log shipping in SQL 2000 and SQL 2005. You can refer these links for more info,

http://sql-articles.com/articles/lship/lship.htm

Neil,

Pls check if the Sql service account in secondary server has sufficient permissions to the shared folder in which the log backup is being copied...

[font="Verdana"]In high protection or high performance mode if the principal server is down then your mirror db will be in restoring state. Now inorder to make the mirror db as...

While performing Detach\Attach operation the default db's for your logins might get misplaced, so pls take a list of default dbs before detaching the dbs and compare it after attaching...

You don't need a log file. Just mention the data file and try. Refer,

http://msdn2.microsoft.com/en-us/library/aa259610(SQL.80).aspx

if you have multiple data files then this procedure will not work.

I think you can make use of sp_attach_single_file_db. It attaches a database that has only one data file to the current server. sp_attach_single_file_db cannot be used with multiple data files.

Pls...

Ensure that the mentioned port is not blocked by Firewall also if possible create an endpoint using different port number. Pls refer the below link,

http://msdn2.microsoft.com/en-us/library/aa337361.aspx

http://sql-articles.com/articles/cng-dbmrr.htm

As Adam said pls chek the version of the sql server in which you are restoring the database once again. You can make use of Select @@version.

Pls refer this thread...

[font="Verdana"]Hi,

You cannot upgrade from SQL server express edition to sql server evaluation edition ! pls refer the below link for the list of upgrades supported !

Can you pls check this link and see if it is helpful ?

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=203340&SiteID=1

Regards

Deepak

Try as specified in the below link and revert,

http://sql-articles.com/articles/HA/suspectdb.htm