SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Which databases need to Restore
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

kond.mohan
Posting Yak Master

India
189 Posts

Posted - 04/25/2013 :  00:42:01  Show Profile  Reply with Quote
hi,
i am loading the data from SAP(DB2) database to sql server 2008.previously we faced very big issue unable to Restore the few databases, when database(Sql server-destination database)is down.what are the steps (either system or User defined Databases or other files)necessary to Restore (rerun the) Database normal mode.means
if server is down how to bring the server to normal way.(Based on Previous backup files)

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 04/25/2013 :  00:52:12  Show Profile  Visit russell's Homepage  Reply with Quote
You can not restore DB2 backups to MSSQL
Go to Top of Page

kond.mohan
Posting Yak Master

India
189 Posts

Posted - 04/25/2013 :  01:00:17  Show Profile  Reply with Quote
hi

i have sql server backups. i need to restore these backups. so system and user defined database back ups need to restore.so explain me the way of sql server backups need to restore on Sql server.

mohan
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2005 Posts

Posted - 04/25/2013 :  01:51:41  Show Profile  Visit jackv's Homepage  Reply with Quote
You will need to use the RESTORE command - find full details on SQL Server Books Online - http://msdn.microsoft.com/en-gb/library/ms186858.aspx

have you tried restoring , are you seeing any error messages?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 04/25/2013 :  13:05:40  Show Profile  Visit russell's Homepage  Reply with Quote
The target server has to be running too. If it's down, then you need to bring it up first.

As Jack said,, if you're getting error messages, post them here.
Go to Top of Page

scook
Starting Member

USA
1 Posts

Posted - 04/26/2013 :  01:28:43  Show Profile  Reply with Quote
Post the screenshot of error what you are getting,then the problem will be detected easily.


want it now
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000