Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Error al hacer BACK UP en SQL

former_member299313
Participant
2,753
  • SAP Managed Tags

estimado Grupo espero se encuentren bien, alguien que me pudiera ayudar con el back up de una bd

al hacer respaldo me aparece el error anexo, ya contacte con MICROSOFT pero no encuentran el error.

de antemano agradezco su ayuda.

dbcc-check.txt estoy entrando por Management Studio como Administrador anexo el DBCC

7 REPLIES 7
Read only

S_Sriram
Active Contributor
0 Likes
2,636
  • SAP Managed Tags

Hi

Are you log in with administrator or SIDADM privileges in Sql console?

Could you share the deatils error message

Regards

SS

Read only

former_member299313
Participant
0 Likes
2,636
  • SAP Managed Tags

dbcc-check.txt estoy entrando por Management Studio como Administrador anexo el DBCC

Read only

S_Sriram
Active Contributor
0 Likes
2,636
  • SAP Managed Tags

Hi Noah

1. If possible, do a restart of the MS SQL server and then try to take the backup. Still, if you are facing the same issue share the error message as a text format attachment.

2. From the DBCC checks Temp DB space is low if possible increase the Temp DB size,

Regards

SS

Read only

0 Likes
2,636
  • SAP Managed Tags

Thanks for your help Sriram, I already did the steps mentioned with Microsoft support, even so I get the same error from the first post.

regards,

Noe

Read only

S_Sriram
Active Contributor
0 Likes
2,636
  • SAP Managed Tags

Hi Noe

Thanks for your information.

Is this any problem in the local disk c:\ drive or any access permission has been changed in the local disk program or MS SQL folders? the first screenshot shows that unable to read the file from MS SQL folder

Regards

SS

Read only

0 Likes
2,636
  • SAP Managed Tags

Hello Sriram,

no changes have been made in any folder, I have 6 databases and only 1 database is where I have this error, in the SAP system I can open the company of that database without problems, I reiterate Microsoft cannot find the error , my question is if in SAP there is a space limitation since my bd weighs 19GB

thank you for you resquest.

regards,

noé

Read only

S_Sriram
Active Contributor
0 Likes
2,636
  • SAP Managed Tags

Hi Noe.

In SAP, at the database level, if any space crunch, the SAP application will not work all the business transactions are getting the dumps.

In MS SQL DB you have to keep eye on transaction log and temp DB space based on your SAP system.

Regards

SS