I think you can try this and test.

http://wiki.cdyne.com/wiki/index.php?title=Mirroring_SQL_Server_2005

SELECT * FROM sys.endpoints

sys.endpointsAll endpoints and all generic properties

sys.database_mirroring_endpoints The Database Mirroring endpoints

----------------------------------------------------------------------------------------------

CREATE ENDPOINT endpoint_mirroring

STATE = STARTED...

Update the services with domain account / network service and restart the services.

Delete the endpoints and retry creating the endpoints again.

Follow: http://www.sql-server-performance.com/articles/clustering/mirroring_2005_p3.aspx

Try configuring.

Nice times...

- Win.

If thats a test server or yur local machine.

Change the SQL Server service accounts to domain account or Network Service and restart the services.

Start configuring mirroring. And the database needs...

Use BDCC TRACEON (1400) and alter the Startup parameter in configuration manager of SQL SERVER ;-T1400

· RUN --> Type sqlservermanager.msc

·...

Correct..

I agree.

Take a point in time recovery or Tail Log backup for the possible recovery. Copy the last Trans Log file to the secondary server. Restore the final T-Log backup...

Can you elaborate what exactly the status of the DB is now and error you are getting, after all tries ???

Post a reply when you fix this with steps if you can...

It might help others in future...

How about...

Take a Trans log backup on the second server.

Kill all the processes on the database.

Try restoring the Trans log backup with recovery on the first and the OLD...

Thanks for your valuable suggestions and points.

Iamaking a note of all the points as said above .

Yes backups tested wih T-SQL

RESTORE VERIFYONLY FROM DISK = 'D:\ApDB_260101.bak'

GO

RESTORE HEADERONLY FROM DISK...

One more thought:

Detach the DB and copy .mdf and .ldf files to another server (if you cant, then kill the processes running on the db). Attach DB here on the...

Thanks.

Planned to backup into tape drives and also Zero (mirrored) drives.

Application changes ?

Thanks all .

Yes,

we are moving the boxes to new location where the servers will work with new IP.

I agree that IP address needs to be changed in Application level....

Anytype of suggestions are appreciated.

Please post your comments.

Hi,

adding a new bit here, can we make this to work for GMail or Yahoo mails ?

any thoughts ?

as i tried in the past but never resolved.

Thanks in advance.