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.

You are right, you cant take the database from 2012 to 2005 as it will not reattach or restore.

Two options I can think of off the top of my head...

DECLARE @a SMALLINT

SELECT @a = cpu_count FROM sys.dm_os_sys_info

IF @a = 1

BEGIN

EXEC sp_configure 'min server memory (MB)',xxxxx

EXEC sp_configure 'max server memory (MB)',xxxxx

...

Somewhere up the north of England, Manchester prefered, London was just to tricky to get to this time around.