There are few things you cannot do in SQL
server. Surprised?? Try some of following points. Please add your comments to
the blog after trying.
- You cannot add
data and log files in master and model database.
- You cannot add
User Defined File Groups in master, model and tempdb database.
- You cannot
change the recovery model of tempdb database.
- You cannot take
transaction log backups of master database even if the recovery model of
master database is changed to Full.
- You cannot take
any backup of tempdb database.
- You cannot
rename any system database.
- You cannot
allocate Transaction log files under File Groups
- You cannot
change the file group of a file once it is set.
- You cannot
create a new database if model database is in use
- You cannot change the owner of master, model, tempdb or distribution databas
