poratips (11/12/2012)

---

Hello,

I have situation that my developer wants some tables from Prodction DB server to their desktop m/c.

We have already sql express installed and Database and tables ae already there...

Your rounding is not following correct rounding rules, typically anything between 0-4 is rounded down and 5-9 rounded up, so to round a value to 10.44 it would have...

Transaction log backups are there so that you can revert to a point in time.

If you dont do transaction log backups you need to ask yourself why is your database...

Database in full recovery but not doing regular transaction log backups?

jasona.work (11/12/2012)

---

The Dixie Flatline (11/10/2012)

---

capnhector (11/9/2012)

---

Revenant (11/9/2012)

---

crookj (11/9/2012)

---

JAZZ Master (11/9/2012)

---

anthony.green (11/9/2012)

---

capnhector (11/8/2012)

---

Cliff Jones (11/8/2012)

---

Tommy Lee Jones...

What I would do is build a calendar table and link to that based on what you class is a business day.

http://www.sqlservercentral.com/scripts/Date/68389/

Will also come in handy for other calendar based...

Change the 2012 instance to listen on a different port, but not 1434 as that port is used for the SQL Browser service

Is there a reason you have set the 2012 instance to listen on the SQL browser port?

Sounds like the full backups last LSN is after the 11pm transaction log backup.

Check msdb.dbo.backupset correlating the first & last LSN columns to get the restore order.

But in this case...

If disk space is going down but the DB total size is staying at 22.5GB then you have something else which is causing the drive to run out of space.

Sounds like the backup is compressed.

http://technet.microsoft.com/en-us/library/bb964719%28v=sql.100%29.aspx

iRobot

Or even Red-Gate's beer, now to get Steve to ship everyone a bottle or two

Yep, thats varchar ordering for you as it orders left to right of the characteres in the string, not based on value, so yep doing it 1,2,3,4 would be the...

Add in an order by clause sorting either Asc or Desc depending on which way round you want the values to be displayed.