Prior to updating sysdatabases entry for database

Rated 3.88/5 based on 684 customer reviews

Now you can jump right in and start creating databases. Let's look at some of the options and how you can use them to build databases.As always in SQL Server, you can achieve your objective through the GUI or through Transact SQL (T-SQL), but I'll use T-SQL statements in this article.A database can grow automatically as you add data, and so can the transaction log.

Instead of occupying space in a device, a database is one or more files visible on the hard disk.

You can spread the transaction log across multiple files or filegroups if it becomes too large for one physical disk.

The database creation syntax has a few inconsistencies.

You can also choose whether the database grows by a fixed number of megabytes or by a percentage of the database size at the time growth occurs.

In either case, avoid growing it in tiny increments, which is time-consuming; grab a reasonably sized increment each time. The database always grows by at least 64KB, in multiples of 64KB, because it allocates space in extents, which are eight 8KB pages.

Leave a Reply