| Author |
Topic |
|
Pruffty
Starting Member
14 Posts |
 Posted - 2012-06-26 : 13:48:53
|
| I have my backups stored on another server. I would like to check the backups and whether they ran successfully by running the following query:Restore verifyonly from disk = `path\name.bakMy backups are on the network drive as follows:\\<servername>\SQLbackups\<servername>\application_backup_2012.bak.This is what I see when I go into SQL Management Studio and search for backups. That is the path it is being backed up to.How would I input this into the query?Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Pruffty
Starting Member
14 Posts |
Posted - 2012-06-26 : 15:27:22
|
| Hi Tara,Yes, I`ve heard about restore verifyonly not being complete. Sadly, the syntax you gave me did not work to verify a backup saved to a remote drive :( |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Pruffty
Starting Member
14 Posts |
Posted - 2012-06-26 : 16:06:07
|
| Here it is:restore verifyonly from disk = '\\storeserver\SQLbkups\firstserver\EventReports_backup_201206260200.bak'Error message as follows:Msg 3201, Level 16, State 2, Line 1Cannot open backup device '\\storeserver\SQLbkups\\firstserver\PuddingPlans_backup_201206260200.bak'. Operating system error 2(failed to retrieve text for this error. Reason: 15105).Msg 3013, Level 16, State 1, Line 1VERIFY DATABASE is terminating abnormally. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Pruffty
Starting Member
14 Posts |
Posted - 2012-06-27 : 14:48:23
|
| Tara:putting the syntax into the start - run didn't work.Says:Windows cannot find 'restore'. Make sure you typed the name correctly, and then try again.So...I have rdp'd to the server where the backups are saved.I ran query analyzer on the actual server (no Management Studio is installed). syntax is as follows: restore verifyonly from DISK = 'Y:\ServerBkps\appserver\fly_bkup_2012.bak'I am getting error:Server: Msg 3201, Level 16, State 2, Line 1Cannot open backup device <Pathname>'. Operating system error 3(failed to retrieve text for this error.Server: Msg 3013, Level 16, State 1, Line 1VERIFY DATABASE is terminating abnormally.There are adequate permissions on the folder that the backups are being sent to.Under security, the sql service account is added with up to modify and the sql server account is also added.Not sure why it is not working.Please advise. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Pruffty
Starting Member
14 Posts |
Posted - 2012-06-27 : 15:06:05
|
| It works on both the server (local path) and remotely (UNC).I get the windows cannot open this file obviously since it is only readable by SQL server but it does take me there.So the path works..gahh! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Pruffty
Starting Member
14 Posts |
Posted - 2012-06-27 : 15:59:40
|
| No spaces in the path. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Pruffty
Starting Member
14 Posts |
Posted - 2012-07-03 : 14:28:31
|
Hi Tara,I finally figured it out last Thursday but I had other issues crop up and I felt like slapping myself when I did. I missed the semi colon at the end after the word 'bak'. It should have been 'bak'; |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
Restore verifyonly on mapped network drive