created backup device is not showing in db13

[former_member183044]

Hi all,

Today i've created a backup device in our database MSSQL server 2005. After that i went to DB13. There i found the backup device which i've created.

But after that when i opened DBA Planning calendar for scheduling a transaction log backup, the created device is not showing.

Can anybody help me in sorting out the above error??? Kindly help

Regards

Praveen

[former_member185239 · Accepted solution]

Hi Praveen,

Just give a new path to backup device which you have created.

QAS1 -> D:\system backup\TBAKP  - old

QAS1 --> D:\Translog\TBAKP - new

Check it again.

With Regards

Ashutosh Chaturvedi

[former_member183044 · Accepted solution]

Hi Ashuthosh,

In sql studio when i checked i couldn't find the option for edit the current location.Is there any option in sql studio for doing the same?

Regards

Praveen

[former_member185239 · Accepted solution]

Hi Praveen,

Just remove the one which you have created and create a new one.

With Regards

Ashutosh Chaturvedi

[former_member183044 · Accepted solution]

Hi,

Now it is working

Regards

Praveen

[Former Member]

Hi,

Check the link

https://msdn.microsoft.com/en-IN/library/ms189109.aspx

You need to define the backup device in SQL studio

Managemnet -> Backup -> New Backup Device.

You can manage backup functionality from the studio instead of doing it from SAP end.

Regards,

Prithviraj.

[former_member183044]

Hi Prithviraj,

Thanks for the reply.

Yes, i configured via SQL management studio itself. I went through the following way.

OBJECT EXPLORER->SERVER OBJECTS->BACKUP DEVICES-> back up device name

But after that i logged into SAP, in BACKUP DEVICES the new device is showing, but in PLANNING CALENDER the new device is not showing.

Regards

Praveen