can we replicate whole database in sql 2000 or 2005?

Question

can we replicate whole database in sql 2000 or 2005?

santosh_chandel

Old Hand

Points: 347
More actions
July 14, 2008 at 7:45 am

#381654

Like we do copy restore the log . .. can we do the same in replication setup with publisher , distributor, subscriber.
Please let me know if you have some input about it.
Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 1

If I understand the question, the thing you're looking for is a snapshot. That's an immediate copy of the entire database.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

santosh_chandel Old Hand Points: 347 More actions · Answer 2

Thanks for your reply!!

Actually i am searching an option .. where i can get copy of the entire database objects like .. database objects, its definition, and data as well.

Will this is be good for production database should be replicated to dr database where i am looking option for replacing the log shiiping option with it to replication as database size is hardly 250 gbs only in transaction.

Many has doubt that log shipping will be good in this case as whole database replication is not possible?

Can you please describe it more?

Thanks

Santosh

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 3

Snapshot replication is a one-time, either on demand or scheduled, operation where an entire database structure and all it's data (but not the security settings, etc.) are copied from one location to another. It does sound like what you need.

Although, if you're currently looking at or using log shipping, two other options are possible. First, you can use Transactional Replication which, after a Snaptshot like above, uses the transaction log to determine any data changes and ships them over to a copy of the database. Structural changes are more problematic with transactional replication. Second, Database Mirroring is a mechanism that takes advantage of log shipping to create a hot stand-by database, all structures, data, and security.

Is that useful at all?

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

santosh_chandel Old Hand Points: 347 More actions · Answer 4

Thanks a bunch!!

I think that i had a doubt that i can do acheive that all with replication like copy of all the database is something you are saying yes..

But thanks a lot for your answer. I think you have also suggested the best can be solution for it.

Thanks a lot

Santosh