I need to install SQLServer 6.5 Enterprise Edition but need to know hat it's
software requirements are.
Can I install it on Windows 2000 Standard Edition or do I need Windows 2000
Advanced server ?
Any guidance on this would be greatly appreciated.
Regards,
Peter Apostolakopoulos
Hi,
SQL 6.5 Ent edition must be installed on NT 4 enterprise edition or Windows
2000 Advance Server
Thanks
Hari
MCDBA
"Peter Apostolakopoulos" wrote:
> I need to install SQLServer 6.5 Enterprise Edition but need to know hat it's
> software requirements are.
> Can I install it on Windows 2000 Standard Edition or do I need Windows 2000
> Advanced server ?
> Any guidance on this would be greatly appreciated.
> Regards,
> Peter Apostolakopoulos
>
|||Hari,
Many thanks for this. It answers the question perfectly.
Peter A.
"Hari Prasad" wrote:
[vbcol=seagreen]
> Hi,
> SQL 6.5 Ent edition must be installed on NT 4 enterprise edition or Windows
> 2000 Advance Server
> Thanks
> Hari
> MCDBA
>
> "Peter Apostolakopoulos" wrote:
Showing posts with label software. Show all posts
Showing posts with label software. Show all posts
Sunday, February 19, 2012
6.5 Enterprise Edition software requirements
I need to install SQLServer 6.5 Enterprise Edition but need to know hat it's
software requirements are.
Can I install it on Windows 2000 Standard Edition or do I need Windows 2000
Advanced server ?
Any guidance on this would be greatly appreciated.
Regards,
Peter ApostolakopoulosHi,
SQL 6.5 Ent edition must be installed on NT 4 enterprise edition or Windows
2000 Advance Server
Thanks
Hari
MCDBA
"Peter Apostolakopoulos" wrote:
> I need to install SQLServer 6.5 Enterprise Edition but need to know hat it's
> software requirements are.
> Can I install it on Windows 2000 Standard Edition or do I need Windows 2000
> Advanced server ?
> Any guidance on this would be greatly appreciated.
> Regards,
> Peter Apostolakopoulos
>|||Well for starters it helps if you can play basketball,
and also if you can keep your cool and not explode!!!
>--Original Message--
>I need to install SQLServer 6.5 Enterprise Edition but
need to know hat it's
>software requirements are.
>Can I install it on Windows 2000 Standard Edition or do
I need Windows 2000
>Advanced server ?
>Any guidance on this would be greatly appreciated.
>Regards,
>Peter Apostolakopoulos
>.
>|||Hari,
Many thanks for this. It answers the question perfectly.
Peter A.
"Hari Prasad" wrote:
> Hi,
> SQL 6.5 Ent edition must be installed on NT 4 enterprise edition or Windows
> 2000 Advance Server
> Thanks
> Hari
> MCDBA
>
> "Peter Apostolakopoulos" wrote:
> > I need to install SQLServer 6.5 Enterprise Edition but need to know hat it's
> > software requirements are.
> >
> > Can I install it on Windows 2000 Standard Edition or do I need Windows 2000
> > Advanced server ?
> >
> > Any guidance on this would be greatly appreciated.
> >
> > Regards,
> >
> > Peter Apostolakopoulos
> >
software requirements are.
Can I install it on Windows 2000 Standard Edition or do I need Windows 2000
Advanced server ?
Any guidance on this would be greatly appreciated.
Regards,
Peter ApostolakopoulosHi,
SQL 6.5 Ent edition must be installed on NT 4 enterprise edition or Windows
2000 Advance Server
Thanks
Hari
MCDBA
"Peter Apostolakopoulos" wrote:
> I need to install SQLServer 6.5 Enterprise Edition but need to know hat it's
> software requirements are.
> Can I install it on Windows 2000 Standard Edition or do I need Windows 2000
> Advanced server ?
> Any guidance on this would be greatly appreciated.
> Regards,
> Peter Apostolakopoulos
>|||Well for starters it helps if you can play basketball,
and also if you can keep your cool and not explode!!!
>--Original Message--
>I need to install SQLServer 6.5 Enterprise Edition but
need to know hat it's
>software requirements are.
>Can I install it on Windows 2000 Standard Edition or do
I need Windows 2000
>Advanced server ?
>Any guidance on this would be greatly appreciated.
>Regards,
>Peter Apostolakopoulos
>.
>|||Hari,
Many thanks for this. It answers the question perfectly.
Peter A.
"Hari Prasad" wrote:
> Hi,
> SQL 6.5 Ent edition must be installed on NT 4 enterprise edition or Windows
> 2000 Advance Server
> Thanks
> Hari
> MCDBA
>
> "Peter Apostolakopoulos" wrote:
> > I need to install SQLServer 6.5 Enterprise Edition but need to know hat it's
> > software requirements are.
> >
> > Can I install it on Windows 2000 Standard Edition or do I need Windows 2000
> > Advanced server ?
> >
> > Any guidance on this would be greatly appreciated.
> >
> > Regards,
> >
> > Peter Apostolakopoulos
> >
Thursday, February 9, 2012
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 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.
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
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 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.
>
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.
>
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.
>
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?
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
Subscribe to:
Posts (Atom)