initial snapshot not yet available is eating me

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.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

initial snapshot not yet available is eating me

Author

Topic

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-11-25 : 05:51:42

Dear All,
i don't know why i'm getting this error and all you experts are not saying any thing about this....
i'm using sql server 2005 on windows 2003 server.
i don't know why i'm the only person getting this problem.

even our experts are unable to help me in this regard.
sp2 is not installled on the server. this might be the problem????
experts, please look into this issue, i'm getting this error very frequently

Arnav
Even you learn 1%, Learn it with 100% confidence.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-11-25 : 06:07:00

moved from yak corral

___________________________________________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.1 out!

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-11-25 : 06:45:49

You mean you are having trouble with

SET TRANSACTION ISOLATION LEVEL SNAPSHOT

Have you preset these database level settings?

ALTER DATABASE xyz SET ALLOW_SNAPSHOT_ISOLATION ON
ALTER DATABASE xyz SET READ_COMMITTED_SNAPSHOT ON

E 12°55'05.63"
N 56°04'39.26"

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-11-25 : 09:41:07

http://forums.microsoft.com/msdn/showpost.aspx?postid=626299&siteid=1&sb=0&d=1&at=7&ft=11&tf=0&pageid=1

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-11-27 : 08:01:24

Peso, it is related to replication.
i'm working with transactional replication and some times i'm getting this proble

Arnav
Even you learn 1%, Learn it with 100% confidence.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-11-27 : 08:09:24

It wasn't obvious from your original post, so I winged it.

E 12°55'05.63"
N 56°04'39.26"

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-11-27 : 10:09:28

Has the snapshot agent finished creating the initial snapshot?
Is the log reader running?

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources