INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

SQL 2000 Strategy for keeping Reporting Server Updated with Prod Server Data

SQL 2000 Strategy for keeping Reporting Server Updated with Prod Server Data

SQL 2000 Strategy for keeping Reporting Server Updated with Prod Server Data

(OP)
SQL Server Enterprise 2000 SP3 | Windows 2003 SP2

I have to build up a reporting server to offload the performance impact when users run reports against the production
server. ERP server where finance group wants reporting server to be updated a couple times during the day so I cannot rely strictly on restoring from the production server's backup from the night before.

I appreciate your recommendations for a strategy to meet this requirement.

Replication, scripting, backup & restore, ??

Thanks,

awaria

RE: SQL 2000 Strategy for keeping Reporting Server Updated with Prod Server Data

Since you are using SQL2000 Enterprise, I would encourage you to take a look at log shipping.

There is a document here that describes how to do it.
http://www.sqlservercentral.com/Forums/Topic403992...

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

RE: SQL 2000 Strategy for keeping Reporting Server Updated with Prod Server Data

(OP)
George,

Thanks for the link.

I will review and hopefully get very familiar with log shipping.

Is the thought that log shipping can replace the need for nightly backup and restores, or to be
used in tandem with the backup/restores to keep data updated during working day?

Thanks again for your suggestion.

awaria

RE: SQL 2000 Strategy for keeping Reporting Server Updated with Prod Server Data

It can probably replace the nightly backup/restore.

Just to be clear... you should ALWAYS backup for disaster recovery reasons. With log shipping, you shouldn't need to restore to the reporting database.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

RE: SQL 2000 Strategy for keeping Reporting Server Updated with Prod Server Data

Log Shipping seems simple on the surface, however, you have to watch or it will break. I have not used sql 2000 log shipping for several years but it will keep the two databases in sync.

I find that when I start log shipping, grabbing a new backup is the easiest way so if there is a problem with log shipping recreating it will resync.

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!

RE: SQL 2000 Strategy for keeping Reporting Server Updated with Prod Server Data

(OP)
Just found out the destination server is SQL Server 2000 Standard, whereas, the source server is
SQL Server 2000 Enterprise, will that cause a problem?

Also source is on SP3 and destination is on SP4.

Thanks for sharing your expertise.

awaria

RE: SQL 2000 Strategy for keeping Reporting Server Updated with Prod Server Data

(OP)
Question, I have been researching and it seems that folks suggest Log Shipping or Replication.

Can someone elaborate on the difference or benefits of using one over the other for this purpose.

Thanks again,

awaria

RE: SQL 2000 Strategy for keeping Reporting Server Updated with Prod Server Data

(OP)
Attempting to add destination server, but, no servers appear to select.

I registered the destination server in the source server's console.

Could this be due to the destination server is 2000 standard and the primary
SQL server is Enterprise 2000?

Need assistance in getting log shipping setup with destination server.

Thanks,

awaria

RE: SQL 2000 Strategy for keeping Reporting Server Updated with Prod Server Data

Enterprise to Standard should not be a problem. Can you type in the server?

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close