Saturday, June 30, 2012

SQL SERVER : We cannot Perform Operation in MASTER database

Good Afternoon .........All...........

I Friends this very important thing which I am sharing with you. Just read about Master Database Restriction.

The operations cannot be performed on the master database in SQL Server 2005/2008/2012.
  • Adding files or filegroups SQL Server 2005/2008
  •  Changing collation. The default collation is the server collation SQL Server 2005/2008

  • Changing the database owner. master is owned by dbo SQL Server 2005/2008

  • Creating a full-text catalog or full-text index SQL Server 2005/2008

  • Removing the primary filegroup, primary data file, or log file.

  • Renaming the database or primary filegroup.
  • We cannot Setting the database to OFFLINE.

  •  We cannot Setting the database or primary filegroup to READ_ONLY.

  • Enabling change data capture. 
  • Participating in database mirroring.
  • Creating triggers on system tables in the database.
  • Dropping the database SQL Server 2005/2008
  •  Dropping the guest user from the database.

I hope this ll help to you .................

Like and Share to SQL Integrity Blog

No comments:

Post a Comment

Thank You !!!!