SQL Server Errors or Failures Error: 1812 to Error: 1832



Error: 1812, Severity: 16,
CREATE DATABASE failed. COLLATE clause cannot be used with the FOR ATTACH option.

Error: 1813, Severity: 16,
Could not open new database ‘%.*ls’. CREATE DATABASE is aborted.

Error: 1814, Severity: 10,
Could not create tempdb. You may not have enough disk space available. Free additional disk space by deleting other files on the tempdb drive and then restart SQL Server. Check for additional errors in the event log that may indicate why the tempdb files

Error: 1815, Severity: 16,
The %ls property cannot be used with database snapshot files.

Error: 1816, Severity: 16,
Database snapshot on the system database %.*ls is not allowed.

Error: 1817, Severity: 16,
Only the owner of database “%.*s” or the system administrator can create a database snapshot on it.

Error: 1818, Severity: 16,
Primary log file ‘%ls’ is missing and the database was not cleanly shut down so it cannot be rebuilt.

Error: 1819, Severity: 10,
Could not create default log file because the name was too long.

Error: 1821, Severity: 16,
Cannot create a database snapshot on another database snapshot.

Error: 1822, Severity: 16,
The database must be online to have a database snapshot.

Error: 1823, Severity: 16,
A database snapshot cannot be created because it failed to start.

Error: 1824, Severity: 16,
Cannot attach a database that was being restored.

Error: 1825, Severity: 16,
Filegroups and collations cannot be specified for database snapshots.

Error: 1826, Severity: 16,
User-defined filegroups are not allowed on “%ls”.

Error: 1827, Severity: 16,
CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of %I64d MB per %S_MSG.

Error: 1828, Severity: 16,
The logical file name “%.*ls” is already in use. Choose a different name.

Error: 1829, Severity: 16,
The FOR ATTACH option requires that at least the primary file be specified.

Error: 1830, Severity: 16,
The files ‘%.*ls’ and ‘%.*ls’ are both primary files. A database can only have one primary file.

Error: 1831, Severity: 16,
File ONLINE/OFFLINE syntax cannot be used with CREATE DATABASE.

Error: 1832, Severity: 20,
Cannot attach the file ‘%.*ls’ as database ‘%.*ls’.%.*ls

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.


Leave a Reply

Your email address will not be published. Required fields are marked *