| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-12-08 : 04:12:51
|
| Dear Experts,can we expect the transactional replication using the current snapshot at the peak time? will that affect the performance at that time? i'm not going to generate a new snapshot.ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2008-12-08 : 16:09:02
|
| Can you rephrase the question? When you say "reinitialize" it means generating a new snapshot.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-12-09 : 00:50:58
|
quote:
Originally posted by dinakar
Can you rephrase the question? When you say "reinitialize" it means generating a new snapshot.
Dear Dinakar, there are two options we can see while reinitializing a snapshot. either we can generate a new snapshot, or we can reinitialize using the current snapshot. based on this, i've asked the question. can you please share your experience on this...Dear Tara madam,Thank you very much, my database is 100Gb database. i've this doubt because unexpectedly the snapshot folder is getting courrupting. (some one is deleting or happening something.) as i've given the permissions to a single user, recently i came to know that so many users are logging in with that userID. that is the reason i'm getting this problem. (initial snapshot not yet available).. so i've copied the entire UNC folder to a different location, and if something happend to the replication, i'l check for the existing replication folder. if some thing happens, i'll just replace the UNC folder with the copy. so that i can reinitialize the replication. even that got succeed in the test environment. so i'm sure this is the solution for this problem. i'l write a technical paper on this topic. please correct me where ever i'm wrongArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2008-12-09 : 11:13:59
|
quote:
Originally posted by sunsanvin
quote:
Originally posted by dinakar
Can you rephrase the question? When you say "reinitialize" it means generating a new snapshot.
Dear Dinakar, there are two options we can see while reinitializing a snapshot. either we can generate a new snapshot, or we can reinitialize using the current snapshot. based on this, i've asked the question. can you please share your experience on this...
to be honest, I have never had the luxury of taking a snapshot. The databases I have worked on were in tera bytes.. so snapshot was never an option. I always backed up/restored the database, initialize without snapshot.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-09 : 11:18:42
|
Yes , We also use Backup/Restore method for replication of database above 100 GB .quote:
Originally posted by dinakar
quote:
Originally posted by sunsanvin
quote:
Originally posted by dinakar
Can you rephrase the question? When you say "reinitialize" it means generating a new snapshot.
Dear Dinakar, there are two options we can see while reinitializing a snapshot. either we can generate a new snapshot, or we can reinitialize using the current snapshot. based on this, i've asked the question. can you please share your experience on this...
to be honest, I have never had the luxury of taking a snapshot. The databases I have worked on were in tera bytes.. so snapshot was never an option. I always backed up/restored the database, initialize without snapshot.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/
|
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-09 : 11:21:16
|
But one thing Dinakar, What I have seen in backup/Restore method while doing Replication is that DDL commands are not replicated in SQL 2005.Any thought??quote:
Originally posted by dinakar
quote:
Originally posted by sunsanvin
quote:
Originally posted by dinakar
Can you rephrase the question? When you say "reinitialize" it means generating a new snapshot.
Dear Dinakar, there are two options we can see while reinitializing a snapshot. either we can generate a new snapshot, or we can reinitialize using the current snapshot. based on this, i've asked the question. can you please share your experience on this...
to be honest, I have never had the luxury of taking a snapshot. The databases I have worked on were in tera bytes.. so snapshot was never an option. I always backed up/restored the database, initialize without snapshot.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/
|
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2008-12-10 : 12:28:20
|
| Any DDL on a replicated object is replicated. If you run CREATE commands, they arent replicated.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-10 : 13:07:56
|
| I guess it has to do with backup/restore in place of snapshot. Create and ALTER are not supported . |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2008-12-10 : 17:29:47
|
quote:
Originally posted by sodeep
I guess it has to do with backup/restore in place of snapshot. Create and ALTER are not supported .
Whether you do backup/restore or create a snapshot, CREATE statements will not be replicated. ALTER's on objects being replicated will however be replicated. For example, if you created a new index on some column(s) in a table, the new index will not be created on subscriber. You need to do it manually. I think creating a clustered index is replicated, though.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-12-11 : 00:40:14
|
| wow absolutely new concept for me. is it possible with backup and restore instead of generating a snapshot?if so, what is the process? will the replication agent consider the backup as a snapshot? after taking the backup, i need to copy that backup file into shared folder? please correct me and provide me a link thanks a lotArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-11 : 08:54:49
|
| http://msdn.microsoft.com/en-us/library/ms151705.aspx |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
|
|
|
can we reinitialize the replication in peak time