A. Check for free space in the Data Drives of the server.
Execute the following command the SQL Server session to check for free space in the data files of the DB:
sp_helpdb Talentica_214
If the total free space in any of the DB data files is less than 10GB, then a new data file has to be created in the data drive which was identified to have more free space in the server.
B. New Data File Creation:
Right click on the Database Name in Object explorer of SSMS and select properties. Select files:
Click on ADD button to add a new file. Give the following propertie values:
Logical Name: Talentica_214_2
File Type: Data
Filegroup: Primary
Initial Size: 1024 MB
Click on Autogrowth Ellipsis and give following values:
File Growth in Megabytes: 128
Maximum file size: Restricted File Growth (MB): 16384
Click on Ok
Give Path as the data drive path which has more space.
The File Name will be given by the system automatically.
No comments:
Post a Comment