• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 989
  • Last Modified:

Access Denied Error Message When Modify Backup Path

Hi,

I want to backup several databases on the live server so I can restore to another server in a test environment. I want to backup since I cannot stop the real database to copy it because its in production.
I right click the database under databases. Select "Backup" then at the bottom where it says desktionation, it lists a non-existent path such as \ABSupport.bak If I use that it says the path doesnt exist. If I click remove on it, I can, but when I click add it says "Property BackupDirectory is not available for Settings 'Microsoft.SqlServer.Management.Smo.Settings'. This property may not exist for this object, or may not be retrievable due to insufficient access rights.  (Microsoft.SqlServer.Express.Smo)"

I am able to backup several of the other databases that for some reason point to a valid path, I just rename them after it backups.

I am logged in as the domain admin, so im out of things to check. What can cause this?
0
borgmember
Asked:
borgmember
  • 3
  • 3
1 Solution
 
St3veMaxCommented:
try:

BACKUP DATABASE <NAME> TO DISK = 'C:\MyBackup.BAK' WITH COPY_ONLY, STATS = 10

This will create a Copy_Only backup; meaning if you have a 3rd party application such as Backup Exec taking care of your backups; it wont interrupt the sequence and leave you in a bad place if you need to restore it later.

You will need to use the command line to restore; as copy_only backups cant be restored via the GUI for some reason I've yet to look into.

To restore:

RESTORE FILELISTONLY FROM DISK = 'C:\YourBackupFile.bak'

Make a note of the names of the files inside the backup; then:

RESTORE DATABASE <NAME> FROM DISK = 'C:\YourBackupFile.bak'
WITH
MOVE '<LogicalName>' TO 'C:\Microsoft....\MyDatafile.mdf'
,MOVE '<LogicalName>' TO 'C:\Microsoft...\MyLogFile.ldf'
,REPLACE <- If you're overwriting an existing database
,STATS = 10

GO

HTH
0
 
borgmemberAuthor Commented:
Where/how can I enter those commands?
0
 
St3veMaxCommented:
via SQL Server Management Studio, Open up a new query window.
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
borgmemberAuthor Commented:
I entered that command and get the error:

Msg 155, Level 15, State 1, Line 1
'COPY_ONLY' is not a recognized BACKUP option.
0
 
St3veMaxCommented:
That would suggest you're using SQL Express? If so; just remove the COPY_ONLY option.

HTH
0
 
borgmemberAuthor Commented:
Removing the "Copy_Only" made it work with express on one system and the non express on the other. Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now