Boot.ini file: sql2k

Showing posts with label sql2k. Show all posts

Sunday, February 19, 2012

Broken merge. Need help.

Hi,
Seems I found how to brake merge replication.
Actually I reproduced this situation on my test env. after we found it on
production.
OK we have SQL2K EE SP3a on W2k AE SP4.
Suppose You create a table with few fields of different type
(field1,field2,field3.etc.. rowguid)
Then you publish it for merge replication an push the subscription to
subscriber (with initialization).
Everything works fine.
Then suppose you need to ALTER one of columns (let's say field2) in that
table (char(12 ->char(20))
In merge (or whatever) you have to do sp_repldropcolumn then
sp_repladdcolumn and restore data of that column on publisher.
All changes are done and synchronized with the subscriber. Everything still
works.
Then you create a new merge publication including the same table and push it
to another subscriber (with initialization).
After we found that changes are not correctly transferred between two
subscribers. All data is still correct at the publisher but at the
subscribers some fields are different.
Does anyone know about this? Or any suggestions how to resolve this problem?
Thank You
Darius T.
Hi Darius,
Try looking at the .sch file created by the publication. It is usually
located at: ...\MSSQL\REPLDATA\name_of_publication. I have dealt with cases
that the snapshot file for the creation of the table was not correctly
created. You can manually modify this file to create the correct table with
the correct columns. When the initialization takes place, it will take this
file and apply it tio the subscribers. Hope this helps!
-Jose Molina
"Darius T." <dta@.takas.lt> wrote in message
news:%23s$CB3Z$EHA.1452@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Seems I found how to brake merge replication.
> Actually I reproduced this situation on my test env. after we found it on
> production.
> OK we have SQL2K EE SP3a on W2k AE SP4.
> Suppose You create a table with few fields of different type
> (field1,field2,field3.etc.. rowguid)
> Then you publish it for merge replication an push the subscription to
> subscriber (with initialization).
> Everything works fine.
> Then suppose you need to ALTER one of columns (let's say field2) in that
> table (char(12 ->char(20))
> In merge (or whatever) you have to do sp_repldropcolumn then
> sp_repladdcolumn and restore data of that column on publisher.
> All changes are done and synchronized with the subscriber. Everything
> still works.
> Then you create a new merge publication including the same table and push
> it to another subscriber (with initialization).
> After we found that changes are not correctly transferred between two
> subscribers. All data is still correct at the publisher but at the
> subscribers some fields are different.
> Does anyone know about this? Or any suggestions how to resolve this
> problem?
> Thank You
> Darius T.
>
>
|||> After we found that changes are not correctly transferred between two
> subscribers. All data is still correct at the publisher but at the
> subscribers some fields are different.
Could you be more specific about this situation ?
What do you mean with "some fields are different." ?
Are you making inserts/updates only on publisher ?
Is replication working properly (replicating data to both subscribers) if
you skip step 2 (alter of the column) ?
Regards,
Kestutis Adomavicius
Consultant
UAB "Baltic Software Solutions"
"Darius T." <dta@.takas.lt> wrote in message
news:%23s$CB3Z$EHA.1452@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Seems I found how to brake merge replication.
> Actually I reproduced this situation on my test env. after we found it on
> production.
> OK we have SQL2K EE SP3a on W2k AE SP4.
> Suppose You create a table with few fields of different type
> (field1,field2,field3.etc.. rowguid)
> Then you publish it for merge replication an push the subscription to
> subscriber (with initialization).
> Everything works fine.
> Then suppose you need to ALTER one of columns (let's say field2) in that
> table (char(12 ->char(20))
> In merge (or whatever) you have to do sp_repldropcolumn then
> sp_repladdcolumn and restore data of that column on publisher.
> All changes are done and synchronized with the subscriber. Everything
still
> works.
> Then you create a new merge publication including the same table and push
it
> to another subscriber (with initialization).
> After we found that changes are not correctly transferred between two
> subscribers. All data is still correct at the publisher but at the
> subscribers some fields are different.
> Does anyone know about this? Or any suggestions how to resolve this
problem?
> Thank You
> Darius T.
>
>
|||"Some field are differnet" means that if you make update on a record at
publisher and run merge agents to both subscribers You find that all data is
correct only at subscriber 2, but at subscriber 1 data in some fiels in not
updated correctly. (INSERT,DELETE statements work properly).
The same things happening when you make an update on subscriber 2. Data is
merged correctly with publisher but not with subscriber 1.
I could post a step by step script here to see how it happens (if you are
interested)
Darius
P.S. gal galime susirayti ir lietuvikai jei k.
"Kestutis Adomavicius" <kicker.lt@.nospaamm_tut.by> wrote in message
news:%232dPB%23s$EHA.2444@.TK2MSFTNGP10.phx.gbl...
> Could you be more specific about this situation ?
> What do you mean with "some fields are different." ?
> Are you making inserts/updates only on publisher ?
> Is replication working properly (replicating data to both subscribers) if
> you skip step 2 (alter of the column) ?
> --
> Regards,
> Kestutis Adomavicius
> Consultant
> UAB "Baltic Software Solutions"
>
> "Darius T." <dta@.takas.lt> wrote in message
> news:%23s$CB3Z$EHA.1452@.TK2MSFTNGP11.phx.gbl...
> still
> it
> problem?
>
|||Thanks, Jose,
I've checked those .sch scripts. Didn't find any problem.
Darius
"Jose Molina" <rcmaniac23@.yahoo.com> wrote in message
news:OCHeF8k$EHA.3840@.tk2msftngp13.phx.gbl...
> Hi Darius,
> Try looking at the .sch file created by the publication. It is usually
> located at: ...\MSSQL\REPLDATA\name_of_publication. I have dealt with
> cases that the snapshot file for the creation of the table was not
> correctly created. You can manually modify this file to create the
> correct table with the correct columns. When the initialization takes
> place, it will take this file and apply it tio the subscribers. Hope this
> helps!
> -Jose Molina
>
> "Darius T." <dta@.takas.lt> wrote in message
> news:%23s$CB3Z$EHA.1452@.TK2MSFTNGP11.phx.gbl...
>

Thursday, February 16, 2012

Bring up the standby server in sql 2k

Hi,
How do I bring up the standby server online in sql2k by restoring the last
log backup(backed up with noinit).
This log file has been restored with standby clause. can I restore again
with recovery?
Thanks,Hi
Yes.
RESTORE <dbname> WITH RECOVERY
will bring the DB into a usable state.
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"mecn" <mecn2002@.yahoo.com> wrote in message
news:uAtveOg9FHA.2264@.tk2msftngp13.phx.gbl...
> Hi,
> How do I bring up the standby server online in sql2k by restoring the last
> log backup(backed up with noinit).
> This log file has been restored with standby clause. can I restore again
> with recovery?
> Thanks,
>|||Thanks,
But when I doing restore with recovery give me error says Server: Msg 4326,
Level 16, State 1, Line 11
The log in this backup set terminates at LSN 6791000023918900001, which is
too early to apply to the database. A more recent log backup that includes
LSN 6794000015810000001 can be restored.
I don't know why?
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:um6tXTg9FHA.252@.TK2MSFTNGP15.phx.gbl...
> Hi
> Yes.
> RESTORE <dbname> WITH RECOVERY
> will bring the DB into a usable state.
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:uAtveOg9FHA.2264@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > How do I bring up the standby server online in sql2k by restoring the
last
> > log backup(backed up with noinit).
> > This log file has been restored with standby clause. can I restore again
> > with recovery?
> >
> > Thanks,
> >
> >
>|||Can you post that exact RESTORE command you are executing?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"mecn" <mecn2002@.yahoo.com> wrote in message news:u4ki7ag9FHA.1332@.tk2msftngp13.phx.gbl...
> Thanks,
> But when I doing restore with recovery give me error says Server: Msg 4326,
> Level 16, State 1, Line 11
> The log in this backup set terminates at LSN 6791000023918900001, which is
> too early to apply to the database. A more recent log backup that includes
> LSN 6794000015810000001 can be restored.
> I don't know why?
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:um6tXTg9FHA.252@.TK2MSFTNGP15.phx.gbl...
>> Hi
>> Yes.
>> RESTORE <dbname> WITH RECOVERY
>> will bring the DB into a usable state.
>> --
>> --
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>> IM: mike@.epprecht.net
>> MVP Program: http://www.microsoft.com/mvp
>> Blog: http://www.msmvps.com/epprecht/
>> "mecn" <mecn2002@.yahoo.com> wrote in message
>> news:uAtveOg9FHA.2264@.tk2msftngp13.phx.gbl...
>> > Hi,
>> >
>> > How do I bring up the standby server online in sql2k by restoring the
> last
>> > log backup(backed up with noinit).
>> > This log file has been restored with standby clause. can I restore again
>> > with recovery?
>> >
>> > Thanks,
>> >
>> >
>>
>|||This is the script I excuted with error.
restore log LDNPROD from disk = 'path.bak' with recovery
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ObMuJOn9FHA.3660@.TK2MSFTNGP09.phx.gbl...
> Can you post that exact RESTORE command you are executing?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
news:u4ki7ag9FHA.1332@.tk2msftngp13.phx.gbl...
> > Thanks,
> > But when I doing restore with recovery give me error says Server: Msg
4326,
> > Level 16, State 1, Line 11
> > The log in this backup set terminates at LSN 6791000023918900001, which
is
> > too early to apply to the database. A more recent log backup that
includes
> > LSN 6794000015810000001 can be restored.
> >
> > I don't know why?
> > "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> > news:um6tXTg9FHA.252@.TK2MSFTNGP15.phx.gbl...
> >> Hi
> >>
> >> Yes.
> >>
> >> RESTORE <dbname> WITH RECOVERY
> >> will bring the DB into a usable state.
> >>
> >> --
> >> --
> >> Mike Epprecht, Microsoft SQL Server MVP
> >> Zurich, Switzerland
> >>
> >> IM: mike@.epprecht.net
> >>
> >> MVP Program: http://www.microsoft.com/mvp
> >>
> >> Blog: http://www.msmvps.com/epprecht/
> >>
> >> "mecn" <mecn2002@.yahoo.com> wrote in message
> >> news:uAtveOg9FHA.2264@.tk2msftngp13.phx.gbl...
> >> > Hi,
> >> >
> >> > How do I bring up the standby server online in sql2k by restoring the
> > last
> >> > log backup(backed up with noinit).
> >> > This log file has been restored with standby clause. can I restore
again
> >> > with recovery?
> >> >
> >> > Thanks,
> >> >
> >> >
> >>
> >>
> >
> >|||If you just want to make the database accessible (fail over), try executing (as suggested by Mike):
RESTORE DATABASE LDNPROD WITH RECOVERY
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"mecn" <mecn2002@.yahoo.com> wrote in message news:eRuvPeo9FHA.1224@.TK2MSFTNGP12.phx.gbl...
> This is the script I excuted with error.
> restore log LDNPROD from disk = 'path.bak' with recovery
>
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:ObMuJOn9FHA.3660@.TK2MSFTNGP09.phx.gbl...
>> Can you post that exact RESTORE command you are executing?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:u4ki7ag9FHA.1332@.tk2msftngp13.phx.gbl...
>> > Thanks,
>> > But when I doing restore with recovery give me error says Server: Msg
> 4326,
>> > Level 16, State 1, Line 11
>> > The log in this backup set terminates at LSN 6791000023918900001, which
> is
>> > too early to apply to the database. A more recent log backup that
> includes
>> > LSN 6794000015810000001 can be restored.
>> >
>> > I don't know why?
>> > "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
>> > news:um6tXTg9FHA.252@.TK2MSFTNGP15.phx.gbl...
>> >> Hi
>> >>
>> >> Yes.
>> >>
>> >> RESTORE <dbname> WITH RECOVERY
>> >> will bring the DB into a usable state.
>> >>
>> >> --
>> >> --
>> >> Mike Epprecht, Microsoft SQL Server MVP
>> >> Zurich, Switzerland
>> >>
>> >> IM: mike@.epprecht.net
>> >>
>> >> MVP Program: http://www.microsoft.com/mvp
>> >>
>> >> Blog: http://www.msmvps.com/epprecht/
>> >>
>> >> "mecn" <mecn2002@.yahoo.com> wrote in message
>> >> news:uAtveOg9FHA.2264@.tk2msftngp13.phx.gbl...
>> >> > Hi,
>> >> >
>> >> > How do I bring up the standby server online in sql2k by restoring the
>> > last
>> >> > log backup(backed up with noinit).
>> >> > This log file has been restored with standby clause. can I restore
> again
>> >> > with recovery?
>> >> >
>> >> > Thanks,
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>

Sunday, February 12, 2012

Bottom half of Page Not Found

I have RS2k on SQL2k for several months with no issues, all users can access
reports for which they have been granted access.
I have one new user lately that has not been able to access a report that he
has been granted access to.
He clicks the link to the report server http://servername.domain.com/reports
and gets directed to the Home folder where he can see the report folder he
needs.
Then he clicks the folder icon so that he is at .../HisRptFolder/ and sees
the two linked reports that his user group has been granted access to. When
he clicks the hyperlink to either of these two reports, the header fo the
site (that has the breadcrumb bar) is still viewable, but the part of the
page that would normally show the "report is generating" message does not
appear and instead he gets a 'Page Not Found' error.
I have tried granting access to his username specifically, but no success.
I have looked at the web.config file but did not make any changes
(Impersonate is set to true, but no username or password is specified which
should cause the logged on user credentials to pass through.)
No other users are having this issue.
The reports are linked to reports in another folder which he does not have
access to.
Any suggestions?
Thanks.2 Other things:
1. Actual error message is "The Page Cannot Be Displayed. The page you are
looking for is currently unavailable..."
2. User is getting the same experience on other reports as well.
"Phillip" wrote:
> I have RS2k on SQL2k for several months with no issues, all users can access
> reports for which they have been granted access.
> I have one new user lately that has not been able to access a report that he
> has been granted access to.
> He clicks the link to the report server http://servername.domain.com/reports
> and gets directed to the Home folder where he can see the report folder he
> needs.
> Then he clicks the folder icon so that he is at .../HisRptFolder/ and sees
> the two linked reports that his user group has been granted access to. When
> he clicks the hyperlink to either of these two reports, the header fo the
> site (that has the breadcrumb bar) is still viewable, but the part of the
> page that would normally show the "report is generating" message does not
> appear and instead he gets a 'Page Not Found' error.
> I have tried granting access to his username specifically, but no success.
> I have looked at the web.config file but did not make any changes
> (Impersonate is set to true, but no username or password is specified which
> should cause the logged on user credentials to pass through.)
> No other users are having this issue.
> The reports are linked to reports in another folder which he does not have
> access to.
> Any suggestions?
> Thanks.

Sunday, February 19, 2012

Broken merge. Need help.

Thursday, February 16, 2012

Bring up the standby server in sql 2k

Bring up the standby server in sql 2k

Bring up the standby server in sql 2k

Sunday, February 12, 2012

Bottom half of Page Not Found

Boot.ini file

Blog Archive

About Me