undoing it when you had it working might have been shooting yourself in the foot. run

alter database dbname set partner off

to remove all traves of mirroring and try...

have you tried setting up endpoints via the GUI?

check ports are not in use by any other process

restore database dbname with recovery

brings a database online again, but did you actually want to know how to failover a mirrored database?

yes, because its not supporting a production application itself.

2.Can we use the same...

rambilla4 (6/30/2009)

---

We have system database's mdf, ldf and user databases mdf files on one drive and user databases ldf files on other drive.

We just building a Virtual machine with only...

Ivanna thats what I would do. If it aint broke don't fix it..

I think you only need to be concerned if database recovery time at server restart seems slow, or...

p.s. logshipping monitoring locally has no performance hit. very small amount of activity in msdb but that's on a seperate drive right? 🙂

Well I do survive without a monitor server myself and I don't think I would ever bother with one.

Microsoft would say that as log-shipping is controlled via SQLAgent jobs all...

If you mean wmware...

Also:

why? Vendors can...

As the database is mirrored FULL recovery mode is the only allowed option.

Ivanna, If you want to reduce your number of virtual logs wait for a quite time. shrink the...

If they are not changing often I would do this manually, run sp_help_revlogin and edit the output to only include the logins you want, then load them in.

tnk (6/29/2009)

---

I'd like to make sure I understand what I am supposed to be shooting for here. My understanding is that you take backups every so often, and then you...

replies to

http://www.sqlservercentral.com/Forums/Topic744064-357-1.aspx

IF you have updated the secondary whilst it was online you will have to back it up and then restore it from that same backup with norecovery.

copy the same backup...