Viewing 3 posts - 1 through 3 (of 3 total)
HI,
You can add a step to your daily backup job such that
1)first step will delete old backup file based on ur need (days).
you can use Xp_cmdshell command or...
April 13, 2011 at 11:41 pm
#1311426
1) Its always recommend to have data file growth in MB than in %.
Reason: If data file is huge say 250 GB then 10% means 25...
April 13, 2011 at 10:33 pm
#1311415
Make sure "Model" database is not in use by another user or session (as default DB) because model Db is use as template to create new DB....
April 11, 2011 at 11:19 pm
#1310209