• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 985
  • 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

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