Is this a one-off thing or a "feature" you're being asked to build? I'm not sure I'd design a database schema around the occasional need to rollback a...

I will try that - thanks.

If I needed Express database engine on a laptop and a full set of tools to manage remote Enterprise or Standard editions, I'd install Management Tools/Complete from the Enterprise\Standard edition...

Create two backups of the database. Then Right-click the database and select Task\Shrink\Files and set File type to Log, then OK.

Dan

I'm not sure if you mean table partitioning, or if you're talking about clustering, mirroring or replication. But SQLExpress does not support any of these functions, so if you...

Should be 800MB - Typo fixed.

Make sure SQLExpress is configured for remote access, TCP is enabled in SQL Configuration Manager and SQL Browser Service is on. From elsewhere on the network you should...

If SQL is clustered it should be shut down in Cluster Manager only. If it is not clustered, I prefer to use SQL Server Configuration Manager.

On our serves we have a dedicated local drive just for the page file. You want some (I'm told a minimum of 800MB) on the system drive for memory...

Lynn Pettis (7/12/2012)

Don't we offer real answers to real questions?...

You can also run this:

USE [master]

GO

EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'BackupDirectory', REG_SZ, N'H:\Backup'

GO

Try plotting out the time slots the various i/o intensive jobs (backups, index rebuilds, DBCC checks, etc.) occupy, or try a tool like Idera SQL Job Manager, and look for...

If you can keep 2 full backups you can delete all log backups older than your oldest full backup, since they are useless if you don't have the full backup...

Questions about Dev edition licensing:

1) Are licences assigned to the server or a particular person/developer? If we have a team doing DEV/QA work, can they all access it on...

You're right - should have been <= 9 or < 10.