Home Forums SQL Server 2008 SQL Server 2008 - General Error creating new db; "application is not configured for this database" RE: Error creating new db; "application is not configured for this database"

  • January 14, 2013 at 2:35 pm

    #1577089

    cummings.rd (1/14/2013)

    I may not understand correctly what you are stating so please bear with me. The database I am transferring isn't empty. It has lots of information across the tables.

    I am upgrading the application which requires an uninstall of the old app to install the new app. I wouldn't uninstall the old until I was certain the new could recieve the db from the old. So I am testing it on another Win 7 computer.

    I was wondering if there was some step I should have made before I created the backup, copy of the detached db and simple copy of the db folder to prepare it for the move to the new app? There were no active connections when I performed any of these steps.

    Thanks for replying !!

    that seems to be the issue: the command you pasted(CREATE DATABASE SLMD_ABP)

    creates an empty database...that's not what you wanted.

    you've got the plan mostly right: you need to backup the existing database, copy it to the other server, and RESTORE the database as the name of your choice. just copying alone is not enough...you need to run the RESTORE command; probably through the GUI, since it can help you the best.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!