how to restore DB (SQL)

[Former Member]

Hi,

I have a similar post here, but not the same. This is a doubt I have when trying to restore DB using a backup file (.BAK)

I have a new Windows 2008 R2 box, and have a .bak file, which is an online sql backup of another SAP system. I want to restore this backup to the new box, and build a new SAP system.

Here's what I have done, and is failing -

1) Installed SQL Server 2008 using SAP's DVD. It was a silent install. While installing, I selected the SQL instance as "default" which was SAP recommended.

2) I am going to the SQL Management studio now, so that I can restore the DB from the BKP file. How do I connect, and what do I connect to? I tried windows authentication. I am administrator on the system, and it don't let me in. I cannot use SU or SQL authentication as I don't have any other info from the install. How do I restore my backup to the system????

Thanks for all the help.

[Former Member]

You should be able to connect using "localhost" and Windows authentication.

Check services "SQL Server (MSSQLSERVER)" and "SQL Server Agent (MSSQLSERVER).  Both need to be running.

Make sure that your user is a part of the local Administrators group.  I have had problems connecting with a domain admin account that was not explicitly made a member of the local group.

If this doesn't work, can you give us the exact error you get?

[Former Member]

Thanks Susan.

I tried localhost and it don't work. To make it more clear, I haven't installed SAP on this system. So, I assume no databases are created. Still, would I be able to connect to the default and restore database from backup? What I am trying to do is to build a system using the db backup I have. Not sure if I am doing something wrong here.

Also note that I am in the administrator group and in the domain admins group.

please see error screen attached.

My user is Domain\User

[Former Member]

This message was moderated.

[former_member188883]

Hi Jim,

In Server name please add the windows server name and check the results.

Regards,

Deepak Kori

[Former Member]

ofcourse tried that, which didn't help. Is my strategy correct? Can I restore the backup without installing SAP on the new system?

[former_member45419]

Hi Jim

have look this link refer to that error code 18456 for authentication user & once try with change the host name from local to some other domain 7 then try

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/33416fb6-13e9-4f46-a983-6d1e32df7ef5/microso...

http://www.katieandemil.com/microsoft-sql-server-error-18456-login-failed-for-user

[Sriram2009]

Hi Jim

Kindly refer the link

http://technet.microsoft.com/en-us/library/ms177429.aspx

http://social.technet.microsoft.com/wiki/contents/articles/7654.how-to-restore-a-database-backup-usi...

Thanks

Sriram

[Sriram2009]

Hi Jim

Yes, you have to restore the backup file and then start the SAP System copy installation by using SAPINST or SWPM

Thanks

Ram

[former_member188883]

Hi Jim,

You can restore the backup using attach / detach method without having SAP installed.

Regards,

Deepak Kori