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.
| 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.meansif 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 |
 |
|
|
kond.mohan
Posting Yak Master
213 Posts |
Posted - 2013-04-25 : 01:00:17
|
| hii 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 |
|
|
|
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.aspxhave you tried restoring , are you seeing any error messages?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
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. |
|
|
|
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 |
|
|
|
|
|
|
Which databases need to Restore