Big log file in backup

I have backup of database which have log file (LDF file) big around 7GB. At
the moment it seem that I don't have enough space to restore it, Is it
possible that I some hove restore only MDF file or reduce size of LDF in
backup?
Johny
If you don't 'need' the LOG file , you can detach the database , remove the
log file and attach the database with the option as single file (only .mdf)
I'd recommed you to start perfoming BACKUP LOG file on regular period of
time so you will be able to manage the size of the log as well as having a
posibility to restore the data at point of time .
"Johny" <goky2002@.beograd.com> wrote in message
news:%23VoAafBMGHA.532@.TK2MSFTNGP15.phx.gbl...
>I have backup of database which have log file (LDF file) big around 7GB. At
> the moment it seem that I don't have enough space to restore it, Is it
> possible that I some hove restore only MDF file or reduce size of LDF in
> backup?
>

Big log file in backup

I have backup of database which have log file (LDF file) big around 7GB. At
the moment it seem that I don't have enough space to restore it, Is it
possible that I some hove restore only MDF file or reduce size of LDF in
backup?Johny
If you don't 'need' the LOG file , you can detach the database , remove the
log file and attach the database with the option as single file (only .mdf)
I'd recommed you to start perfoming BACKUP LOG file on regular period of
time so you will be able to manage the size of the log as well as having a
posibility to restore the data at point of time .
"Johny" <goky2002@.beograd.com> wrote in message
news:%23VoAafBMGHA.532@.TK2MSFTNGP15.phx.gbl...
>I have backup of database which have log file (LDF file) big around 7GB. At
> the moment it seem that I don't have enough space to restore it, Is it
> possible that I some hove restore only MDF file or reduce size of LDF in
> backup?
>

Big log file in backup

I have backup of database which have log file (LDF file) big around 7GB. At
the moment it seem that I don't have enough space to restore it, Is it
possible that I some hove restore only MDF file or reduce size of LDF in
backup?Johny
If you don't 'need' the LOG file , you can detach the database , remove the
log file and attach the database with the option as single file (only .mdf)
I'd recommed you to start perfoming BACKUP LOG file on regular period of
time so you will be able to manage the size of the log as well as having a
posibility to restore the data at point of time .
"Johny" <goky2002@.beograd.com> wrote in message
news:%23VoAafBMGHA.532@.TK2MSFTNGP15.phx.gbl...
>I have backup of database which have log file (LDF file) big around 7GB. At
> the moment it seem that I don't have enough space to restore it, Is it
> possible that I some hove restore only MDF file or reduce size of LDF in
> backup?
>

Better to backup up all server databases or backup system databases separately from databa

Gurus,
Running SQL Server 2005 SP2 and using named instances. I am having lots of
important application databases on my server these days. My question is
this. Is it better to back up all server databases in one maintenance plan
or backup system databases separately from databases?
Spin
I don't think it matters one way or another. But then it depends on what
issues you may be struggling with.
If you have scheduling issues running a single maintenance plan, break it up
into multiple plans. Personally, I prefer dealing system databases
separately. In particular, when you are dealing relatively large user
databases, you may not want to use the MS maintenance plans and may choose to
schedule their backups in your own schduler for better flexibility.
Linchi
Linchi
"Spin" wrote:

> Gurus,
> Running SQL Server 2005 SP2 and using named instances. I am having lots of
> important application databases on my server these days. My question is
> this. Is it better to back up all server databases in one maintenance plan
> or backup system databases separately from databases?
> --
> Spin
>

Better to backup up all server databases or backup system databases separately from databa

Gurus,
Running SQL Server 2005 SP2 and using named instances. I am having lots of
important application databases on my server these days. My question is
this. Is it better to back up all server databases in one maintenance plan
or backup system databases separately from databases?
--
SpinI don't think it matters one way or another. But then it depends on what
issues you may be struggling with.
If you have scheduling issues running a single maintenance plan, break it up
into multiple plans. Personally, I prefer dealing system databases
separately. In particular, when you are dealing relatively large user
databases, you may not want to use the MS maintenance plans and may choose to
schedule their backups in your own schduler for better flexibility.
Linchi
Linchi
"Spin" wrote:
> Gurus,
> Running SQL Server 2005 SP2 and using named instances. I am having lots of
> important application databases on my server these days. My question is
> this. Is it better to back up all server databases in one maintenance plan
> or backup system databases separately from databases?
> --
> Spin
>

Best way to test backup restores

Ok, so I'm using SQL Server 2000, and I'm just wondering what the best way
to test my backups is.
I don't want to restore over the actual database because it's still being
used. I realise I can just take a copy of the database and use that as the
new database - thus allowing me to restore the original, but this is not
actually what I want.
Is there any way to just 'verify' that the backup will be useable? Or to
restore it to a different database?
Thanks in advance
Amanda
Only way to really verify a SQL Server backup is to restore it. You don't need to create the
database beforehand, as the new database will be created with the RESTORE command. Pay attention to
the MOVE option of the RESTORE command.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Amanda Toogood" <amanda@.autumncare.com.au> wrote in message
news:OkQj1kOXEHA.1764@.TK2MSFTNGP10.phx.gbl...
> Ok, so I'm using SQL Server 2000, and I'm just wondering what the best way
> to test my backups is.
> I don't want to restore over the actual database because it's still being
> used. I realise I can just take a copy of the database and use that as the
> new database - thus allowing me to restore the original, but this is not
> actually what I want.
> Is there any way to just 'verify' that the backup will be useable? Or to
> restore it to a different database?
> Thanks in advance
> Amanda
>
|||Hi,
Use the VERIFYONLY option in RESTORE DATABASE comamnd. This verifies the
backup but does not restore the backup. THis command Checks to see that the
backup set is complete and that all volumes are readable. However, RESTORE
VERIFYONLY does not attempt to verify the structure of the data contained in
the backup volumes.
RESTORE VERIFYONLY from disk='c:\backup\dbname.bak'
This command executes for the backup file provided and If the backup is
valid, Microsoft SQL Server 2000 returns the message:
"The backup set is valid."
Thanks
Hari
MCDBA
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e8r#3yOXEHA.2716@.tk2msftngp13.phx.gbl...
> Only way to really verify a SQL Server backup is to restore it. You don't
need to create the
> database beforehand, as the new database will be created with the RESTORE
command. Pay attention to[vbcol=seagreen]
> the MOVE option of the RESTORE command.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Amanda Toogood" <amanda@.autumncare.com.au> wrote in message
> news:OkQj1kOXEHA.1764@.TK2MSFTNGP10.phx.gbl...
way[vbcol=seagreen]
being[vbcol=seagreen]
the
>
|||I do not recommend using VERIFYONLY, as it basically only verify that the backup file is readable.
I.e., it gives us false security, IMO.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OQ2iGFQXEHA.1440@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Use the VERIFYONLY option in RESTORE DATABASE comamnd. This verifies the
> backup but does not restore the backup. THis command Checks to see that the
> backup set is complete and that all volumes are readable. However, RESTORE
> VERIFYONLY does not attempt to verify the structure of the data contained in
> the backup volumes.
> RESTORE VERIFYONLY from disk='c:\backup\dbname.bak'
> This command executes for the backup file provided and If the backup is
> valid, Microsoft SQL Server 2000 returns the message:
> "The backup set is valid."
>
> Thanks
> Hari
> MCDBA
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:e8r#3yOXEHA.2716@.tk2msftngp13.phx.gbl...
> need to create the
> command. Pay attention to
> way
> being
> the
>
|||I have to agree with Tibor on this, the only true way to test is to actually
do the complete restore. I've certainly see restore issues with backups that
passed a verifyonly. Better safe than sorry :-)
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eD6n3bQXEHA.3640@.TK2MSFTNGP11.phx.gbl...
> I do not recommend using VERIFYONLY, as it basically only verify that the
backup file is readable.[vbcol=seagreen]
> I.e., it gives us false security, IMO.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:OQ2iGFQXEHA.1440@.TK2MSFTNGP12.phx.gbl...
the[vbcol=seagreen]
RESTORE[vbcol=seagreen]
contained in[vbcol=seagreen]
in[vbcol=seagreen]
don't[vbcol=seagreen]
RESTORE[vbcol=seagreen]
best[vbcol=seagreen]
as[vbcol=seagreen]
not[vbcol=seagreen]
Or to
>
|||I have to agree with Tibor on this, the only true way to test is to actually
do the complete restore. I've certainly see restore issues with backups that
passed a verifyonly. Better safe than sorry :-)
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eD6n3bQXEHA.3640@.TK2MSFTNGP11.phx.gbl...
> I do not recommend using VERIFYONLY, as it basically only verify that the
backup file is readable.[vbcol=seagreen]
> I.e., it gives us false security, IMO.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:OQ2iGFQXEHA.1440@.TK2MSFTNGP12.phx.gbl...
the[vbcol=seagreen]
RESTORE[vbcol=seagreen]
contained in[vbcol=seagreen]
in[vbcol=seagreen]
don't[vbcol=seagreen]
RESTORE[vbcol=seagreen]
best[vbcol=seagreen]
as[vbcol=seagreen]
not[vbcol=seagreen]
Or to
>
|||I will also strongly agree. You might even wish to run a DBCC CHECKDB on it
after the restore. Of coarse if there was corruption in the original db it
will be in the restored one as well.
Andrew J. Kelly SQL MVP
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:%23K4hwWTXEHA.644@.tk2msftngp13.phx.gbl...
> I have to agree with Tibor on this, the only true way to test is to
actually
> do the complete restore. I've certainly see restore issues with backups
that
> passed a verifyonly. Better safe than sorry :-)
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in[vbcol=seagreen]
> message news:eD6n3bQXEHA.3640@.TK2MSFTNGP11.phx.gbl...
the[vbcol=seagreen]
> backup file is readable.
the[vbcol=seagreen]
that[vbcol=seagreen]
> the
> RESTORE
> contained in
is[vbcol=seagreen]
wrote[vbcol=seagreen]
> in
> don't
> RESTORE
> best
still[vbcol=seagreen]
that[vbcol=seagreen]
> as
is
> not
> Or to
>
|||I will also strongly agree. You might even wish to run a DBCC CHECKDB on it
after the restore. Of coarse if there was corruption in the original db it
will be in the restored one as well.
Andrew J. Kelly SQL MVP
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:%23K4hwWTXEHA.644@.tk2msftngp13.phx.gbl...
> I have to agree with Tibor on this, the only true way to test is to
actually
> do the complete restore. I've certainly see restore issues with backups
that
> passed a verifyonly. Better safe than sorry :-)
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in[vbcol=seagreen]
> message news:eD6n3bQXEHA.3640@.TK2MSFTNGP11.phx.gbl...
the[vbcol=seagreen]
> backup file is readable.
the[vbcol=seagreen]
that[vbcol=seagreen]
> the
> RESTORE
> contained in
is[vbcol=seagreen]
wrote[vbcol=seagreen]
> in
> don't
> RESTORE
> best
still[vbcol=seagreen]
that[vbcol=seagreen]
> as
is
> not
> Or to
>
|||Thanks for the advice everyone, I'll probably end up doing a verify only AND
an actual restore. Definitely better to be safe than sorry.
Thanks again
Amanda
"Amanda Toogood" <amanda@.autumncare.com.au> wrote in message
news:OkQj1kOXEHA.1764@.TK2MSFTNGP10.phx.gbl...
> Ok, so I'm using SQL Server 2000, and I'm just wondering what the best way
> to test my backups is.
> I don't want to restore over the actual database because it's still being
> used. I realise I can just take a copy of the database and use that as the
> new database - thus allowing me to restore the original, but this is not
> actually what I want.
> Is there any way to just 'verify' that the backup will be useable? Or to
> restore it to a different database?
> Thanks in advance
> Amanda
>
|||Thanks for the advice everyone, I'll probably end up doing a verify only AND
an actual restore. Definitely better to be safe than sorry.
Thanks again
Amanda
"Amanda Toogood" <amanda@.autumncare.com.au> wrote in message
news:OkQj1kOXEHA.1764@.TK2MSFTNGP10.phx.gbl...
> Ok, so I'm using SQL Server 2000, and I'm just wondering what the best way
> to test my backups is.
> I don't want to restore over the actual database because it's still being
> used. I realise I can just take a copy of the database and use that as the
> new database - thus allowing me to restore the original, but this is not
> actually what I want.
> Is there any way to just 'verify' that the backup will be useable? Or to
> restore it to a different database?
> Thanks in advance
> Amanda
>

Best way to take backUp

Which is the best way to take BackUp of the DB from MSSQL 2000 to a
secondary server with out loosing any single Insert/update?Hi
Do you want the secondary server read only ?
1)Log shipping
2) Repliaction
"imtiaz" <Imtiaz@.microsoft.com> wrote in message
news:uioGWaxfGHA.3860@.TK2MSFTNGP02.phx.gbl...
> Which is the best way to take BackUp of the DB from MSSQL 2000 to a
> secondary server with out loosing any single Insert/update?
>|||Yes I want secondary server to be readonly/ or to a backup device is also
will work.
Can you please explain the following in detail(steps)
1.log shipping
2.replication
Thanks in advance
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OFfRO3xfGHA.1276@.TK2MSFTNGP03.phx.gbl...
> Hi
> Do you want the secondary server read only ?
> 1)Log shipping
> 2) Repliaction
> "imtiaz" <Imtiaz@.microsoft.com> wrote in message
> news:uioGWaxfGHA.3860@.TK2MSFTNGP02.phx.gbl...
>|||Check this out
http://www.sql-server-performance.c...og_shipping.asp
I guess it would give you an good idea about Log Shipping in SQL Server.
Best Regards
Vadivel
http://vadivel.blogspot.com
"imtiaz" wrote:

> Yes I want secondary server to be readonly/ or to a backup device is also
> will work.
> Can you please explain the following in detail(steps)
> 1.log shipping
> 2.replication
> Thanks in advance
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OFfRO3xfGHA.1276@.TK2MSFTNGP03.phx.gbl...
>
>|||http://www.sql-server-performance.c...og_shipping.asp
About replications it is very big topic , you are going to spend a lot of
time to learn it
http://www.mssqlcity.com/Articles/Replic/Replic.htm --Setting All
Replica (Step by step)
"imtiaz" <Imtiaz@.microsoft.com> wrote in message
news:OlYL4AyfGHA.1792@.TK2MSFTNGP03.phx.gbl...
> Yes I want secondary server to be readonly/ or to a backup device is also
> will work.
> Can you please explain the following in detail(steps)
> 1.log shipping
> 2.replication
> Thanks in advance
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OFfRO3xfGHA.1276@.TK2MSFTNGP03.phx.gbl...
>

Best way to make a copy of an existing sql server database to another (physical) server

Hello!
What is the best way to make a copy of an existing sql server database to another (physical) server?
Plan to make a full backup of another sql server database to another server. I've read about detach and attach
and copying the datafiles and log files but some say it is prone to data loss? Is this true?

And another thing, what if the existing sql server can't affor downtime for me to copy db files etc.?

Anybody here who have done the same?

Any help is very much appreciated.

Thanks!

(a) if u don't have down time then the best method is Backup/restore...

(b) If you have down time both Detach/attach and backup/restore can be used. ..

(c) You can also use COPY Database Wizards

(d) You have to copy all the server level components to the new server. by copying use database Jobs/Packages/operator etc are not copied

(e) If you have to transfer the login also refer http://support.microsoft.com/kb/246133

I would always prefer Backup/restore method

Madhu

|||Thank you very much!

Best way to keep a database synched with a server that is outside the firewall

Hi,
We have two servers, one inside the firewall and one outside and need to
keep them synched up on a daily basis. Short of doing full backup and
restore, what is best solution?
Thanks.
<a> wrote in message news:eE7ukKlcHHA.3484@.TK2MSFTNGP04.phx.gbl...
> Hi,
> We have two servers, one inside the firewall and one outside and need to
> keep them synched up on a daily basis. Short of doing full backup and
> restore, what is best solution?
Depends on what you need.
If you need read-only, I'd go with either replication or log-shipping.
With log-shipping just create a stand-by file between loading each log file.
You'll be able to read from the database.
Shipping just the log files should be smaller than a full-backup and
restore.
If you go with replication, you're probably going to have to open up your
firewall a bit more and be a bit more careful about security.
But then you won't get kicked out each time changes are made on the outside
server.

> Thanks.
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
|||Thank for the response. Can I set up log shipping or replication when the
primary and secondary server can not even see each other? The only port
open on the primary server's firewall is 80. Thanks again.
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:euMRAfncHHA.4772@.TK2MSFTNGP05.phx.gbl...
> <a> wrote in message news:eE7ukKlcHHA.3484@.TK2MSFTNGP04.phx.gbl...
> Depends on what you need.
> If you need read-only, I'd go with either replication or log-shipping.
> With log-shipping just create a stand-by file between loading each log
> file. You'll be able to read from the database.
> Shipping just the log files should be smaller than a full-backup and
> restore.
> If you go with replication, you're probably going to have to open up your
> firewall a bit more and be a bit more careful about security.
> But then you won't get kicked out each time changes are made on the
> outside server.
>
> --
> Greg Moore
> SQL Server DBA Consulting Remote and Onsite available!
> Email: sql (at) greenms.com
> http://www.greenms.com/sqlserver.html
>
|||<a> wrote in message news:uM2c7hucHHA.4624@.TK2MSFTNGP03.phx.gbl...
> Thank for the response. Can I set up log shipping or replication when the
> primary and secondary server can not even see each other? The only port
> open on the primary server's firewall is 80. Thanks again.
Hmm... not out of the box.
Realistically you probably could do this through port 80, but it would be a
mess.
One possible way, though a bit more complicated and error prone, would be to
log-ship the files via FTP.

> "Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in
> message news:euMRAfncHHA.4772@.TK2MSFTNGP05.phx.gbl...
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

Best way to keep a database synched with a server that is outside the firewall

Hi,
We have two servers, one inside the firewall and one outside and need to
keep them synched up on a daily basis. Short of doing full backup and
restore, what is best solution?
Thanks.<a> wrote in message news:eE7ukKlcHHA.3484@.TK2MSFTNGP04.phx.gbl...
> Hi,
> We have two servers, one inside the firewall and one outside and need to
> keep them synched up on a daily basis. Short of doing full backup and
> restore, what is best solution?
Depends on what you need.
If you need read-only, I'd go with either replication or log-shipping.
With log-shipping just create a stand-by file between loading each log file.
You'll be able to read from the database.
Shipping just the log files should be smaller than a full-backup and
restore.
If you go with replication, you're probably going to have to open up your
firewall a bit more and be a bit more careful about security.
But then you won't get kicked out each time changes are made on the outside
server.

> Thanks.
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||Thank for the response. Can I set up log shipping or replication when the
primary and secondary server can not even see each other? The only port
open on the primary server's firewall is 80. Thanks again.
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:euMRAfncHHA.4772@.TK2MSFTNGP05.phx.gbl...
> <a> wrote in message news:eE7ukKlcHHA.3484@.TK2MSFTNGP04.phx.gbl...
> Depends on what you need.
> If you need read-only, I'd go with either replication or log-shipping.
> With log-shipping just create a stand-by file between loading each log
> file. You'll be able to read from the database.
> Shipping just the log files should be smaller than a full-backup and
> restore.
> If you go with replication, you're probably going to have to open up your
> firewall a bit more and be a bit more careful about security.
> But then you won't get kicked out each time changes are made on the
> outside server.
>
> --
> Greg Moore
> SQL Server DBA Consulting Remote and Onsite available!
> Email: sql (at) greenms.com
> http://www.greenms.com/sqlserver.html
>|||<a> wrote in message news:uM2c7hucHHA.4624@.TK2MSFTNGP03.phx.gbl...
> Thank for the response. Can I set up log shipping or replication when the
> primary and secondary server can not even see each other? The only port
> open on the primary server's firewall is 80. Thanks again.
Hmm... not out of the box.
Realistically you probably could do this through port 80, but it would be a
mess.
One possible way, though a bit more complicated and error prone, would be to
log-ship the files via FTP.

> "Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in
> message news:euMRAfncHHA.4772@.TK2MSFTNGP05.phx.gbl...
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

Best way to keep a database synched with a server that is outside the firewall

Hi,
We have two servers, one inside the firewall and one outside and need to
keep them synched up on a daily basis. Short of doing full backup and
restore, what is best solution?
Thanks.<a> wrote in message news:eE7ukKlcHHA.3484@.TK2MSFTNGP04.phx.gbl...
> Hi,
> We have two servers, one inside the firewall and one outside and need to
> keep them synched up on a daily basis. Short of doing full backup and
> restore, what is best solution?
Depends on what you need.
If you need read-only, I'd go with either replication or log-shipping.
With log-shipping just create a stand-by file between loading each log file.
You'll be able to read from the database.
Shipping just the log files should be smaller than a full-backup and
restore.
If you go with replication, you're probably going to have to open up your
firewall a bit more and be a bit more careful about security.
But then you won't get kicked out each time changes are made on the outside
server.
> Thanks.
>
--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||Thank for the response. Can I set up log shipping or replication when the
primary and secondary server can not even see each other? The only port
open on the primary server's firewall is 80. Thanks again.
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:euMRAfncHHA.4772@.TK2MSFTNGP05.phx.gbl...
> <a> wrote in message news:eE7ukKlcHHA.3484@.TK2MSFTNGP04.phx.gbl...
>> Hi,
>> We have two servers, one inside the firewall and one outside and need to
>> keep them synched up on a daily basis. Short of doing full backup and
>> restore, what is best solution?
> Depends on what you need.
> If you need read-only, I'd go with either replication or log-shipping.
> With log-shipping just create a stand-by file between loading each log
> file. You'll be able to read from the database.
> Shipping just the log files should be smaller than a full-backup and
> restore.
> If you go with replication, you're probably going to have to open up your
> firewall a bit more and be a bit more careful about security.
> But then you won't get kicked out each time changes are made on the
> outside server.
>
>> Thanks.
> --
> Greg Moore
> SQL Server DBA Consulting Remote and Onsite available!
> Email: sql (at) greenms.com
> http://www.greenms.com/sqlserver.html
>|||<a> wrote in message news:uM2c7hucHHA.4624@.TK2MSFTNGP03.phx.gbl...
> Thank for the response. Can I set up log shipping or replication when the
> primary and secondary server can not even see each other? The only port
> open on the primary server's firewall is 80. Thanks again.
Hmm... not out of the box.
Realistically you probably could do this through port 80, but it would be a
mess.
One possible way, though a bit more complicated and error prone, would be to
log-ship the files via FTP.
> "Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in
> message news:euMRAfncHHA.4772@.TK2MSFTNGP05.phx.gbl...
>> <a> wrote in message news:eE7ukKlcHHA.3484@.TK2MSFTNGP04.phx.gbl...
>> Hi,
>> We have two servers, one inside the firewall and one outside and need to
>> keep them synched up on a daily basis. Short of doing full backup and
>> restore, what is best solution?
>> Depends on what you need.
>> If you need read-only, I'd go with either replication or log-shipping.
>> With log-shipping just create a stand-by file between loading each log
>> file. You'll be able to read from the database.
>> Shipping just the log files should be smaller than a full-backup and
>> restore.
>> If you go with replication, you're probably going to have to open up your
>> firewall a bit more and be a bit more careful about security.
>> But then you won't get kicked out each time changes are made on the
>> outside server.
>>
>> Thanks.
>>
>> --
>> Greg Moore
>> SQL Server DBA Consulting Remote and Onsite available!
>> Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
>>
>
--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

Best way to implement "warm" standby? - considering log shipping

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
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > >
> >
> >
> >
> >
>
>