I have TWO networked servers; one production, and one backup. I want to be
able to use the backup in case of a production server failure. The loss of
a "little" data is acceptable in case of failure. Log Shipping looks like
the easiest but there seems to be a lot of warnings about (1) having a
monitor server, and (2) having this server NOT be either the production
server nor the backup. I only have two servers so I can't do this.
Is Log Shipping the best solution? Also--and this might affect your
response--it is possible that the backup system might not be available 100%
of the time. I bring this up because I don't know what will happen if the
production system wants to ship a log, and the backup computer isn't
available to accept it. (')
Any help, recommendations?
TIA,
Larry WoodsLog shipping is the best option. You don't really need a monitoring server.
You could write your own logshipping scripts, customised for your
requirements. If you search this newsgroup archive, you will find some
scripts. Also checkout sql-server-performance.com
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Larry Woods" <larry@.lwoods.com> wrote in message
news:%23ljrQh13DHA.3216@.TK2MSFTNGP11.phx.gbl...
I have TWO networked servers; one production, and one backup. I want to be
able to use the backup in case of a production server failure. The loss of
a "little" data is acceptable in case of failure. Log Shipping looks like
the easiest but there seems to be a lot of warnings about (1) having a
monitor server, and (2) having this server NOT be either the production
server nor the backup. I only have two servers so I can't do this.
Is Log Shipping the best solution? Also--and this might affect your
response--it is possible that the backup system might not be available 100%
of the time. I bring this up because I don't know what will happen if the
production system wants to ship a log, and the backup computer isn't
available to accept it. (')
Any help, recommendations?
TIA,
Larry Woods|||Follow up question--I am NOT an SQL Server expert, by the way. I am trying
some tests using Log Shipping. The database does NOT exist on the backup
server. When I run the Maintenance Plan (last step) I immediately get a
"access denied" as follows:
BackupDiskFile::CreateMedia: Backup device 'G:\DummyDB_logshipping_init.bak'
failed to create. Operating system error = 5(Access is denied.).
I am running under Adminstrator and both servers use the same password for
Administrator. The "G" drive has Adminstrator permissions. BTW, "G" is a
folder on the backup server. Here is an earlier attempt:
BackupDiskFile::CreateMedia: Backup device
'\\2kdotnet\TransactionLogs_102\DummyDB_logshipping_init.bak' failed to
create. Operating system error = 5(Access is denied.).
Any help here?
TIA,
Larry Woods
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23C9OFl13DHA.1652@.TK2MSFTNGP11.phx.gbl...
> Log shipping is the best option. You don't really need a monitoring
server.
> You could write your own logshipping scripts, customised for your
> requirements. If you search this newsgroup archive, you will find some
> scripts. Also checkout sql-server-performance.com
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
> "Larry Woods" <larry@.lwoods.com> wrote in message
> news:%23ljrQh13DHA.3216@.TK2MSFTNGP11.phx.gbl...
> I have TWO networked servers; one production, and one backup. I want to
be
> able to use the backup in case of a production server failure. The loss
of
> a "little" data is acceptable in case of failure. Log Shipping looks like
> the easiest but there seems to be a lot of warnings about (1) having a
> monitor server, and (2) having this server NOT be either the production
> server nor the backup. I only have two servers so I can't do this.
> Is Log Shipping the best solution? Also--and this might affect your
> response--it is possible that the backup system might not be available
100%
> of the time. I bring this up because I don't know what will happen if the
> production system wants to ship a log, and the backup computer isn't
> available to accept it. (')
> Any help, recommendations?
> TIA,
> Larry Woods
>
>|||Make sure the SQL Server and SQL Agent service accounts have permissions to
the share 2kdotnet\TransactionLogs_102\
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Larry Woods" <larry@.lwoods.com> wrote in message
news:ujeGis13DHA.3196@.TK2MSFTNGP11.phx.gbl...
Follow up question--I am NOT an SQL Server expert, by the way. I am trying
some tests using Log Shipping. The database does NOT exist on the backup
server. When I run the Maintenance Plan (last step) I immediately get a
"access denied" as follows:
BackupDiskFile::CreateMedia: Backup device 'G:\DummyDB_logshipping_init.bak'
failed to create. Operating system error = 5(Access is denied.).
I am running under Adminstrator and both servers use the same password for
Administrator. The "G" drive has Adminstrator permissions. BTW, "G" is a
folder on the backup server. Here is an earlier attempt:
BackupDiskFile::CreateMedia: Backup device
'\\2kdotnet\TransactionLogs_102\DummyDB_logshipping_init.bak' failed to
create. Operating system error = 5(Access is denied.).
Any help here?
TIA,
Larry Woods
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23C9OFl13DHA.1652@.TK2MSFTNGP11.phx.gbl...
> Log shipping is the best option. You don't really need a monitoring
server.
> You could write your own logshipping scripts, customised for your
> requirements. If you search this newsgroup archive, you will find some
> scripts. Also checkout sql-server-performance.com
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
> "Larry Woods" <larry@.lwoods.com> wrote in message
> news:%23ljrQh13DHA.3216@.TK2MSFTNGP11.phx.gbl...
> I have TWO networked servers; one production, and one backup. I want to
be
> able to use the backup in case of a production server failure. The loss
of
> a "little" data is acceptable in case of failure. Log Shipping looks like
> the easiest but there seems to be a lot of warnings about (1) having a
> monitor server, and (2) having this server NOT be either the production
> server nor the backup. I only have two servers so I can't do this.
> Is Log Shipping the best solution? Also--and this might affect your
> response--it is possible that the backup system might not be available
100%
> of the time. I bring this up because I don't know what will happen if the
> production system wants to ship a log, and the backup computer isn't
> available to accept it. (')
> Any help, recommendations?
> TIA,
> Larry Woods
>
>|||Hi Larry,
Log Shipping is the ultimate solution if you are on SQL
Server Enterprise Edition. Follow these Resources..
Log Shipping in SQL Server 2000 - Part 1
http://www.microsoft.com/technet/treeview/default.asp?
url=/technet/prodtechnol/sql/deploy/prodspecs/logship1.asp
Log Shipping in SQL Server 2000 - Part 2
http://www.microsoft.com/technet/treeview/default.asp?
url=/technet/prodtechnol/sql/deploy/prodspecs/logship1.asp
How to Perform SQL Server Log Shipping
http://www.sql-server-
performance.com/sql_server_log_shipping.asp
HTH
--
THIRUMAL REDDY MARAM
Sys Amin / SQL DBA
>--Original Message--
>I have TWO networked servers; one production, and one
backup. I want to be
>able to use the backup in case of a production server
failure. The loss of
>a "little" data is acceptable in case of failure. Log
Shipping looks like
>the easiest but there seems to be a lot of warnings about
(1) having a
>monitor server, and (2) having this server NOT be either
the production
>server nor the backup. I only have two servers so I
can't do this.
>Is Log Shipping the best solution? Also--and this might
affect your
>response--it is possible that the backup system might
not be available 100%
>of the time. I bring this up because I don't know what
will happen if the
>production system wants to ship a log, and the backup
computer isn't
>available to accept it. (')
>Any help, recommendations?
>TIA,
>Larry Woods
>
>.
>|||Getting further. I changed my service account to Administrator and now I
was able to dump the logshipping file into the backup server...then it
crashed on the second step, Initializing Destination, with the error:
Unable to copy the initialization file to the secondary server '2KDOTNET'
(Permissions will be the death of me yet!)
Any ideas?
TIA,
Larry Woods
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:OtAFlz13DHA.3468@.TK2MSFTNGP11.phx.gbl...
> Make sure the SQL Server and SQL Agent service accounts have permissions
to
> the share 2kdotnet\TransactionLogs_102\
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
> "Larry Woods" <larry@.lwoods.com> wrote in message
> news:ujeGis13DHA.3196@.TK2MSFTNGP11.phx.gbl...
> Follow up question--I am NOT an SQL Server expert, by the way. I am
trying
> some tests using Log Shipping. The database does NOT exist on the backup
> server. When I run the Maintenance Plan (last step) I immediately get a
> "access denied" as follows:
> BackupDiskFile::CreateMedia: Backup device
'G:\DummyDB_logshipping_init.bak'
> failed to create. Operating system error = 5(Access is denied.).
> I am running under Adminstrator and both servers use the same password for
> Administrator. The "G" drive has Adminstrator permissions. BTW, "G" is
a
> folder on the backup server. Here is an earlier attempt:
> BackupDiskFile::CreateMedia: Backup device
> '\\2kdotnet\TransactionLogs_102\DummyDB_logshipping_init.bak' failed to
> create. Operating system error = 5(Access is denied.).
> Any help here?
> TIA,
> Larry Woods
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:%23C9OFl13DHA.1652@.TK2MSFTNGP11.phx.gbl...
> > Log shipping is the best option. You don't really need a monitoring
> server.
> > You could write your own logshipping scripts, customised for your
> > requirements. If you search this newsgroup archive, you will find some
> > scripts. Also checkout sql-server-performance.com
> >
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> > Is .NET important for a database professional?
> > http://vyaskn.tripod.com/poll.htm
> >
> >
> > "Larry Woods" <larry@.lwoods.com> wrote in message
> > news:%23ljrQh13DHA.3216@.TK2MSFTNGP11.phx.gbl...
> > I have TWO networked servers; one production, and one backup. I want to
> be
> > able to use the backup in case of a production server failure. The loss
> of
> > a "little" data is acceptable in case of failure. Log Shipping looks
like
> > the easiest but there seems to be a lot of warnings about (1) having a
> > monitor server, and (2) having this server NOT be either the production
> > server nor the backup. I only have two servers so I can't do this.
> >
> > Is Log Shipping the best solution? Also--and this might affect your
> > response--it is possible that the backup system might not be available
> 100%
> > of the time. I bring this up because I don't know what will happen if
the
> > production system wants to ship a log, and the backup computer isn't
> > available to accept it. (')
> >
> > Any help, recommendations?
> >
> > TIA,
> >
> > Larry Woods
> >
> >
> >
>
>|||Hmm...I am not sure about that error. Haven't used built-in logshipping
before, sorry. You could try searching on that error message at:
http://groups.google.com and http://support.microsoft.com
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Larry Woods" <larry@.lwoods.com> wrote in message
news:OpACCO23DHA.488@.TK2MSFTNGP12.phx.gbl...
Getting further. I changed my service account to Administrator and now I
was able to dump the logshipping file into the backup server...then it
crashed on the second step, Initializing Destination, with the error:
Unable to copy the initialization file to the secondary server '2KDOTNET'
(Permissions will be the death of me yet!)
Any ideas?
TIA,
Larry Woods
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:OtAFlz13DHA.3468@.TK2MSFTNGP11.phx.gbl...
> Make sure the SQL Server and SQL Agent service accounts have permissions
to
> the share 2kdotnet\TransactionLogs_102\
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
> "Larry Woods" <larry@.lwoods.com> wrote in message
> news:ujeGis13DHA.3196@.TK2MSFTNGP11.phx.gbl...
> Follow up question--I am NOT an SQL Server expert, by the way. I am
trying
> some tests using Log Shipping. The database does NOT exist on the backup
> server. When I run the Maintenance Plan (last step) I immediately get a
> "access denied" as follows:
> BackupDiskFile::CreateMedia: Backup device
'G:\DummyDB_logshipping_init.bak'
> failed to create. Operating system error = 5(Access is denied.).
> I am running under Adminstrator and both servers use the same password for
> Administrator. The "G" drive has Adminstrator permissions. BTW, "G" is
a
> folder on the backup server. Here is an earlier attempt:
> BackupDiskFile::CreateMedia: Backup device
> '\\2kdotnet\TransactionLogs_102\DummyDB_logshipping_init.bak' failed to
> create. Operating system error = 5(Access is denied.).
> Any help here?
> TIA,
> Larry Woods
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:%23C9OFl13DHA.1652@.TK2MSFTNGP11.phx.gbl...
> > Log shipping is the best option. You don't really need a monitoring
> server.
> > You could write your own logshipping scripts, customised for your
> > requirements. If you search this newsgroup archive, you will find some
> > scripts. Also checkout sql-server-performance.com
> >
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> > Is .NET important for a database professional?
> > http://vyaskn.tripod.com/poll.htm
> >
> >
> > "Larry Woods" <larry@.lwoods.com> wrote in message
> > news:%23ljrQh13DHA.3216@.TK2MSFTNGP11.phx.gbl...
> > I have TWO networked servers; one production, and one backup. I want to
> be
> > able to use the backup in case of a production server failure. The loss
> of
> > a "little" data is acceptable in case of failure. Log Shipping looks
like
> > the easiest but there seems to be a lot of warnings about (1) having a
> > monitor server, and (2) having this server NOT be either the production
> > server nor the backup. I only have two servers so I can't do this.
> >
> > Is Log Shipping the best solution? Also--and this might affect your
> > response--it is possible that the backup system might not be available
> 100%
> > of the time. I bring this up because I don't know what will happen if
the
> > production system wants to ship a log, and the backup computer isn't
> > available to accept it. (')
> >
> > Any help, recommendations?
> >
> > TIA,
> >
> > Larry Woods
> >
> >
> >
>
>|||So, you use TSQL? If so, can you point me to any sources?
Thanks.
Larry
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:uR2TeP23DHA.2428@.tk2msftngp13.phx.gbl...
> Hmm...I am not sure about that error. Haven't used built-in logshipping
> before, sorry. You could try searching on that error message at:
> http://groups.google.com and http://support.microsoft.com
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
> "Larry Woods" <larry@.lwoods.com> wrote in message
> news:OpACCO23DHA.488@.TK2MSFTNGP12.phx.gbl...
> Getting further. I changed my service account to Administrator and now I
> was able to dump the logshipping file into the backup server...then it
> crashed on the second step, Initializing Destination, with the error:
> Unable to copy the initialization file to the secondary server '2KDOTNET'
> (Permissions will be the death of me yet!)
> Any ideas?
> TIA,
> Larry Woods
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:OtAFlz13DHA.3468@.TK2MSFTNGP11.phx.gbl...
> > Make sure the SQL Server and SQL Agent service accounts have permissions
> to
> > the share 2kdotnet\TransactionLogs_102\
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> > Is .NET important for a database professional?
> > http://vyaskn.tripod.com/poll.htm
> >
> >
> > "Larry Woods" <larry@.lwoods.com> wrote in message
> > news:ujeGis13DHA.3196@.TK2MSFTNGP11.phx.gbl...
> > Follow up question--I am NOT an SQL Server expert, by the way. I am
> trying
> > some tests using Log Shipping. The database does NOT exist on the
backup
> > server. When I run the Maintenance Plan (last step) I immediately get a
> > "access denied" as follows:
> >
> > BackupDiskFile::CreateMedia: Backup device
> 'G:\DummyDB_logshipping_init.bak'
> > failed to create. Operating system error = 5(Access is denied.).
> >
> > I am running under Adminstrator and both servers use the same password
for
> > Administrator. The "G" drive has Adminstrator permissions. BTW, "G"
is
> a
> > folder on the backup server. Here is an earlier attempt:
> >
> > BackupDiskFile::CreateMedia: Backup device
> > '\\2kdotnet\TransactionLogs_102\DummyDB_logshipping_init.bak' failed to
> > create. Operating system error = 5(Access is denied.).
> >
> > Any help here?
> >
> > TIA,
> >
> > Larry Woods
> >
> > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > news:%23C9OFl13DHA.1652@.TK2MSFTNGP11.phx.gbl...
> > > Log shipping is the best option. You don't really need a monitoring
> > server.
> > > You could write your own logshipping scripts, customised for your
> > > requirements. If you search this newsgroup archive, you will find some
> > > scripts. Also checkout sql-server-performance.com
> > >
> > > --
> > > HTH,
> > > Vyas, MVP (SQL Server)
> > > http://vyaskn.tripod.com/
> > > Is .NET important for a database professional?
> > > http://vyaskn.tripod.com/poll.htm
> > >
> > >
> > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > news:%23ljrQh13DHA.3216@.TK2MSFTNGP11.phx.gbl...
> > > I have TWO networked servers; one production, and one backup. I want
to
> > be
> > > able to use the backup in case of a production server failure. The
loss
> > of
> > > a "little" data is acceptable in case of failure. Log Shipping looks
> like
> > > the easiest but there seems to be a lot of warnings about (1) having a
> > > monitor server, and (2) having this server NOT be either the
production
> > > server nor the backup. I only have two servers so I can't do this.
> > >
> > > Is Log Shipping the best solution? Also--and this might affect your
> > > response--it is possible that the backup system might not be
available
> > 100%
> > > of the time. I bring this up because I don't know what will happen if
> the
> > > production system wants to ship a log, and the backup computer isn't
> > > available to accept it. (')
> > >
> > > Any help, recommendations?
> > >
> > > TIA,
> > >
> > > Larry Woods
> > >
> > >
> > >
> >
> >
> >
>
>|||Here's one example:
http://www.sql-server-performance.com/sql_server_log_shipping.asp
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Larry Woods" <larry@.lwoods.com> wrote in message
news:%23YDBUf23DHA.1804@.TK2MSFTNGP12.phx.gbl...
So, you use TSQL? If so, can you point me to any sources?
Thanks.
Larry
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:uR2TeP23DHA.2428@.tk2msftngp13.phx.gbl...
> Hmm...I am not sure about that error. Haven't used built-in logshipping
> before, sorry. You could try searching on that error message at:
> http://groups.google.com and http://support.microsoft.com
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
> "Larry Woods" <larry@.lwoods.com> wrote in message
> news:OpACCO23DHA.488@.TK2MSFTNGP12.phx.gbl...
> Getting further. I changed my service account to Administrator and now I
> was able to dump the logshipping file into the backup server...then it
> crashed on the second step, Initializing Destination, with the error:
> Unable to copy the initialization file to the secondary server '2KDOTNET'
> (Permissions will be the death of me yet!)
> Any ideas?
> TIA,
> Larry Woods
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:OtAFlz13DHA.3468@.TK2MSFTNGP11.phx.gbl...
> > Make sure the SQL Server and SQL Agent service accounts have permissions
> to
> > the share 2kdotnet\TransactionLogs_102\
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> > Is .NET important for a database professional?
> > http://vyaskn.tripod.com/poll.htm
> >
> >
> > "Larry Woods" <larry@.lwoods.com> wrote in message
> > news:ujeGis13DHA.3196@.TK2MSFTNGP11.phx.gbl...
> > Follow up question--I am NOT an SQL Server expert, by the way. I am
> trying
> > some tests using Log Shipping. The database does NOT exist on the
backup
> > server. When I run the Maintenance Plan (last step) I immediately get a
> > "access denied" as follows:
> >
> > BackupDiskFile::CreateMedia: Backup device
> 'G:\DummyDB_logshipping_init.bak'
> > failed to create. Operating system error = 5(Access is denied.).
> >
> > I am running under Adminstrator and both servers use the same password
for
> > Administrator. The "G" drive has Adminstrator permissions. BTW, "G"
is
> a
> > folder on the backup server. Here is an earlier attempt:
> >
> > BackupDiskFile::CreateMedia: Backup device
> > '\\2kdotnet\TransactionLogs_102\DummyDB_logshipping_init.bak' failed to
> > create. Operating system error = 5(Access is denied.).
> >
> > Any help here?
> >
> > TIA,
> >
> > Larry Woods
> >
> > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > news:%23C9OFl13DHA.1652@.TK2MSFTNGP11.phx.gbl...
> > > Log shipping is the best option. You don't really need a monitoring
> > server.
> > > You could write your own logshipping scripts, customised for your
> > > requirements. If you search this newsgroup archive, you will find some
> > > scripts. Also checkout sql-server-performance.com
> > >
> > > --
> > > HTH,
> > > Vyas, MVP (SQL Server)
> > > http://vyaskn.tripod.com/
> > > Is .NET important for a database professional?
> > > http://vyaskn.tripod.com/poll.htm
> > >
> > >
> > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > news:%23ljrQh13DHA.3216@.TK2MSFTNGP11.phx.gbl...
> > > I have TWO networked servers; one production, and one backup. I want
to
> > be
> > > able to use the backup in case of a production server failure. The
loss
> > of
> > > a "little" data is acceptable in case of failure. Log Shipping looks
> like
> > > the easiest but there seems to be a lot of warnings about (1) having a
> > > monitor server, and (2) having this server NOT be either the
production
> > > server nor the backup. I only have two servers so I can't do this.
> > >
> > > Is Log Shipping the best solution? Also--and this might affect your
> > > response--it is possible that the backup system might not be
available
> > 100%
> > > of the time. I bring this up because I don't know what will happen if
> the
> > > production system wants to ship a log, and the backup computer isn't
> > > available to accept it. (')
> > >
> > > Any help, recommendations?
> > >
> > > TIA,
> > >
> > > Larry Woods
> > >
> > >
> > >
> >
> >
> >
>
>|||Just in the process of reading this one. Thanks. Also, one of my earlier
questions was: What happens if the backup server is down when the Log
Shipping want to take place? (Sorry if this is covered in the article. I
haven't gotten that far).
Larry
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23Orcon23DHA.3936@.TK2MSFTNGP11.phx.gbl...
> Here's one example:
> http://www.sql-server-performance.com/sql_server_log_shipping.asp
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
> "Larry Woods" <larry@.lwoods.com> wrote in message
> news:%23YDBUf23DHA.1804@.TK2MSFTNGP12.phx.gbl...
> So, you use TSQL? If so, can you point me to any sources?
> Thanks.
> Larry
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:uR2TeP23DHA.2428@.tk2msftngp13.phx.gbl...
> > Hmm...I am not sure about that error. Haven't used built-in logshipping
> > before, sorry. You could try searching on that error message at:
> > http://groups.google.com and http://support.microsoft.com
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> > Is .NET important for a database professional?
> > http://vyaskn.tripod.com/poll.htm
> >
> >
> > "Larry Woods" <larry@.lwoods.com> wrote in message
> > news:OpACCO23DHA.488@.TK2MSFTNGP12.phx.gbl...
> > Getting further. I changed my service account to Administrator and now
I
> > was able to dump the logshipping file into the backup server...then it
> > crashed on the second step, Initializing Destination, with the error:
> >
> > Unable to copy the initialization file to the secondary server
'2KDOTNET'
> >
> > (Permissions will be the death of me yet!)
> >
> > Any ideas?
> >
> > TIA,
> >
> > Larry Woods
> >
> > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > news:OtAFlz13DHA.3468@.TK2MSFTNGP11.phx.gbl...
> > > Make sure the SQL Server and SQL Agent service accounts have
permissions
> > to
> > > the share 2kdotnet\TransactionLogs_102\
> > > --
> > > HTH,
> > > Vyas, MVP (SQL Server)
> > > http://vyaskn.tripod.com/
> > > Is .NET important for a database professional?
> > > http://vyaskn.tripod.com/poll.htm
> > >
> > >
> > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > news:ujeGis13DHA.3196@.TK2MSFTNGP11.phx.gbl...
> > > Follow up question--I am NOT an SQL Server expert, by the way. I am
> > trying
> > > some tests using Log Shipping. The database does NOT exist on the
> backup
> > > server. When I run the Maintenance Plan (last step) I immediately get
a
> > > "access denied" as follows:
> > >
> > > BackupDiskFile::CreateMedia: Backup device
> > 'G:\DummyDB_logshipping_init.bak'
> > > failed to create. Operating system error = 5(Access is denied.).
> > >
> > > I am running under Adminstrator and both servers use the same password
> for
> > > Administrator. The "G" drive has Adminstrator permissions. BTW, "G"
> is
> > a
> > > folder on the backup server. Here is an earlier attempt:
> > >
> > > BackupDiskFile::CreateMedia: Backup device
> > > '\\2kdotnet\TransactionLogs_102\DummyDB_logshipping_init.bak' failed
to
> > > create. Operating system error = 5(Access is denied.).
> > >
> > > Any help here?
> > >
> > > TIA,
> > >
> > > Larry Woods
> > >
> > > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > > news:%23C9OFl13DHA.1652@.TK2MSFTNGP11.phx.gbl...
> > > > Log shipping is the best option. You don't really need a monitoring
> > > server.
> > > > You could write your own logshipping scripts, customised for your
> > > > requirements. If you search this newsgroup archive, you will find
some
> > > > scripts. Also checkout sql-server-performance.com
> > > >
> > > > --
> > > > HTH,
> > > > Vyas, MVP (SQL Server)
> > > > http://vyaskn.tripod.com/
> > > > Is .NET important for a database professional?
> > > > http://vyaskn.tripod.com/poll.htm
> > > >
> > > >
> > > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > > news:%23ljrQh13DHA.3216@.TK2MSFTNGP11.phx.gbl...
> > > > I have TWO networked servers; one production, and one backup. I
want
> to
> > > be
> > > > able to use the backup in case of a production server failure. The
> loss
> > > of
> > > > a "little" data is acceptable in case of failure. Log Shipping
looks
> > like
> > > > the easiest but there seems to be a lot of warnings about (1) having
a
> > > > monitor server, and (2) having this server NOT be either the
> production
> > > > server nor the backup. I only have two servers so I can't do this.
> > > >
> > > > Is Log Shipping the best solution? Also--and this might affect
your
> > > > response--it is possible that the backup system might not be
> available
> > > 100%
> > > > of the time. I bring this up because I don't know what will happen
if
> > the
> > > > production system wants to ship a log, and the backup computer isn't
> > > > available to accept it. (')
> > > >
> > > > Any help, recommendations?
> > > >
> > > > TIA,
> > > >
> > > > Larry Woods
> > > >
> > > >
> > > >
> > >
> > >
> > >
> >
> >
> >
>
>|||It depends on the logshipping solution you go with. If your solution is
written to wait and retry, if the target server is down, then it will
eventually continue restoring when the target server comes back up. If it is
not written to do so, you'll have bring back the target server, and restart
the task manually. The backup process should continue on the primary server
though.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Larry Woods" <larry@.lwoods.com> wrote in message
news:OsK0Yr23DHA.1816@.TK2MSFTNGP12.phx.gbl...
Just in the process of reading this one. Thanks. Also, one of my earlier
questions was: What happens if the backup server is down when the Log
Shipping want to take place? (Sorry if this is covered in the article. I
haven't gotten that far).
Larry
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23Orcon23DHA.3936@.TK2MSFTNGP11.phx.gbl...
> Here's one example:
> http://www.sql-server-performance.com/sql_server_log_shipping.asp
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
> "Larry Woods" <larry@.lwoods.com> wrote in message
> news:%23YDBUf23DHA.1804@.TK2MSFTNGP12.phx.gbl...
> So, you use TSQL? If so, can you point me to any sources?
> Thanks.
> Larry
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:uR2TeP23DHA.2428@.tk2msftngp13.phx.gbl...
> > Hmm...I am not sure about that error. Haven't used built-in logshipping
> > before, sorry. You could try searching on that error message at:
> > http://groups.google.com and http://support.microsoft.com
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> > Is .NET important for a database professional?
> > http://vyaskn.tripod.com/poll.htm
> >
> >
> > "Larry Woods" <larry@.lwoods.com> wrote in message
> > news:OpACCO23DHA.488@.TK2MSFTNGP12.phx.gbl...
> > Getting further. I changed my service account to Administrator and now
I
> > was able to dump the logshipping file into the backup server...then it
> > crashed on the second step, Initializing Destination, with the error:
> >
> > Unable to copy the initialization file to the secondary server
'2KDOTNET'
> >
> > (Permissions will be the death of me yet!)
> >
> > Any ideas?
> >
> > TIA,
> >
> > Larry Woods
> >
> > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > news:OtAFlz13DHA.3468@.TK2MSFTNGP11.phx.gbl...
> > > Make sure the SQL Server and SQL Agent service accounts have
permissions
> > to
> > > the share 2kdotnet\TransactionLogs_102\
> > > --
> > > HTH,
> > > Vyas, MVP (SQL Server)
> > > http://vyaskn.tripod.com/
> > > Is .NET important for a database professional?
> > > http://vyaskn.tripod.com/poll.htm
> > >
> > >
> > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > news:ujeGis13DHA.3196@.TK2MSFTNGP11.phx.gbl...
> > > Follow up question--I am NOT an SQL Server expert, by the way. I am
> > trying
> > > some tests using Log Shipping. The database does NOT exist on the
> backup
> > > server. When I run the Maintenance Plan (last step) I immediately get
a
> > > "access denied" as follows:
> > >
> > > BackupDiskFile::CreateMedia: Backup device
> > 'G:\DummyDB_logshipping_init.bak'
> > > failed to create. Operating system error = 5(Access is denied.).
> > >
> > > I am running under Adminstrator and both servers use the same password
> for
> > > Administrator. The "G" drive has Adminstrator permissions. BTW, "G"
> is
> > a
> > > folder on the backup server. Here is an earlier attempt:
> > >
> > > BackupDiskFile::CreateMedia: Backup device
> > > '\\2kdotnet\TransactionLogs_102\DummyDB_logshipping_init.bak' failed
to
> > > create. Operating system error = 5(Access is denied.).
> > >
> > > Any help here?
> > >
> > > TIA,
> > >
> > > Larry Woods
> > >
> > > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > > news:%23C9OFl13DHA.1652@.TK2MSFTNGP11.phx.gbl...
> > > > Log shipping is the best option. You don't really need a monitoring
> > > server.
> > > > You could write your own logshipping scripts, customised for your
> > > > requirements. If you search this newsgroup archive, you will find
some
> > > > scripts. Also checkout sql-server-performance.com
> > > >
> > > > --
> > > > HTH,
> > > > Vyas, MVP (SQL Server)
> > > > http://vyaskn.tripod.com/
> > > > Is .NET important for a database professional?
> > > > http://vyaskn.tripod.com/poll.htm
> > > >
> > > >
> > > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > > news:%23ljrQh13DHA.3216@.TK2MSFTNGP11.phx.gbl...
> > > > I have TWO networked servers; one production, and one backup. I
want
> to
> > > be
> > > > able to use the backup in case of a production server failure. The
> loss
> > > of
> > > > a "little" data is acceptable in case of failure. Log Shipping
looks
> > like
> > > > the easiest but there seems to be a lot of warnings about (1) having
a
> > > > monitor server, and (2) having this server NOT be either the
> production
> > > > server nor the backup. I only have two servers so I can't do this.
> > > >
> > > > Is Log Shipping the best solution? Also--and this might affect
your
> > > > response--it is possible that the backup system might not be
> available
> > > 100%
> > > > of the time. I bring this up because I don't know what will happen
if
> > the
> > > > production system wants to ship a log, and the backup computer isn't
> > > > available to accept it. (')
> > > >
> > > > Any help, recommendations?
> > > >
> > > > TIA,
> > > >
> > > > Larry Woods
> > > >
> > > >
> > > >
> > >
> > >
> > >
> >
> >
> >
>
>|||Thanks for EVERYTHING, Vyas. I'll leave you alone now and get to my
reading...and experimenting.
(I might be back!)
Larry
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:O1tkCw23DHA.1804@.TK2MSFTNGP12.phx.gbl...
> It depends on the logshipping solution you go with. If your solution is
> written to wait and retry, if the target server is down, then it will
> eventually continue restoring when the target server comes back up. If it
is
> not written to do so, you'll have bring back the target server, and
restart
> the task manually. The backup process should continue on the primary
server
> though.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
> "Larry Woods" <larry@.lwoods.com> wrote in message
> news:OsK0Yr23DHA.1816@.TK2MSFTNGP12.phx.gbl...
> Just in the process of reading this one. Thanks. Also, one of my earlier
> questions was: What happens if the backup server is down when the Log
> Shipping want to take place? (Sorry if this is covered in the article. I
> haven't gotten that far).
> Larry
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:%23Orcon23DHA.3936@.TK2MSFTNGP11.phx.gbl...
> > Here's one example:
> > http://www.sql-server-performance.com/sql_server_log_shipping.asp
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> > Is .NET important for a database professional?
> > http://vyaskn.tripod.com/poll.htm
> >
> >
> > "Larry Woods" <larry@.lwoods.com> wrote in message
> > news:%23YDBUf23DHA.1804@.TK2MSFTNGP12.phx.gbl...
> > So, you use TSQL? If so, can you point me to any sources?
> >
> > Thanks.
> >
> > Larry
> >
> > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > news:uR2TeP23DHA.2428@.tk2msftngp13.phx.gbl...
> > > Hmm...I am not sure about that error. Haven't used built-in
logshipping
> > > before, sorry. You could try searching on that error message at:
> > > http://groups.google.com and http://support.microsoft.com
> > > --
> > > HTH,
> > > Vyas, MVP (SQL Server)
> > > http://vyaskn.tripod.com/
> > > Is .NET important for a database professional?
> > > http://vyaskn.tripod.com/poll.htm
> > >
> > >
> > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > news:OpACCO23DHA.488@.TK2MSFTNGP12.phx.gbl...
> > > Getting further. I changed my service account to Administrator and
now
> I
> > > was able to dump the logshipping file into the backup server...then it
> > > crashed on the second step, Initializing Destination, with the error:
> > >
> > > Unable to copy the initialization file to the secondary server
> '2KDOTNET'
> > >
> > > (Permissions will be the death of me yet!)
> > >
> > > Any ideas?
> > >
> > > TIA,
> > >
> > > Larry Woods
> > >
> > > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > > news:OtAFlz13DHA.3468@.TK2MSFTNGP11.phx.gbl...
> > > > Make sure the SQL Server and SQL Agent service accounts have
> permissions
> > > to
> > > > the share 2kdotnet\TransactionLogs_102\
> > > > --
> > > > HTH,
> > > > Vyas, MVP (SQL Server)
> > > > http://vyaskn.tripod.com/
> > > > Is .NET important for a database professional?
> > > > http://vyaskn.tripod.com/poll.htm
> > > >
> > > >
> > > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > > news:ujeGis13DHA.3196@.TK2MSFTNGP11.phx.gbl...
> > > > Follow up question--I am NOT an SQL Server expert, by the way. I
am
> > > trying
> > > > some tests using Log Shipping. The database does NOT exist on the
> > backup
> > > > server. When I run the Maintenance Plan (last step) I immediately
get
> a
> > > > "access denied" as follows:
> > > >
> > > > BackupDiskFile::CreateMedia: Backup device
> > > 'G:\DummyDB_logshipping_init.bak'
> > > > failed to create. Operating system error = 5(Access is denied.).
> > > >
> > > > I am running under Adminstrator and both servers use the same
password
> > for
> > > > Administrator. The "G" drive has Adminstrator permissions. BTW,
"G"
> > is
> > > a
> > > > folder on the backup server. Here is an earlier attempt:
> > > >
> > > > BackupDiskFile::CreateMedia: Backup device
> > > > '\\2kdotnet\TransactionLogs_102\DummyDB_logshipping_init.bak' failed
> to
> > > > create. Operating system error = 5(Access is denied.).
> > > >
> > > > Any help here?
> > > >
> > > > TIA,
> > > >
> > > > Larry Woods
> > > >
> > > > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > > > news:%23C9OFl13DHA.1652@.TK2MSFTNGP11.phx.gbl...
> > > > > Log shipping is the best option. You don't really need a
monitoring
> > > > server.
> > > > > You could write your own logshipping scripts, customised for your
> > > > > requirements. If you search this newsgroup archive, you will find
> some
> > > > > scripts. Also checkout sql-server-performance.com
> > > > >
> > > > > --
> > > > > HTH,
> > > > > Vyas, MVP (SQL Server)
> > > > > http://vyaskn.tripod.com/
> > > > > Is .NET important for a database professional?
> > > > > http://vyaskn.tripod.com/poll.htm
> > > > >
> > > > >
> > > > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > > > news:%23ljrQh13DHA.3216@.TK2MSFTNGP11.phx.gbl...
> > > > > I have TWO networked servers; one production, and one backup. I
> want
> > to
> > > > be
> > > > > able to use the backup in case of a production server failure.
The
> > loss
> > > > of
> > > > > a "little" data is acceptable in case of failure. Log Shipping
> looks
> > > like
> > > > > the easiest but there seems to be a lot of warnings about (1)
having
> a
> > > > > monitor server, and (2) having this server NOT be either the
> > production
> > > > > server nor the backup. I only have two servers so I can't do
this.
> > > > >
> > > > > Is Log Shipping the best solution? Also--and this might affect
> your
> > > > > response--it is possible that the backup system might not be
> > available
> > > > 100%
> > > > > of the time. I bring this up because I don't know what will
happen
> if
> > > the
> > > > > production system wants to ship a log, and the backup computer
isn't
> > > > > available to accept it. (')
> > > > >
> > > > > Any help, recommendations?
> > > > >
> > > > > TIA,
> > > > >
> > > > > Larry Woods
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> >
> >
> >
>
>|||Thanks, Thirumal,
I've printed off all three articles and I will study them.
Larry
"Thirumal" <treddym@.hotmail.nospam.com> wrote in message
news:129a01c3df61$ab5c71d0$a601280a@.phx.gbl...
> Hi Larry,
> Log Shipping is the ultimate solution if you are on SQL
> Server Enterprise Edition. Follow these Resources..
> Log Shipping in SQL Server 2000 - Part 1
> http://www.microsoft.com/technet/treeview/default.asp?
> url=/technet/prodtechnol/sql/deploy/prodspecs/logship1.asp
> Log Shipping in SQL Server 2000 - Part 2
> http://www.microsoft.com/technet/treeview/default.asp?
> url=/technet/prodtechnol/sql/deploy/prodspecs/logship1.asp
> How to Perform SQL Server Log Shipping
> http://www.sql-server-
> performance.com/sql_server_log_shipping.asp
> HTH
> --
> THIRUMAL REDDY MARAM
> Sys Amin / SQL DBA
> >--Original Message--
> >I have TWO networked servers; one production, and one
> backup. I want to be
> >able to use the backup in case of a production server
> failure. The loss of
> >a "little" data is acceptable in case of failure. Log
> Shipping looks like
> >the easiest but there seems to be a lot of warnings about
> (1) having a
> >monitor server, and (2) having this server NOT be either
> the production
> >server nor the backup. I only have two servers so I
> can't do this.
> >
> >Is Log Shipping the best solution? Also--and this might
> affect your
> >response--it is possible that the backup system might
> not be available 100%
> >of the time. I bring this up because I don't know what
> will happen if the
> >production system wants to ship a log, and the backup
> computer isn't
> >available to accept it. (')
> >
> >Any help, recommendations?
> >
> >TIA,
> >
> >Larry Woods
> >
> >
> >.
> >|||Need some additional help, I am afraid, Vyas.
I am trying to install the procedures from "How to Perform SQL Server Log
Shipping." In it he executes a remote stored procedure. My remote server
name starts with a number ("long history"). The problem that I am having is
that SQL Server will not execute a procedure name that starts with a number,
which I have to use since I am referencing a linkedserver that is named
'2KDOTNET'. I can't find any way around this.
'''
TIA,
Larry
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:O1tkCw23DHA.1804@.TK2MSFTNGP12.phx.gbl...
> It depends on the logshipping solution you go with. If your solution is
> written to wait and retry, if the target server is down, then it will
> eventually continue restoring when the target server comes back up. If it
is
> not written to do so, you'll have bring back the target server, and
restart
> the task manually. The backup process should continue on the primary
server
> though.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
> "Larry Woods" <larry@.lwoods.com> wrote in message
> news:OsK0Yr23DHA.1816@.TK2MSFTNGP12.phx.gbl...
> Just in the process of reading this one. Thanks. Also, one of my earlier
> questions was: What happens if the backup server is down when the Log
> Shipping want to take place? (Sorry if this is covered in the article. I
> haven't gotten that far).
> Larry
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:%23Orcon23DHA.3936@.TK2MSFTNGP11.phx.gbl...
> > Here's one example:
> > http://www.sql-server-performance.com/sql_server_log_shipping.asp
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> > Is .NET important for a database professional?
> > http://vyaskn.tripod.com/poll.htm
> >
> >
> > "Larry Woods" <larry@.lwoods.com> wrote in message
> > news:%23YDBUf23DHA.1804@.TK2MSFTNGP12.phx.gbl...
> > So, you use TSQL? If so, can you point me to any sources?
> >
> > Thanks.
> >
> > Larry
> >
> > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > news:uR2TeP23DHA.2428@.tk2msftngp13.phx.gbl...
> > > Hmm...I am not sure about that error. Haven't used built-in
logshipping
> > > before, sorry. You could try searching on that error message at:
> > > http://groups.google.com and http://support.microsoft.com
> > > --
> > > HTH,
> > > Vyas, MVP (SQL Server)
> > > http://vyaskn.tripod.com/
> > > Is .NET important for a database professional?
> > > http://vyaskn.tripod.com/poll.htm
> > >
> > >
> > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > news:OpACCO23DHA.488@.TK2MSFTNGP12.phx.gbl...
> > > Getting further. I changed my service account to Administrator and
now
> I
> > > was able to dump the logshipping file into the backup server...then it
> > > crashed on the second step, Initializing Destination, with the error:
> > >
> > > Unable to copy the initialization file to the secondary server
> '2KDOTNET'
> > >
> > > (Permissions will be the death of me yet!)
> > >
> > > Any ideas?
> > >
> > > TIA,
> > >
> > > Larry Woods
> > >
> > > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > > news:OtAFlz13DHA.3468@.TK2MSFTNGP11.phx.gbl...
> > > > Make sure the SQL Server and SQL Agent service accounts have
> permissions
> > > to
> > > > the share 2kdotnet\TransactionLogs_102\
> > > > --
> > > > HTH,
> > > > Vyas, MVP (SQL Server)
> > > > http://vyaskn.tripod.com/
> > > > Is .NET important for a database professional?
> > > > http://vyaskn.tripod.com/poll.htm
> > > >
> > > >
> > > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > > news:ujeGis13DHA.3196@.TK2MSFTNGP11.phx.gbl...
> > > > Follow up question--I am NOT an SQL Server expert, by the way. I
am
> > > trying
> > > > some tests using Log Shipping. The database does NOT exist on the
> > backup
> > > > server. When I run the Maintenance Plan (last step) I immediately
get
> a
> > > > "access denied" as follows:
> > > >
> > > > BackupDiskFile::CreateMedia: Backup device
> > > 'G:\DummyDB_logshipping_init.bak'
> > > > failed to create. Operating system error = 5(Access is denied.).
> > > >
> > > > I am running under Adminstrator and both servers use the same
password
> > for
> > > > Administrator. The "G" drive has Adminstrator permissions. BTW,
"G"
> > is
> > > a
> > > > folder on the backup server. Here is an earlier attempt:
> > > >
> > > > BackupDiskFile::CreateMedia: Backup device
> > > > '\\2kdotnet\TransactionLogs_102\DummyDB_logshipping_init.bak' failed
> to
> > > > create. Operating system error = 5(Access is denied.).
> > > >
> > > > Any help here?
> > > >
> > > > TIA,
> > > >
> > > > Larry Woods
> > > >
> > > > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > > > news:%23C9OFl13DHA.1652@.TK2MSFTNGP11.phx.gbl...
> > > > > Log shipping is the best option. You don't really need a
monitoring
> > > > server.
> > > > > You could write your own logshipping scripts, customised for your
> > > > > requirements. If you search this newsgroup archive, you will find
> some
> > > > > scripts. Also checkout sql-server-performance.com
> > > > >
> > > > > --
> > > > > HTH,
> > > > > Vyas, MVP (SQL Server)
> > > > > http://vyaskn.tripod.com/
> > > > > Is .NET important for a database professional?
> > > > > http://vyaskn.tripod.com/poll.htm
> > > > >
> > > > >
> > > > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > > > news:%23ljrQh13DHA.3216@.TK2MSFTNGP11.phx.gbl...
> > > > > I have TWO networked servers; one production, and one backup. I
> want
> > to
> > > > be
> > > > > able to use the backup in case of a production server failure.
The
> > loss
> > > > of
> > > > > a "little" data is acceptable in case of failure. Log Shipping
> looks
> > > like
> > > > > the easiest but there seems to be a lot of warnings about (1)
having
> a
> > > > > monitor server, and (2) having this server NOT be either the
> > production
> > > > > server nor the backup. I only have two servers so I can't do
this.
> > > > >
> > > > > Is Log Shipping the best solution? Also--and this might affect
> your
> > > > > response--it is possible that the backup system might not be
> > available
> > > > 100%
> > > > > of the time. I bring this up because I don't know what will
happen
> if
> > > the
> > > > > production system wants to ship a log, and the backup computer
isn't
> > > > > available to accept it. (')
> > > > >
> > > > > Any help, recommendations?
> > > > >
> > > > > TIA,
> > > > >
> > > > > Larry Woods
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> >
> >
> >
>
>|||Have you tried square brackets. Example: [2KDOTNET].DBName.dbo.ProcedureName
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Larry Woods" <larry@.lwoods.com> wrote in message
news:O$7uzc43DHA.2000@.TK2MSFTNGP11.phx.gbl...
Need some additional help, I am afraid, Vyas.
I am trying to install the procedures from "How to Perform SQL Server Log
Shipping." In it he executes a remote stored procedure. My remote server
name starts with a number ("long history"). The problem that I am having is
that SQL Server will not execute a procedure name that starts with a number,
which I have to use since I am referencing a linkedserver that is named
'2KDOTNET'. I can't find any way around this.
'''
TIA,
Larry
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:O1tkCw23DHA.1804@.TK2MSFTNGP12.phx.gbl...
> It depends on the logshipping solution you go with. If your solution is
> written to wait and retry, if the target server is down, then it will
> eventually continue restoring when the target server comes back up. If it
is
> not written to do so, you'll have bring back the target server, and
restart
> the task manually. The backup process should continue on the primary
server
> though.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
> "Larry Woods" <larry@.lwoods.com> wrote in message
> news:OsK0Yr23DHA.1816@.TK2MSFTNGP12.phx.gbl...
> Just in the process of reading this one. Thanks. Also, one of my earlier
> questions was: What happens if the backup server is down when the Log
> Shipping want to take place? (Sorry if this is covered in the article. I
> haven't gotten that far).
> Larry
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:%23Orcon23DHA.3936@.TK2MSFTNGP11.phx.gbl...
> > Here's one example:
> > http://www.sql-server-performance.com/sql_server_log_shipping.asp
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> > Is .NET important for a database professional?
> > http://vyaskn.tripod.com/poll.htm
> >
> >
> > "Larry Woods" <larry@.lwoods.com> wrote in message
> > news:%23YDBUf23DHA.1804@.TK2MSFTNGP12.phx.gbl...
> > So, you use TSQL? If so, can you point me to any sources?
> >
> > Thanks.
> >
> > Larry
> >
> > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > news:uR2TeP23DHA.2428@.tk2msftngp13.phx.gbl...
> > > Hmm...I am not sure about that error. Haven't used built-in
logshipping
> > > before, sorry. You could try searching on that error message at:
> > > http://groups.google.com and http://support.microsoft.com
> > > --
> > > HTH,
> > > Vyas, MVP (SQL Server)
> > > http://vyaskn.tripod.com/
> > > Is .NET important for a database professional?
> > > http://vyaskn.tripod.com/poll.htm
> > >
> > >
> > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > news:OpACCO23DHA.488@.TK2MSFTNGP12.phx.gbl...
> > > Getting further. I changed my service account to Administrator and
now
> I
> > > was able to dump the logshipping file into the backup server...then it
> > > crashed on the second step, Initializing Destination, with the error:
> > >
> > > Unable to copy the initialization file to the secondary server
> '2KDOTNET'
> > >
> > > (Permissions will be the death of me yet!)
> > >
> > > Any ideas?
> > >
> > > TIA,
> > >
> > > Larry Woods
> > >
> > > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > > news:OtAFlz13DHA.3468@.TK2MSFTNGP11.phx.gbl...
> > > > Make sure the SQL Server and SQL Agent service accounts have
> permissions
> > > to
> > > > the share 2kdotnet\TransactionLogs_102\
> > > > --
> > > > HTH,
> > > > Vyas, MVP (SQL Server)
> > > > http://vyaskn.tripod.com/
> > > > Is .NET important for a database professional?
> > > > http://vyaskn.tripod.com/poll.htm
> > > >
> > > >
> > > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > > news:ujeGis13DHA.3196@.TK2MSFTNGP11.phx.gbl...
> > > > Follow up question--I am NOT an SQL Server expert, by the way. I
am
> > > trying
> > > > some tests using Log Shipping. The database does NOT exist on the
> > backup
> > > > server. When I run the Maintenance Plan (last step) I immediately
get
> a
> > > > "access denied" as follows:
> > > >
> > > > BackupDiskFile::CreateMedia: Backup device
> > > 'G:\DummyDB_logshipping_init.bak'
> > > > failed to create. Operating system error = 5(Access is denied.).
> > > >
> > > > I am running under Adminstrator and both servers use the same
password
> > for
> > > > Administrator. The "G" drive has Adminstrator permissions. BTW,
"G"
> > is
> > > a
> > > > folder on the backup server. Here is an earlier attempt:
> > > >
> > > > BackupDiskFile::CreateMedia: Backup device
> > > > '\\2kdotnet\TransactionLogs_102\DummyDB_logshipping_init.bak' failed
> to
> > > > create. Operating system error = 5(Access is denied.).
> > > >
> > > > Any help here?
> > > >
> > > > TIA,
> > > >
> > > > Larry Woods
> > > >
> > > > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > > > news:%23C9OFl13DHA.1652@.TK2MSFTNGP11.phx.gbl...
> > > > > Log shipping is the best option. You don't really need a
monitoring
> > > > server.
> > > > > You could write your own logshipping scripts, customised for your
> > > > > requirements. If you search this newsgroup archive, you will find
> some
> > > > > scripts. Also checkout sql-server-performance.com
> > > > >
> > > > > --
> > > > > HTH,
> > > > > Vyas, MVP (SQL Server)
> > > > > http://vyaskn.tripod.com/
> > > > > Is .NET important for a database professional?
> > > > > http://vyaskn.tripod.com/poll.htm
> > > > >
> > > > >
> > > > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > > > news:%23ljrQh13DHA.3216@.TK2MSFTNGP11.phx.gbl...
> > > > > I have TWO networked servers; one production, and one backup. I
> want
> > to
> > > > be
> > > > > able to use the backup in case of a production server failure.
The
> > loss
> > > > of
> > > > > a "little" data is acceptable in case of failure. Log Shipping
> looks
> > > like
> > > > > the easiest but there seems to be a lot of warnings about (1)
having
> a
> > > > > monitor server, and (2) having this server NOT be either the
> > production
> > > > > server nor the backup. I only have two servers so I can't do
this.
> > > > >
> > > > > Is Log Shipping the best solution? Also--and this might affect
> your
> > > > > response--it is possible that the backup system might not be
> > available
> > > > 100%
> > > > > of the time. I bring this up because I don't know what will
happen
> if
> > > the
> > > > > production system wants to ship a log, and the backup computer
isn't
> > > > > available to accept it. (')
> > > > >
> > > > > Any help, recommendations?
> > > > >
> > > > > TIA,
> > > > >
> > > > > Larry Woods
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> >
> >
> >
>
>|||Yes. If I use square brackets then it thinks that '2kDOTNET' is a database
name ...and says that it can't find it.
Larry
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:uRX2ri43DHA.1760@.TK2MSFTNGP10.phx.gbl...
> Have you tried square brackets. Example:
[2KDOTNET].DBName.dbo.ProcedureName
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
>
> "Larry Woods" <larry@.lwoods.com> wrote in message
> news:O$7uzc43DHA.2000@.TK2MSFTNGP11.phx.gbl...
> Need some additional help, I am afraid, Vyas.
> I am trying to install the procedures from "How to Perform SQL Server Log
> Shipping." In it he executes a remote stored procedure. My remote server
> name starts with a number ("long history"). The problem that I am having
is
> that SQL Server will not execute a procedure name that starts with a
number,
> which I have to use since I am referencing a linkedserver that is named
> '2KDOTNET'. I can't find any way around this.
> '''
> TIA,
> Larry
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:O1tkCw23DHA.1804@.TK2MSFTNGP12.phx.gbl...
> > It depends on the logshipping solution you go with. If your solution is
> > written to wait and retry, if the target server is down, then it will
> > eventually continue restoring when the target server comes back up. If
it
> is
> > not written to do so, you'll have bring back the target server, and
> restart
> > the task manually. The backup process should continue on the primary
> server
> > though.
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> > Is .NET important for a database professional?
> > http://vyaskn.tripod.com/poll.htm
> >
> >
> > "Larry Woods" <larry@.lwoods.com> wrote in message
> > news:OsK0Yr23DHA.1816@.TK2MSFTNGP12.phx.gbl...
> > Just in the process of reading this one. Thanks. Also, one of my
earlier
> > questions was: What happens if the backup server is down when the Log
> > Shipping want to take place? (Sorry if this is covered in the article.
I
> > haven't gotten that far).
> >
> > Larry
> >
> > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > news:%23Orcon23DHA.3936@.TK2MSFTNGP11.phx.gbl...
> > > Here's one example:
> > > http://www.sql-server-performance.com/sql_server_log_shipping.asp
> > > --
> > > HTH,
> > > Vyas, MVP (SQL Server)
> > > http://vyaskn.tripod.com/
> > > Is .NET important for a database professional?
> > > http://vyaskn.tripod.com/poll.htm
> > >
> > >
> > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > news:%23YDBUf23DHA.1804@.TK2MSFTNGP12.phx.gbl...
> > > So, you use TSQL? If so, can you point me to any sources?
> > >
> > > Thanks.
> > >
> > > Larry
> > >
> > > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > > news:uR2TeP23DHA.2428@.tk2msftngp13.phx.gbl...
> > > > Hmm...I am not sure about that error. Haven't used built-in
> logshipping
> > > > before, sorry. You could try searching on that error message at:
> > > > http://groups.google.com and http://support.microsoft.com
> > > > --
> > > > HTH,
> > > > Vyas, MVP (SQL Server)
> > > > http://vyaskn.tripod.com/
> > > > Is .NET important for a database professional?
> > > > http://vyaskn.tripod.com/poll.htm
> > > >
> > > >
> > > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > > news:OpACCO23DHA.488@.TK2MSFTNGP12.phx.gbl...
> > > > Getting further. I changed my service account to Administrator and
> now
> > I
> > > > was able to dump the logshipping file into the backup server...then
it
> > > > crashed on the second step, Initializing Destination, with the
error:
> > > >
> > > > Unable to copy the initialization file to the secondary server
> > '2KDOTNET'
> > > >
> > > > (Permissions will be the death of me yet!)
> > > >
> > > > Any ideas?
> > > >
> > > > TIA,
> > > >
> > > > Larry Woods
> > > >
> > > > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > > > news:OtAFlz13DHA.3468@.TK2MSFTNGP11.phx.gbl...
> > > > > Make sure the SQL Server and SQL Agent service accounts have
> > permissions
> > > > to
> > > > > the share 2kdotnet\TransactionLogs_102\
> > > > > --
> > > > > HTH,
> > > > > Vyas, MVP (SQL Server)
> > > > > http://vyaskn.tripod.com/
> > > > > Is .NET important for a database professional?
> > > > > http://vyaskn.tripod.com/poll.htm
> > > > >
> > > > >
> > > > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > > > news:ujeGis13DHA.3196@.TK2MSFTNGP11.phx.gbl...
> > > > > Follow up question--I am NOT an SQL Server expert, by the way. I
> am
> > > > trying
> > > > > some tests using Log Shipping. The database does NOT exist on the
> > > backup
> > > > > server. When I run the Maintenance Plan (last step) I immediately
> get
> > a
> > > > > "access denied" as follows:
> > > > >
> > > > > BackupDiskFile::CreateMedia: Backup device
> > > > 'G:\DummyDB_logshipping_init.bak'
> > > > > failed to create. Operating system error = 5(Access is denied.).
> > > > >
> > > > > I am running under Adminstrator and both servers use the same
> password
> > > for
> > > > > Administrator. The "G" drive has Adminstrator permissions. BTW,
> "G"
> > > is
> > > > a
> > > > > folder on the backup server. Here is an earlier attempt:
> > > > >
> > > > > BackupDiskFile::CreateMedia: Backup device
> > > > > '\\2kdotnet\TransactionLogs_102\DummyDB_logshipping_init.bak'
failed
> > to
> > > > > create. Operating system error = 5(Access is denied.).
> > > > >
> > > > > Any help here?
> > > > >
> > > > > TIA,
> > > > >
> > > > > Larry Woods
> > > > >
> > > > > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > > > > news:%23C9OFl13DHA.1652@.TK2MSFTNGP11.phx.gbl...
> > > > > > Log shipping is the best option. You don't really need a
> monitoring
> > > > > server.
> > > > > > You could write your own logshipping scripts, customised for
your
> > > > > > requirements. If you search this newsgroup archive, you will
find
> > some
> > > > > > scripts. Also checkout sql-server-performance.com
> > > > > >
> > > > > > --
> > > > > > HTH,
> > > > > > Vyas, MVP (SQL Server)
> > > > > > http://vyaskn.tripod.com/
> > > > > > Is .NET important for a database professional?
> > > > > > http://vyaskn.tripod.com/poll.htm
> > > > > >
> > > > > >
> > > > > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > > > > news:%23ljrQh13DHA.3216@.TK2MSFTNGP11.phx.gbl...
> > > > > > I have TWO networked servers; one production, and one backup. I
> > want
> > > to
> > > > > be
> > > > > > able to use the backup in case of a production server failure.
> The
> > > loss
> > > > > of
> > > > > > a "little" data is acceptable in case of failure. Log Shipping
> > looks
> > > > like
> > > > > > the easiest but there seems to be a lot of warnings about (1)
> having
> > a
> > > > > > monitor server, and (2) having this server NOT be either the
> > > production
> > > > > > server nor the backup. I only have two servers so I can't do
> this.
> > > > > >
> > > > > > Is Log Shipping the best solution? Also--and this might affect
> > your
> > > > > > response--it is possible that the backup system might not be
> > > available
> > > > > 100%
> > > > > > of the time. I bring this up because I don't know what will
> happen
> > if
> > > > the
> > > > > > production system wants to ship a log, and the backup computer
> isn't
> > > > > > available to accept it. (')
> > > > > >
> > > > > > Any help, recommendations?
> > > > > >
> > > > > > TIA,
> > > > > >
> > > > > > Larry Woods
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> >
> >
> >
>
>|||Could you show us what exactly you are trying to execute? Did you setup a
linked server already?
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Larry Woods" <larry@.lwoods.com> wrote in message
news:#nQXc543DHA.2528@.TK2MSFTNGP10.phx.gbl...
Yes. If I use square brackets then it thinks that '2kDOTNET' is a database
name ...and says that it can't find it.
Larry
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:uRX2ri43DHA.1760@.TK2MSFTNGP10.phx.gbl...
> Have you tried square brackets. Example:
[2KDOTNET].DBName.dbo.ProcedureName
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
>
> "Larry Woods" <larry@.lwoods.com> wrote in message
> news:O$7uzc43DHA.2000@.TK2MSFTNGP11.phx.gbl...
> Need some additional help, I am afraid, Vyas.
> I am trying to install the procedures from "How to Perform SQL Server Log
> Shipping." In it he executes a remote stored procedure. My remote server
> name starts with a number ("long history"). The problem that I am having
is
> that SQL Server will not execute a procedure name that starts with a
number,
> which I have to use since I am referencing a linkedserver that is named
> '2KDOTNET'. I can't find any way around this.
> '''
> TIA,
> Larry
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:O1tkCw23DHA.1804@.TK2MSFTNGP12.phx.gbl...
> > It depends on the logshipping solution you go with. If your solution is
> > written to wait and retry, if the target server is down, then it will
> > eventually continue restoring when the target server comes back up. If
it
> is
> > not written to do so, you'll have bring back the target server, and
> restart
> > the task manually. The backup process should continue on the primary
> server
> > though.
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> > Is .NET important for a database professional?
> > http://vyaskn.tripod.com/poll.htm
> >
> >
> > "Larry Woods" <larry@.lwoods.com> wrote in message
> > news:OsK0Yr23DHA.1816@.TK2MSFTNGP12.phx.gbl...
> > Just in the process of reading this one. Thanks. Also, one of my
earlier
> > questions was: What happens if the backup server is down when the Log
> > Shipping want to take place? (Sorry if this is covered in the article.
I
> > haven't gotten that far).
> >
> > Larry
> >
> > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > news:%23Orcon23DHA.3936@.TK2MSFTNGP11.phx.gbl...
> > > Here's one example:
> > > http://www.sql-server-performance.com/sql_server_log_shipping.asp
> > > --
> > > HTH,
> > > Vyas, MVP (SQL Server)
> > > http://vyaskn.tripod.com/
> > > Is .NET important for a database professional?
> > > http://vyaskn.tripod.com/poll.htm
> > >
> > >
> > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > news:%23YDBUf23DHA.1804@.TK2MSFTNGP12.phx.gbl...
> > > So, you use TSQL? If so, can you point me to any sources?
> > >
> > > Thanks.
> > >
> > > Larry
> > >
> > > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > > news:uR2TeP23DHA.2428@.tk2msftngp13.phx.gbl...
> > > > Hmm...I am not sure about that error. Haven't used built-in
> logshipping
> > > > before, sorry. You could try searching on that error message at:
> > > > http://groups.google.com and http://support.microsoft.com
> > > > --
> > > > HTH,
> > > > Vyas, MVP (SQL Server)
> > > > http://vyaskn.tripod.com/
> > > > Is .NET important for a database professional?
> > > > http://vyaskn.tripod.com/poll.htm
> > > >
> > > >
> > > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > > news:OpACCO23DHA.488@.TK2MSFTNGP12.phx.gbl...
> > > > Getting further. I changed my service account to Administrator and
> now
> > I
> > > > was able to dump the logshipping file into the backup server...then
it
> > > > crashed on the second step, Initializing Destination, with the
error:
> > > >
> > > > Unable to copy the initialization file to the secondary server
> > '2KDOTNET'
> > > >
> > > > (Permissions will be the death of me yet!)
> > > >
> > > > Any ideas?
> > > >
> > > > TIA,
> > > >
> > > > Larry Woods
> > > >
> > > > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > > > news:OtAFlz13DHA.3468@.TK2MSFTNGP11.phx.gbl...
> > > > > Make sure the SQL Server and SQL Agent service accounts have
> > permissions
> > > > to
> > > > > the share 2kdotnet\TransactionLogs_102\
> > > > > --
> > > > > HTH,
> > > > > Vyas, MVP (SQL Server)
> > > > > http://vyaskn.tripod.com/
> > > > > Is .NET important for a database professional?
> > > > > http://vyaskn.tripod.com/poll.htm
> > > > >
> > > > >
> > > > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > > > news:ujeGis13DHA.3196@.TK2MSFTNGP11.phx.gbl...
> > > > > Follow up question--I am NOT an SQL Server expert, by the way. I
> am
> > > > trying
> > > > > some tests using Log Shipping. The database does NOT exist on the
> > > backup
> > > > > server. When I run the Maintenance Plan (last step) I immediately
> get
> > a
> > > > > "access denied" as follows:
> > > > >
> > > > > BackupDiskFile::CreateMedia: Backup device
> > > > 'G:\DummyDB_logshipping_init.bak'
> > > > > failed to create. Operating system error = 5(Access is denied.).
> > > > >
> > > > > I am running under Adminstrator and both servers use the same
> password
> > > for
> > > > > Administrator. The "G" drive has Adminstrator permissions. BTW,
> "G"
> > > is
> > > > a
> > > > > folder on the backup server. Here is an earlier attempt:
> > > > >
> > > > > BackupDiskFile::CreateMedia: Backup device
> > > > > '\\2kdotnet\TransactionLogs_102\DummyDB_logshipping_init.bak'
failed
> > to
> > > > > create. Operating system error = 5(Access is denied.).
> > > > >
> > > > > Any help here?
> > > > >
> > > > > TIA,
> > > > >
> > > > > Larry Woods
> > > > >
> > > > > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > > > > news:%23C9OFl13DHA.1652@.TK2MSFTNGP11.phx.gbl...
> > > > > > Log shipping is the best option. You don't really need a
> monitoring
> > > > > server.
> > > > > > You could write your own logshipping scripts, customised for
your
> > > > > > requirements. If you search this newsgroup archive, you will
find
> > some
> > > > > > scripts. Also checkout sql-server-performance.com
> > > > > >
> > > > > > --
> > > > > > HTH,
> > > > > > Vyas, MVP (SQL Server)
> > > > > > http://vyaskn.tripod.com/
> > > > > > Is .NET important for a database professional?
> > > > > > http://vyaskn.tripod.com/poll.htm
> > > > > >
> > > > > >
> > > > > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > > > > news:%23ljrQh13DHA.3216@.TK2MSFTNGP11.phx.gbl...
> > > > > > I have TWO networked servers; one production, and one backup. I
> > want
> > > to
> > > > > be
> > > > > > able to use the backup in case of a production server failure.
> The
> > > loss
> > > > > of
> > > > > > a "little" data is acceptable in case of failure. Log Shipping
> > looks
> > > > like
> > > > > > the easiest but there seems to be a lot of warnings about (1)
> having
> > a
> > > > > > monitor server, and (2) having this server NOT be either the
> > > production
> > > > > > server nor the backup. I only have two servers so I can't do
> this.
> > > > > >
> > > > > > Is Log Shipping the best solution? Also--and this might affect
> > your
> > > > > > response--it is possible that the backup system might not be
> > > available
> > > > > 100%
> > > > > > of the time. I bring this up because I don't know what will
> happen
> > if
> > > > the
> > > > > > production system wants to ship a log, and the backup computer
> isn't
> > > > > > available to accept it. (')
> > > > > >
> > > > > > Any help, recommendations?
> > > > > >
> > > > > > TIA,
> > > > > >
> > > > > > Larry Woods
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> >
> >
> >
>
>|||Here is the EXEC statement:
EXEC 2KDOTNET.LogShippingAdmin.restore_database_backups
The server that this is being executed on is named DEVELOPMENT; the remote
server is 2KDOTNET.
2KDOTNET is the name of the remote server, and the name of the linked server
tht is defined in the local server, DEVELOPMENT.
Larry
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:ephyzC53DHA.1636@.TK2MSFTNGP12.phx.gbl...
> Could you show us what exactly you are trying to execute? Did you setup a
> linked server already?
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
>
> "Larry Woods" <larry@.lwoods.com> wrote in message
> news:#nQXc543DHA.2528@.TK2MSFTNGP10.phx.gbl...
> Yes. If I use square brackets then it thinks that '2kDOTNET' is a
database
> name ...and says that it can't find it.
> Larry
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:uRX2ri43DHA.1760@.TK2MSFTNGP10.phx.gbl...
> > Have you tried square brackets. Example:
> [2KDOTNET].DBName.dbo.ProcedureName
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> > Is .NET important for a database professional?
> > http://vyaskn.tripod.com/poll.htm
> >
> >
> >
> >
> > "Larry Woods" <larry@.lwoods.com> wrote in message
> > news:O$7uzc43DHA.2000@.TK2MSFTNGP11.phx.gbl...
> > Need some additional help, I am afraid, Vyas.
> >
> > I am trying to install the procedures from "How to Perform SQL Server
Log
> > Shipping." In it he executes a remote stored procedure. My remote
server
> > name starts with a number ("long history"). The problem that I am
having
> is
> > that SQL Server will not execute a procedure name that starts with a
> number,
> > which I have to use since I am referencing a linkedserver that is named
> > '2KDOTNET'. I can't find any way around this.
> >
> > '''
> >
> > TIA,
> >
> > Larry
> >
> > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > news:O1tkCw23DHA.1804@.TK2MSFTNGP12.phx.gbl...
> > > It depends on the logshipping solution you go with. If your solution
is
> > > written to wait and retry, if the target server is down, then it will
> > > eventually continue restoring when the target server comes back up. If
> it
> > is
> > > not written to do so, you'll have bring back the target server, and
> > restart
> > > the task manually. The backup process should continue on the primary
> > server
> > > though.
> > > --
> > > HTH,
> > > Vyas, MVP (SQL Server)
> > > http://vyaskn.tripod.com/
> > > Is .NET important for a database professional?
> > > http://vyaskn.tripod.com/poll.htm
> > >
> > >
> > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > news:OsK0Yr23DHA.1816@.TK2MSFTNGP12.phx.gbl...
> > > Just in the process of reading this one. Thanks. Also, one of my
> earlier
> > > questions was: What happens if the backup server is down when the Log
> > > Shipping want to take place? (Sorry if this is covered in the
article.
> I
> > > haven't gotten that far).
> > >
> > > Larry
> > >
> > > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > > news:%23Orcon23DHA.3936@.TK2MSFTNGP11.phx.gbl...
> > > > Here's one example:
> > > > http://www.sql-server-performance.com/sql_server_log_shipping.asp
> > > > --
> > > > HTH,
> > > > Vyas, MVP (SQL Server)
> > > > http://vyaskn.tripod.com/
> > > > Is .NET important for a database professional?
> > > > http://vyaskn.tripod.com/poll.htm
> > > >
> > > >
> > > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > > news:%23YDBUf23DHA.1804@.TK2MSFTNGP12.phx.gbl...
> > > > So, you use TSQL? If so, can you point me to any sources?
> > > >
> > > > Thanks.
> > > >
> > > > Larry
> > > >
> > > > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > > > news:uR2TeP23DHA.2428@.tk2msftngp13.phx.gbl...
> > > > > Hmm...I am not sure about that error. Haven't used built-in
> > logshipping
> > > > > before, sorry. You could try searching on that error message at:
> > > > > http://groups.google.com and http://support.microsoft.com
> > > > > --
> > > > > HTH,
> > > > > Vyas, MVP (SQL Server)
> > > > > http://vyaskn.tripod.com/
> > > > > Is .NET important for a database professional?
> > > > > http://vyaskn.tripod.com/poll.htm
> > > > >
> > > > >
> > > > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > > > news:OpACCO23DHA.488@.TK2MSFTNGP12.phx.gbl...
> > > > > Getting further. I changed my service account to Administrator
and
> > now
> > > I
> > > > > was able to dump the logshipping file into the backup
server...then
> it
> > > > > crashed on the second step, Initializing Destination, with the
> error:
> > > > >
> > > > > Unable to copy the initialization file to the secondary server
> > > '2KDOTNET'
> > > > >
> > > > > (Permissions will be the death of me yet!)
> > > > >
> > > > > Any ideas?
> > > > >
> > > > > TIA,
> > > > >
> > > > > Larry Woods
> > > > >
> > > > > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > > > > news:OtAFlz13DHA.3468@.TK2MSFTNGP11.phx.gbl...
> > > > > > Make sure the SQL Server and SQL Agent service accounts have
> > > permissions
> > > > > to
> > > > > > the share 2kdotnet\TransactionLogs_102\
> > > > > > --
> > > > > > HTH,
> > > > > > Vyas, MVP (SQL Server)
> > > > > > http://vyaskn.tripod.com/
> > > > > > Is .NET important for a database professional?
> > > > > > http://vyaskn.tripod.com/poll.htm
> > > > > >
> > > > > >
> > > > > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > > > > news:ujeGis13DHA.3196@.TK2MSFTNGP11.phx.gbl...
> > > > > > Follow up question--I am NOT an SQL Server expert, by the way.
I
> > am
> > > > > trying
> > > > > > some tests using Log Shipping. The database does NOT exist on
the
> > > > backup
> > > > > > server. When I run the Maintenance Plan (last step) I
immediately
> > get
> > > a
> > > > > > "access denied" as follows:
> > > > > >
> > > > > > BackupDiskFile::CreateMedia: Backup device
> > > > > 'G:\DummyDB_logshipping_init.bak'
> > > > > > failed to create. Operating system error = 5(Access is denied.).
> > > > > >
> > > > > > I am running under Adminstrator and both servers use the same
> > password
> > > > for
> > > > > > Administrator. The "G" drive has Adminstrator permissions.
BTW,
> > "G"
> > > > is
> > > > > a
> > > > > > folder on the backup server. Here is an earlier attempt:
> > > > > >
> > > > > > BackupDiskFile::CreateMedia: Backup device
> > > > > > '\\2kdotnet\TransactionLogs_102\DummyDB_logshipping_init.bak'
> failed
> > > to
> > > > > > create. Operating system error = 5(Access is denied.).
> > > > > >
> > > > > > Any help here?
> > > > > >
> > > > > > TIA,
> > > > > >
> > > > > > Larry Woods
> > > > > >
> > > > > > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in
message
> > > > > > news:%23C9OFl13DHA.1652@.TK2MSFTNGP11.phx.gbl...
> > > > > > > Log shipping is the best option. You don't really need a
> > monitoring
> > > > > > server.
> > > > > > > You could write your own logshipping scripts, customised for
> your
> > > > > > > requirements. If you search this newsgroup archive, you will
> find
> > > some
> > > > > > > scripts. Also checkout sql-server-performance.com
> > > > > > >
> > > > > > > --
> > > > > > > HTH,
> > > > > > > Vyas, MVP (SQL Server)
> > > > > > > http://vyaskn.tripod.com/
> > > > > > > Is .NET important for a database professional?
> > > > > > > http://vyaskn.tripod.com/poll.htm
> > > > > > >
> > > > > > >
> > > > > > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > > > > > news:%23ljrQh13DHA.3216@.TK2MSFTNGP11.phx.gbl...
> > > > > > > I have TWO networked servers; one production, and one backup.
I
> > > want
> > > > to
> > > > > > be
> > > > > > > able to use the backup in case of a production server failure.
> > The
> > > > loss
> > > > > > of
> > > > > > > a "little" data is acceptable in case of failure. Log
Shipping
> > > looks
> > > > > like
> > > > > > > the easiest but there seems to be a lot of warnings about (1)
> > having
> > > a
> > > > > > > monitor server, and (2) having this server NOT be either the
> > > > production
> > > > > > > server nor the backup. I only have two servers so I can't do
> > this.
> > > > > > >
> > > > > > > Is Log Shipping the best solution? Also--and this might
affect
> > > your
> > > > > > > response--it is possible that the backup system might not be
> > > > available
> > > > > > 100%
> > > > > > > of the time. I bring this up because I don't know what will
> > happen
> > > if
> > > > > the
> > > > > > > production system wants to ship a log, and the backup computer
> > isn't
> > > > > > > available to accept it. (')
> > > > > > >
> > > > > > > Any help, recommendations?
> > > > > > >
> > > > > > > TIA,
> > > > > > >
> > > > > > > Larry Woods
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> >
> >
> >
> >
>
>|||It should be a 4 part name consiting of server name, database name, owner
name and stored procedure name. You only have 3 parts in your call.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Larry Woods" <larry@.lwoods.com> wrote in message
news:#1Yim783DHA.2296@.TK2MSFTNGP11.phx.gbl...
Here is the EXEC statement:
EXEC 2KDOTNET.LogShippingAdmin.restore_database_backups
The server that this is being executed on is named DEVELOPMENT; the remote
server is 2KDOTNET.
2KDOTNET is the name of the remote server, and the name of the linked server
tht is defined in the local server, DEVELOPMENT.
Larry
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:ephyzC53DHA.1636@.TK2MSFTNGP12.phx.gbl...
> Could you show us what exactly you are trying to execute? Did you setup a
> linked server already?
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
>
> "Larry Woods" <larry@.lwoods.com> wrote in message
> news:#nQXc543DHA.2528@.TK2MSFTNGP10.phx.gbl...
> Yes. If I use square brackets then it thinks that '2kDOTNET' is a
database
> name ...and says that it can't find it.
> Larry
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:uRX2ri43DHA.1760@.TK2MSFTNGP10.phx.gbl...
> > Have you tried square brackets. Example:
> [2KDOTNET].DBName.dbo.ProcedureName
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> > Is .NET important for a database professional?
> > http://vyaskn.tripod.com/poll.htm
> >
> >
> >
> >
> > "Larry Woods" <larry@.lwoods.com> wrote in message
> > news:O$7uzc43DHA.2000@.TK2MSFTNGP11.phx.gbl...
> > Need some additional help, I am afraid, Vyas.
> >
> > I am trying to install the procedures from "How to Perform SQL Server
Log
> > Shipping." In it he executes a remote stored procedure. My remote
server
> > name starts with a number ("long history"). The problem that I am
having
> is
> > that SQL Server will not execute a procedure name that starts with a
> number,
> > which I have to use since I am referencing a linkedserver that is named
> > '2KDOTNET'. I can't find any way around this.
> >
> > '''
> >
> > TIA,
> >
> > Larry
> >
> > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > news:O1tkCw23DHA.1804@.TK2MSFTNGP12.phx.gbl...
> > > It depends on the logshipping solution you go with. If your solution
is
> > > written to wait and retry, if the target server is down, then it will
> > > eventually continue restoring when the target server comes back up. If
> it
> > is
> > > not written to do so, you'll have bring back the target server, and
> > restart
> > > the task manually. The backup process should continue on the primary
> > server
> > > though.
> > > --
> > > HTH,
> > > Vyas, MVP (SQL Server)
> > > http://vyaskn.tripod.com/
> > > Is .NET important for a database professional?
> > > http://vyaskn.tripod.com/poll.htm
> > >
> > >
> > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > news:OsK0Yr23DHA.1816@.TK2MSFTNGP12.phx.gbl...
> > > Just in the process of reading this one. Thanks. Also, one of my
> earlier
> > > questions was: What happens if the backup server is down when the Log
> > > Shipping want to take place? (Sorry if this is covered in the
article.
> I
> > > haven't gotten that far).
> > >
> > > Larry
> > >
> > > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > > news:%23Orcon23DHA.3936@.TK2MSFTNGP11.phx.gbl...
> > > > Here's one example:
> > > > http://www.sql-server-performance.com/sql_server_log_shipping.asp
> > > > --
> > > > HTH,
> > > > Vyas, MVP (SQL Server)
> > > > http://vyaskn.tripod.com/
> > > > Is .NET important for a database professional?
> > > > http://vyaskn.tripod.com/poll.htm
> > > >
> > > >
> > > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > > news:%23YDBUf23DHA.1804@.TK2MSFTNGP12.phx.gbl...
> > > > So, you use TSQL? If so, can you point me to any sources?
> > > >
> > > > Thanks.
> > > >
> > > > Larry
> > > >
> > > > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > > > news:uR2TeP23DHA.2428@.tk2msftngp13.phx.gbl...
> > > > > Hmm...I am not sure about that error. Haven't used built-in
> > logshipping
> > > > > before, sorry. You could try searching on that error message at:
> > > > > http://groups.google.com and http://support.microsoft.com
> > > > > --
> > > > > HTH,
> > > > > Vyas, MVP (SQL Server)
> > > > > http://vyaskn.tripod.com/
> > > > > Is .NET important for a database professional?
> > > > > http://vyaskn.tripod.com/poll.htm
> > > > >
> > > > >
> > > > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > > > news:OpACCO23DHA.488@.TK2MSFTNGP12.phx.gbl...
> > > > > Getting further. I changed my service account to Administrator
and
> > now
> > > I
> > > > > was able to dump the logshipping file into the backup
server...then
> it
> > > > > crashed on the second step, Initializing Destination, with the
> error:
> > > > >
> > > > > Unable to copy the initialization file to the secondary server
> > > '2KDOTNET'
> > > > >
> > > > > (Permissions will be the death of me yet!)
> > > > >
> > > > > Any ideas?
> > > > >
> > > > > TIA,
> > > > >
> > > > > Larry Woods
> > > > >
> > > > > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > > > > news:OtAFlz13DHA.3468@.TK2MSFTNGP11.phx.gbl...
> > > > > > Make sure the SQL Server and SQL Agent service accounts have
> > > permissions
> > > > > to
> > > > > > the share 2kdotnet\TransactionLogs_102\
> > > > > > --
> > > > > > HTH,
> > > > > > Vyas, MVP (SQL Server)
> > > > > > http://vyaskn.tripod.com/
> > > > > > Is .NET important for a database professional?
> > > > > > http://vyaskn.tripod.com/poll.htm
> > > > > >
> > > > > >
> > > > > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > > > > news:ujeGis13DHA.3196@.TK2MSFTNGP11.phx.gbl...
> > > > > > Follow up question--I am NOT an SQL Server expert, by the way.
I
> > am
> > > > > trying
> > > > > > some tests using Log Shipping. The database does NOT exist on
the
> > > > backup
> > > > > > server. When I run the Maintenance Plan (last step) I
immediately
> > get
> > > a
> > > > > > "access denied" as follows:
> > > > > >
> > > > > > BackupDiskFile::CreateMedia: Backup device
> > > > > 'G:\DummyDB_logshipping_init.bak'
> > > > > > failed to create. Operating system error = 5(Access is denied.).
> > > > > >
> > > > > > I am running under Adminstrator and both servers use the same
> > password
> > > > for
> > > > > > Administrator. The "G" drive has Adminstrator permissions.
BTW,
> > "G"
> > > > is
> > > > > a
> > > > > > folder on the backup server. Here is an earlier attempt:
> > > > > >
> > > > > > BackupDiskFile::CreateMedia: Backup device
> > > > > > '\\2kdotnet\TransactionLogs_102\DummyDB_logshipping_init.bak'
> failed
> > > to
> > > > > > create. Operating system error = 5(Access is denied.).
> > > > > >
> > > > > > Any help here?
> > > > > >
> > > > > > TIA,
> > > > > >
> > > > > > Larry Woods
> > > > > >
> > > > > > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in
message
> > > > > > news:%23C9OFl13DHA.1652@.TK2MSFTNGP11.phx.gbl...
> > > > > > > Log shipping is the best option. You don't really need a
> > monitoring
> > > > > > server.
> > > > > > > You could write your own logshipping scripts, customised for
> your
> > > > > > > requirements. If you search this newsgroup archive, you will
> find
> > > some
> > > > > > > scripts. Also checkout sql-server-performance.com
> > > > > > >
> > > > > > > --
> > > > > > > HTH,
> > > > > > > Vyas, MVP (SQL Server)
> > > > > > > http://vyaskn.tripod.com/
> > > > > > > Is .NET important for a database professional?
> > > > > > > http://vyaskn.tripod.com/poll.htm
> > > > > > >
> > > > > > >
> > > > > > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > > > > > news:%23ljrQh13DHA.3216@.TK2MSFTNGP11.phx.gbl...
> > > > > > > I have TWO networked servers; one production, and one backup.
I
> > > want
> > > > to
> > > > > > be
> > > > > > > able to use the backup in case of a production server failure.
> > The
> > > > loss
> > > > > > of
> > > > > > > a "little" data is acceptable in case of failure. Log
Shipping
> > > looks
> > > > > like
> > > > > > > the easiest but there seems to be a lot of warnings about (1)
> > having
> > > a
> > > > > > > monitor server, and (2) having this server NOT be either the
> > > > production
> > > > > > > server nor the backup. I only have two servers so I can't do
> > this.
> > > > > > >
> > > > > > > Is Log Shipping the best solution? Also--and this might
affect
> > > your
> > > > > > > response--it is possible that the backup system might not be
> > > > available
> > > > > > 100%
> > > > > > > of the time. I bring this up because I don't know what will
> > happen
> > > if
> > > > > the
> > > > > > > production system wants to ship a log, and the backup computer
> > isn't
> > > > > > > available to accept it. (')
> > > > > > >
> > > > > > > Any help, recommendations?
> > > > > > >
> > > > > > > TIA,
> > > > > > >
> > > > > > > Larry Woods
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> >
> >
> >
> >
>
>|||That's it! Adding 'dbo' AND bracketing the server name '2KDOTNET' did it!
THANKS!
You have been VERY helpful...and VERY patient.
Larry Woods
(Of course, it still doesn't work, but I'll keep digging. See my "access"
problem newsletter enquiry if you want to keep putting up with me!)
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:O1MAxW$3DHA.2480@.TK2MSFTNGP09.phx.gbl...
> It should be a 4 part name consiting of server name, database name, owner
> name and stored procedure name. You only have 3 parts in your call.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
>
> "Larry Woods" <larry@.lwoods.com> wrote in message
> news:#1Yim783DHA.2296@.TK2MSFTNGP11.phx.gbl...
> Here is the EXEC statement:
> EXEC 2KDOTNET.LogShippingAdmin.restore_database_backups
> The server that this is being executed on is named DEVELOPMENT; the remote
> server is 2KDOTNET.
> 2KDOTNET is the name of the remote server, and the name of the linked
server
> tht is defined in the local server, DEVELOPMENT.
>
> Larry
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:ephyzC53DHA.1636@.TK2MSFTNGP12.phx.gbl...
> > Could you show us what exactly you are trying to execute? Did you setup
a
> > linked server already?
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> > Is .NET important for a database professional?
> > http://vyaskn.tripod.com/poll.htm
> >
> >
> >
> >
> > "Larry Woods" <larry@.lwoods.com> wrote in message
> > news:#nQXc543DHA.2528@.TK2MSFTNGP10.phx.gbl...
> > Yes. If I use square brackets then it thinks that '2kDOTNET' is a
> database
> > name ...and says that it can't find it.
> >
> > Larry
> >
> > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > news:uRX2ri43DHA.1760@.TK2MSFTNGP10.phx.gbl...
> > > Have you tried square brackets. Example:
> > [2KDOTNET].DBName.dbo.ProcedureName
> > > --
> > > HTH,
> > > Vyas, MVP (SQL Server)
> > > http://vyaskn.tripod.com/
> > > Is .NET important for a database professional?
> > > http://vyaskn.tripod.com/poll.htm
> > >
> > >
> > >
> > >
> > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > news:O$7uzc43DHA.2000@.TK2MSFTNGP11.phx.gbl...
> > > Need some additional help, I am afraid, Vyas.
> > >
> > > I am trying to install the procedures from "How to Perform SQL Server
> Log
> > > Shipping." In it he executes a remote stored procedure. My remote
> server
> > > name starts with a number ("long history"). The problem that I am
> having
> > is
> > > that SQL Server will not execute a procedure name that starts with a
> > number,
> > > which I have to use since I am referencing a linkedserver that is
named
> > > '2KDOTNET'. I can't find any way around this.
> > >
> > > '''
> > >
> > > TIA,
> > >
> > > Larry
> > >
> > > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > > news:O1tkCw23DHA.1804@.TK2MSFTNGP12.phx.gbl...
> > > > It depends on the logshipping solution you go with. If your solution
> is
> > > > written to wait and retry, if the target server is down, then it
will
> > > > eventually continue restoring when the target server comes back up.
If
> > it
> > > is
> > > > not written to do so, you'll have bring back the target server, and
> > > restart
> > > > the task manually. The backup process should continue on the primary
> > > server
> > > > though.
> > > > --
> > > > HTH,
> > > > Vyas, MVP (SQL Server)
> > > > http://vyaskn.tripod.com/
> > > > Is .NET important for a database professional?
> > > > http://vyaskn.tripod.com/poll.htm
> > > >
> > > >
> > > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > > news:OsK0Yr23DHA.1816@.TK2MSFTNGP12.phx.gbl...
> > > > Just in the process of reading this one. Thanks. Also, one of my
> > earlier
> > > > questions was: What happens if the backup server is down when the
Log
> > > > Shipping want to take place? (Sorry if this is covered in the
> article.
> > I
> > > > haven't gotten that far).
> > > >
> > > > Larry
> > > >
> > > > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > > > news:%23Orcon23DHA.3936@.TK2MSFTNGP11.phx.gbl...
> > > > > Here's one example:
> > > > > http://www.sql-server-performance.com/sql_server_log_shipping.asp
> > > > > --
> > > > > HTH,
> > > > > Vyas, MVP (SQL Server)
> > > > > http://vyaskn.tripod.com/
> > > > > Is .NET important for a database professional?
> > > > > http://vyaskn.tripod.com/poll.htm
> > > > >
> > > > >
> > > > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > > > news:%23YDBUf23DHA.1804@.TK2MSFTNGP12.phx.gbl...
> > > > > So, you use TSQL? If so, can you point me to any sources?
> > > > >
> > > > > Thanks.
> > > > >
> > > > > Larry
> > > > >
> > > > > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > > > > news:uR2TeP23DHA.2428@.tk2msftngp13.phx.gbl...
> > > > > > Hmm...I am not sure about that error. Haven't used built-in
> > > logshipping
> > > > > > before, sorry. You could try searching on that error message at:
> > > > > > http://groups.google.com and http://support.microsoft.com
> > > > > > --
> > > > > > HTH,
> > > > > > Vyas, MVP (SQL Server)
> > > > > > http://vyaskn.tripod.com/
> > > > > > Is .NET important for a database professional?
> > > > > > http://vyaskn.tripod.com/poll.htm
> > > > > >
> > > > > >
> > > > > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > > > > news:OpACCO23DHA.488@.TK2MSFTNGP12.phx.gbl...
> > > > > > Getting further. I changed my service account to Administrator
> and
> > > now
> > > > I
> > > > > > was able to dump the logshipping file into the backup
> server...then
> > it
> > > > > > crashed on the second step, Initializing Destination, with the
> > error:
> > > > > >
> > > > > > Unable to copy the initialization file to the secondary server
> > > > '2KDOTNET'
> > > > > >
> > > > > > (Permissions will be the death of me yet!)
> > > > > >
> > > > > > Any ideas?
> > > > > >
> > > > > > TIA,
> > > > > >
> > > > > > Larry Woods
> > > > > >
> > > > > > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in
message
> > > > > > news:OtAFlz13DHA.3468@.TK2MSFTNGP11.phx.gbl...
> > > > > > > Make sure the SQL Server and SQL Agent service accounts have
> > > > permissions
> > > > > > to
> > > > > > > the share 2kdotnet\TransactionLogs_102\
> > > > > > > --
> > > > > > > HTH,
> > > > > > > Vyas, MVP (SQL Server)
> > > > > > > http://vyaskn.tripod.com/
> > > > > > > Is .NET important for a database professional?
> > > > > > > http://vyaskn.tripod.com/poll.htm
> > > > > > >
> > > > > > >
> > > > > > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > > > > > news:ujeGis13DHA.3196@.TK2MSFTNGP11.phx.gbl...
> > > > > > > Follow up question--I am NOT an SQL Server expert, by the
way.
> I
> > > am
> > > > > > trying
> > > > > > > some tests using Log Shipping. The database does NOT exist on
> the
> > > > > backup
> > > > > > > server. When I run the Maintenance Plan (last step) I
> immediately
> > > get
> > > > a
> > > > > > > "access denied" as follows:
> > > > > > >
> > > > > > > BackupDiskFile::CreateMedia: Backup device
> > > > > > 'G:\DummyDB_logshipping_init.bak'
> > > > > > > failed to create. Operating system error = 5(Access is
denied.).
> > > > > > >
> > > > > > > I am running under Adminstrator and both servers use the same
> > > password
> > > > > for
> > > > > > > Administrator. The "G" drive has Adminstrator permissions.
> BTW,
> > > "G"
> > > > > is
> > > > > > a
> > > > > > > folder on the backup server. Here is an earlier attempt:
> > > > > > >
> > > > > > > BackupDiskFile::CreateMedia: Backup device
> > > > > > > '\\2kdotnet\TransactionLogs_102\DummyDB_logshipping_init.bak'
> > failed
> > > > to
> > > > > > > create. Operating system error = 5(Access is denied.).
> > > > > > >
> > > > > > > Any help here?
> > > > > > >
> > > > > > > TIA,
> > > > > > >
> > > > > > > Larry Woods
> > > > > > >
> > > > > > > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in
> message
> > > > > > > news:%23C9OFl13DHA.1652@.TK2MSFTNGP11.phx.gbl...
> > > > > > > > Log shipping is the best option. You don't really need a
> > > monitoring
> > > > > > > server.
> > > > > > > > You could write your own logshipping scripts, customised for
> > your
> > > > > > > > requirements. If you search this newsgroup archive, you will
> > find
> > > > some
> > > > > > > > scripts. Also checkout sql-server-performance.com
> > > > > > > >
> > > > > > > > --
> > > > > > > > HTH,
> > > > > > > > Vyas, MVP (SQL Server)
> > > > > > > > http://vyaskn.tripod.com/
> > > > > > > > Is .NET important for a database professional?
> > > > > > > > http://vyaskn.tripod.com/poll.htm
> > > > > > > >
> > > > > > > >
> > > > > > > > "Larry Woods" <larry@.lwoods.com> wrote in message
> > > > > > > > news:%23ljrQh13DHA.3216@.TK2MSFTNGP11.phx.gbl...
> > > > > > > > I have TWO networked servers; one production, and one
backup.
> I
> > > > want
> > > > > to
> > > > > > > be
> > > > > > > > able to use the backup in case of a production server
failure.
> > > The
> > > > > loss
> > > > > > > of
> > > > > > > > a "little" data is acceptable in case of failure. Log
> Shipping
> > > > looks
> > > > > > like
> > > > > > > > the easiest but there seems to be a lot of warnings about
(1)
> > > having
> > > > a
> > > > > > > > monitor server, and (2) having this server NOT be either the
> > > > > production
> > > > > > > > server nor the backup. I only have two servers so I can't
do
> > > this.
> > > > > > > >
> > > > > > > > Is Log Shipping the best solution? Also--and this might
> affect
> > > > your
> > > > > > > > response--it is possible that the backup system might not
be
> > > > > available
> > > > > > > 100%
> > > > > > > > of the time. I bring this up because I don't know what will
> > > happen
> > > > if
> > > > > > the
> > > > > > > > production system wants to ship a log, and the backup
computer
> > > isn't
> > > > > > > > available to accept it. (')
> > > > > > > >
> > > > > > > > Any help, recommendations?
> > > > > > > >
> > > > > > > > TIA,
> > > > > > > >
> > > > > > > > Larry Woods
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > >
> >
> >
> >
> >
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment