Results 1 to 4 of 4

Thread: How to restore database in SQL Server 2005

  1. #1
    Join Date
    Apr 2009

    How to restore database in SQL Server 2005


    I have created 5 to 10 tables, each table containing 25 records plus rows and along with that 7 users, I made some changes to the database and forget to save the changes made to the database, when i again login to the database i was unable to see the changes made to the database, can someone please let me know how to restore database in SQL Server 2005.

    Thanks for your suggestions.

  2. #2
    Join Date
    Apr 2008

    Re: How to restore database in SQL Server 2005

    If you've tried to backup a database in SQL Server 2005, you should keep in mind that database backups are not backward compatible. However, but with SQL Server 2008 Management Studio, you are allow to script data and schemas in SQL Server 2005 mode but for that you need to have SQL Management Studio. This Solution gives you the steps to back up of the database on SQL Server 2008 and restore it to SQL Server 2005.

    And with this wizard if you wanted to create the scripts, you have to run the "Generate SQL Server Scripts" wizard, which you can run within SQL Server Management Studio by right clicking on the database and selecting "Tasks > Generate Scripts."

  3. #3
    Join Date
    Dec 2008

    Re: How to restore database in SQL Server 2005

    I have some doubt in my mind related to restoring database in SQL Server 2005.Infact,these are doubts but the pre-requisite you need to complete.

    1. Have u tried WITH REPLACE clause in your RESTORE DATABASE command? If not, then use it. If you still get errors, provide me with the following information:

    The output of the following command:
    2. From the Target Server (on which you want to restore the database), send the output commands as given below:
    USE DBName  (Existing target database name)
    SELECT name, filename FROM SYSFILES
    NB: and for that you need to know the target database files

    3. Is the existing target database OR a copy of the database backup you want to restore or is it some different database altogether?

    Waiting for your reply.

  4. #4
    Janupagla Guest

    Re: How to restore database in SQL Server 2005

    Your database is down, your users are in a panic, what do you do?. If you have been performing routine backups of your database, you can restore it to the point of the most recent backup. To restore your database, follow these steps:

    1. Open SQL Server 2005 Management Stu

Similar Threads

  1. How to restore database on a Linked Server
    By AaAgMaN in forum Operating Systems
    Replies: 5
    Last Post: 05-03-2011, 07:17 PM
  2. Access database upgrade to SQL Server 2005
    By Umberto-Micro in forum Software Development
    Replies: 4
    Last Post: 12-02-2010, 11:16 PM
  3. Replies: 3
    Last Post: 20-05-2009, 01:03 PM
  4. Replies: 3
    Last Post: 20-02-2009, 01:33 AM
  5. Upgrade fails: SQL Server Express 2005 to SQL Server 2005
    By Steve BB in forum Small Business Server
    Replies: 3
    Last Post: 11-06-2008, 07:37 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts