Home Forums SQL Server 2005 Administering DBCC CheckDB CREATE FILE encountered operating system error 1450 RE: DBCC CheckDB CREATE FILE encountered operating system error 1450

  • Hi Gila,

    Thanks for your reply. I found that same article when googling this error. Our server is WS2003 Enterprise Edition x64 edition with 42GB RAM so we don't have the /3GB switch in boot.ini.

    The other strange thing is that we don't have any database snapshots configured for this DB. Although I understand that Check DB automatically creates a database snapshot when running in multi-user mode?

    In fact, although there was an error mentioned in the output of DBCC CHECKDB there is also the following message:

    CHECKDB found 0 allocation errors and 0 consistency errors in database 'DBName'.

    Which gives me hope..

    Will the following solution require me to place the DB into single user mode?

    Run DBCC CHECKDB in OFFLINE mode (WITH TABLOCK)

    Sorry for all the Q's, I'm still not 100% sure I understand the issue after reading that article.

    I am restoring a previous backup of the DB in question (overwriting the current database files) to see if this resolves the issue. Obviously the data will be slightly outdated.

    Many THanks,

    Phil