thinknight (12/17/2008)

Which method below is preferred while carrying a database to another server?

1) Detach / Attach Mdf, ldf files?

2) Full Backup and take transaction log backup after full backup up...

Not sure what you are asking exactly, but assuming you are in full recovery mode you shouldn't lose data by taking a log backup.

I would suggest reading up...

Might try using the DAC to add a new log file on a separate disk (assuming you have one) until you can figure out what is making it grow so...

This brings up a best practice question...should you be logging on to the DB server and using SSMS there for routine queries, or using SSMS on a remote client machine?

When mirroring, you can take snapshots of your database, but you can't backup or restore a snapshot, or have the snapshot on a different server than the server you are...

venablc (12/10/2008)

You can take snapshots of a mirror database and then restore these onto a live reporting database (although not if you are using sql2008 as your mirror database according...

I've run into that same edition requirement before. I don't mind them making you have the Enterprise edition for asynch. mirroring, but I found the same edition reqirement for...

I think I did that to my chin once when I was a kid...6 stitches if I remember correctly.

Good one!

I've had that happen also, that's what caused me to come up with this question.

We recently had a deploy script that dropped and recreated several stored procedures something...

Interesting. I hadn't seen that one. It doesn't 100% match my symptoms, but I've got 2/3. ...

I'll see if our hardware guys are cool with a reboot.

I've re-run that query many times and can't get it to reproduce. But then that would be too easy.

Another thought occured to me last night also...if you were to have a failure of the principal (2005)database and recovered the mirror (2008) database so people can use it, you...

I've always thought of it as fixing the symptom of a problem without fixing the underlying cause.

Either way, I think I agree with you.

Messing with the...

What is the definition of workarround?