I want to create a SQL 2005 database with the following options:
- SIMPLE RECOVERY
- AUTO_SHRINK ON
- AUTO_CLOSE ON
What is the command to do this? The docs on Microsofts site are somewhat vague on this issue. They say:
ALTER DATABASE
{
SET < optionspec > [ ,...n ] [ WITH < termination > ]
}
whatever that means...
I have tried this, which fails:
CREATE DATABASE TESTX SET RECOVERY SIMPLE, AUTO_CLOSE ON;
and I tried something like this, which failed also:
ALTER DATABASE TESTX
{
AUTO_CLOSE ON
| AUTO_CREATE_STATISTICS ON
| AUTO_SHRINK ON
}