Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Which databases need to Restore

Author  Topic 

kond.mohan
Posting Yak Master

213 Posts

Posted - 2013-04-25 : 00:42:01
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

5072 Posts

Posted - 2013-04-25 : 00:52:12
You can not restore DB2 backups to MSSQL
Go to Top of Page

kond.mohan
Posting Yak Master

213 Posts

Posted - 2013-04-25 : 01:00:17
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
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-04-25 : 01:51:41
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

5072 Posts

Posted - 2013-04-25 : 13:05:40
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

1 Post

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


want it now
Go to Top of Page
   

- Advertisement -