I am mirroring one database

It's a simple code change for him to point the software at a new ip. I guess the reason it's a mirroed database is so it's easy to have...

The application will use it. The developer will have to go in and change the code on the program to point to the new database or he can change...

Thanks for the quick replies. There is no witness server setup between the two but the mirror is setup as "High safety without automatic failover". The applications are...

I have two more questions for everyone.

1). Say my principal box dies. Do I go to the mirror box and simply run the command, "RESTORE DATABASE <dbname> WITH...

I got it working. I needed to Grant Connect on endpoint on the principal side, that's what was screwing it up.

GRANT CONNECT ON ENDPOINT::Endpoint_Mirroring TO [Somedomain\someuser];

WOW. Thanks for...

So im connecting from the principal server to the mirror server using "SQL Server Administration", the sa account. How would I grant the sa account CONNECT privileges on the...

Calvo,

Thanks for the response. I have been using the wizard the whole time. For 2008 standard, do i need to have a witness server? that may be...

So i got the correct versions on both sides, did a full back up of the database and log files, did a restore on the backup server with no recovery...

So your saying I have to initiate the mirror on the mirror server not the principal server? This goes against all the articles i've read.

Actually i found the problem. The target version has developer edition installed instead of standard edition. I need to unistall dev edition and install the standard and i'll...

OK, I ran the command "RESTORE DATABASE PROD WITH RECOVERY" and I can see my database and view all the tables etc! Now I'm still having the issue with...