Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-09-11 : 04:42:55
|
| Dear All,i'm getting the problem in replication. it is not showing the error in replication. but i got the error "initial snapshot not yet available" please help me to resolve the issue.i'm using sql server 2005 on windows 2003 environment which is 64 bitArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-09-12 : 02:57:30
|
| Dear Experts,I've found the solution for this special issue. the reason is paging of the server memory. if there is no sufficient paging memory in the selected drive, we will get this problem. by default the drive will be C:\ drive. if there is not sufficient space in this drive, windows will look for the free-up memory so that timeout errors, general network errors, and replication error mentioned in the subject, will be arise. so please check the paginig. this is for the replication DBA's who are getting this type of problem.this solution is 100% and now it is working fine with my servers.this solution is dedicated to the experts, Tkizer, sodeep and peso.ArnavEven you learn 1%, Learn it with 100% confidence. |
 |
|
|
|
|
|
initial snapshot not yet avialable