Hi,
I have two sql server enterprise servers running sp4 on windows server2003
sp1
I have a DTS package that does some various processing on one machine, then
at the end of the package. I copy tables to the other sql server box.
In one of the tables being copied, I have a bigint data type. The table
copies and shows that the bigint datatype is still part of the table
definition, but the values in the bigint column are negatives and positives.
Does anyone have any ideas as to what might be causing this?
thanks in advance,
Troy
Values in a bigint column can be negative as well as positive, but I assume
that you have only positive values on one side and end up with negative and
positive values on the other? If that's the case it looks to me like your
bigints are accidentally treated as ints somewhere along the way, at a
binary level.
Jacco Schalkwijk
SQL Server MVP
"Troy Sherrill" <tsherrill@.nc.rr.com> wrote in message
news:ekzUk8kfFHA.460@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I have two sql server enterprise servers running sp4 on windows server2003
> sp1
> I have a DTS package that does some various processing on one machine,
> then
> at the end of the package. I copy tables to the other sql server box.
> In one of the tables being copied, I have a bigint data type. The table
> copies and shows that the bigint datatype is still part of the table
> definition, but the values in the bigint column are negatives and
> positives.
> Does anyone have any ideas as to what might be causing this?
> thanks in advance,
> Troy
>
|||What provider are you using? It may not understand a BigInt datatype.
Andrew J. Kelly SQL MVP
"Troy Sherrill" <tsherrill@.nc.rr.com> wrote in message
news:ekzUk8kfFHA.460@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I have two sql server enterprise servers running sp4 on windows server2003
> sp1
> I have a DTS package that does some various processing on one machine,
> then
> at the end of the package. I copy tables to the other sql server box.
> In one of the tables being copied, I have a bigint data type. The table
> copies and shows that the bigint datatype is still part of the table
> definition, but the values in the bigint column are negatives and
> positives.
> Does anyone have any ideas as to what might be causing this?
> thanks in advance,
> Troy
>
Showing posts with label enterprise. Show all posts
Showing posts with label enterprise. Show all posts
Thursday, March 22, 2012
bigint problem
Hi,
I have two sql server enterprise servers running sp4 on windows server2003
sp1
I have a DTS package that does some various processing on one machine, then
at the end of the package. I copy tables to the other sql server box.
In one of the tables being copied, I have a bigint data type. The table
copies and shows that the bigint datatype is still part of the table
definition, but the values in the bigint column are negatives and positives.
Does anyone have any ideas as to what might be causing this?
thanks in advance,
TroyValues in a bigint column can be negative as well as positive, but I assume
that you have only positive values on one side and end up with negative and
positive values on the other? If that's the case it looks to me like your
bigints are accidentally treated as ints somewhere along the way, at a
binary level.
--
Jacco Schalkwijk
SQL Server MVP
"Troy Sherrill" <tsherrill@.nc.rr.com> wrote in message
news:ekzUk8kfFHA.460@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I have two sql server enterprise servers running sp4 on windows server2003
> sp1
> I have a DTS package that does some various processing on one machine,
> then
> at the end of the package. I copy tables to the other sql server box.
> In one of the tables being copied, I have a bigint data type. The table
> copies and shows that the bigint datatype is still part of the table
> definition, but the values in the bigint column are negatives and
> positives.
> Does anyone have any ideas as to what might be causing this?
> thanks in advance,
> Troy
>|||What provider are you using? It may not understand a BigInt datatype.
--
Andrew J. Kelly SQL MVP
"Troy Sherrill" <tsherrill@.nc.rr.com> wrote in message
news:ekzUk8kfFHA.460@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I have two sql server enterprise servers running sp4 on windows server2003
> sp1
> I have a DTS package that does some various processing on one machine,
> then
> at the end of the package. I copy tables to the other sql server box.
> In one of the tables being copied, I have a bigint data type. The table
> copies and shows that the bigint datatype is still part of the table
> definition, but the values in the bigint column are negatives and
> positives.
> Does anyone have any ideas as to what might be causing this?
> thanks in advance,
> Troy
>sql
I have two sql server enterprise servers running sp4 on windows server2003
sp1
I have a DTS package that does some various processing on one machine, then
at the end of the package. I copy tables to the other sql server box.
In one of the tables being copied, I have a bigint data type. The table
copies and shows that the bigint datatype is still part of the table
definition, but the values in the bigint column are negatives and positives.
Does anyone have any ideas as to what might be causing this?
thanks in advance,
TroyValues in a bigint column can be negative as well as positive, but I assume
that you have only positive values on one side and end up with negative and
positive values on the other? If that's the case it looks to me like your
bigints are accidentally treated as ints somewhere along the way, at a
binary level.
--
Jacco Schalkwijk
SQL Server MVP
"Troy Sherrill" <tsherrill@.nc.rr.com> wrote in message
news:ekzUk8kfFHA.460@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I have two sql server enterprise servers running sp4 on windows server2003
> sp1
> I have a DTS package that does some various processing on one machine,
> then
> at the end of the package. I copy tables to the other sql server box.
> In one of the tables being copied, I have a bigint data type. The table
> copies and shows that the bigint datatype is still part of the table
> definition, but the values in the bigint column are negatives and
> positives.
> Does anyone have any ideas as to what might be causing this?
> thanks in advance,
> Troy
>|||What provider are you using? It may not understand a BigInt datatype.
--
Andrew J. Kelly SQL MVP
"Troy Sherrill" <tsherrill@.nc.rr.com> wrote in message
news:ekzUk8kfFHA.460@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I have two sql server enterprise servers running sp4 on windows server2003
> sp1
> I have a DTS package that does some various processing on one machine,
> then
> at the end of the package. I copy tables to the other sql server box.
> In one of the tables being copied, I have a bigint data type. The table
> copies and shows that the bigint datatype is still part of the table
> definition, but the values in the bigint column are negatives and
> positives.
> Does anyone have any ideas as to what might be causing this?
> thanks in advance,
> Troy
>sql
bigint problem
Hi,
I have two sql server enterprise servers running sp4 on windows server2003
sp1
I have a DTS package that does some various processing on one machine, then
at the end of the package. I copy tables to the other sql server box.
In one of the tables being copied, I have a bigint data type. The table
copies and shows that the bigint datatype is still part of the table
definition, but the values in the bigint column are negatives and positives.
Does anyone have any ideas as to what might be causing this?
thanks in advance,
TroyValues in a bigint column can be negative as well as positive, but I assume
that you have only positive values on one side and end up with negative and
positive values on the other? If that's the case it looks to me like your
bigints are accidentally treated as ints somewhere along the way, at a
binary level.
Jacco Schalkwijk
SQL Server MVP
"Troy Sherrill" <tsherrill@.nc.rr.com> wrote in message
news:ekzUk8kfFHA.460@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I have two sql server enterprise servers running sp4 on windows server2003
> sp1
> I have a DTS package that does some various processing on one machine,
> then
> at the end of the package. I copy tables to the other sql server box.
> In one of the tables being copied, I have a bigint data type. The table
> copies and shows that the bigint datatype is still part of the table
> definition, but the values in the bigint column are negatives and
> positives.
> Does anyone have any ideas as to what might be causing this?
> thanks in advance,
> Troy
>|||What provider are you using? It may not understand a BigInt datatype.
Andrew J. Kelly SQL MVP
"Troy Sherrill" <tsherrill@.nc.rr.com> wrote in message
news:ekzUk8kfFHA.460@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I have two sql server enterprise servers running sp4 on windows server2003
> sp1
> I have a DTS package that does some various processing on one machine,
> then
> at the end of the package. I copy tables to the other sql server box.
> In one of the tables being copied, I have a bigint data type. The table
> copies and shows that the bigint datatype is still part of the table
> definition, but the values in the bigint column are negatives and
> positives.
> Does anyone have any ideas as to what might be causing this?
> thanks in advance,
> Troy
>
I have two sql server enterprise servers running sp4 on windows server2003
sp1
I have a DTS package that does some various processing on one machine, then
at the end of the package. I copy tables to the other sql server box.
In one of the tables being copied, I have a bigint data type. The table
copies and shows that the bigint datatype is still part of the table
definition, but the values in the bigint column are negatives and positives.
Does anyone have any ideas as to what might be causing this?
thanks in advance,
TroyValues in a bigint column can be negative as well as positive, but I assume
that you have only positive values on one side and end up with negative and
positive values on the other? If that's the case it looks to me like your
bigints are accidentally treated as ints somewhere along the way, at a
binary level.
Jacco Schalkwijk
SQL Server MVP
"Troy Sherrill" <tsherrill@.nc.rr.com> wrote in message
news:ekzUk8kfFHA.460@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I have two sql server enterprise servers running sp4 on windows server2003
> sp1
> I have a DTS package that does some various processing on one machine,
> then
> at the end of the package. I copy tables to the other sql server box.
> In one of the tables being copied, I have a bigint data type. The table
> copies and shows that the bigint datatype is still part of the table
> definition, but the values in the bigint column are negatives and
> positives.
> Does anyone have any ideas as to what might be causing this?
> thanks in advance,
> Troy
>|||What provider are you using? It may not understand a BigInt datatype.
Andrew J. Kelly SQL MVP
"Troy Sherrill" <tsherrill@.nc.rr.com> wrote in message
news:ekzUk8kfFHA.460@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I have two sql server enterprise servers running sp4 on windows server2003
> sp1
> I have a DTS package that does some various processing on one machine,
> then
> at the end of the package. I copy tables to the other sql server box.
> In one of the tables being copied, I have a bigint data type. The table
> copies and shows that the bigint datatype is still part of the table
> definition, but the values in the bigint column are negatives and
> positives.
> Does anyone have any ideas as to what might be causing this?
> thanks in advance,
> Troy
>
Monday, March 19, 2012
Big Data size and SQL Server
Does SQL Server 2005 Enterprise 64bit can handle 250 - 300 terabyte of data considering my DBA is guru.
Thank you - Ashok
Your question is not cleare, can you refrase it?
If you are looking for biggest db the sql serve can handle? see the link below...
http://www.microsoft.com/sql/prodinfo/compare/wintercorp.mspx
|||My question is we are planning for a new project which will merge several databases with other things. we think new data size can go up to 250 terabyte. There will be hardware for that size of data and I think this is big size for any database like Oracle, Sybase or SQL Server. We are looking close to SQL Server 2005 and SSIS to use but same time we are trying to find if software has some any limitation to handle this type of size once it is setup in different partitions and etc.
Thank you - Ashok
Sunday, March 11, 2012
BI Web Intelligence
I am currently looking for a reporting solution for my company. I am tore
between RS and Crystal. We are primarily a MS shop with enterprise
licensing.
Business Objects (BO) has presented me with a really nice set of tools aside
from their reporting solution. Aside from reporting I would like to get
more involved with BI (dataming and cube analysis). At some point I would
like to have the end users browse the cube/universe data for quick adhoc
analysis.
BO presented me with really nice web intelligence software which is all
integrated with the BO product line. The products were: BO Web
Intelligence, BO Predictive Analysis, BO Set Analysis. These products seem
easy to use and the data can all be analyzed through the web once the
developer creates the middle layer.
I know MS has SSAS which contains the cube technology and data mining.
Do they offer a packaged product ready for enduser use similiar to BO?
Do you need to program your needs in the BI environment to develop what your
looking for?
Is there a way to get the SSAS cubes designed for end users to access
through the web/intranet?
Thanks.Basically you need to see what exactly you require. Both offer same things
but MS is cost effective solution and one stop solution. You also get
everything packged and moreover the SSRS comes free with Enterprise version
of SQL SERVER. So if you are planning for a small / mid size then this will
be ideal for you.
Amarnath
"Brian Shannon" wrote:
> I am currently looking for a reporting solution for my company. I am tore
> between RS and Crystal. We are primarily a MS shop with enterprise
> licensing.
> Business Objects (BO) has presented me with a really nice set of tools aside
> from their reporting solution. Aside from reporting I would like to get
> more involved with BI (dataming and cube analysis). At some point I would
> like to have the end users browse the cube/universe data for quick adhoc
> analysis.
> BO presented me with really nice web intelligence software which is all
> integrated with the BO product line. The products were: BO Web
> Intelligence, BO Predictive Analysis, BO Set Analysis. These products seem
> easy to use and the data can all be analyzed through the web once the
> developer creates the middle layer.
> I know MS has SSAS which contains the cube technology and data mining.
> Do they offer a packaged product ready for enduser use similiar to BO?
> Do you need to program your needs in the BI environment to develop what your
> looking for?
> Is there a way to get the SSAS cubes designed for end users to access
> through the web/intranet?
> Thanks.
>
>|||"Brian Shannon" <brian.shannon@.diamondjo.com> wrote in message
news:O2$FcrnDHHA.1220@.TK2MSFTNGP04.phx.gbl...
> BO presented me with really nice web intelligence software which is all
> integrated with the BO product line. The products were: BO Web
> Intelligence, BO Predictive Analysis, BO Set Analysis. These products
> seem easy to use and the data can all be analyzed through the web once the
> developer creates the middle layer.
> I know MS has SSAS which contains the cube technology and data mining.
> Do they offer a packaged product ready for enduser use similiar to BO?
> Do you need to program your needs in the BI environment to develop what
> your looking for?
Take a look at Microsoft Performance Point 2007, as it will help you do much
of what you're looking for.
http://office.microsoft.com/en-us/performancepoint/FX101680481033.aspx
Hope this helps.
Ted|||Hey, Brian
One of Microsoft's biggest ambitions is to be leading the Business
Intelligence (BI) arena. In 2007, they have announced the release of
several new products and integration with the Office suite (especially
Excel). I would really consider the Microsoft suite of BI offerings
that will be coming up in the next year. Like Ted said,
PerformancePoint will be a key product to get into BIPM, and will allow
users to view scorecard technology, data mining, cube analysis, etc.
They will be leveraging a lot of their BI offerings with Office and
SharePoint, in order to provide the end users access to data w/ tools
like Excel and their web browser (IE) which they're already familiar
with and comfortable using.
Since your company is a MS shop, and they already run SQL Server, the
license for Reporting Services is included, so you can have a pretty
good reporting engine up and running fairly quickly. Reporting
Services can connect to several data sources including OLTP and OLAP,
such as SQL Server DB, Analysis Services cubes, Oracle, XML web
services (RS 2005), and in the SP2 of SQL 2005, they will be adding
support for Hyperion. If you already have cubes setup in an Analysis
Services database, you can simply write the MDX (or use the MDX query
generator in RS 2005) for the report query, then design your report
layout, and the learning curve for Reporting Services is fairly
minimal.
I have seen a lot of companies that used Crystal reports as their main
reporting tool, move away from that and migrate all their reports to
Reporting Services because the licensing is much more cost effective --
it's included w/ their SQL Server license!
I would definitely recommend spending some time in the MS BI web site
to learn about their future offerings in that area.
(http://www.microsoft.com/bi)
Regards,
Thiago Silva, MCAD.NET
On Nov 22, 10:09 pm, "Ted Malone" <ted.nospam.mal...@.gmail.com> wrote:
> "Brian Shannon" <brian.shan...@.diamondjo.com> wrote in messagenews:O2$FcrnDHHA.1220@.TK2MSFTNGP04.phx.gbl...
> > BO presented me with really nice web intelligence software which is all
> > integrated with the BO product line. The products were: BO Web
> > Intelligence, BO Predictive Analysis, BO Set Analysis. These products
> > seem easy to use and the data can all be analyzed through the web once the
> > developer creates the middle layer.
> > I know MS has SSAS which contains the cube technology and data mining.
> > Do they offer a packaged product ready for enduser use similiar to BO?
> > Do you need to program your needs in the BI environment to develop what
> > your looking for?Take a look at Microsoft Performance Point 2007, as it will help you do much
> of what you're looking for.
> http://office.microsoft.com/en-us/performancepoint/FX101680481033.aspx
> Hope this helps.
> Ted
between RS and Crystal. We are primarily a MS shop with enterprise
licensing.
Business Objects (BO) has presented me with a really nice set of tools aside
from their reporting solution. Aside from reporting I would like to get
more involved with BI (dataming and cube analysis). At some point I would
like to have the end users browse the cube/universe data for quick adhoc
analysis.
BO presented me with really nice web intelligence software which is all
integrated with the BO product line. The products were: BO Web
Intelligence, BO Predictive Analysis, BO Set Analysis. These products seem
easy to use and the data can all be analyzed through the web once the
developer creates the middle layer.
I know MS has SSAS which contains the cube technology and data mining.
Do they offer a packaged product ready for enduser use similiar to BO?
Do you need to program your needs in the BI environment to develop what your
looking for?
Is there a way to get the SSAS cubes designed for end users to access
through the web/intranet?
Thanks.Basically you need to see what exactly you require. Both offer same things
but MS is cost effective solution and one stop solution. You also get
everything packged and moreover the SSRS comes free with Enterprise version
of SQL SERVER. So if you are planning for a small / mid size then this will
be ideal for you.
Amarnath
"Brian Shannon" wrote:
> I am currently looking for a reporting solution for my company. I am tore
> between RS and Crystal. We are primarily a MS shop with enterprise
> licensing.
> Business Objects (BO) has presented me with a really nice set of tools aside
> from their reporting solution. Aside from reporting I would like to get
> more involved with BI (dataming and cube analysis). At some point I would
> like to have the end users browse the cube/universe data for quick adhoc
> analysis.
> BO presented me with really nice web intelligence software which is all
> integrated with the BO product line. The products were: BO Web
> Intelligence, BO Predictive Analysis, BO Set Analysis. These products seem
> easy to use and the data can all be analyzed through the web once the
> developer creates the middle layer.
> I know MS has SSAS which contains the cube technology and data mining.
> Do they offer a packaged product ready for enduser use similiar to BO?
> Do you need to program your needs in the BI environment to develop what your
> looking for?
> Is there a way to get the SSAS cubes designed for end users to access
> through the web/intranet?
> Thanks.
>
>|||"Brian Shannon" <brian.shannon@.diamondjo.com> wrote in message
news:O2$FcrnDHHA.1220@.TK2MSFTNGP04.phx.gbl...
> BO presented me with really nice web intelligence software which is all
> integrated with the BO product line. The products were: BO Web
> Intelligence, BO Predictive Analysis, BO Set Analysis. These products
> seem easy to use and the data can all be analyzed through the web once the
> developer creates the middle layer.
> I know MS has SSAS which contains the cube technology and data mining.
> Do they offer a packaged product ready for enduser use similiar to BO?
> Do you need to program your needs in the BI environment to develop what
> your looking for?
Take a look at Microsoft Performance Point 2007, as it will help you do much
of what you're looking for.
http://office.microsoft.com/en-us/performancepoint/FX101680481033.aspx
Hope this helps.
Ted|||Hey, Brian
One of Microsoft's biggest ambitions is to be leading the Business
Intelligence (BI) arena. In 2007, they have announced the release of
several new products and integration with the Office suite (especially
Excel). I would really consider the Microsoft suite of BI offerings
that will be coming up in the next year. Like Ted said,
PerformancePoint will be a key product to get into BIPM, and will allow
users to view scorecard technology, data mining, cube analysis, etc.
They will be leveraging a lot of their BI offerings with Office and
SharePoint, in order to provide the end users access to data w/ tools
like Excel and their web browser (IE) which they're already familiar
with and comfortable using.
Since your company is a MS shop, and they already run SQL Server, the
license for Reporting Services is included, so you can have a pretty
good reporting engine up and running fairly quickly. Reporting
Services can connect to several data sources including OLTP and OLAP,
such as SQL Server DB, Analysis Services cubes, Oracle, XML web
services (RS 2005), and in the SP2 of SQL 2005, they will be adding
support for Hyperion. If you already have cubes setup in an Analysis
Services database, you can simply write the MDX (or use the MDX query
generator in RS 2005) for the report query, then design your report
layout, and the learning curve for Reporting Services is fairly
minimal.
I have seen a lot of companies that used Crystal reports as their main
reporting tool, move away from that and migrate all their reports to
Reporting Services because the licensing is much more cost effective --
it's included w/ their SQL Server license!
I would definitely recommend spending some time in the MS BI web site
to learn about their future offerings in that area.
(http://www.microsoft.com/bi)
Regards,
Thiago Silva, MCAD.NET
On Nov 22, 10:09 pm, "Ted Malone" <ted.nospam.mal...@.gmail.com> wrote:
> "Brian Shannon" <brian.shan...@.diamondjo.com> wrote in messagenews:O2$FcrnDHHA.1220@.TK2MSFTNGP04.phx.gbl...
> > BO presented me with really nice web intelligence software which is all
> > integrated with the BO product line. The products were: BO Web
> > Intelligence, BO Predictive Analysis, BO Set Analysis. These products
> > seem easy to use and the data can all be analyzed through the web once the
> > developer creates the middle layer.
> > I know MS has SSAS which contains the cube technology and data mining.
> > Do they offer a packaged product ready for enduser use similiar to BO?
> > Do you need to program your needs in the BI environment to develop what
> > your looking for?Take a look at Microsoft Performance Point 2007, as it will help you do much
> of what you're looking for.
> http://office.microsoft.com/en-us/performancepoint/FX101680481033.aspx
> Hope this helps.
> Ted
Friday, February 24, 2012
Beta 2 Management studio navigation
A couple of questions:
-- I can see how to desgin a table in the tree, but how do you quickly view all rows in a table like you could in enterprise manager?
-- Where do you go to set up a new DTS script if it is not done with the wizard?
Thanks.
If you have a question about SQL Server 2005 Beta 2, please ask it in
the newsgroups that have been established for it. You can find out how
to access those newsgroups where you got the beta version of SQL Server
2005.
Steve Kass
Drew University
bogus_boy wrote:
>A couple of questions:
>-- I can see how to desgin a table in the tree, but how do you quickly view all rows in a table like you could in enterprise manager?
>-- Where do you go to set up a new DTS script if it is not done with the wizard?
>Thanks.
>
-- I can see how to desgin a table in the tree, but how do you quickly view all rows in a table like you could in enterprise manager?
-- Where do you go to set up a new DTS script if it is not done with the wizard?
Thanks.
If you have a question about SQL Server 2005 Beta 2, please ask it in
the newsgroups that have been established for it. You can find out how
to access those newsgroups where you got the beta version of SQL Server
2005.
Steve Kass
Drew University
bogus_boy wrote:
>A couple of questions:
>-- I can see how to desgin a table in the tree, but how do you quickly view all rows in a table like you could in enterprise manager?
>-- Where do you go to set up a new DTS script if it is not done with the wizard?
>Thanks.
>
Tuesday, February 14, 2012
Best way to implement "warm" standby? - considering log shipping
Hi Larry,
Log Shipping is the ultimate solution if you are on SQL
Server Enterprise Edition. Follow these Resources..
Log Shipping in SQL Server 2000 - Part 1
http://www.microsoft.com/technet/treeview/default.asp?
url=/technet/prodtechnol/sql/deploy/prodspecs/logship1.asp
Log Shipping in SQL Server 2000 - Part 2
http://www.microsoft.com/technet/treeview/default.asp?
url=/technet/prodtechnol/sql/deploy/prodspecs/logship1.asp
How to Perform SQL Server Log Shipping
http://www.sql-server-
performance.com/sql_server_log_shipping.asp
HTH
THIRUMAL REDDY MARAM
Sys Amin / SQL DBA
backup. I want to be
failure. The loss of
Shipping looks like
(1) having a
the production
can't do this.
affect your
not be available 100%
will happen if the
computer isn't
I've printed off all three articles and I will study them.
Larry
"Thirumal" <treddym@.hotmail.nospam.com> wrote in message
news:129a01c3df61$ab5c71d0$a601280a@.phx.gbl...[QUOTE]
> Hi Larry,
> Log Shipping is the ultimate solution if you are on SQL
> Server Enterprise Edition. Follow these Resources..
> Log Shipping in SQL Server 2000 - Part 1
> http://www.microsoft.com/technet/treeview/default.asp?
> url=/technet/prodtechnol/sql/deploy/prodspecs/logship1.asp
> Log Shipping in SQL Server 2000 - Part 2
> http://www.microsoft.com/technet/treeview/default.asp?
> url=/technet/prodtechnol/sql/deploy/prodspecs/logship1.asp
> How to Perform SQL Server Log Shipping
> http://www.sql-server-
> performance.com/sql_server_log_shipping.asp
> HTH
> --
> THIRUMAL REDDY MARAM
> Sys Amin / SQL DBA
> backup. I want to be
> failure. The loss of
> Shipping looks like
> (1) having a
> the production
> can't do this.
> affect your
> not be available 100%
> will happen if the
> computer isn't
Log Shipping is the ultimate solution if you are on SQL
Server Enterprise Edition. Follow these Resources..
Log Shipping in SQL Server 2000 - Part 1
http://www.microsoft.com/technet/treeview/default.asp?
url=/technet/prodtechnol/sql/deploy/prodspecs/logship1.asp
Log Shipping in SQL Server 2000 - Part 2
http://www.microsoft.com/technet/treeview/default.asp?
url=/technet/prodtechnol/sql/deploy/prodspecs/logship1.asp
How to Perform SQL Server Log Shipping
http://www.sql-server-
performance.com/sql_server_log_shipping.asp
HTH
THIRUMAL REDDY MARAM
Sys Amin / SQL DBA
quote:
>--Original Message--
>I have TWO networked servers; one production, and one
backup. I want to be
quote:
>able to use the backup in case of a production server
failure. The loss of
quote:
>a "little" data is acceptable in case of failure. Log
Shipping looks like
quote:
>the easiest but there seems to be a lot of warnings about
(1) having a
quote:
>monitor server, and (2) having this server NOT be either
the production
quote:
>server nor the backup. I only have two servers so I
can't do this.
quote:
>Is Log Shipping the best solution? Also--and this might
affect your
quote:
>response--it is possible that the backup system might
not be available 100%
quote:
>of the time. I bring this up because I don't know what
will happen if the
quote:
>production system wants to ship a log, and the backup
computer isn't
quote:Thanks, Thirumal,
>available to accept it. (')
>Any help, recommendations?
>TIA,
>Larry Woods
>
>.
>
I've printed off all three articles and I will study them.
Larry
"Thirumal" <treddym@.hotmail.nospam.com> wrote in message
news:129a01c3df61$ab5c71d0$a601280a@.phx.gbl...[QUOTE]
> Hi Larry,
> Log Shipping is the ultimate solution if you are on SQL
> Server Enterprise Edition. Follow these Resources..
> Log Shipping in SQL Server 2000 - Part 1
> http://www.microsoft.com/technet/treeview/default.asp?
> url=/technet/prodtechnol/sql/deploy/prodspecs/logship1.asp
> Log Shipping in SQL Server 2000 - Part 2
> http://www.microsoft.com/technet/treeview/default.asp?
> url=/technet/prodtechnol/sql/deploy/prodspecs/logship1.asp
> How to Perform SQL Server Log Shipping
> http://www.sql-server-
> performance.com/sql_server_log_shipping.asp
> HTH
> --
> THIRUMAL REDDY MARAM
> Sys Amin / SQL DBA
> backup. I want to be
> failure. The loss of
> Shipping looks like
> (1) having a
> the production
> can't do this.
> affect your
> not be available 100%
> will happen if the
> computer isn't
Sunday, February 12, 2012
best way to copy database
I need to move a database from sql 2000 to sql 2005. My research suggests that I can backup a sql 2000 db from enterprise manager and restore it with sql 2005 management studio. Are there step by step directions for this or can someone tell me how to do this?
what about logins? Are they transfered in this process. My research also suggests the I use copy database wizard by this failed on me and I can't find anything in the event log or anywhere else to tell me why. Please help. ThanksIMO, I would probably suggest backup and restore tactic for user databases. As for logins, either you dump the data into a file by doing a BCP out (bulk copy program) on master..syslogins table of the old server and BCP IN to the same table of the new server, however, since I've no experience on SQL2005, please check the structure of master..syslogins table if they're similar on both versions. As for the sysusers of user databases, you can make sp_adduser statements by doing a SELECT 'sp_adduser ' + NAME + ', ' + NAME + ' FROM MASTER..SYSLOGINS
As for syntax reference, try BOL. :)
HTH|||The BCP of syslogins trick quit working in SQL server 7.0. SQL 2005 has an all new system table structure, so I greatly doubt it would work here. For the logins, look up the CREATE LOGIN command. You will want to pay especial attention to the SID parameter. If you keep the SID for each user the same for SQL 2005 as it was on SQL 2000, they will match up with no problems. If you do not supply a SID for the CREATE USER command, a new random SID will be generated, and you will have to drop and recreate the user in the database (or recreate the login with the right SID).
Any jobs/maintenance plans that will have to come over?|||I got it over with backup and restore and all the logins are there. No job or maintenance plans need to be restored. Thanks
what about logins? Are they transfered in this process. My research also suggests the I use copy database wizard by this failed on me and I can't find anything in the event log or anywhere else to tell me why. Please help. ThanksIMO, I would probably suggest backup and restore tactic for user databases. As for logins, either you dump the data into a file by doing a BCP out (bulk copy program) on master..syslogins table of the old server and BCP IN to the same table of the new server, however, since I've no experience on SQL2005, please check the structure of master..syslogins table if they're similar on both versions. As for the sysusers of user databases, you can make sp_adduser statements by doing a SELECT 'sp_adduser ' + NAME + ', ' + NAME + ' FROM MASTER..SYSLOGINS
As for syntax reference, try BOL. :)
HTH|||The BCP of syslogins trick quit working in SQL server 7.0. SQL 2005 has an all new system table structure, so I greatly doubt it would work here. For the logins, look up the CREATE LOGIN command. You will want to pay especial attention to the SID parameter. If you keep the SID for each user the same for SQL 2005 as it was on SQL 2000, they will match up with no problems. If you do not supply a SID for the CREATE USER command, a new random SID will be generated, and you will have to drop and recreate the user in the database (or recreate the login with the right SID).
Any jobs/maintenance plans that will have to come over?|||I got it over with backup and restore and all the logins are there. No job or maintenance plans need to be restored. Thanks
Subscribe to:
Posts (Atom)