domain1\user of sql_server1 should be able to login as domain1\user in sql_server2 of domain2.

Please help

But shouldn't we add one of the domains as trusted to the other.

How will we know weather test1 user is belonging to sql_server1 or sql_server2.

Check out:

http://blogs.techrepublic.com.com/howdoi/?p=123

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

http://www.exforsys.com/tutorials/sql-server-2005/sql-server-configuring-replication.html

If database1 and database2 are in diff servers then you can add one of the server as liked server to the other and run queries such as

select * from scud.master.sys.databases

which...

Have installed Service Pack 2

Try shrinking the log using DBCC shrinkfile command.

I think mirroring will get back on track.

Yes you (urgently) need to assign a strong password to the SA Login.

Secure your sa login account with a non-NULL password. There are worms that only work if you have...

Dude

Check out this

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

Also I found this http://go.microsoft.com/fwlink/?LinkID=94937&clcid=0x409 to...

Check out

http://msdn.microsoft.com/en-us/library/aa176562(SQL.80).aspx

If the servers are connected over network you can use "Sql server Import and Export wizard" to export data.

Check out

http://www.sql-server-performance.com/faq/cluster_log_shipping_replication_p1.aspx

Only a sysadmin can give a sysadmin role.

If you have set missed authentication while installation you can login using windows authentication abd give sysadmin role to users.

Checkout

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

You can run...

Can u tell me what exactly is the error shown.

For the Features Supported by the Editions of SQL Server 2005

Check out this might help

http://msdn.microsoft.com/en-us/library/ms143761(SQL.90).aspx

Only if you need to move the physical files to another location you need add a MOVE command for each file you want to move.

I don't think you can specify backup size it divides the db backup approximately to equal parts.