| Author |
Topic |
|
savior faire
Posting Yak Master
194 Posts |
 Posted - 2008-06-19 : 07:05:19
|
| Good morning,I am wondering if any of you can give me some help with the practice exercise in the MS Press 70-431 Text, starting on page 671.I am doing this on my personal PC that runs Vista, and am using the Enterprise Edition that comes on the enclosed CD with the book.The instructions for the practice are fairly detailed, however, I completely understand all of it. They have you set up a folder off the C drive, then three subfolders, one of which will store the backups, that you name "LSBackup". You also have to make this subfolder "shared" and give "Everyone" permissions.The configue has you select "Yes, Make a Full Backup, and restore" option. This creates a backup in this shared folder. Then when the process starts to restore the database from this just created backup into one of the other subfolders, the process stops with the following error:"Cannot open backup device '\\HP-PC\LSBackup\LSTesting.bak' Network path not found Error 53"Note "HP-PC" is my computer name that I determined in the System icon in Control Panel. "\\HP-PC\LSBackup" is the network path name entered in one of the text boxes in the exercise.I tried doing a regular restore of the backup file above, using the right click menu and referencing the file via it's path name:"c:\LogShipPractice\LSBackup\LSTesting.bak"; and restoring the DB into the other folder and it works fine.The LSBackup share folder shows on Windows Explorer off the Network Node.Go easy on me guys, I am not a tech support/engineer... I do systems development work. I may have missed something obvious to many of you somewhere along the line.Any suggestions/help will be well appreciated.Thanks!Talk sense to a fool and he calls you foolish. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-06-19 : 07:34:48
|
| As this is local, I am guessing that your SQL Agent account is under local system account and is refusing the connection due to you using a UNC path to the directory, especially with Vistas security model.Set this to a account you create with the correct permissions and it should work fine.When you are running a backup yourself, it is running under your security credentials, so this is the difference. |
 |
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2008-06-19 : 07:39:02
|
| Thanks for the response.The UNC path seems to be required, though this is a practice exercise in an MS Press Book. Anyway, I think I will try this at work, where I have access to a network drive...Talk sense to a fool and he calls you foolish. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-06-19 : 07:46:34
|
| Yeah, it is, but you have to remember, this is usually done with a Windows 2003 Server security model where the SQL Agent account will generally be a domain user account with access to the required directories.As I said, change this account (you'll probably have to create a new user), give it the access required and it should work fine. |
|
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2008-06-19 : 07:53:49
|
quote:
Yeah, it is, but you have to remember, this is usually done with a Windows 2003 Server security model where the SQL Agent account will generally be a domain user account with access to the required directories.
Yes, got it. Doing this through the GUI interface.quote:
As I said, change this account (you'll probably have to create a new user), give it the access required and it should work fine.
The "backup" part works fine. Access to the folder is "shared for Everyone". And I'm using sysadmin privileges, which is the default in this scenario.Thanks for the reply.Talk sense to a fool and he calls you foolish. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-06-19 : 08:38:44
|
| Yes, YOU are using sysadmin privledges, but the SQL Agent account probably is not.Go to the SQL Server Configuration Manager, find your SQL Server Agent, right click and check the properties. If it says localsystem account, then you will have no access, you need to change that to use This account. Then you need to set that to a user with the correct rights. |
|
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2008-06-19 : 09:08:27
|
| Thanks Rick, I shall do this when I get home tonight! Appreciate the advice/suggestions!Actually, I just checked the configuration I have installed here in the office(yeah, studying on company time...LOL), SQL Server Agent is "stopped"... I'm a betting man, I bet SQL Agent is stopped on my PC at home....Talk sense to a fool and he calls you foolish. |
|
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2008-06-20 : 07:16:22
|
| If anyone can help... this is still not working. While attempting to restore the database, it still says it cannot find the backup device.I have SQL Agent running, and tried with Local Service and Network credentials(right clicked, in SQL Confige Manager).I'm not sure what the issue is? Very frustrating...Thanks....Talk sense to a fool and he calls you foolish. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-20 : 23:06:02
|
| You have to start sql agent with domain account and give it permission to access file share \\HP-PC\LSBackup. |
|
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2008-06-22 : 13:06:04
|
| You have to start sql agent with domain account and give it permission to access file share \\HP-PC\LSBackup.Thanks for replying.I can assign two "rights", "Local Service" and "Network Service" to SQL Agent. These are what come up in SSCM, on the properties dialog. I'm running this on my home PC that runs Vista. I don't understand why the "backup" process operates okay and can access and write to the file share folder. I have the folder setup so "everyone" can access.Other than the above, I'm not certain what to do.Thanks.Talk sense to a fool and he calls you foolish. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-22 : 16:57:59
|
| You can assign other domain or local account for sql agent service. Do you log shipping to db on same instance? If so, don't need unc path for backup files. |
|
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2008-06-23 : 15:54:54
|
| You can assign other domain or local account for sql agent service. Do you log shipping to db on same instance? If so, don't need unc path for backup files.--------------------------------------------------------------------I am following the example practice in the ms press book and doing it on a single server instance, using two separate db's. I did notice that the Log Shipping Wizard requires a unc path, and "complains" when you do not enter a properly constructed path.Talk sense to a fool and he calls you foolish. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-23 : 22:36:41
|
| Then how did you create file share LSBackup on \\HP-PC? |
|
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2008-06-25 : 07:20:47
|
| Then how did you create file share LSBackup on \\HP-PC?-----------------------------------------------------------------In Windows Explorer, I created the folders specified, the for the folder LSBackup, I right clicked it, and selected the item "Share...", and followed the menus and instructions. This folder also shows up in the Network Node in Windows ExplorerTalk sense to a fool and he calls you foolish. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-27 : 23:16:34
|
| Did you set permission properly for the share? |
|
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2008-07-01 : 07:55:19
|
| Did you set permission properly for the share?-----------------------------------------------I believe so. The backup task places the files in the folder, yet the copy task cannot access the folder.Talk sense to a fool and he calls you foolish. |
|
|
|
|
Log Shipping Example in MS Press Book