Check if the below link helps,

http://sql-articles.com/index.php?page=articles/diffdbmrr.htm

For SQL Server 2005 the latest service pack is SP2 and after that there are many cumulative updates available the latest being CU 5, CU 6 will be available this...

They will remain OFFLINE only !

Check this link and see the workaround 2 Step 2 http://sql-articles.com/index.php?page=articles/HA/suspectdb.htm

Do you have sufficient disk space ? if yes then One possible reason could be that you have restricted the growth of your data file. Go to properties of the...

I am not sure if i am right, so anyone pls correct me if am wrong..

Try using begin tran and then execute truncate statement and then commit the transaction using...

As per the below link, you can perform an Inplace Upgrade from SQL Server 2000 EE SP3 or later to SQL Server 2005 EE. In your case it is not...

Pls check the below links,

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

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

There are 2 possibilities namely,

1. The port you specified might have been already used or blocked.

2. While restoring you...

You can make use of these links to configure database mirroring in SQL Server 2005. If you have any queries pls, let us know. The below mentioned has all the...

You need to run this query in secondary server to bring the db online.

Restore Database Yourdbname with Recovery

Refer these links for more info,

http://sql-articles.com/index.php?page=articles/lship/lship.htm

http://sql-articles.com/index.php?page=articles/lship/fail-lship.htm

Refer these links for installing SQL 2005 and SQL 2008 which might help you in a great deal 🙂 also as mentioned earlier you cannot install SQL 2000 or MSDE...

Its because of the features available in SQL 2005. Generally everybody will tend to use the latest product in the market and its features. Refer these links, http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

http://www.sqlservercentral.com/articles/News/3036/%5B/url%5D

In SQL Server 2005 Standard edition you cannot create database snapshots and hence you cannot use it for reporting purposes as the mirror database will be in restoring state. You...

Yes you can make use of that. Also refer this link for more info,

http://support.microsoft.com/kb/321185

Check this link where you can create the login in mirror server with the same SID of the principal server and after failover you dont need to map the logins....