No, you cannot shrink the tlog on a mirrored database without breaking the mirror first.

Given that your log is 50Gb vs data at 2Gb you're going to need...

If your log file is growing from 2Gb to 27Gb every day then there is a reason for it.

Having to shrink the log every day just means SQL has to...

CrazyMan (10/15/2008)

---

Hi All

I am having a table with 5 columns, with 2 big int columns, 1 int and 1...

rbarryyoung (10/13/2008)

---

Correct - I have enough problems with performance when some genius decides...

Hmmm a good point. And best of all, I've just counted the rows in the table.

You. Don't. Want. To. Know.

I could buy a...

SELECT Col1, Col2, Col3, ColD4 FROM TABLE1

WHERE Col1 LIKE

CASE

...

The way I've done it in the past is to use vbs scripts (scheduled task run) to copy the latest backup files from prod then a SQL job to restore...

If there are connections open on the secondary database then the logshipping will fail. The logshipping jobs need exclusive access while they're restoring the transaction log.

Let's say your backup...

Firewall issue:

Is your SQL server on a different part of the network (for security reasons) and thus having port 1433 blocked?

DNS issue:

Has some numpty in the network team typo'ed the...

Maint plans (such as full db backup) should be on the primary server.

I normally make a copy of all these plans on the secondary server but leave them disabled. ...

How big is the database? There's always cut'n'paste 😀 from the results window. Or saving to a text file and importing the results 😉

I've found the Export Data...

Are you sure you don't work for the same place I do?

The best solution I've found is to allow them to do whatever they want with the dev systems. ...

Thanks for all your suggestions.

I just wanted to make sure I hadn't missed a simple method for doing what seems to be basic task. Since the live db must...

Yes I do need data as well as structure. Since the db is 20Gb I was rather hoping to avoid the backup to file, copy file (to another server),...

You send me money and I'll send an envelope containing lots of space. 😀

Seriously, some more details would be helpful.