Log Shipping Error

After studying Log Shipping last week and reading up on it, it appears to be
the best solution for us. I am using to test servers to get it up and
running before releasing it to production.
I upgraded both servers from Standard to Enterprise edition. This allows me
the capabilities of using the DB Maint. Wizard to setup Log Shipping.
However, in setting it up, I am now encountering errors. I have researched
the errors on MS website but to no avail. Here is what I am doing and
getting:
1) I step through the Wizard as discussed in
http://msdn.microsoft.com/library/de...erver_8elj.asp
2) Upon finishing the wizrd I receive the error: "Unable to copy the
initialization file to \\SOURCE\data\file.bak"
Does anyone have any ideas on this? I have provided detailed steps below as
to my wizard selections.
Thanks,
Marty
Wizard:
1) Right clicked on the database on the SOURCE server.
2) Chose DB Maint. Plan
3) Clicked Next
4) Chose my DB then checked the Log Shipping option
5) Clicked Next
6) Clicked Next until the Specify the Transaction Log Share screen came up.
In this field I chose \\SOURCE\data
7) Clicked Next
8) Clicked ADD to add log shipping destination.
9) Chose the DESTINATION server.
10) Clicked OK
11) Clicked Next
12) Chose User Most Recent Backup File \\SOURCE\data\file.bak clicked Next
13) Clicked Next to the end
14) Clicked Finish
15) Error "Unable to Copy...\\SOURCE\data\file.bak" as mentioned above.
I tried with different login options and nothing works. When I tried it with
PERFORM A FULL DATABASE BACKUP NOW on step 12, I receive this error at the
end: "ERROR 3201: Cannot open Backup device '\\SOURCE\data\file.bak'. Device
error or device off-line. See the SQL Server error log for more details.
BACKUP DATABASE is terminating abnormally."
have a look at kb article 811890.
You also don't need the Enterprise Edition to do log shipping. SQL Server EE
has a log shipping wizard but you can roll your own. Here is a link to an
article which talks about how to do this:
http://www.sql-server-performance.co...g_shipping.asp
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"M.Smith" <martys@.bennyhinn.org> wrote in message
news:ez1%23RkKKFHA.724@.TK2MSFTNGP10.phx.gbl...
> After studying Log Shipping last week and reading up on it, it appears to
be
> the best solution for us. I am using to test servers to get it up and
> running before releasing it to production.
> I upgraded both servers from Standard to Enterprise edition. This allows
me
> the capabilities of using the DB Maint. Wizard to setup Log Shipping.
> However, in setting it up, I am now encountering errors. I have researched
> the errors on MS website but to no avail. Here is what I am doing and
> getting:
> 1) I step through the Wizard as discussed in
>
http://msdn.microsoft.com/library/de...erver_8elj.asp
> 2) Upon finishing the wizrd I receive the error: "Unable to copy the
> initialization file to \\SOURCE\data\file.bak"
> Does anyone have any ideas on this? I have provided detailed steps below
as
> to my wizard selections.
> Thanks,
> Marty
> Wizard:
> 1) Right clicked on the database on the SOURCE server.
> 2) Chose DB Maint. Plan
> 3) Clicked Next
> 4) Chose my DB then checked the Log Shipping option
> 5) Clicked Next
> 6) Clicked Next until the Specify the Transaction Log Share screen came
up.
> In this field I chose \\SOURCE\data
> 7) Clicked Next
> 8) Clicked ADD to add log shipping destination.
> 9) Chose the DESTINATION server.
> 10) Clicked OK
> 11) Clicked Next
> 12) Chose User Most Recent Backup File \\SOURCE\data\file.bak clicked Next
> 13) Clicked Next to the end
> 14) Clicked Finish
> 15) Error "Unable to Copy...\\SOURCE\data\file.bak" as mentioned above.
> I tried with different login options and nothing works. When I tried it
with
> PERFORM A FULL DATABASE BACKUP NOW on step 12, I receive this error at the
> end: "ERROR 3201: Cannot open Backup device '\\SOURCE\data\file.bak'.
Device
> error or device off-line. See the SQL Server error log for more details.
> BACKUP DATABASE is terminating abnormally."
>
|||Thanks for the response Hilary...Acutally I have already read both of those
articles :-) I started my research with the one at sql-server-performance
and after researching thought that the wizard in EE would be easier.
So, I will step back and try to do it manually and see how that turns out.
Thanks again,
Marty
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:ecNEp4KKFHA.1172@.TK2MSFTNGP12.phx.gbl...
> have a look at kb article 811890.
> You also don't need the Enterprise Edition to do log shipping. SQL Server
> EE
> has a log shipping wizard but you can roll your own. Here is a link to an
> article which talks about how to do this:
> http://www.sql-server-performance.co...g_shipping.asp
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "M.Smith" <martys@.bennyhinn.org> wrote in message
> news:ez1%23RkKKFHA.724@.TK2MSFTNGP10.phx.gbl...
> be
> me
> http://msdn.microsoft.com/library/de...erver_8elj.asp
> as
> up.
> with
> Device
>