a couple reporting/ normalization questions

I have one DB in specific that fails to even be in 1NF, much less 3rd. It is
used only for reporting, no OLTP. The queries are quite slow to say the
least. Every day this data is truncated and repopulated from a mainframe.
From what I can tell there are a few options here.
1; Normalize it. The problem here is there are 150+ Stored Procs dependant
on the existing structure, and of course nobody has time to re-write them.
Theres probably software that can do this for us, (?) but if so, does it
really work well? Also, the DTS Package that populates this DB every day
would need total overhauling.
2; Forget this pile of crap. Let it stay how it is for existing stuff. But
have new stuff go into Analysis Services, and then use Reporting Services.
Everyone here want to use AS and RS anyways, so thats the way we are
leaning. The problem is I have little experience with either of these tools.
Im open to the challenge and we move fairly slow anyways, so I think it can
work. Now my questions.
1; Can Reporting Services connect/report from Analysis Services?
2, Can AS be populated from a totally de-normalized DB? Can I design the
cubes how they should be, and take the data from several different tables to
populate them?
3; If #2 isnt hopefull, would I be better off to create a new, well designed
db, populate that, and from there populate AS?
All insights are appreciated.
TIA,
ChrisR
to answer number2
You should use DTS to do this
Create the structure that you think will work for you amd then you can
create your cubes (fact and dimension tables) however you want
http://sqlservercode.blogspot.com/
"ChrisR" wrote:

> I have one DB in specific that fails to even be in 1NF, much less 3rd. It is
> used only for reporting, no OLTP. The queries are quite slow to say the
> least. Every day this data is truncated and repopulated from a mainframe.
> From what I can tell there are a few options here.
> 1; Normalize it. The problem here is there are 150+ Stored Procs dependant
> on the existing structure, and of course nobody has time to re-write them.
> Theres probably software that can do this for us, (?) but if so, does it
> really work well? Also, the DTS Package that populates this DB every day
> would need total overhauling.
> 2; Forget this pile of crap. Let it stay how it is for existing stuff. But
> have new stuff go into Analysis Services, and then use Reporting Services.
> Everyone here want to use AS and RS anyways, so thats the way we are
> leaning. The problem is I have little experience with either of these tools.
> Im open to the challenge and we move fairly slow anyways, so I think it can
> work. Now my questions.
> 1; Can Reporting Services connect/report from Analysis Services?
> 2, Can AS be populated from a totally de-normalized DB? Can I design the
> cubes how they should be, and take the data from several different tables to
> populate them?
> 3; If #2 isnt hopefull, would I be better off to create a new, well designed
> db, populate that, and from there populate AS?
> All insights are appreciated.
> --
> TIA,
> ChrisR
|||Chris,
1. Yes you can use AS as a source of data to RS.
2 & 3. Depends on how the data is structured. A normalized structure to a
denormalized (star or snowflake) structure would be prefered.
HTH
Jerry
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:BE095EAD-5738-43EC-A2EC-1BF20E837BEF@.microsoft.com...
>I have one DB in specific that fails to even be in 1NF, much less 3rd. It
>is
> used only for reporting, no OLTP. The queries are quite slow to say the
> least. Every day this data is truncated and repopulated from a mainframe.
> From what I can tell there are a few options here.
> 1; Normalize it. The problem here is there are 150+ Stored Procs dependant
> on the existing structure, and of course nobody has time to re-write them.
> Theres probably software that can do this for us, (?) but if so, does it
> really work well? Also, the DTS Package that populates this DB every day
> would need total overhauling.
> 2; Forget this pile of crap. Let it stay how it is for existing stuff. But
> have new stuff go into Analysis Services, and then use Reporting Services.
> Everyone here want to use AS and RS anyways, so thats the way we are
> leaning. The problem is I have little experience with either of these
> tools.
> Im open to the challenge and we move fairly slow anyways, so I think it
> can
> work. Now my questions.
> 1; Can Reporting Services connect/report from Analysis Services?
> 2, Can AS be populated from a totally de-normalized DB? Can I design the
> cubes how they should be, and take the data from several different tables
> to
> populate them?
> 3; If #2 isnt hopefull, would I be better off to create a new, well
> designed
> db, populate that, and from there populate AS?
> All insights are appreciated.
> --
> TIA,
> ChrisR
|||Do both of you mean that I can, or cannot, populate well designed cubes from
my poorly designed tables? I think you are both saying I can, but want to
clarify.
Thanks, ChrisR
"ChrisR" wrote:

> I have one DB in specific that fails to even be in 1NF, much less 3rd. It is
> used only for reporting, no OLTP. The queries are quite slow to say the
> least. Every day this data is truncated and repopulated from a mainframe.
> From what I can tell there are a few options here.
> 1; Normalize it. The problem here is there are 150+ Stored Procs dependant
> on the existing structure, and of course nobody has time to re-write them.
> Theres probably software that can do this for us, (?) but if so, does it
> really work well? Also, the DTS Package that populates this DB every day
> would need total overhauling.
> 2; Forget this pile of crap. Let it stay how it is for existing stuff. But
> have new stuff go into Analysis Services, and then use Reporting Services.
> Everyone here want to use AS and RS anyways, so thats the way we are
> leaning. The problem is I have little experience with either of these tools.
> Im open to the challenge and we move fairly slow anyways, so I think it can
> work. Now my questions.
> 1; Can Reporting Services connect/report from Analysis Services?
> 2, Can AS be populated from a totally de-normalized DB? Can I design the
> cubes how they should be, and take the data from several different tables to
> populate them?
> 3; If #2 isnt hopefull, would I be better off to create a new, well designed
> db, populate that, and from there populate AS?
> All insights are appreciated.
> --
> TIA,
> ChrisR
|||Chris,
It's kinda like asking can I get 'there' from 'here' without being able to
accurately qualify where 'here' is. AS cubes are built off of denormalized
structures (star and snowflake). I'm "somewhat" sure with views and DTS you
can populate the structure tables for the AS cubes or possibly the AS cubes
themselves. Would it be easier if you were working with a normalized design
to start with? Would there be less coding and less possiblity for error?
I'd say yes to both.
HTH
Jerry
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:1C1291EB-FAD5-41E1-8655-5E3BC7B7B695@.microsoft.com...[vbcol=seagreen]
> Do both of you mean that I can, or cannot, populate well designed cubes
> from
> my poorly designed tables? I think you are both saying I can, but want to
> clarify.
> Thanks, ChrisR
>
> "ChrisR" wrote:
sql

a couple reporting/ normalization questions

I have one DB in specific that fails to even be in 1NF, much less 3rd. It is
used only for reporting, no OLTP. The queries are quite slow to say the
least. Every day this data is truncated and repopulated from a mainframe.
From what I can tell there are a few options here.
1; Normalize it. The problem here is there are 150+ Stored Procs dependant
on the existing structure, and of course nobody has time to re-write them.
Theres probably software that can do this for us, (?) but if so, does it
really work well? Also, the DTS Package that populates this DB every day
would need total overhauling.
2; Forget this pile of crap. Let it stay how it is for existing stuff. But
have new stuff go into Analysis Services, and then use Reporting Services.
Everyone here want to use AS and RS anyways, so thats the way we are
leaning. The problem is I have little experience with either of these tools.
Im open to the challenge and we move fairly slow anyways, so I think it can
work. Now my questions.
1; Can Reporting Services connect/report from Analysis Services?
2, Can AS be populated from a totally de-normalized DB? Can I design the
cubes how they should be, and take the data from several different tables to
populate them?
3; If #2 isnt hopefull, would I be better off to create a new, well designed
db, populate that, and from there populate AS?
All insights are appreciated.
--
TIA,
ChrisRto answer number2
You should use DTS to do this
Create the structure that you think will work for you amd then you can
create your cubes (fact and dimension tables) however you want
http://sqlservercode.blogspot.com/
"ChrisR" wrote:
> I have one DB in specific that fails to even be in 1NF, much less 3rd. It is
> used only for reporting, no OLTP. The queries are quite slow to say the
> least. Every day this data is truncated and repopulated from a mainframe.
> From what I can tell there are a few options here.
> 1; Normalize it. The problem here is there are 150+ Stored Procs dependant
> on the existing structure, and of course nobody has time to re-write them.
> Theres probably software that can do this for us, (?) but if so, does it
> really work well? Also, the DTS Package that populates this DB every day
> would need total overhauling.
> 2; Forget this pile of crap. Let it stay how it is for existing stuff. But
> have new stuff go into Analysis Services, and then use Reporting Services.
> Everyone here want to use AS and RS anyways, so thats the way we are
> leaning. The problem is I have little experience with either of these tools.
> Im open to the challenge and we move fairly slow anyways, so I think it can
> work. Now my questions.
> 1; Can Reporting Services connect/report from Analysis Services?
> 2, Can AS be populated from a totally de-normalized DB? Can I design the
> cubes how they should be, and take the data from several different tables to
> populate them?
> 3; If #2 isnt hopefull, would I be better off to create a new, well designed
> db, populate that, and from there populate AS?
> All insights are appreciated.
> --
> TIA,
> ChrisR|||Chris,
1. Yes you can use AS as a source of data to RS.
2 & 3. Depends on how the data is structured. A normalized structure to a
denormalized (star or snowflake) structure would be prefered.
HTH
Jerry
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:BE095EAD-5738-43EC-A2EC-1BF20E837BEF@.microsoft.com...
>I have one DB in specific that fails to even be in 1NF, much less 3rd. It
>is
> used only for reporting, no OLTP. The queries are quite slow to say the
> least. Every day this data is truncated and repopulated from a mainframe.
> From what I can tell there are a few options here.
> 1; Normalize it. The problem here is there are 150+ Stored Procs dependant
> on the existing structure, and of course nobody has time to re-write them.
> Theres probably software that can do this for us, (?) but if so, does it
> really work well? Also, the DTS Package that populates this DB every day
> would need total overhauling.
> 2; Forget this pile of crap. Let it stay how it is for existing stuff. But
> have new stuff go into Analysis Services, and then use Reporting Services.
> Everyone here want to use AS and RS anyways, so thats the way we are
> leaning. The problem is I have little experience with either of these
> tools.
> Im open to the challenge and we move fairly slow anyways, so I think it
> can
> work. Now my questions.
> 1; Can Reporting Services connect/report from Analysis Services?
> 2, Can AS be populated from a totally de-normalized DB? Can I design the
> cubes how they should be, and take the data from several different tables
> to
> populate them?
> 3; If #2 isnt hopefull, would I be better off to create a new, well
> designed
> db, populate that, and from there populate AS?
> All insights are appreciated.
> --
> TIA,
> ChrisR|||Do both of you mean that I can, or cannot, populate well designed cubes from
my poorly designed tables? I think you are both saying I can, but want to
clarify.
Thanks, ChrisR
"ChrisR" wrote:
> I have one DB in specific that fails to even be in 1NF, much less 3rd. It is
> used only for reporting, no OLTP. The queries are quite slow to say the
> least. Every day this data is truncated and repopulated from a mainframe.
> From what I can tell there are a few options here.
> 1; Normalize it. The problem here is there are 150+ Stored Procs dependant
> on the existing structure, and of course nobody has time to re-write them.
> Theres probably software that can do this for us, (?) but if so, does it
> really work well? Also, the DTS Package that populates this DB every day
> would need total overhauling.
> 2; Forget this pile of crap. Let it stay how it is for existing stuff. But
> have new stuff go into Analysis Services, and then use Reporting Services.
> Everyone here want to use AS and RS anyways, so thats the way we are
> leaning. The problem is I have little experience with either of these tools.
> Im open to the challenge and we move fairly slow anyways, so I think it can
> work. Now my questions.
> 1; Can Reporting Services connect/report from Analysis Services?
> 2, Can AS be populated from a totally de-normalized DB? Can I design the
> cubes how they should be, and take the data from several different tables to
> populate them?
> 3; If #2 isnt hopefull, would I be better off to create a new, well designed
> db, populate that, and from there populate AS?
> All insights are appreciated.
> --
> TIA,
> ChrisR|||Chris,
It's kinda like asking can I get 'there' from 'here' without being able to
accurately qualify where 'here' is. AS cubes are built off of denormalized
structures (star and snowflake). I'm "somewhat" sure with views and DTS you
can populate the structure tables for the AS cubes or possibly the AS cubes
themselves. Would it be easier if you were working with a normalized design
to start with? Would there be less coding and less possiblity for error?
I'd say yes to both.
HTH
Jerry
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:1C1291EB-FAD5-41E1-8655-5E3BC7B7B695@.microsoft.com...
> Do both of you mean that I can, or cannot, populate well designed cubes
> from
> my poorly designed tables? I think you are both saying I can, but want to
> clarify.
> Thanks, ChrisR
>
> "ChrisR" wrote:
>> I have one DB in specific that fails to even be in 1NF, much less 3rd. It
>> is
>> used only for reporting, no OLTP. The queries are quite slow to say the
>> least. Every day this data is truncated and repopulated from a mainframe.
>> From what I can tell there are a few options here.
>> 1; Normalize it. The problem here is there are 150+ Stored Procs
>> dependant
>> on the existing structure, and of course nobody has time to re-write
>> them.
>> Theres probably software that can do this for us, (?) but if so, does it
>> really work well? Also, the DTS Package that populates this DB every day
>> would need total overhauling.
>> 2; Forget this pile of crap. Let it stay how it is for existing stuff.
>> But
>> have new stuff go into Analysis Services, and then use Reporting
>> Services.
>> Everyone here want to use AS and RS anyways, so thats the way we are
>> leaning. The problem is I have little experience with either of these
>> tools.
>> Im open to the challenge and we move fairly slow anyways, so I think it
>> can
>> work. Now my questions.
>> 1; Can Reporting Services connect/report from Analysis Services?
>> 2, Can AS be populated from a totally de-normalized DB? Can I design the
>> cubes how they should be, and take the data from several different tables
>> to
>> populate them?
>> 3; If #2 isnt hopefull, would I be better off to create a new, well
>> designed
>> db, populate that, and from there populate AS?
>> All insights are appreciated.
>> --
>> TIA,
>> ChrisR

a couple reporting/ normalization questions

I have one DB in specific that fails to even be in 1NF, much less 3rd. It is
used only for reporting, no OLTP. The queries are quite slow to say the
least. Every day this data is truncated and repopulated from a mainframe.
From what I can tell there are a few options here.
1; Normalize it. The problem here is there are 150+ Stored Procs dependant
on the existing structure, and of course nobody has time to re-write them.
Theres probably software that can do this for us, (?) but if so, does it
really work well? Also, the DTS Package that populates this DB every day
would need total overhauling.
2; Forget this pile of crap. Let it stay how it is for existing stuff. But
have new stuff go into Analysis Services, and then use Reporting Services.
Everyone here want to use AS and RS anyways, so thats the way we are
leaning. The problem is I have little experience with either of these tools.
Im open to the challenge and we move fairly slow anyways, so I think it can
work. Now my questions.
1; Can Reporting Services connect/report from Analysis Services?
2, Can AS be populated from a totally de-normalized DB? Can I design the
cubes how they should be, and take the data from several different tables to
populate them?
3; If #2 isnt hopefull, would I be better off to create a new, well designed
db, populate that, and from there populate AS?
All insights are appreciated.
TIA,
ChrisRto answer number2
You should use DTS to do this
Create the structure that you think will work for you amd then you can
create your cubes (fact and dimension tables) however you want
http://sqlservercode.blogspot.com/
"ChrisR" wrote:

> I have one DB in specific that fails to even be in 1NF, much less 3rd. It
is
> used only for reporting, no OLTP. The queries are quite slow to say the
> least. Every day this data is truncated and repopulated from a mainframe.
> From what I can tell there are a few options here.
> 1; Normalize it. The problem here is there are 150+ Stored Procs dependant
> on the existing structure, and of course nobody has time to re-write them.
> Theres probably software that can do this for us, (?) but if so, does it
> really work well? Also, the DTS Package that populates this DB every day
> would need total overhauling.
> 2; Forget this pile of crap. Let it stay how it is for existing stuff. But
> have new stuff go into Analysis Services, and then use Reporting Services.
> Everyone here want to use AS and RS anyways, so thats the way we are
> leaning. The problem is I have little experience with either of these tool
s.
> Im open to the challenge and we move fairly slow anyways, so I think it ca
n
> work. Now my questions.
> 1; Can Reporting Services connect/report from Analysis Services?
> 2, Can AS be populated from a totally de-normalized DB? Can I design the
> cubes how they should be, and take the data from several different tables
to
> populate them?
> 3; If #2 isnt hopefull, would I be better off to create a new, well design
ed
> db, populate that, and from there populate AS?
> All insights are appreciated.
> --
> TIA,
> ChrisR|||Chris,
1. Yes you can use AS as a source of data to RS.
2 & 3. Depends on how the data is structured. A normalized structure to a
denormalized (star or snowflake) structure would be prefered.
HTH
Jerry
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:BE095EAD-5738-43EC-A2EC-1BF20E837BEF@.microsoft.com...
>I have one DB in specific that fails to even be in 1NF, much less 3rd. It
>is
> used only for reporting, no OLTP. The queries are quite slow to say the
> least. Every day this data is truncated and repopulated from a mainframe.
> From what I can tell there are a few options here.
> 1; Normalize it. The problem here is there are 150+ Stored Procs dependant
> on the existing structure, and of course nobody has time to re-write them.
> Theres probably software that can do this for us, (?) but if so, does it
> really work well? Also, the DTS Package that populates this DB every day
> would need total overhauling.
> 2; Forget this pile of crap. Let it stay how it is for existing stuff. But
> have new stuff go into Analysis Services, and then use Reporting Services.
> Everyone here want to use AS and RS anyways, so thats the way we are
> leaning. The problem is I have little experience with either of these
> tools.
> Im open to the challenge and we move fairly slow anyways, so I think it
> can
> work. Now my questions.
> 1; Can Reporting Services connect/report from Analysis Services?
> 2, Can AS be populated from a totally de-normalized DB? Can I design the
> cubes how they should be, and take the data from several different tables
> to
> populate them?
> 3; If #2 isnt hopefull, would I be better off to create a new, well
> designed
> db, populate that, and from there populate AS?
> All insights are appreciated.
> --
> TIA,
> ChrisR|||Do both of you mean that I can, or cannot, populate well designed cubes from
my poorly designed tables? I think you are both saying I can, but want to
clarify.
Thanks, ChrisR
"ChrisR" wrote:

> I have one DB in specific that fails to even be in 1NF, much less 3rd. It
is
> used only for reporting, no OLTP. The queries are quite slow to say the
> least. Every day this data is truncated and repopulated from a mainframe.
> From what I can tell there are a few options here.
> 1; Normalize it. The problem here is there are 150+ Stored Procs dependant
> on the existing structure, and of course nobody has time to re-write them.
> Theres probably software that can do this for us, (?) but if so, does it
> really work well? Also, the DTS Package that populates this DB every day
> would need total overhauling.
> 2; Forget this pile of crap. Let it stay how it is for existing stuff. But
> have new stuff go into Analysis Services, and then use Reporting Services.
> Everyone here want to use AS and RS anyways, so thats the way we are
> leaning. The problem is I have little experience with either of these tool
s.
> Im open to the challenge and we move fairly slow anyways, so I think it ca
n
> work. Now my questions.
> 1; Can Reporting Services connect/report from Analysis Services?
> 2, Can AS be populated from a totally de-normalized DB? Can I design the
> cubes how they should be, and take the data from several different tables
to
> populate them?
> 3; If #2 isnt hopefull, would I be better off to create a new, well design
ed
> db, populate that, and from there populate AS?
> All insights are appreciated.
> --
> TIA,
> ChrisR|||Chris,
It's kinda like asking can I get 'there' from 'here' without being able to
accurately qualify where 'here' is. AS cubes are built off of denormalized
structures (star and snowflake). I'm "somewhat" sure with views and DTS you
can populate the structure tables for the AS cubes or possibly the AS cubes
themselves. Would it be easier if you were working with a normalized design
to start with? Would there be less coding and less possiblity for error?
I'd say yes to both.
HTH
Jerry
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:1C1291EB-FAD5-41E1-8655-5E3BC7B7B695@.microsoft.com...[vbcol=seagreen]
> Do both of you mean that I can, or cannot, populate well designed cubes
> from
> my poorly designed tables? I think you are both saying I can, but want to
> clarify.
> Thanks, ChrisR
>
> "ChrisR" wrote:
>

3rd party tools for job scheduling

I am looking for a better way to schedule jobs in SQL Server. I found
this tool called SQLschedule at www.idera.com and am using the 30 day
trial. This tool really has a cool GUI, and seems to work well. Does
anyone else have any experience with their tools?Are you aware of SQL Server's own Agent? What functionality are you looking
for that Agent doesn't provide?

--
David Portas
SQL Server MVP
--

3rd party tools

Hello, I am searching for any third party MS SQL
Server2000 tools that would encrypt table data from being
viewedCheck out this page:
http://www.sqlsecurity.com/DesktopD...index=1&tabid=2
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"Ehioze" <ehioze@.usa.net> wrote in message
news:042f01c3c7f1$533f02b0$a001280a@.phx.gbl...
Hello, I am searching for any third party MS SQL
Server2000 tools that would encrypt table data from being
viewed

3rd party tool to create reports

Hi,
Does any one know of a 3rd party tool to create report definitions for SQL
Reporting Services so you don't have to use Visual Studio.NET?
Y/JakobUnless you have objections about how it creates it or how easy it is to
create it, all you need to have is any version of VS, which includes VB. I
believe it is possible to get something with VS that costs only $100. I
doubt you could purchase a report writer for less than that. $100 per
developer is pretty inexpensive.
Bruce L-C
"Jakob Olsen" <jaoss@.wmdata.com> wrote in message
news:OVlIKaDlEHA.3520@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Does any one know of a 3rd party tool to create report definitions for SQL
> Reporting Services so you don't have to use Visual Studio.NET?
> Y/Jakob
>|||There are some 3rd party tools listed at
http://www.microsoft.com/sql/reporting/partners/softwareapps.asp.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23C5JSLElEHA.592@.TK2MSFTNGP11.phx.gbl...
> Unless you have objections about how it creates it or how easy it is to
> create it, all you need to have is any version of VS, which includes VB. I
> believe it is possible to get something with VS that costs only $100. I
> doubt you could purchase a report writer for less than that. $100 per
> developer is pretty inexpensive.
> Bruce L-C
> "Jakob Olsen" <jaoss@.wmdata.com> wrote in message
> news:OVlIKaDlEHA.3520@.TK2MSFTNGP11.phx.gbl...
>> Hi,
>> Does any one know of a 3rd party tool to create report definitions for
>> SQL Reporting Services so you don't have to use Visual Studio.NET?
>> Y/Jakob
>

3rd Party Source Control that leverages VSS

I noticed from this link:

http://www.aspfaq.com/show.asp?id=2495

There are four well known products that are used by medium to large size shops to help aid in change management of SQL Environments.

- AbaPerls
- DBGhost
- MSSqlExpress
- SQL Source Control

Does anyone currently use any of the above? Could you briefly explain your likes an dislikes and if you have reviewed any of the other options above when you had to make a decision as to which product to use?I guess no one uses 3rd party tools to complement Visual Source Safe??|||I did not know anything complemented VSS. We certainly don't ;-).

3rd party software

Does anyone know any software to backup single tables ? i recall one software that extracts the data into a text file called SQLinsert or something but wondering if they are others around ?Rey SQLLiteSpeed from DBAssociates (I think it has been bought by IMCEDA).

3rd party replication tools

Hi all,
We need to setup a simple 2 way replication between 2 independent sites to
synchronize the data between them.
It looks to us that setting up the native SQL Server replication is somewhat
an overkill for our needs.
We are worried about the administrative overhead and problems associated
with it.
Reading the posts here on this newsgroup only elevated our concerns :-)
I would like to know if you have any recommendations for a simple and
reliable 3rd party replication tools to do the job.
The servers (clustered WIN2K machines with SQL Server 2000 SP3 Ent.) will be
located on the east and west coast, connected by a fast and reliable ISP
backbone.
backup network will be a VPN over the internet.
The allowed time delta of data sync is about 5 minutes max, faster is
better.
Replicated data size will be less than 1MB/hour in each direction.
any comments and recomendations will be appreciated.
Thank in advance,
Amy
If you think you are going to have problems with SQL Server replication,
imagine the problems you will have with 3rd partly replication products
which actually use SQL Server replication under the covers (i.e. data
mirror).
Just because this newsgroup is pretty active doesn't mean that replication
is problematic?
Think of it like divorce attorneys. All they see are failed marriages, and
so they are pretty pessimistic about marriages. Simiarly, just because this
newsgroup deals with replication doesn't mean that it can't be made to be
bullet proof.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Amy" <XXXNOSPAMXXX___l.a@.usa.com> wrote in message
news:%23ZQHVRJgEHA.3948@.TK2MSFTNGP11.phx.gbl...
> Hi all,
> We need to setup a simple 2 way replication between 2 independent sites to
> synchronize the data between them.
> It looks to us that setting up the native SQL Server replication is
somewhat
> an overkill for our needs.
> We are worried about the administrative overhead and problems associated
> with it.
> Reading the posts here on this newsgroup only elevated our concerns :-)
> I would like to know if you have any recommendations for a simple and
> reliable 3rd party replication tools to do the job.
> The servers (clustered WIN2K machines with SQL Server 2000 SP3 Ent.) will
be
> located on the east and west coast, connected by a fast and reliable ISP
> backbone.
> backup network will be a VPN over the internet.
> The allowed time delta of data sync is about 5 minutes max, faster is
> better.
> Replicated data size will be less than 1MB/hour in each direction.
> any comments and recomendations will be appreciated.
> Thank in advance,
> Amy
>
>
|||Thanks Hilary,
I think i get you.
BTW: The remark about the newsgroup was not meant seriously :-)
We have experience on another larger system with SQL Server replication but
on that system (13 Servers with multiple merge and transactional
replications) the demands were pretty complex so we chose the native system.
The system works great until something happens and it fails. Sometimes it's
a breeze to recover, on other times we have spent white nights recovering
and reinitializing it.
For this system, the demands are really simple.
Just sync around 5 tables both ways.
We have considered writing a custom SQL / c# asynchronous application with
simple queue tables that will use DTS / linked servers to do the trick.
We have also checked the option of using diff tools like red gate's data
compare and sqldiff. Although it's not their true purpose, we feel it might
just work.
This should be very easy to recover and reinitialize J
I was wondering if anyone has tried this approach before and any other
comments you may have on this issue.
Thanks again,
Amy
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:eNkFfiJgEHA.1196@.TK2MSFTNGP11.phx.gbl...
> If you think you are going to have problems with SQL Server replication,
> imagine the problems you will have with 3rd partly replication products
> which actually use SQL Server replication under the covers (i.e. data
> mirror).
> Just because this newsgroup is pretty active doesn't mean that replication
> is problematic?
> Think of it like divorce attorneys. All they see are failed marriages, and
> so they are pretty pessimistic about marriages. Simiarly, just because
this[vbcol=seagreen]
> newsgroup deals with replication doesn't mean that it can't be made to be
> bullet proof.
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Amy" <XXXNOSPAMXXX___l.a@.usa.com> wrote in message
> news:%23ZQHVRJgEHA.3948@.TK2MSFTNGP11.phx.gbl...
to[vbcol=seagreen]
> somewhat
will
> be
>
|||I wish I could tell you that replication has been problem free for me, and I
have never had to tear everything down and start from scratch. But
occasionally I have. Sometimes it has been due to bugs, and sometimes due to
errors I have made in deployment.
Without knowing exactly why you are running into the errors you are
experiencing which force you to reinitialize, regenerate, and redistribute
your snapshots, its hard for me to comment on what approach you should take.
The temptation is always great to believe that you can cobble together
something that will work better than the solution that Microsoft has
provided us. However, when you use replication and it fails you can always
call Microsoft at 2:00 am and get support. When you cobble together a system
of your own design it is always fragile, and could break with the next
schema change, service pack, version upgrade, reinitialization or even the
next transaction. Then again, you might come up with something that is
bullet proof.
Your decision will have to be based on where your skill levels lie - i.e.
with SQL Server replication, or something you cobble together yourself.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Amy" <XXXNOSPAMXXX___l.a@.usa.com> wrote in message
news:ug8fjnKgEHA.2896@.TK2MSFTNGP11.phx.gbl...
> Thanks Hilary,
>
> I think i get you.
> BTW: The remark about the newsgroup was not meant seriously :-)
>
> We have experience on another larger system with SQL Server replication
but
> on that system (13 Servers with multiple merge and transactional
> replications) the demands were pretty complex so we chose the native
system.
> The system works great until something happens and it fails. Sometimes
it's
> a breeze to recover, on other times we have spent white nights recovering
> and reinitializing it.
>
> For this system, the demands are really simple.
> Just sync around 5 tables both ways.
>
> We have considered writing a custom SQL / c# asynchronous application with
> simple queue tables that will use DTS / linked servers to do the trick.
> We have also checked the option of using diff tools like red gate's data
> compare and sqldiff. Although it's not their true purpose, we feel it
might[vbcol=seagreen]
> just work.
> This should be very easy to recover and reinitialize J
>
> I was wondering if anyone has tried this approach before and any other
> comments you may have on this issue.
>
> Thanks again,
>
> Amy
>
> "Hilary Cotter" <hilaryk@.att.net> wrote in message
> news:eNkFfiJgEHA.1196@.TK2MSFTNGP11.phx.gbl...
replication[vbcol=seagreen]
and[vbcol=seagreen]
> this
be[vbcol=seagreen]
sites[vbcol=seagreen]
> to
associated[vbcol=seagreen]
:-)[vbcol=seagreen]
> will
ISP
>

3rd party performance tuning monitor/software?

Hi all, My boss has asked me to research and recommend a product that our developers (not database developers, but front-end developers that *cringe* get into the database to make the occasional stored procedure) can use to determine the relative efficiency of thier code and/or the database structure and keys.

We currently have a few licensed versions of Quest's Coefficient software, which I think is very usable for such things (I do on a regular basis), but he doesn't think that is "friendly" enough for a GUI developer that is not a database expert.

Any thought and/or suggestions for a 3rd party software package that y'all have used or are using that might fit the bill? I don't mind doing the footwork and research, just thought I would "seek the advice of my peers" to get started.

Yeah, I know the design should drive the database, but we are in various stages of "getting there", so any help in the interim is a good thing.

Thanks for the thoughts and waste of brain cells on my behalf.I'm still not understanding exactly what you want to analyze. Are you trying to get at the design of the database, the implementation, the performance of specific queries... There are too many moving parts for me to figure out how to start to answer your question.

-PatP|||Pat, this request is coming from a manager. :rolleyes: The target, therefore, is a moving one. Assuming (big leap here) that the basic design of the database is sound, then what I am looking for is something that will suggest where an index would be valuable, Probably by examining specific queries, or tables, or views.

Probably Enterprise Manager has such tools, such as SQL Profiler, and I will also look into that, but someone has gotten my manager's ear, I think, about getting a tool that makes the detection of problem access methods/code apparent.

The basic trouble is that the developers are NOT SQL Server experts, as I am the closest to that in the group (yep, scary, eh?) and there is only so many of me.

The ultimate solution is to educate the masses, but that ain't gonna happen soon, so I am just looking for a tool or suggestions (or both) regarding some ways to keep 'em out of too much trouble in the meantime.|||I have been beating the drum of sql quality control around my shop since I got here.

The only effective method of improving the sql going into the application that I have found is education and mentoring. A developer will come to me and say "sql server sucks, why is my code so slow. QA says the page performs like crap". I will make them sit there while I go over their sql, execution plan and table design and indexes and I will explain stuff to them. Then I will offer to lend them a book on writing sql.

In my 16 months here I think I have helped the quality of the overall output of 3 or 4 of the developers.

3rd Party Performance Tool/Software

Is there any software that can analyze stored procedure performance and
recommend solutions?
Thanks,
Dave
How about the database engine tuning advisor, which ships with the product?
You can send it a workload consisting of a single stored procedure call, but
for a better analysis and set of recommended enhancements, you're better off
providing a workload of a typical business day.
Note that this tool will recommend structural changes like adding/removing
indexes, partitioning, etc. It will not look at your SELECT query with 18
unions and suggest a single FROM with a CASE expression. :-)
A
"David" <nospam@.home.com> wrote in message
news:216B98B9-8D9B-4143-A12C-810B24CD2723@.microsoft.com...
> Is there any software that can analyze stored procedure performance and
> recommend solutions?
> Thanks,
> Dave
|||As far as I am aware, there is no tool that would take a stored procedure,
optimize and refactor it, and recommend alternative solutions.
The only 'tool' that can do that is a skilled DBA!!
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"David" <nospam@.home.com> wrote in message
news:216B98B9-8D9B-4143-A12C-810B24CD2723@.microsoft.com...
> Is there any software that can analyze stored procedure performance and
> recommend solutions?
> Thanks,
> Dave
|||InDepth for SQL Server has such a feature which it implements by levaraging
either ITW or DTA depending on SQL version. It uses performance data stored
in its Performance Warehouse to feed the recommendations. It also clearly
identifies the statements and batches that are consuming most resource to
help guide your tuning efforts. To be honest we mostly use it for the latter
as it's extremely light weight and much less resource intensive than a trace
plus we don't want ITW/DTA run against a production database. However by
identifying the main resource consumers these can be tuned and measured in
the QA envionment to produce recommendations for production.
http://www.symantec.com/enterprise/products/overview.jsp?pcid=1021&pvid=317_1
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"David" <nospam@.home.com> wrote in message
news:216B98B9-8D9B-4143-A12C-810B24CD2723@.microsoft.com...
> Is there any software that can analyze stored procedure performance and
> recommend solutions?
> Thanks,
> Dave

3rd party Data Administration Tools

I'm looking for a 3rd party tool to manage
disabling/enabling triggers. I evaluated Teratraw
Database Manager and it easily allows disabling/enabling
triggers via the gui but only 1 trigger at a time. I need
a tool that can disable/enable ALL triggers in a database
easily. (Similar to TOAD for Oracle).
Anyone know of such a management tool?
Thanks Rich
SQLExecMS from www.laplas-soft.com will help you
"Rich" <rstoll@.cadencenet.com> wrote in message
news:1c5701c5317f$dc1023a0$a601280a@.phx.gbl...
> I'm looking for a 3rd party tool to manage
> disabling/enabling triggers. I evaluated Teratraw
> Database Manager and it easily allows disabling/enabling
> triggers via the gui but only 1 trigger at a time. I need
> a tool that can disable/enable ALL triggers in a database
> easily. (Similar to TOAD for Oracle).
> Anyone know of such a management tool?
> Thanks Rich
|||Would a stored procedure work for you?
"Rich" wrote:

> I'm looking for a 3rd party tool to manage
> disabling/enabling triggers. I evaluated Teratraw
> Database Manager and it easily allows disabling/enabling
> triggers via the gui but only 1 trigger at a time. I need
> a tool that can disable/enable ALL triggers in a database
> easily. (Similar to TOAD for Oracle).
> Anyone know of such a management tool?
> Thanks Rich
>
|||
> I'm looking for a 3rd party tool to manage
> disabling/enabling triggers. I evaluated Teratraw
> Database Manager and it easily allows disabling/enabling
> triggers via the gui but only 1 trigger at a time. I need
> a tool that can disable/enable ALL triggers in a database
> easily. (Similar to TOAD for Oracle).
> Anyone know of such a management tool?
Database Workbench - www.upscene.com
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com
|||Hello Rich,
TOAD for SQL Server is currently in freeware (http://www.toadsoft.com/toadsqlserve..._sqlserver.htm), but a -much- more feature-laden version will go into beta in June. Take a look at the current version and stay on the lookout for the beta announceme
nt for the big summer release.
Hope this helps,
-Kev
~~~
-Kevin Kline
Quest Software (www.quest.com)
SQL Server MVP
I support PASS, the Professional Association for SQL Server. (www.sqlpass.org)

> I'm looking for a 3rd party tool to manage disabling/enabling
> triggers. I evaluated Teratraw Database Manager and it easily allows
> disabling/enabling triggers via the gui but only 1 trigger at a time.
> I need a tool that can disable/enable ALL triggers in a database
> easily. (Similar to TOAD for Oracle).
> Anyone know of such a management tool?
> Thanks Rich
>

3rd party components/API support in SISS

Greetings,

I was just getting through the features of SSIS, i wanted to confirm a few things

can i make my own dll in .net (version 2.0 or earlier) and use them im SISS via Execute Script? thers is one thing i saw on msn that i can make my ssis packages reusable by adding them on mt tool box and drag drop use them on other ssis packages. correct? can i use any other 3rd party components like APIs, or some other ETL tool's package in SISS ?

regards,

adnan shamim

1. Yes, you can use the Script task or component to reference external .NET assemblies.

2. You can't add a package to your toolbar. You can call packages from other packages. And you can create custom tasks and components to reuse across multiple packages.

3. You can call outside APIs from the script task or component. You can also use Execute Process to run external executables.

|||Thank you very much for the timely response welch! . i really appreciate it.

3rd party backup/restore

I'm looking for recommendations for 3rd party backup/restore software for
SQL Server 2000.
The software must be cluster aware. Ease and speed of recoverability are
most important. I am not so concerned with compression ratio but rather the
ease of which junior staff could restore databases at crunch time. Point in
time restore is essential.
thanks to any one who could offer an opinion.
A follow-up if I may. Do any of these products allow you to recovers users
at the server level when a restoring a database to a different server. It's
a hassle scripting and transferring logins.
"Terri" <terri@.cybernets.com> wrote in message
news:f1vj1k$teb$1@.reader2.nmix.net...
> I'm looking for recommendations for 3rd party backup/restore software for
> SQL Server 2000.
> The software must be cluster aware. Ease and speed of recoverability are
> most important. I am not so concerned with compression ratio but rather
the
> ease of which junior staff could restore databases at crunch time. Point
in
> time restore is essential.
> thanks to any one who could offer an opinion.
>
|||"Terri" <terri@.cybernets.com> wrote in message
news:f1vj1k$teb$1@.reader2.nmix.net...
> I'm looking for recommendations for 3rd party backup/restore software for
> SQL Server 2000.
>
Any particular reason you can't use the built in backup tools for SQL Server
2000?
In any case, I'd recommend Litespeed for SQL Server.

> The software must be cluster aware. Ease and speed of recoverability are
> most important. I am not so concerned with compression ratio but rather
> the
> ease of which junior staff could restore databases at crunch time. Point
> in
> time restore is essential.
> thanks to any one who could offer an opinion.
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
|||I am very happy with the price, the speed, and the ease of restores and
backups using RED GATE. Instead of bak sizes of 80+ gig, they are about 10
gig. Its a great piece of software.
Regards,
Jamie
"Terri" wrote:

> A follow-up if I may. Do any of these products allow you to recovers users
> at the server level when a restoring a database to a different server. It's
> a hassle scripting and transferring logins.
>
> "Terri" <terri@.cybernets.com> wrote in message
> news:f1vj1k$teb$1@.reader2.nmix.net...
> the
> in
>
>
|||"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:OURUS2ykHHA.3484@.TK2MSFTNGP02.phx.gbl...[vbcol=seagreen]
>
> "Terri" <terri@.cybernets.com> wrote in message
> news:f1vj1k$teb$1@.reader2.nmix.net...
for
> Any particular reason you can't use the built in backup tools for SQL
Server
> 2000?
I'm hoping it would be easier for an administrator to make a timely restore.
The performance boost can't hurt.

> In any case, I'd recommend Litespeed for SQL Server.
Thanks for your response, I'll take a look.
|||"Terri" <terri@.cybernets.com> wrote in message
news:f2070q$2i9$1@.reader2.nmix.net...
> "Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in
> message
> news:OURUS2ykHHA.3484@.TK2MSFTNGP02.phx.gbl...
> for
> Server
> I'm hoping it would be easier for an administrator to make a timely
> restore.
> The performance boost can't hurt.
Easier?
Can't say I ever found
RESTORE DATABASE FOO from file="backup.bak" with NORECOVERY
all that complex :-)
But.. the performance boost is definitely a plus.

>
> Thanks for your response, I'll take a look.
>
|||Are Red Gate and Lightspeed cluster aware? Also, can those products restore
to a server on which the product does not reside?
Terri, if you REALLY want ease/speed of recoverability, get familiar with
the backupset system table and create a restore database script that takes a
parameter of @.DBName and creates all necessary RESTORE statements to
completely recover a database. Holy-Shit time is NOT the time to be
futzing with an interface you aren't familiar with. I used such a mechanism
(albeit a BIT more complex and hand-crafted at crunch time) earlier this
year to restore 719 databases having 6 backup files each to two different
servers in about 4 hours total time. :-O
TheSQLGuru
President
Indicium Resources, Inc.
"Terri" <terri@.cybernets.com> wrote in message
news:f1vj1k$teb$1@.reader2.nmix.net...
> I'm looking for recommendations for 3rd party backup/restore software for
> SQL Server 2000.
> The software must be cluster aware. Ease and speed of recoverability are
> most important. I am not so concerned with compression ratio but rather
> the
> ease of which junior staff could restore databases at crunch time. Point
> in
> time restore is essential.
> thanks to any one who could offer an opinion.
>

3rd party backup/restore

I'm looking for recommendations for 3rd party backup/restore software for
SQL Server 2000.
The software must be cluster aware. Ease and speed of recoverability are
most important. I am not so concerned with compression ratio but rather the
ease of which junior staff could restore databases at crunch time. Point in
time restore is essential.
thanks to any one who could offer an opinion.A follow-up if I may. Do any of these products allow you to recovers users
at the server level when a restoring a database to a different server. It's
a hassle scripting and transferring logins.
"Terri" <terri@.cybernets.com> wrote in message
news:f1vj1k$teb$1@.reader2.nmix.net...
> I'm looking for recommendations for 3rd party backup/restore software for
> SQL Server 2000.
> The software must be cluster aware. Ease and speed of recoverability are
> most important. I am not so concerned with compression ratio but rather
the
> ease of which junior staff could restore databases at crunch time. Point
in
> time restore is essential.
> thanks to any one who could offer an opinion.
>|||"Terri" <terri@.cybernets.com> wrote in message
news:f1vj1k$teb$1@.reader2.nmix.net...
> I'm looking for recommendations for 3rd party backup/restore software for
> SQL Server 2000.
>
Any particular reason you can't use the built in backup tools for SQL Server
2000?
In any case, I'd recommend Litespeed for SQL Server.

> The software must be cluster aware. Ease and speed of recoverability are
> most important. I am not so concerned with compression ratio but rather
> the
> ease of which junior staff could restore databases at crunch time. Point
> in
> time restore is essential.
> thanks to any one who could offer an opinion.
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||I am very happy with the price, the speed, and the ease of restores and
backups using RED GATE. Instead of bak sizes of 80+ gig, they are about 10
gig. Its a great piece of software.
--
Regards,
Jamie
"Terri" wrote:

> A follow-up if I may. Do any of these products allow you to recovers users
> at the server level when a restoring a database to a different server. It'
s
> a hassle scripting and transferring logins.
>
> "Terri" <terri@.cybernets.com> wrote in message
> news:f1vj1k$teb$1@.reader2.nmix.net...
> the
> in
>
>|||"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:OURUS2ykHHA.3484@.TK2MSFTNGP02.phx.gbl...
>
> "Terri" <terri@.cybernets.com> wrote in message
> news:f1vj1k$teb$1@.reader2.nmix.net...
for[vbcol=seagreen]
> Any particular reason you can't use the built in backup tools for SQL
Server
> 2000?
I'm hoping it would be easier for an administrator to make a timely restore.
The performance boost can't hurt.

> In any case, I'd recommend Litespeed for SQL Server.
Thanks for your response, I'll take a look.|||"Terri" <terri@.cybernets.com> wrote in message
news:f2070q$2i9$1@.reader2.nmix.net...
> "Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in
> message
> news:OURUS2ykHHA.3484@.TK2MSFTNGP02.phx.gbl...
> for
> Server
> I'm hoping it would be easier for an administrator to make a timely
> restore.
> The performance boost can't hurt.
Easier?
Can't say I ever found
RESTORE DATABASE FOO from file="backup.bak" with NORECOVERY
all that complex :-)
But.. the performance boost is definitely a plus.

>
> Thanks for your response, I'll take a look.
>|||Are Red Gate and Lightspeed cluster aware? Also, can those products restore
to a server on which the product does not reside?
Terri, if you REALLY want ease/speed of recoverability, get familiar with
the backupset system table and create a restore database script that takes a
parameter of @.DBName and creates all necessary RESTORE statements to
completely recover a database. Holy-Shit time is NOT the time to be
futzing with an interface you aren't familiar with. I used such a mechanism
(albeit a BIT more complex and hand-crafted at crunch time) earlier this
year to restore 719 databases having 6 backup files each to two different
servers in about 4 hours total time. :-O
TheSQLGuru
President
Indicium Resources, Inc.
"Terri" <terri@.cybernets.com> wrote in message
news:f1vj1k$teb$1@.reader2.nmix.net...
> I'm looking for recommendations for 3rd party backup/restore software for
> SQL Server 2000.
> The software must be cluster aware. Ease and speed of recoverability are
> most important. I am not so concerned with compression ratio but rather
> the
> ease of which junior staff could restore databases at crunch time. Point
> in
> time restore is essential.
> thanks to any one who could offer an opinion.
>

3rd party backup/restore

I'm looking for recommendations for 3rd party backup/restore software for
SQL Server 2000.
The software must be cluster aware. Ease and speed of recoverability are
most important. I am not so concerned with compression ratio but rather the
ease of which junior staff could restore databases at crunch time. Point in
time restore is essential.
thanks to any one who could offer an opinion.A follow-up if I may. Do any of these products allow you to recovers users
at the server level when a restoring a database to a different server. It's
a hassle scripting and transferring logins.
"Terri" <terri@.cybernets.com> wrote in message
news:f1vj1k$teb$1@.reader2.nmix.net...
> I'm looking for recommendations for 3rd party backup/restore software for
> SQL Server 2000.
> The software must be cluster aware. Ease and speed of recoverability are
> most important. I am not so concerned with compression ratio but rather
the
> ease of which junior staff could restore databases at crunch time. Point
in
> time restore is essential.
> thanks to any one who could offer an opinion.
>|||"Terri" <terri@.cybernets.com> wrote in message
news:f1vj1k$teb$1@.reader2.nmix.net...
> I'm looking for recommendations for 3rd party backup/restore software for
> SQL Server 2000.
>
Any particular reason you can't use the built in backup tools for SQL Server
2000?
In any case, I'd recommend Litespeed for SQL Server.
> The software must be cluster aware. Ease and speed of recoverability are
> most important. I am not so concerned with compression ratio but rather
> the
> ease of which junior staff could restore databases at crunch time. Point
> in
> time restore is essential.
> thanks to any one who could offer an opinion.
>
--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||I am very happy with the price, the speed, and the ease of restores and
backups using RED GATE. Instead of bak sizes of 80+ gig, they are about 10
gig. Its a great piece of software.
--
Regards,
Jamie
"Terri" wrote:
> A follow-up if I may. Do any of these products allow you to recovers users
> at the server level when a restoring a database to a different server. It's
> a hassle scripting and transferring logins.
>
> "Terri" <terri@.cybernets.com> wrote in message
> news:f1vj1k$teb$1@.reader2.nmix.net...
> > I'm looking for recommendations for 3rd party backup/restore software for
> > SQL Server 2000.
> >
> > The software must be cluster aware. Ease and speed of recoverability are
> > most important. I am not so concerned with compression ratio but rather
> the
> > ease of which junior staff could restore databases at crunch time. Point
> in
> > time restore is essential.
> >
> > thanks to any one who could offer an opinion.
> >
> >
>
>|||"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:OURUS2ykHHA.3484@.TK2MSFTNGP02.phx.gbl...
>
> "Terri" <terri@.cybernets.com> wrote in message
> news:f1vj1k$teb$1@.reader2.nmix.net...
> > I'm looking for recommendations for 3rd party backup/restore software
for
> > SQL Server 2000.
> >
> Any particular reason you can't use the built in backup tools for SQL
Server
> 2000?
I'm hoping it would be easier for an administrator to make a timely restore.
The performance boost can't hurt.
> In any case, I'd recommend Litespeed for SQL Server.
Thanks for your response, I'll take a look.|||"Terri" <terri@.cybernets.com> wrote in message
news:f2070q$2i9$1@.reader2.nmix.net...
> "Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in
> message
> news:OURUS2ykHHA.3484@.TK2MSFTNGP02.phx.gbl...
>>
>> "Terri" <terri@.cybernets.com> wrote in message
>> news:f1vj1k$teb$1@.reader2.nmix.net...
>> > I'm looking for recommendations for 3rd party backup/restore software
> for
>> > SQL Server 2000.
>> >
>> Any particular reason you can't use the built in backup tools for SQL
> Server
>> 2000?
> I'm hoping it would be easier for an administrator to make a timely
> restore.
> The performance boost can't hurt.
Easier?
Can't say I ever found
RESTORE DATABASE FOO from file="backup.bak" with NORECOVERY
all that complex :-)
But.. the performance boost is definitely a plus.
>> In any case, I'd recommend Litespeed for SQL Server.
> Thanks for your response, I'll take a look.
>|||Are Red Gate and Lightspeed cluster aware? Also, can those products restore
to a server on which the product does not reside?
Terri, if you REALLY want ease/speed of recoverability, get familiar with
the backupset system table and create a restore database script that takes a
parameter of @.DBName and creates all necessary RESTORE statements to
completely recover a database. Holy-Shit time is NOT the time to be
futzing with an interface you aren't familiar with. I used such a mechanism
(albeit a BIT more complex and hand-crafted at crunch time) earlier this
year to restore 719 databases having 6 backup files each to two different
servers in about 4 hours total time. :-O
--
TheSQLGuru
President
Indicium Resources, Inc.
"Terri" <terri@.cybernets.com> wrote in message
news:f1vj1k$teb$1@.reader2.nmix.net...
> I'm looking for recommendations for 3rd party backup/restore software for
> SQL Server 2000.
> The software must be cluster aware. Ease and speed of recoverability are
> most important. I am not so concerned with compression ratio but rather
> the
> ease of which junior staff could restore databases at crunch time. Point
> in
> time restore is essential.
> thanks to any one who could offer an opinion.
>

3rd party Backup Software and MSSQL 2000

Can SQL 2000 initiate backups to 3rd party applications (like LiteSpeed
and BrightStor's SQL Backup Agent)? My goal is to be able to manage
backup and restores completely through SQL Enterprise Manager and Query
Analyzer without having to logon to the Server and using the 3rd party
backup application's software. Is this possible through SQL?

Thank you,
Stephanie"Stephanie" <stuttle@.centene.com> wrote in message
news:1125609584.963975.200390@.g44g2000cwa.googlegr oups.com...
> Can SQL 2000 initiate backups to 3rd party applications (like LiteSpeed
> and BrightStor's SQL Backup Agent)? My goal is to be able to manage
> backup and restores completely through SQL Enterprise Manager and Query
> Analyzer without having to logon to the Server and using the 3rd party
> backup application's software. Is this possible through SQL?

Yes.

> Thank you,
> Stephanie

3rd party app supported on 32-bit sql, but not 64-bit?

Hi,

We have a 3rd party application which supports its DB running on SQL 2005.

Its a standard client/server windows application - very good, stable app.

They have told us that they only support it when it is running on 32-bit version of SQL 2005. Not 64-bit.

Is that common? Is that sensible?

Are there any differences on the DB Engine between 32-bit and 64-bit which would force them into that position?

Thanks,

Daniel.

There is no external difference between a 64bit and a 32bit SQL server. Unless they are installing something, like the app, on the server itself just tell them it is 32bit.

|||Actually unless their code is compiled with the AnyCPU build option you could run into issues related to installing a 32bits application in a 64bits box. In Win2003 server you have to run the code in WOW64 which is running it in 32bits mode but that will not resolve issues that require the AnyCPU build option. The main issue is that the application layer may not run without needed modifications. I am a beta 1 volunteer of the SQL Server 64bits project. Post again if you still have questions.