Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to restore database in SQL Server 2005

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 02-05-2009
Member
 
Join Date: Apr 2009
Posts: 69
How to restore database in SQL Server 2005
  

Hello,

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.

Reply With Quote
  #2  
Old 02-05-2009
Member
 
Join Date: Apr 2008
Posts: 193
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."
Reply With Quote
  #3  
Old 02-05-2009
Member
 
Join Date: Dec 2008
Posts: 161
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:
Quote:
RESTORE FILELISTONLY FROM YourDBBackupFile_name.BAK
2. From the Target Server (on which you want to restore the database), send the output commands as given below:
Code:
USE DBName  (Existing target database name)
GO
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.
Regards
Reply With Quote
  #4  
Old 02-05-2009
Janupagla
 
Posts: n/a
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
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to restore database in SQL Server 2005"
Thread Thread Starter Forum Replies Last Post
How to restore database on a Linked Server AaAgMaN Operating Systems 5 05-03-2011 07:17 PM
Access database upgrade to SQL Server 2005 Umberto-Micro Software Development 4 12-02-2010 11:16 PM
How to Uninstall Multiple Database Instances of Microsoft SQL Server 2005 Jasonholt Networking & Security 3 20-05-2009 01:03 PM
Shared Business Contact Manager for Outlook 2007 database on an SQL 2005 Server Dhananjay MS Office Support 3 20-02-2009 01:33 AM
Upgrade fails: SQL Server Express 2005 to SQL Server 2005 Steve BB Small Business Server 3 11-06-2008 07:37 PM


All times are GMT +5.5. The time now is 11:04 PM.