Disaster recovery

How to protect the transaction logs from disaster considering the loss
of hardware mirror? Can we use remote mirror for these files?
tram,
Back them up frequently, say every 5 mins? You can also deploy log shipping:
http://msdn.microsoft.com/library/de...erver_8elj.asp
Do you have redundancy at the disk level? Have you implemented a raid array?
RAID-1 is commonly used for transaction log protection - this cannot be used
remotely though, it is local to the server.
See:
http://www.acnc.com/04_01_01_flash.html
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"tram" <tram_e@.hotmail.com> wrote in message
news:26ee1067.0404211702.2fbb4462@.posting.google.c om...
> How to protect the transaction logs from disaster considering the loss
> of hardware mirror? Can we use remote mirror for these files?
|||What if RAID 1 crashes or on fire? Oracle has got redo groups where
you can place on REDO group in local and other in SAN. Sql
serverdoesn't have this functionality and we lose the data in active
redo . Log shipping doesn't meet our requirement.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message news:<e41kfnEKEHA.2716@.tk2msftngp13.phx.gbl>...[vbcol=seagreen]
> tram,
> Back them up frequently, say every 5 mins? You can also deploy log shipping:
> http://msdn.microsoft.com/library/de...erver_8elj.asp
> Do you have redundancy at the disk level? Have you implemented a raid array?
> RAID-1 is commonly used for transaction log protection - this cannot be used
> remotely though, it is local to the server.
> See:
> http://www.acnc.com/04_01_01_flash.html
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
>
>
> "tram" <tram_e@.hotmail.com> wrote in message
> news:26ee1067.0404211702.2fbb4462@.posting.google.c om...
|||tram,
I'm not familiar with REDO groups. If you are using a SAN, then you could
use the SAN replication functionality to replicate the SQL Server data.
Which SAN vendor are you using? I know this is possible with EMC SRDF and
also Hitachi Data Systems TrueCopy.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"tram" <tram_e@.hotmail.com> wrote in message
news:26ee1067.0404230248.78fefeb1@.posting.google.c om...
> What if RAID 1 crashes or on fire? Oracle has got redo groups where
> you can place on REDO group in local and other in SAN. Sql
> serverdoesn't have this functionality and we lose the data in active
> redo . Log shipping doesn't meet our requirement.
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:<e41kfnEKEHA.2716@.tk2msftngp13.phx.gbl>...[vbcol=seagreen]
shipping:[vbcol=seagreen]
http://msdn.microsoft.com/library/de...erver_8elj.asp[vbcol=seagreen]
array?[vbcol=seagreen]
used[vbcol=seagreen]

Disaster recovery

How to protect the transaction logs from disaster considering the loss
of hardware mirror? Can we use remote mirror for these files?tram,
Back them up frequently, say every 5 mins? You can also deploy log shipping:
http://msdn.microsoft.com/library/d...>
ver_8elj.asp
Do you have redundancy at the disk level? Have you implemented a raid array?
RAID-1 is commonly used for transaction log protection - this cannot be used
remotely though, it is local to the server.
See:
http://www.acnc.com/04_01_01_flash.html
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"tram" <tram_e@.hotmail.com> wrote in message
news:26ee1067.0404211702.2fbb4462@.posting.google.com...
> How to protect the transaction logs from disaster considering the loss
> of hardware mirror? Can we use remote mirror for these files?|||What if RAID 1 crashes or on fire? Oracle has got redo groups where
you can place on REDO group in local and other in SAN. Sql
serverdoesn't have this functionality and we lose the data in active
redo . Log shipping doesn't meet our requirement.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message news:<e41kfnEKEHA.2716@.tk2ms
ftngp13.phx.gbl>...[vbcol=seagreen]
> tram,
> Back them up frequently, say every 5 mins? You can also deploy log shippin
g:
> http://msdn.microsoft.com/library/d...
erver_8elj.asp
> Do you have redundancy at the disk level? Have you implemented a raid arra
y?
> RAID-1 is commonly used for transaction log protection - this cannot be us
ed
> remotely though, it is local to the server.
> See:
> http://www.acnc.com/04_01_01_flash.html
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
>
>
> "tram" <tram_e@.hotmail.com> wrote in message
> news:26ee1067.0404211702.2fbb4462@.posting.google.com...|||tram,
I'm not familiar with REDO groups. If you are using a SAN, then you could
use the SAN replication functionality to replicate the SQL Server data.
Which SAN vendor are you using? I know this is possible with EMC SRDF and
also Hitachi Data Systems TrueCopy.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"tram" <tram_e@.hotmail.com> wrote in message
news:26ee1067.0404230248.78fefeb1@.posting.google.com...
> What if RAID 1 crashes or on fire? Oracle has got redo groups where
> you can place on REDO group in local and other in SAN. Sql
> serverdoesn't have this functionality and we lose the data in active
> redo . Log shipping doesn't meet our requirement.
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:<e41kfnEKEHA.2716@.tk2msftngp13.phx.gbl>...[vbcol=seagreen]
shipping:[vbcol=seagreen]
[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_8elj.asp[/ur
l][vbcol=seagreen]
array?[vbcol=seagreen]
used[vbcol=seagreen]

Disaster recovery

How to protect the transaction logs from disaster considering the loss
of hardware mirror? Can we use remote mirror for these files?My server stuff is a bit rusty but I don't believe you can
have a remote mirror, mainly due to network traffic.
Have you though of backing up your database (files and
logs) onto a different server.
J
>--Original Message--
>How to protect the transaction logs from disaster
considering the loss
>of hardware mirror? Can we use remote mirror for these
files?
>.
>|||tram,
Back them up frequently, say every 5 mins? You can also deploy log shipping:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_8elj.asp
Do you have redundancy at the disk level? Have you implemented a raid array?
RAID-1 is commonly used for transaction log protection - this cannot be used
remotely though, it is local to the server.
See:
http://www.acnc.com/04_01_01_flash.html
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"tram" <tram_e@.hotmail.com> wrote in message
news:26ee1067.0404211702.2fbb4462@.posting.google.com...
> How to protect the transaction logs from disaster considering the loss
> of hardware mirror? Can we use remote mirror for these files?|||What if RAID 1 crashes or on fire? Oracle has got redo groups where
you can place on REDO group in local and other in SAN. Sql
serverdoesn't have this functionality and we lose the data in active
redo . Log shipping doesn't meet our requirement.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message news:<e41kfnEKEHA.2716@.tk2msftngp13.phx.gbl>...
> tram,
> Back them up frequently, say every 5 mins? You can also deploy log shipping:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_8elj.asp
> Do you have redundancy at the disk level? Have you implemented a raid array?
> RAID-1 is commonly used for transaction log protection - this cannot be used
> remotely though, it is local to the server.
> See:
> http://www.acnc.com/04_01_01_flash.html
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
>
>
> "tram" <tram_e@.hotmail.com> wrote in message
> news:26ee1067.0404211702.2fbb4462@.posting.google.com...
> > How to protect the transaction logs from disaster considering the loss
> > of hardware mirror? Can we use remote mirror for these files?|||tram,
I'm not familiar with REDO groups. If you are using a SAN, then you could
use the SAN replication functionality to replicate the SQL Server data.
Which SAN vendor are you using? I know this is possible with EMC SRDF and
also Hitachi Data Systems TrueCopy.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"tram" <tram_e@.hotmail.com> wrote in message
news:26ee1067.0404230248.78fefeb1@.posting.google.com...
> What if RAID 1 crashes or on fire? Oracle has got redo groups where
> you can place on REDO group in local and other in SAN. Sql
> serverdoesn't have this functionality and we lose the data in active
> redo . Log shipping doesn't meet our requirement.
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:<e41kfnEKEHA.2716@.tk2msftngp13.phx.gbl>...
> > tram,
> >
> > Back them up frequently, say every 5 mins? You can also deploy log
shipping:
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_8elj.asp
> >
> > Do you have redundancy at the disk level? Have you implemented a raid
array?
> > RAID-1 is commonly used for transaction log protection - this cannot be
used
> > remotely though, it is local to the server.
> >
> > See:
> > http://www.acnc.com/04_01_01_flash.html
> >
> > --
> > Mark Allison, SQL Server MVP
> > http://www.markallison.co.uk
> >
> >
> >
> >
> > "tram" <tram_e@.hotmail.com> wrote in message
> > news:26ee1067.0404211702.2fbb4462@.posting.google.com...
> > > How to protect the transaction logs from disaster considering the loss
> > > of hardware mirror? Can we use remote mirror for these files?

Disappearing parameter values

I have an ASP.NET application with a page which has a Reportviewer control
linked to a Reporting Services report on a Remote Server. I pass parameters
into it OK including the name of the database which is then referenced by a
dynamic connection string. The database is the first parameter. Other
parameters have dropdown lists based on datasets using the dynamic connection
string.
All of this works fine, but...
When I hide some of the parameters, because I know what value is required,
the value is not acceoted, nor does the report use the default value. It is
as though hiding the parameter prevents the list of available values being
requeried; consequently the passed in value is ignored as it does not match
an available value!
Can anyone help please?
Thanks
GeorgeGeorge,
I assume you are setting the Visible property of some web control that
holds the value of your report parameter. You should set the Visibility
Style of the control to 'hidden' so that it still gets rendered into the web
form but is not 'seen' in the web browser. This way the controls value is
still within the form and viewstate when the form is posted back.
Hope I made the correct assumption and this helps.
thx
-jsh
"George Davies" wrote:
> I have an ASP.NET application with a page which has a Reportviewer control
> linked to a Reporting Services report on a Remote Server. I pass parameters
> into it OK including the name of the database which is then referenced by a
> dynamic connection string. The database is the first parameter. Other
> parameters have dropdown lists based on datasets using the dynamic connection
> string.
> All of this works fine, but...
> When I hide some of the parameters, because I know what value is required,
> the value is not acceoted, nor does the report use the default value. It is
> as though hiding the parameter prevents the list of available values being
> requeried; consequently the passed in value is ignored as it does not match
> an available value!
> Can anyone help please?
> Thanks
> George|||Thanks jsh for replying so promptly
I'm not sure I've explained the problem correctly, as I could not find the
Visibility Style for the control as you suggested. I am using RS2005 and
ASP.NET 1.1 with a ReportViewer control linked to a deployed remote report.
But I think you may be on to something as the problem does not arise when
designing the report, nor in Report Manager, only when I run it from within
the ASP ReportViewer control as a Remote Report.
The parameter is passed into the Reporting Services report OK, but when the
Report Server processes the parameters it first takes the name of the
database as the first parameter, then it recognises that there are cascading
parameters because the dropdown lists require data from tables which have
been queried using the dynamic connection string. At this point it seems to
assume that because it is going to refresh the dropdown lists that it can no
longer rely on the selections supplied in the other parameters and scrubs
them i.e. it insists that the user rekey each of the parameter values
wherever the dropdown lists use the dynamic connection string.
This causes two problems:
1 When I want a parameter value hidden, it is impossible to set it and the
report fails with e.g. "Parameter zzz does not have a value". I could get
round this by using two parameters for each value, one for when I want to
force the parameter to be a certain value and hide it with no associated
dropdown list, and one for when I want to show it and ask the user to pick
from a list. Messy, but I could get the report SQL to test for either of the
values in the two parameters. But this still leaves problem number 2...
2 When cascading parameters are used, each time the user picks a value, it
postbacks to the server. This is not very clever of Reporting Services. It
should post back when the value for a parameter is changed where that
parameter is used by other parameters, not when a parameter changes which
uses the value from another parameter.
The long and short of it is that with eight parameters, the selection of
report options is excruciatingly slow and won't be acceptable to my users.
If you or anyone else can shed any light on this problem, I would be really
grateful.
Thanks again and best wishes
George
"jsh02_nova@.hotmail.com" wrote:
> George,
> I assume you are setting the Visible property of some web control that
> holds the value of your report parameter. You should set the Visibility
> Style of the control to 'hidden' so that it still gets rendered into the web
> form but is not 'seen' in the web browser. This way the controls value is
> still within the form and viewstate when the form is posted back.
> Hope I made the correct assumption and this helps.
> thx
> -jsh
> "George Davies" wrote:
> > I have an ASP.NET application with a page which has a Reportviewer control
> > linked to a Reporting Services report on a Remote Server. I pass parameters
> > into it OK including the name of the database which is then referenced by a
> > dynamic connection string. The database is the first parameter. Other
> > parameters have dropdown lists based on datasets using the dynamic connection
> > string.
> >
> > All of this works fine, but...
> >
> > When I hide some of the parameters, because I know what value is required,
> > the value is not acceoted, nor does the report use the default value. It is
> > as though hiding the parameter prevents the list of available values being
> > requeried; consequently the passed in value is ignored as it does not match
> > an available value!
> >
> > Can anyone help please?
> >
> > Thanks
> >
> > George

disabled fields, such as Upload File, in Report Manager

When I open Report Manager through IE on server 2003 installed with reporting
service and login as an admin through remote desktop connection, I can see
all the features but disabled. I can not Upload File, Add New Data Source
etc.. What is wrong? Please help.See what role-based security you have.
At the "Home" folder, go to Properties --> Security and see the roles
assigned to the admin. If you don't have "Content Manager" role
assigned to you, you can not upload the files.
Shang wrote:
> When I open Report Manager through IE on server 2003 installed with reporting
> service and login as an admin through remote desktop connection, I can see
> all the features but disabled. I can not Upload File, Add New Data Source
> etc.. What is wrong? Please help.|||Well, what i m used to do to upload rdls, is -
1 - go to the properties of reports virtual folder under IIS
2 - click directory security tab
3 - click edit button
4 - turn of anoymous access
it works for me|||I agree, it seems like the website has anonymous turned on. When anonymous
is turned on, even logged in as administrator does not give you the
administrators rights to do things in RS. This is because with anonymous
turned on everybody is treated the same, because they are anonymous.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Techotsav" <Utsav.Verma@.gmail.com> wrote in message
news:1134195509.900311.33640@.o13g2000cwo.googlegroups.com...
> Well, what i m used to do to upload rdls, is -
> 1 - go to the properties of reports virtual folder under IIS
> 2 - click directory security tab
> 3 - click edit button
> 4 - turn of anoymous access
> it works for me
>|||Hi Bruce,
Having similar problem.
Fresh install of Windows 2003 Standard, and IIS, SP1
Fresh Install of SQL 2005 w/ Reporting Services
Fresh install of Visual Studio 2005
Can not create new folder etc... Logged on as user with Administrative
privileges or Local Administrator or Domain Administrator, no difference?
Thanx in advance,
Greg Rowland|||Hi Siva,
It is Content Manager role for the admin login. Anonymous access is disabled
and Integrated Windows authentication is checked.
The server 2003 is just installed with IS6.0 and reporting services only.
Any hints?
"siva.jasthi@.gmail.com" wrote:
> See what role-based security you have.
> At the "Home" folder, go to Properties --> Security and see the roles
> assigned to the admin. If you don't have "Content Manager" role
> assigned to you, you can not upload the files.
>
> Shang wrote:
> > When I open Report Manager through IE on server 2003 installed with reporting
> > service and login as an admin through remote desktop connection, I can see
> > all the features but disabled. I can not Upload File, Add New Data Source
> > etc.. What is wrong? Please help.
>|||Greg,
Please inform me of any possible solutions since we share a similar problem.
"Greg Rowland" wrote:
> Hi Bruce,
>
> Having similar problem.
> Fresh install of Windows 2003 Standard, and IIS, SP1
> Fresh Install of SQL 2005 w/ Reporting Services
> Fresh install of Visual Studio 2005
>
> Can not create new folder etc... Logged on as user with Administrative
> privileges or Local Administrator or Domain Administrator, no difference?
>
>
> Thanx in advance,
>
> Greg Rowland
>
>
>|||I found a change to http://localhost/reports instead of
http://computername/reports
made the difference. But why?
"Greg Rowland" wrote:
> OK
>
>

Disable updates via triggers - how?

Hi,
We use push transactional replication successfully and are about to bring a
few remote on-sites into the fold. The connection speed will be low - in the
64k/128k range. As I understand it "Not for replication" means that a trigger
on the subcriber will not fire if the update is generated via a replication
process, i.e. all updates are pushed from the publisher. If this is correct
is there any way to reverse the logic, i.e. don't replicate updates on the
publisher that are caused by triggers and assume the subscriber will have the
appropriate triggers in place to do the update.
We are interested in doing this to reduce the amount of network bandwidth
consummed be replication (this will be critical when the remote sites come
on-line).
Can this be done?
Cheers, Peter
The not for replication switch means that replication related activity
will not cause the trigger, constraint, identity property to be enforced
if the triggering activity occurs by a replication process. This could
happen on the publisher or subscriber.
There is a way to bypass the replication process. What you do is add
filters to your tables which look like this
select * from published tables where 1=1.
A filter proc will be created which the log reader agent uses when
figuring out what commands are to be written to the distribution agent.
Change this filter to always return 0 when you want the commands to be
ignored. Change it back to 1 when you want the commands to be processed.
The problem is you can't alter procs via a trigger.
The way I handle things like this is to build the logic into the
replication proc that applies these transactions on the subscriber(s).
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
|||Hi Hillary,
Thanks for the response.
Where do I go to add the filter: "select * from published tables where 1=1."?
When and where would I change the filter?
I do have a copy of your fine book - what sections are relevent to this
particular issue.
I presume the following isn't relevent to my circumstance as what I'm trying
to do reduce network traffice. Or I have I misunderstood?

> The way I handle things like this is to build the logic into the
> replication proc that applies these transactions on the subscriber(s).
Cheers, Peter
"Hilary Cotter" wrote:

> The not for replication switch means that replication related activity
> will not cause the trigger, constraint, identity property to be enforced
> if the triggering activity occurs by a replication process. This could
> happen on the publisher or subscriber.
> There is a way to bypass the replication process. What you do is add
> filters to your tables which look like this
>
> A filter proc will be created which the log reader agent uses when
> figuring out what commands are to be written to the distribution agent.
> Change this filter to always return 0 when you want the commands to be
> ignored. Change it back to 1 when you want the commands to be processed.
> The problem is you can't alter procs via a trigger.
> The way I handle things like this is to build the logic into the
> replication proc that applies these transactions on the subscriber(s).
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
|||You are correct, making these change to the replication procs used to
synchronize your data will not minimize network traffic. Replicating the
execution of stored procedures will, if the majority of your transactions
occurring on the publisher affect more than one row.
Have a look at this post for an example of how to make the log reader agent
bypass transactions.
http://groups-beta.google.com/group/...c?dmode=source
"Peter Jones" <PeterJones@.discussions.microsoft.com> wrote in message
news:87E55BFF-BCB2-4C20-B5F5-9C48B3B8064D@.microsoft.com...[vbcol=seagreen]
> Hi Hillary,
> Thanks for the response.
> Where do I go to add the filter: "select * from published tables where
> 1=1."?
> When and where would I change the filter?
> I do have a copy of your fine book - what sections are relevent to this
> particular issue.
> I presume the following isn't relevent to my circumstance as what I'm
> trying
> to do reduce network traffice. Or I have I misunderstood?
>
> Cheers, Peter
>
> "Hilary Cotter" wrote: