• Errors creating database with SQL Server 2008 I&M Training Manual

    I'm going through the SQL Server 2008 I&M self-paced training manual, and when I do the exercise for creating a database, here's what happens: CREATE DATABASE TK432 ON PRIMARY ( NAME = N'TK432_Data', FILENAME = N'c:\test\TK432.mdf', SIZE = 8MB, MAXSIZE = UNLIMITED, FILEGROWTH = 16MB ),...

    Howhighthemoon20 pointsBadges:
  • SQL Server 2008 restore error

    error message : The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.1600. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server....

    Kazem10 pointsBadges:
  • SQL Server 2008 Restore Fails – There is insufficient system memory in resource pool ‘internal’ to run this query

    I am trying to restore from a backup to a new database, and it processes for 8 hours and completes to 100%, and i get the following error. 100 percent processed. Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally. Msg 701, Level 17, State 123, Line 1 There is...

    MTLONDON20 pointsBadges:
  • SQL Server 2008 Restore error message

    I get this error when trying to restore a 30 mg database "Callback:SQL Server 2008: Out of memory on restore" and then get the error ""There is insufficient system memory in resource pool ‘internal’" Anyone have any ideas?

    Kmmc1122334455665 pointsBadges:
  • Error Message when restoring a SQL server DB in SQL Server Express 2008 R2

    This error received and cannot determine resolution: System.data.Sqlclient.Sqlerror:Create Database or Alter Database failed because the resulting cumulative database size would exceed your licensed limit of 10240MB per database. The DB.bak file is 1.67MB

    Trackster209515 pointsBadges:
  • sql server 2008 backup and restore

    can u get me the command to recover the database . my backup is in d:nor.bak . as i m running the command   >restore database 'd:nor.bak' it gives me the message as : Incorrect syntax near 'd:nor.bak'. pls let me know how to reatore . Regards, Rino

    Fhhdjfhjdhfjhjdfh135 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.