Import Bacpac from Azure to SQL Server 2012

1

I am importing a bacpac that I generated from the portal of Azure to a SQL Server 2012 local and I get the error that I detail next. Do you know how I can fix it so that the package is imported correctly?

TITLE: Microsoft SQL Server Management Studio

  

The package could not be imported.

     

Warning SQL72012: The object [dd_produccion_Data] exists in the destination, but it will not be removed   you have selected the box 'Generate DROP instructions for objects   that are in the destination database but are not in the   database project '.

     

Warning SQL72012: The object   [dd_produccion_Log] exists in the destination, but it will not be removed   you have selected the box 'Generate DROP instructions for objects   that are in the destination database but are not in the   database project '.

     

Error SQL72016: Unable to allocate a   new page for the database 'dd_production' because the group of   'PRIMARY' files have insufficient disk space. Remove   objects in the file group, add additional files to the group   of files or set the option of automatic growth for   existing files in the file group in order to create the   Necessary space

     

The instruction was finished. Error SQL72045: Error of   script execution.

     

The executed script:

     

/ * The data is loaded from   massive form at this time of implementation execution   * /

     

(Microsoft.SqlServer.Dac)

ADDITIONAL INFORMATION:

  

Could not assign a new page for the database   'dd_production' because the group of files 'PRIMARY' has space   insufficient on the disk. Remove objects from the file group, add   additional files to the file group or set the option to   automatic growth for existing files in the group of   files in order to create the necessary space. The end of the   instruction. (Microsoft SQL Server, Error: 1101)

     

For help, click: link

asked by user7122 23.05.2016 в 09:26
source

1 answer

1

Error 1101 is telling us that you do not have space for the filegroup primary in the file it has or it can not grow anymore, verify that the database is not full and that it has an adequate growth.

There may also be a relationship with this error in the SSDT, in this case make an update to your data tools tools.

link

    
answered by 23.05.2016 в 18:23