What are the Navicat for SQL Server file attributes

Source: Internet
Author: User
Tags filegroup

For NAVICAT for SQL Server users know that this is a comprehensive graphical way to manage the database, to create, edit, and delete all database objects, in order to get a better understanding of this software, this tutorial will explain Navicat for SQL Server The file properties.


Navicat for SQL Server

SQL Server file Group properties:

Filegroup: Add or remove filegroups, PRIMARY filegroups cannot be deleted.

File stream Filegroup: Adds or removes a file stream filegroup that supports only SQL Server 2008 or later.

file properties for SQL Server:

Name: Specifies the logical name of the file.

Type: The type of file.

Filegroups: Groups of files that can be selected.

File directory: The path that the operating system uses when creating the file.

FileName: The file name used by the operating system when creating the file.

Size: Specifies the size of the file.

Allow auto-increment: Tick this to allow auto-increment.

Increment: Specifies the automatic increment of the file.

Maximum size: Specifies the maximum amount of files that can be increased.

Unrestricted: Indicates that the file can grow at will until the disk is full. In SQL Server, the maximum number of log files that are specified as unrestricted growth is 2 TB, and the data files are up to a maximum of TB.

For more related tutorials on Navicat for SQL Server, refer to Navicat Chinese official website .

The above is reproduced content, the original is: http://www.formysql.com/jiqiao/SQL-Server-wenjian.html

What are the Navicat for SQL Server file attributes

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.