Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dexterm
Starting Member
4 Posts |
 Posted - 2009-08-03 : 08:38:40
|
| I am writing an application that will log real-time events. The application currently uses SQL Server Express Edition which has a 4GB per database limit.My questions(s):1) Does the 4GB restriction apply only the to database file? Or the database and log files? In combination?2) Can I set up scheduled backups and database shrinks in the SQL Server Express edition? Do I have to script these, or will SQL Server Agent work?Thanks,Dexter |
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-08-10 : 16:46:20
|
| SQL agent i snot included with SQL express edition. The service terminates when you attempt to start it manually.The 4gb restriction is when the MDF attempts to expand beyond 4gb. When the database tries to expand beyond 4gb that quere bombs out.Shrinking the database is generally unnecessary. A customer of mine ran SQL Express from 500mb right up to the 4gb limit over 2 years. Never did we shrink the DB. |
 |
|
|
|
|
|
size estimates for Sql Server Express