"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.com/sql_server_log_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/default.asp?url=/library/en-us/adminsql/ad_1_server_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."
>>
>>
>
>

"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/default.asp?url=/library/en-us/adminsql/ad_1_server_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."
>
>