Best way to copy database: production

Showing posts with label production. Show all posts

Wednesday, March 7, 2012

Between database servers

Hi all,
I like to access a production database server from my development database,
I need to count how fast one table in the production table grows, is there
any way to do it without actually getting on the production server? linked
server?
Thanks.Yes you can create a linked server
http://sqlservercode.blogspot.com/
"Matthew Z" wrote:
> Hi all,
> I like to access a production database server from my development database,
> I need to count how fast one table in the production table grows, is there
> any way to do it without actually getting on the production server? linked
> server?
> Thanks.|||Thanks. Because the company security reseans, I can't use the linked server,
is there a way to work around?
"SQL" wrote:
> Yes you can create a linked server
> http://sqlservercode.blogspot.com/
>
> "Matthew Z" wrote:
> > Hi all,
> > I like to access a production database server from my development database,
> > I need to count how fast one table in the production table grows, is there
> > any way to do it without actually getting on the production server? linked
> > server?
> >
> > Thanks.|||look up OPENROWSET and OPENDATASOURCE in Books on line
http://sqlservercode.blogspot.com/
"Matthew Z" wrote:
> Thanks. Because the company security reseans, I can't use the linked server,
> is there a way to work around?
>
> "SQL" wrote:
> > Yes you can create a linked server
> >
> > http://sqlservercode.blogspot.com/
> >
> >
> > "Matthew Z" wrote:
> >
> > > Hi all,
> > > I like to access a production database server from my development database,
> > > I need to count how fast one table in the production table grows, is there
> > > any way to do it without actually getting on the production server? linked
> > > server?
> > >
> > > Thanks.|||Thanks for reply.
Even I have sa permission to all sql servers, I still can't have have access
from one server to a different server.
"SQL" wrote:
> look up OPENROWSET and OPENDATASOURCE in Books on line
> http://sqlservercode.blogspot.com/
>
> "Matthew Z" wrote:
> > Thanks. Because the company security reseans, I can't use the linked server,
> > is there a way to work around?
> >
> >
> > "SQL" wrote:
> >
> > > Yes you can create a linked server
> > >
> > > http://sqlservercode.blogspot.com/
> > >
> > >
> > > "Matthew Z" wrote:
> > >
> > > > Hi all,
> > > > I like to access a production database server from my development database,
> > > > I need to count how fast one table in the production table grows, is there
> > > > any way to do it without actually getting on the production server? linked
> > > > server?
> > > >
> > > > Thanks.|||Matthew,
as SQL said:
1. Linked Server
2. OPENROWSET or OPENDATASOURCE - neither requires a linked server to be
created
3. Use EM, QA, OSQL or some other application to connect directly to your
other server.
4. Job or DTS to get the value required to your local db
HTH
Jerry
"Matthew Z" <MatthewZ@.discussions.microsoft.com> wrote in message
news:46E45877-8585-4709-AEA8-BDD7886E7FC5@.microsoft.com...
> Thanks for reply.
> Even I have sa permission to all sql servers, I still can't have have
> access
> from one server to a different server.
> "SQL" wrote:
>> look up OPENROWSET and OPENDATASOURCE in Books on line
>> http://sqlservercode.blogspot.com/
>>
>> "Matthew Z" wrote:
>> > Thanks. Because the company security reseans, I can't use the linked
>> > server,
>> > is there a way to work around?
>> >
>> >
>> > "SQL" wrote:
>> >
>> > > Yes you can create a linked server
>> > >
>> > > http://sqlservercode.blogspot.com/
>> > >
>> > >
>> > > "Matthew Z" wrote:
>> > >
>> > > > Hi all,
>> > > > I like to access a production database server from my development
>> > > > database,
>> > > > I need to count how fast one table in the production table grows,
>> > > > is there
>> > > > any way to do it without actually getting on the production server?
>> > > > linked
>> > > > server?
>> > > >
>> > > > Thanks.|||Another option is to create an xp_sendmail proc job on the production DB
that will mail the result to yourself whenever you execute this job
"Matthew Z" wrote:
> Thanks for reply.
> Even I have sa permission to all sql servers, I still can't have have access
> from one server to a different server.
> "SQL" wrote:
> > look up OPENROWSET and OPENDATASOURCE in Books on line
> >
> > http://sqlservercode.blogspot.com/
> >
> >
> >
> > "Matthew Z" wrote:
> >
> > > Thanks. Because the company security reseans, I can't use the linked server,
> > > is there a way to work around?
> > >
> > >
> > > "SQL" wrote:
> > >
> > > > Yes you can create a linked server
> > > >
> > > > http://sqlservercode.blogspot.com/
> > > >
> > > >
> > > > "Matthew Z" wrote:
> > > >
> > > > > Hi all,
> > > > > I like to access a production database server from my development database,
> > > > > I need to count how fast one table in the production table grows, is there
> > > > > any way to do it without actually getting on the production server? linked
> > > > > server?
> > > > >
> > > > > Thanks.|||Thanks guys, based on your replies,I got a idea, I may try DTS job & send
mail functions. This is not a one time process, it runs every week for
reporting Purpose.
"Matthew Z" wrote:
> Hi all,
> I like to access a production database server from my development database,
> I need to count how fast one table in the production table grows, is there
> any way to do it without actually getting on the production server? linked
> server?
> Thanks.

Between database servers

Saturday, February 25, 2012

Between database servers

Friday, February 24, 2012

Best Way To Update Existing Rows

IUpdating existing rows in a SQL server 2005 destination table

--I have a CSV file and every row needs to perform an update on a production table

The most straight forward is to use an OLEDB Command Data Flow Transformation Object that sends one SQL statement per row coming in. How do I configure this object ?

That might be okay if you've only got a small number of updates, however if you've got a large set, I prefer landing this set to a temporary table and then doing Set based updates in a following Execute SQL task. Can you please tell me how I can set up the Execute SQL Task to do set based updates in the Control flow?

thanks in advance

Dave

Mr Pro Tools wrote:

IUpdating existing rows in a SQL server 2005 destination table
--I have a CSV file and every row needs to perform an update on a production table
The most straight forward is to use an OLEDB Command Data Flow Transformation Object that sends one SQL statement per row coming in. How do I configure this object ?

I assume you can write SQL, right?

All explained here: http://msdn2.microsoft.com/en-us/library/ms141138.aspx

Mr Pro Tools wrote:

That might be okay if you've only got a small number of updates, however if you've got a large set, I prefer landing this set to a temporary table and then doing Set based updates in a following Execute SQL task. Can you please tell me how I can set up the Execute SQL Task to do set based updates in the Control flow?
thanks in advance
Dave

Again, I assume you can write SQL. Just paste your SQL into the 'SQL Statement' proeprty of the Execute SQL Task.

-Jamie

|||

Thanks Jamie

First method works --Profiler is telling me its taking about a second per update

but is too slow as I have 900,000 records to update across two tables each having 7 million records which will take

889,641 records in the file supplied / 3600 per hour (1 per second)

= 250 hours

= 10 days

the Excecute SQL task looks like another option and sure I can paste into the SQL Statement window my sproc Exec dbo.MySproc ?,?

How do I map ?,? to each row in the Execute SQL Task--in other words what are the main properties I have to set for row by row processing and is it much faster than the OLE DB Command Transformation method --which is nice and simple and slow

thanks in advance

Dave

|||

Mr Pro Tools wrote:

Thanks Jamie
First method works --Profiler is telling me its taking about a second per update
but is too slow as I have 900,000 records to update across two tables each having 7 million records which will take
889,641 records in the file supplied / 3600 per hour (1 per second)

= 250 hours

= 10 days
the Excecute SQL task looks like another option and sure I can paste into the SQL Statement window my sproc Exec dbo.MySproc ?,?
How do I map ?,? to each row in the Execute SQL Task--in other words what are the main properties I have to set for row by row processing and is it much faster than the OLE DB Command Transformation method --which is nice and simple and slow
thanks in advance
Dave

I'm confused (seems to happen alot these days ) Why are you trying to map any columns at all using '?' ?

All you have to do is load the data into a temporary staging area (using OLE DB Destination) and then issue a SQL statement along the lines of:

UPDATE t

SET t.<col> = te.<col> ,......

FROM target t INNER JOIN temp te ON <some join columns>

Also, if OLE DB Command really is taking one second per row then your bottleneck is not the OLE DB Comamnd. its something else.

-Jamie

|||

Mr Pro Tools wrote:

How do I map ?,? to each row in the Execute SQL Task--in other words what are the main properties I have to set for row by row processing and is it much faster than the OLE DB Command Transformation method --which is nice and simple and slow

Dave,

The OLEDB command is just slow becasue performs the same command in a row by row basis. The intention of using a Execute SQL task is to be able to perform execute a SQL command over a set of rows at once. What Jamie is sugesting is to push the rows in your CSV file to an staging table and then, in control flow to issue un Update stament against your target table using the staging table rows. That would be a one time update.

|||

UPDATE t

SET t.<col> = te.<col> ,......

FROM target t INNER JOIN temp te ON <some join columns>

Yeah that is simple enough what Im getting at is can the Execute SQL Task do row by row processing like the DTS DDQ task and how do set the properties if so

In my case the updates will only occur if one of columns in the temp staging table has an particular value in a column

If it has --we do the update otherwise do a delete

thats why I had ? as parameters for a store prod

|||

No, the Execute SQL Task does not do row-by-row processing. As already established, that's what the OLE DB Command does.

-Jamie

Sunday, February 19, 2012

Best way to promote DTS packages

To make the packages portable I have made connections as (local). Because once the packages go from say Development to Production, they would still work without re-designing them on a different box. The '(local)' as a the servername always looks for a the (local) server its on. But this seems too simple.

I have tired different methods such as using a INI file, Dynamic Protperties task etc., I have used global variables in the packages. Ultimately, I have used configuration tables to supply all the global variables, file names, etc.

Is there a flaw in this idea? Has anyone tired this before? If not how have you made DTS packages portable? Any ideas?

Thanks in advance.Your Idea sounds fine, but how does the package identify which record to pull to get the correct information. Do you query the server name, and use that in a where clause?

This is what I do, I put all my information in the registry of that machine. then have an active x script pull it out and assign it to global variables, then populate the properties of the tasks. How you populate the properties depends on the version of sql you are running.

hope this helps.|||Your Idea sounds fine, but how does the package identify which record to pull to get the correct information. Do you query the server name, and use that in a where clause?

This is what I do, I put all my information in the registry of that machine. then have an active x script pull it out and assign it to global variables, then populate the properties of the tasks. How you populate the properties depends on the version of sql you are running.

hope this helps.|||Originally posted by SHICKS
Your Idea sounds fine, but how does the package identify which record to pull to get the correct information. Do you query the server name, and use that in a where clause?

This is what I do, I put all my information in the registry of that machine. then have an active x script pull it out and assign it to global variables, then populate the properties of the tasks. How you populate the properties depends on the version of sql you are running.

hope this helps.

Yeah i run queries using the dynamic task properties to assign the global variables with the proper value from a conflict table. I have heard alot about putting the information in the registry of that machine. To do this wont you need to go on the computer you want to put the reg on? IF thats the case, it's hard for me to do that cuz the DEV,UAT,Production are spread all over the country.

But I would appreciate if I could find some more information about using registries.

Thanks is advance.|||Originally posted by vmlal
Yeah i run queries using the dynamic task properties to assign the global variables with the proper value from a conflict table. I have heard alot about putting the information in the registry of that machine. To do this wont you need to go on the computer you want to put the reg on? IF thats the case, it's hard for me to do that cuz the DEV,UAT,Production are spread all over the country.

But I would appreciate if I could find some more information about using registries.

Thanks is advance.

Updating the registry on remote machines is an administration issue I don't think I can anwser, but here is how I read the registy in an ActiveX script

Dim sh

Set sh = CreateObject("WScript.Shell")

path=sh.RegRead("HKEY_LOCAL_MACHINE\SOFTWARE\FileLocations\Path")
server=sh.RegRead("HKEY_LOCAL_MACHINE\SOFTWARE\Server\Server")
database=sh.RegRead("HKEY_LOCAL_MACHINE\SOFTWARE\Server\Database")
username=sh.RegRead("HKEY_LOCAL_MACHINE\SOFTWARE\Login\Username")
password=sh.RegRead("HKEY_LOCAL_MACHINE\SOFTWARE\Login\Password")

Thursday, February 16, 2012

best way to move database from development to production

Hi,
What's the best way to move a database from development server (once you
have done all the testing and everything runs fine) to the production server?
Thanks in advance.
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:4E363380-ED77-4A23-8F76-6EAB7573394B@.microsoft.com...
> Hi,
> What's the best way to move a database from development server (once you
> have done all the testing and everything runs fine) to the production
> server?
> Thanks in advance.
|||"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:4E363380-ED77-4A23-8F76-6EAB7573394B@.microsoft.com...
> Hi,
> What's the best way to move a database from development server (once you
> have done all the testing and everything runs fine) to the production
> server?
> Thanks in advance.
|||Hi,
1. Perform a database backup in Dev server
2. Send the BAK file to prod server
3. Restore the database into right drives
4. Clean up all the development data
5. Increase the MDF and LDF size. Project atleast for next 1 year.
6. Setup the recovery model to FULL
7. Setup the FULL Backup and Transaction log backup jobs
8. Setup the DBCC CHECKDB job every day night
9. Setup the Update Statistics every day night
10. Setup the Re-Indexing jobs every weekends...
Thanks
Hari
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:4E363380-ED77-4A23-8F76-6EAB7573394B@.microsoft.com...
> Hi,
> What's the best way to move a database from development server (once you
> have done all the testing and everything runs fine) to the production
> server?
> Thanks in advance.
|||Use Backup/Restore. (Leaves a copy for DEV use.)
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:4E363380-ED77-4A23-8F76-6EAB7573394B@.microsoft.com...
> Hi,
> What's the best way to move a database from development server (once you
> have done all the testing and everything runs fine) to the production
> server?
> Thanks in advance.
|||Hi
This will depend on what you want to do! If you only have one live site you
may use the backup/restore approach as described by others. If you have
multiple sites or if there is any cleaning up then you may want build basic
database in the development environment and then ship this template database
into live. You could then have an installation process which adds any site
specific data. Whatever method you use it should be tested!
This may be useful http://support.microsoft.com/kb/314546
John
"sharman" wrote:

> Hi,
> What's the best way to move a database from development server (once you
> have done all the testing and everything runs fine) to the production server?
> Thanks in advance.
|||Hi,
Thanks for the reply. I was reading the article at
http://support.microsoft.com/kb/314546 and found that it mentions moving the
logins, jobs, alerts, operators and dts packages separately.
I have done backup/restore procedures before and I recall that everything
related to the databse (logins, passwords, dts packages) gets moved except
for the jobs, alerts and operators that has to be set up separately. Please
correct me if I am wrong. Thanks again.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> This will depend on what you want to do! If you only have one live site you
> may use the backup/restore approach as described by others. If you have
> multiple sites or if there is any cleaning up then you may want build basic
> database in the development environment and then ship this template database
> into live. You could then have an installation process which adds any site
> specific data. Whatever method you use it should be tested!
> This may be useful http://support.microsoft.com/kb/314546
> John
> "sharman" wrote:
|||Jobs, Alerts, Operators, DTS Packages, etc., are not database specific, but
server specific,and kept in the msdb database. Anything that is not
accessible throught the user database (using EM or SSMS) is not included in
a database backup. If you want those items, you will need to script them out
and add the scripts to the installation process.
Perhaps you can also move the msdb database. See:
Moving Databases to a new location
http://support.microsoft.com/kb/224071/EN-US/
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:356DBCC1-E61B-478A-82D7-8BC784EC281F@.microsoft.com...[vbcol=seagreen]
> Hi,
> Thanks for the reply. I was reading the article at
> http://support.microsoft.com/kb/314546 and found that it mentions moving
> the
> logins, jobs, alerts, operators and dts packages separately.
> I have done backup/restore procedures before and I recall that everything
> related to the databse (logins, passwords, dts packages) gets moved except
> for the jobs, alerts and operators that has to be set up separately.
> Please
> correct me if I am wrong. Thanks again.
> "John Bell" wrote:
|||Hi
Your database users will get transferred, but if your destination machine is
not on the same domain or if you are using SQL Server logins, then you will
most likely get orphaned users which are users who are not associated to a
login. See http://support.microsoft.com/kb/274188/ for more on this.
Jobs etc can be scripted (which if you are using source code control you
would have done already!) and recreated on the destination server. For DTS
packages you can use DTS Backup http://www.sqldts.com/default.aspx?242.
HTH
John
"sharman" wrote:
[vbcol=seagreen]
> Hi,
> Thanks for the reply. I was reading the article at
> http://support.microsoft.com/kb/314546 and found that it mentions moving the
> logins, jobs, alerts, operators and dts packages separately.
> I have done backup/restore procedures before and I recall that everything
> related to the databse (logins, passwords, dts packages) gets moved except
> for the jobs, alerts and operators that has to be set up separately. Please
> correct me if I am wrong. Thanks again.
> "John Bell" wrote:
|||Jobs, Alerts, Operators, DTS Packages, etc., are not database specific, but
server specific,and kept in the msdb database. Anything that is not
accessible throught the user database (using EM or SSMS) is not included in
a database backup. If you want those items, you will need to script them out
and add the scripts to the installation process.
Perhaps you can also move the msdb database. See:
Moving Databases to a new location
http://support.microsoft.com/kb/224071/EN-US/
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:356DBCC1-E61B-478A-82D7-8BC784EC281F@.microsoft.com...[vbcol=seagreen]
> Hi,
> Thanks for the reply. I was reading the article at
> http://support.microsoft.com/kb/314546 and found that it mentions moving
> the
> logins, jobs, alerts, operators and dts packages separately.
> I have done backup/restore procedures before and I recall that everything
> related to the databse (logins, passwords, dts packages) gets moved except
> for the jobs, alerts and operators that has to be set up separately.
> Please
> correct me if I am wrong. Thanks again.
> "John Bell" wrote:

best way to move database from development to production

Hi,
What's the best way to move a database from development server (once you
have done all the testing and everything runs fine) to the production server
?
Thanks in advance."sharman" <sharman@.discussions.microsoft.com> wrote in message
news:4E363380-ED77-4A23-8F76-6EAB7573394B@.microsoft.com...
> Hi,
> What's the best way to move a database from development server (once you
> have done all the testing and everything runs fine) to the production
> server?
> Thanks in advance.|||"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:4E363380-ED77-4A23-8F76-6EAB7573394B@.microsoft.com...
> Hi,
> What's the best way to move a database from development server (once you
> have done all the testing and everything runs fine) to the production
> server?
> Thanks in advance.|||Hi,
1. Perform a database backup in Dev server
2. Send the BAK file to prod server
3. Restore the database into right drives
4. Clean up all the development data
5. Increase the MDF and LDF size. Project atleast for next 1 year.
6. Setup the recovery model to FULL
7. Setup the FULL Backup and Transaction log backup jobs
8. Setup the DBCC CHECKDB job every day night
9. Setup the Update Statistics every day night
10. Setup the Re-Indexing jobs every weekends...
Thanks
Hari
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:4E363380-ED77-4A23-8F76-6EAB7573394B@.microsoft.com...
> Hi,
> What's the best way to move a database from development server (once you
> have done all the testing and everything runs fine) to the production
> server?
> Thanks in advance.|||Use Backup/Restore. (Leaves a copy for DEV use.)
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:4E363380-ED77-4A23-8F76-6EAB7573394B@.microsoft.com...
> Hi,
> What's the best way to move a database from development server (once you
> have done all the testing and everything runs fine) to the production
> server?
> Thanks in advance.|||Hi
This will depend on what you want to do! If you only have one live site you
may use the backup/restore approach as described by others. If you have
multiple sites or if there is any cleaning up then you may want build basic
database in the development environment and then ship this template database
into live. You could then have an installation process which adds any site
specific data. Whatever method you use it should be tested!
This may be useful http://support.microsoft.com/kb/314546
John
"sharman" wrote:

> Hi,
> What's the best way to move a database from development server (once you
> have done all the testing and everything runs fine) to the production serv
er?
> Thanks in advance.|||Hi,
Thanks for the reply. I was reading the article at
http://support.microsoft.com/kb/314546 and found that it mentions moving the
logins, jobs, alerts, operators and dts packages separately.
I have done backup/restore procedures before and I recall that everything
related to the databse (logins, passwords, dts packages) gets moved except
for the jobs, alerts and operators that has to be set up separately. Please
correct me if I am wrong. Thanks again.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> This will depend on what you want to do! If you only have one live site yo
u
> may use the backup/restore approach as described by others. If you have
> multiple sites or if there is any cleaning up then you may want build basi
c
> database in the development environment and then ship this template databa
se
> into live. You could then have an installation process which adds any site
> specific data. Whatever method you use it should be tested!
> This may be useful http://support.microsoft.com/kb/314546
> John
> "sharman" wrote:
>|||Jobs, Alerts, Operators, DTS Packages, etc., are not database specific, but
server specific,and kept in the msdb database. Anything that is not
accessible throught the user database (using EM or SSMS) is not included in
a database backup. If you want those items, you will need to script them out
and add the scripts to the installation process.
Perhaps you can also move the msdb database. See:
Moving Databases to a new location
http://support.microsoft.com/kb/224071/EN-US/
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:356DBCC1-E61B-478A-82D7-8BC784EC281F@.microsoft.com...[vbcol=seagreen]
> Hi,
> Thanks for the reply. I was reading the article at
> http://support.microsoft.com/kb/314546 and found that it mentions moving
> the
> logins, jobs, alerts, operators and dts packages separately.
> I have done backup/restore procedures before and I recall that everything
> related to the databse (logins, passwords, dts packages) gets moved except
> for the jobs, alerts and operators that has to be set up separately.
> Please
> correct me if I am wrong. Thanks again.
> "John Bell" wrote:
>|||Hi
Your database users will get transferred, but if your destination machine is
not on the same domain or if you are using SQL Server logins, then you will
most likely get orphaned users which are users who are not associated to a
login. See http://support.microsoft.com/kb/274188/ for more on this.
Jobs etc can be scripted (which if you are using source code control you
would have done already!) and recreated on the destination server. For DTS
packages you can use DTS Backup http://www.sqldts.com/default.aspx?242.
HTH
John
"sharman" wrote:
[vbcol=seagreen]
> Hi,
> Thanks for the reply. I was reading the article at
> http://support.microsoft.com/kb/314546 and found that it mentions moving t
he
> logins, jobs, alerts, operators and dts packages separately.
> I have done backup/restore procedures before and I recall that everything
> related to the databse (logins, passwords, dts packages) gets moved except
> for the jobs, alerts and operators that has to be set up separately. Pleas
e
> correct me if I am wrong. Thanks again.
> "John Bell" wrote:
>|||Jobs, Alerts, Operators, DTS Packages, etc., are not database specific, but
server specific,and kept in the msdb database. Anything that is not
accessible throught the user database (using EM or SSMS) is not included in
a database backup. If you want those items, you will need to script them out
and add the scripts to the installation process.
Perhaps you can also move the msdb database. See:
Moving Databases to a new location
http://support.microsoft.com/kb/224071/EN-US/
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:356DBCC1-E61B-478A-82D7-8BC784EC281F@.microsoft.com...[vbcol=seagreen]
> Hi,
> Thanks for the reply. I was reading the article at
> http://support.microsoft.com/kb/314546 and found that it mentions moving
> the
> logins, jobs, alerts, operators and dts packages separately.
> I have done backup/restore procedures before and I recall that everything
> related to the databse (logins, passwords, dts packages) gets moved except
> for the jobs, alerts and operators that has to be set up separately.
> Please
> correct me if I am wrong. Thanks again.
> "John Bell" wrote:
>

best way to move database from development to production

Hi,
What's the best way to move a database from development server (once you
have done all the testing and everything runs fine) to the production server?
Thanks in advance.Hi,
1. Perform a database backup in Dev server
2. Send the BAK file to prod server
3. Restore the database into right drives
4. Clean up all the development data
5. Increase the MDF and LDF size. Project atleast for next 1 year.
6. Setup the recovery model to FULL
7. Setup the FULL Backup and Transaction log backup jobs
8. Setup the DBCC CHECKDB job every day night
9. Setup the Update Statistics every day night
10. Setup the Re-Indexing jobs every weekends...
Thanks
Hari
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:4E363380-ED77-4A23-8F76-6EAB7573394B@.microsoft.com...
> Hi,
> What's the best way to move a database from development server (once you
> have done all the testing and everything runs fine) to the production
> server?
> Thanks in advance.|||"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:4E363380-ED77-4A23-8F76-6EAB7573394B@.microsoft.com...
> Hi,
> What's the best way to move a database from development server (once you
> have done all the testing and everything runs fine) to the production
> server?
> Thanks in advance.|||"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:4E363380-ED77-4A23-8F76-6EAB7573394B@.microsoft.com...
> Hi,
> What's the best way to move a database from development server (once you
> have done all the testing and everything runs fine) to the production
> server?
> Thanks in advance.|||Use Backup/Restore. (Leaves a copy for DEV use.)
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:4E363380-ED77-4A23-8F76-6EAB7573394B@.microsoft.com...
> Hi,
> What's the best way to move a database from development server (once you
> have done all the testing and everything runs fine) to the production
> server?
> Thanks in advance.|||Hi
This will depend on what you want to do! If you only have one live site you
may use the backup/restore approach as described by others. If you have
multiple sites or if there is any cleaning up then you may want build basic
database in the development environment and then ship this template database
into live. You could then have an installation process which adds any site
specific data. Whatever method you use it should be tested!
This may be useful http://support.microsoft.com/kb/314546
John
"sharman" wrote:
> Hi,
> What's the best way to move a database from development server (once you
> have done all the testing and everything runs fine) to the production server?
> Thanks in advance.|||Hi,
Thanks for the reply. I was reading the article at
http://support.microsoft.com/kb/314546 and found that it mentions moving the
logins, jobs, alerts, operators and dts packages separately.
I have done backup/restore procedures before and I recall that everything
related to the databse (logins, passwords, dts packages) gets moved except
for the jobs, alerts and operators that has to be set up separately. Please
correct me if I am wrong. Thanks again.
"John Bell" wrote:
> Hi
> This will depend on what you want to do! If you only have one live site you
> may use the backup/restore approach as described by others. If you have
> multiple sites or if there is any cleaning up then you may want build basic
> database in the development environment and then ship this template database
> into live. You could then have an installation process which adds any site
> specific data. Whatever method you use it should be tested!
> This may be useful http://support.microsoft.com/kb/314546
> John
> "sharman" wrote:
> > Hi,
> >
> > What's the best way to move a database from development server (once you
> > have done all the testing and everything runs fine) to the production server?
> > Thanks in advance.|||Jobs, Alerts, Operators, DTS Packages, etc., are not database specific, but
server specific,and kept in the msdb database. Anything that is not
accessible throught the user database (using EM or SSMS) is not included in
a database backup. If you want those items, you will need to script them out
and add the scripts to the installation process.
Perhaps you can also move the msdb database. See:
Moving Databases to a new location
http://support.microsoft.com/kb/224071/EN-US/
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:356DBCC1-E61B-478A-82D7-8BC784EC281F@.microsoft.com...
> Hi,
> Thanks for the reply. I was reading the article at
> http://support.microsoft.com/kb/314546 and found that it mentions moving
> the
> logins, jobs, alerts, operators and dts packages separately.
> I have done backup/restore procedures before and I recall that everything
> related to the databse (logins, passwords, dts packages) gets moved except
> for the jobs, alerts and operators that has to be set up separately.
> Please
> correct me if I am wrong. Thanks again.
> "John Bell" wrote:
>> Hi
>> This will depend on what you want to do! If you only have one live site
>> you
>> may use the backup/restore approach as described by others. If you have
>> multiple sites or if there is any cleaning up then you may want build
>> basic
>> database in the development environment and then ship this template
>> database
>> into live. You could then have an installation process which adds any
>> site
>> specific data. Whatever method you use it should be tested!
>> This may be useful http://support.microsoft.com/kb/314546
>> John
>> "sharman" wrote:
>> > Hi,
>> >
>> > What's the best way to move a database from development server (once
>> > you
>> > have done all the testing and everything runs fine) to the production
>> > server?
>> > Thanks in advance.|||Hi
Your database users will get transferred, but if your destination machine is
not on the same domain or if you are using SQL Server logins, then you will
most likely get orphaned users which are users who are not associated to a
login. See http://support.microsoft.com/kb/274188/ for more on this.
Jobs etc can be scripted (which if you are using source code control you
would have done already!) and recreated on the destination server. For DTS
packages you can use DTS Backup http://www.sqldts.com/default.aspx?242.
HTH
John
"sharman" wrote:
> Hi,
> Thanks for the reply. I was reading the article at
> http://support.microsoft.com/kb/314546 and found that it mentions moving the
> logins, jobs, alerts, operators and dts packages separately.
> I have done backup/restore procedures before and I recall that everything
> related to the databse (logins, passwords, dts packages) gets moved except
> for the jobs, alerts and operators that has to be set up separately. Please
> correct me if I am wrong. Thanks again.
> "John Bell" wrote:
> > Hi
> >
> > This will depend on what you want to do! If you only have one live site you
> > may use the backup/restore approach as described by others. If you have
> > multiple sites or if there is any cleaning up then you may want build basic
> > database in the development environment and then ship this template database
> > into live. You could then have an installation process which adds any site
> > specific data. Whatever method you use it should be tested!
> >
> > This may be useful http://support.microsoft.com/kb/314546
> >
> > John
> >
> > "sharman" wrote:
> >
> > > Hi,
> > >
> > > What's the best way to move a database from development server (once you
> > > have done all the testing and everything runs fine) to the production server?
> > > Thanks in advance.|||Jobs, Alerts, Operators, DTS Packages, etc., are not database specific, but
server specific,and kept in the msdb database. Anything that is not
accessible throught the user database (using EM or SSMS) is not included in
a database backup. If you want those items, you will need to script them out
and add the scripts to the installation process.
Perhaps you can also move the msdb database. See:
Moving Databases to a new location
http://support.microsoft.com/kb/224071/EN-US/
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:356DBCC1-E61B-478A-82D7-8BC784EC281F@.microsoft.com...
> Hi,
> Thanks for the reply. I was reading the article at
> http://support.microsoft.com/kb/314546 and found that it mentions moving
> the
> logins, jobs, alerts, operators and dts packages separately.
> I have done backup/restore procedures before and I recall that everything
> related to the databse (logins, passwords, dts packages) gets moved except
> for the jobs, alerts and operators that has to be set up separately.
> Please
> correct me if I am wrong. Thanks again.
> "John Bell" wrote:
>> Hi
>> This will depend on what you want to do! If you only have one live site
>> you
>> may use the backup/restore approach as described by others. If you have
>> multiple sites or if there is any cleaning up then you may want build
>> basic
>> database in the development environment and then ship this template
>> database
>> into live. You could then have an installation process which adds any
>> site
>> specific data. Whatever method you use it should be tested!
>> This may be useful http://support.microsoft.com/kb/314546
>> John
>> "sharman" wrote:
>> > Hi,
>> >
>> > What's the best way to move a database from development server (once
>> > you
>> > have done all the testing and everything runs fine) to the production
>> > server?
>> > Thanks in advance.|||Thanks for the quick responses.
"Arnie Rowland" wrote:
> Jobs, Alerts, Operators, DTS Packages, etc., are not database specific, but
> server specific,and kept in the msdb database. Anything that is not
> accessible throught the user database (using EM or SSMS) is not included in
> a database backup. If you want those items, you will need to script them out
> and add the scripts to the installation process.
> Perhaps you can also move the msdb database. See:
> Moving Databases to a new location
> http://support.microsoft.com/kb/224071/EN-US/
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to the
> top yourself.
> - H. Norman Schwarzkopf
>
> "sharman" <sharman@.discussions.microsoft.com> wrote in message
> news:356DBCC1-E61B-478A-82D7-8BC784EC281F@.microsoft.com...
> > Hi,
> >
> > Thanks for the reply. I was reading the article at
> > http://support.microsoft.com/kb/314546 and found that it mentions moving
> > the
> > logins, jobs, alerts, operators and dts packages separately.
> >
> > I have done backup/restore procedures before and I recall that everything
> > related to the databse (logins, passwords, dts packages) gets moved except
> > for the jobs, alerts and operators that has to be set up separately.
> > Please
> > correct me if I am wrong. Thanks again.
> >
> > "John Bell" wrote:
> >
> >> Hi
> >>
> >> This will depend on what you want to do! If you only have one live site
> >> you
> >> may use the backup/restore approach as described by others. If you have
> >> multiple sites or if there is any cleaning up then you may want build
> >> basic
> >> database in the development environment and then ship this template
> >> database
> >> into live. You could then have an installation process which adds any
> >> site
> >> specific data. Whatever method you use it should be tested!
> >>
> >> This may be useful http://support.microsoft.com/kb/314546
> >>
> >> John
> >>
> >> "sharman" wrote:
> >>
> >> > Hi,
> >> >
> >> > What's the best way to move a database from development server (once
> >> > you
> >> > have done all the testing and everything runs fine) to the production
> >> > server?
> >> > Thanks in advance.
>
>|||Thanks for the quick responses.
"John Bell" wrote:
> Hi
> Your database users will get transferred, but if your destination machine is
> not on the same domain or if you are using SQL Server logins, then you will
> most likely get orphaned users which are users who are not associated to a
> login. See http://support.microsoft.com/kb/274188/ for more on this.
> Jobs etc can be scripted (which if you are using source code control you
> would have done already!) and recreated on the destination server. For DTS
> packages you can use DTS Backup http://www.sqldts.com/default.aspx?242.
> HTH
> John
> "sharman" wrote:
> > Hi,
> >
> > Thanks for the reply. I was reading the article at
> > http://support.microsoft.com/kb/314546 and found that it mentions moving the
> > logins, jobs, alerts, operators and dts packages separately.
> >
> > I have done backup/restore procedures before and I recall that everything
> > related to the databse (logins, passwords, dts packages) gets moved except
> > for the jobs, alerts and operators that has to be set up separately. Please
> > correct me if I am wrong. Thanks again.
> >
> > "John Bell" wrote:
> >
> > > Hi
> > >
> > > This will depend on what you want to do! If you only have one live site you
> > > may use the backup/restore approach as described by others. If you have
> > > multiple sites or if there is any cleaning up then you may want build basic
> > > database in the development environment and then ship this template database
> > > into live. You could then have an installation process which adds any site
> > > specific data. Whatever method you use it should be tested!
> > >
> > > This may be useful http://support.microsoft.com/kb/314546
> > >
> > > John
> > >
> > > "sharman" wrote:
> > >
> > > > Hi,
> > > >
> > > > What's the best way to move a database from development server (once you
> > > > have done all the testing and everything runs fine) to the production server?
> > > > Thanks in advance.

Best way to maintain up to date SQL Jobs and SSIS on failover Serv

Hi,
on SQL 2005 we use log shipping to maintain our production server to an
alternate server. Now I would like to do something similar with our SQL
Agent jobs and SSIS. While those jobs are enabled on the production server,
I would like them to become disable on the alternate server, this process
would be scheduled once per day.
I'm sure there are many ways to achieve this, but I am wondering what would
be the most efficient.
any ideas ?
Thanks
Fred
ok, I just figured out how to transfer/disable jobs using the Transfer Job
task in SSIS, it's quite nice actually.
But, I am still in the dark on how to transfer SSIS from one server to
another.
BTW, a backup and restore of MSDB is out of the question.
Thanks
"FredDBA" wrote:

> Hi,
> on SQL 2005 we use log shipping to maintain our production server to an
> alternate server. Now I would like to do something similar with our SQL
> Agent jobs and SSIS. While those jobs are enabled on the production server,
> I would like them to become disable on the alternate server, this process
> would be scheduled once per day.
> I'm sure there are many ways to achieve this, but I am wondering what would
> be the most efficient.
> any ideas ?
> Thanks
> Fred

Best way to maintain up to date SQL Jobs and SSIS on failover Serv

Hi,
on SQL 2005 we use log shipping to maintain our production server to an
alternate server. Now I would like to do something similar with our SQL
Agent jobs and SSIS. While those jobs are enabled on the production server,
I would like them to become disable on the alternate server, this process
would be scheduled once per day.
I'm sure there are many ways to achieve this, but I am wondering what would
be the most efficient.
any ideas ?
Thanks
Fredok, I just figured out how to transfer/disable jobs using the Transfer Job
task in SSIS, it's quite nice actually.
But, I am still in the dark on how to transfer SSIS from one server to
another.
BTW, a backup and restore of MSDB is out of the question.
Thanks
"FredDBA" wrote:

> Hi,
> on SQL 2005 we use log shipping to maintain our production server to an
> alternate server. Now I would like to do something similar with our SQL
> Agent jobs and SSIS. While those jobs are enabled on the production serve
r,
> I would like them to become disable on the alternate server, this process
> would be scheduled once per day.
> I'm sure there are many ways to achieve this, but I am wondering what woul
d
> be the most efficient.
> any ideas ?
> Thanks
> Fred|||If its not too late, consider storing your SSIS packages in the
filesystem and just keep copies on your DR machines
Terry|||Anotther thing we do here (mostly for legacy dts packages) is to
restore the MSDB as another name. During DR, rename that database to
MSDB and all the objects will be there.
Terry

Best way to maintain up to date SQL Jobs and SSIS on failover Serv

Hi,
on SQL 2005 we use log shipping to maintain our production server to an
alternate server. Now I would like to do something similar with our SQL
Agent jobs and SSIS. While those jobs are enabled on the production server,
I would like them to become disable on the alternate server, this process
would be scheduled once per day.
I'm sure there are many ways to achieve this, but I am wondering what would
be the most efficient.
any ideas ?
Thanks
Fredok, I just figured out how to transfer/disable jobs using the Transfer Job
task in SSIS, it's quite nice actually.
But, I am still in the dark on how to transfer SSIS from one server to
another.
BTW, a backup and restore of MSDB is out of the question.
Thanks
"FredDBA" wrote:
> Hi,
> on SQL 2005 we use log shipping to maintain our production server to an
> alternate server. Now I would like to do something similar with our SQL
> Agent jobs and SSIS. While those jobs are enabled on the production server,
> I would like them to become disable on the alternate server, this process
> would be scheduled once per day.
> I'm sure there are many ways to achieve this, but I am wondering what would
> be the most efficient.
> any ideas ?
> Thanks
> Fred|||If its not too late, consider storing your SSIS packages in the
filesystem and just keep copies on your DR machines
Terry|||Anotther thing we do here (mostly for legacy dts packages) is to
restore the MSDB as another name. During DR, rename that database to
MSDB and all the objects will be there.
Terry

Tuesday, February 14, 2012

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

Wednesday, March 7, 2012

Between database servers

Between database servers

Saturday, February 25, 2012

Between database servers

Friday, February 24, 2012

Best Way To Update Existing Rows

Sunday, February 19, 2012

Best way to promote DTS packages

Thursday, February 16, 2012

best way to move database from development to production

best way to move database from development to production

best way to move database from development to production

Best way to maintain up to date SQL Jobs and SSIS on failover Serv

Best way to maintain up to date SQL Jobs and SSIS on failover Serv

Best way to maintain up to date SQL Jobs and SSIS on failover Serv

Tuesday, February 14, 2012

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

Best way to copy database

Blog Archive

About Me