question

ankitpanwar avatar image
ankitpanwar asked

Database is unauthenticated to restore back-up.

I have run this script Step:1 sp_configure 'contained database authentication', 1; GO RECONFIGURE; GO Step:2 BACKUP DATABASE DataBaseName TO DISK = 'DataBaseName Path (Local Drive)' GO BACKUP LOG DataBaseName TO DISK = 'DataBaseName Path (Local Drive)' GO
sql-server-2012backup
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

What error message are you getting If you're restoring to a different instance of SQL Server, have you run that step 1 ('sp_configure') on the server you're restoring to? Your question doesn't make it clear.
1 Like 1 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.