How to Restore Backup SQLSERVER 2005 ATTACH BKF file

[Former Member]

Dear Experts,

I have SAP ECC6.0 with Sql server 2005. I am taking backup in daily basis with 1 TB External Harddisk.

That file stored in BKF format. Now I have to attach the database through SQL Server in the format BKF.

How can i do?

Please tell me steps.

Regards

Thomas.T

[markus_doehr2]

You don't attach this file, you do a restore of the database.

http://www.tech-recipes.com/rx/2081/sql_server_2005_how_to_restore_database_backup/

Markus

[Former Member]

Dear Markus,

Still I take a backup from External Harddisk.

I don't have Tape Drive with media. If it is possible for that .bkf file?

Please advice me.

Regards

Thomas.T

[Former Member]

Dear,

When I am restore the database backup, that .bkf file not supported.

Please Let me know

[markus_doehr2]

How did you take that backup?

Markus

[Former Member]

Dear Expert,

I take the back up from Start --> Run ( Ntbackup ) and select the Database file and scheduled.

[Former Member]

Dear,

I took that backup ( Start -> Run--> Ntbackup )

from External harddik file and it will be stored in .BKF file.

Thanks

Thomas.T

[markus_doehr2]

> I took that backup ( Start -> Run--> Ntbackup )

> from External harddik file and it will be stored in .BKF file.

Did you do that while the database was running? Did you back up the files only?

Markus

[Former Member]

Dear,

No sir, while attach the database file it will not supported .

I select the files from Drive ( DEVdata1, DEVdata2, DEVdata3 & Logfile)

Edited by: thomas_raja on Jul 7, 2011 3:30 PM

[markus_doehr2]

> No sir, while attach the database file it will not supported .

I'm sorry, I don't understand that sentence.

> I select the files from Drive ( DEVdata1, DEVdata2, DEVdata3 & Logfile)

My question was: did you backup the DATABASE or did you back up the DATABASE FILES?

Markus

[markus_doehr2]

You have to restore the same way you did the backup.

So you have to start ntbackup and restore.

Markus

[Former Member]

Dear Experts,

I need to perform backup & then restore of our SAP ECC6.0 through SQL Server Management studuio..

so I want to know backup stored in Local Drive and after that I have restore the same datas.

Please Let me know.

Regards

Thomas.T

[former_member211282]

Hi Thomas,

As per the last status of your message , i see the issue is not solved yet.

as you took the backup in the .bkf format, so restore those files using the same way on the local drive and then point these files to the database under the database properties(right click on database--> properties[you can find the physical path of the files])

now point the .mdf,.ndf and .ldf files to the location where you have restored.

If you have any queries please post it back.

thank you.

regards,

Sanath Kumar

[former_member211282]

Can i the forum know the status of the issue.

[Former Member]

Hi,

As Marcus said, you can´t attach this type of file. So you have 2 choices,

1.- Make a bakcup from SQL Server 2005 from right click on data base --> backup database --> backup.bak

and restore the .bak

2.- Stop SAP, copy all datafiles to the HD and then go to the new SQL right click --> attach database and select the data files and new location. Remember the files must be with permissions for the current user that you used.

Aldo