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?
borgmemberAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
borgmemberAuthor Commented:
Removing the "Copy_Only" made it work with express on one system and the non express on the other. Thanks!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.