Folks,
I am a new DBA in my co. I would like to have a good practices on how to
really keep track and maintain the dbs that we have. We have a lot of dbs
around the co.
Best practices, tips to how effeciently manage the dbs would be a great
start for me. we also do have phone call support here and i wonder what types
of roles i can pass to them.
TIAThis is a multi-part message in MIME format.
--020005080903090402010906
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
SQL Server 2000 Operations Guide
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops0.mspx
This is a document that Microsoft put together some time ago but is
still a good best-practices reference. The part of Microsoft's TechNet
website they've dubbed Microsoft SQL Server TechCenter is also a good
source of information around tips & tricks, operations, design/planning,
etc. You can find it here:
http://www.microsoft.com/technet/prodtechnol/sql/default.mspx
All that documentation should keep you reading until you're ready to retire.
HTH
--
*mike hodgson*
/ mallesons stephen jaques/
blog: http://sqlnerd.blogspot.com
rupart wrote:
>Folks,
>I am a new DBA in my co. I would like to have a good practices on how to
>really keep track and maintain the dbs that we have. We have a lot of dbs
>around the co.
>Best practices, tips to how effeciently manage the dbs would be a great
>start for me. we also do have phone call support here and i wonder what types
>of roles i can pass to them.
>TIA
>
--020005080903090402010906
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>SQL Server 2000 Operations Guide<br>
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops0.mspx</a><br>">http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops0.mspx">http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops0.mspx</a><br>
<br>
This is a document that Microsoft put together some time ago but is
still a good best-practices reference. The part of Microsoft's TechNet
website they've dubbed Microsoft SQL Server TechCenter is also a good
source of information around tips & tricks, operations,
design/planning, etc. You can find it here:<br>
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://www.microsoft.com/technet/prodtechnol/sql/default.mspx</a><br>">http://www.microsoft.com/technet/prodtechnol/sql/default.mspx">http://www.microsoft.com/technet/prodtechnol/sql/default.mspx</a><br>
<br>
All that documentation should keep you reading until you're ready to
retire.<br>
<br>
HTH<br>
</tt>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font> </span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"><br>
<em><font face="Tahoma" size="2"> mallesons</font><font face="Tahoma"> </font><font
face="Tahoma" size="2">stephen</font><font face="Tahoma"> </font><font
face="Tahoma" size="2"> jaques</font></em><font face="Tahoma"><br>
</font><font face="Tahoma" size="2">blog:</font><font face="Tahoma"
size="2"> <a href="http://links.10026.com/?link=/">http://sqlnerd.blogspot.com">
http://sqlnerd.blogspot.com</a></font></span> </p>
</div>
<br>
<br>
rupart wrote:
<blockquote cite="midE7D2A204-7587-4226-B454-206E4E7C301C@.microsoft.com"
type="cite">
<pre wrap="">Folks,
I am a new DBA in my co. I would like to have a good practices on how to
really keep track and maintain the dbs that we have. We have a lot of dbs
around the co.
Best practices, tips to how effeciently manage the dbs would be a great
start for me. we also do have phone call support here and i wonder what types
of roles i can pass to them.
TIA
</pre>
</blockquote>
</body>
</html>
--020005080903090402010906--|||rupart
I prefer
<http://vyaskn.tripod.com/sql_server_administration_best_practices.htm#Step1
> --administaiting best practices
<http://vyaskn.tripod.com/sql_server_security_best_practices.htm> --se
curity best practices
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:E7D2A204-7587-4226-B454-206E4E7C301C@.microsoft.com...
> Folks,
> I am a new DBA in my co. I would like to have a good practices on how to
> really keep track and maintain the dbs that we have. We have a lot of dbs
> around the co.
> Best practices, tips to how effeciently manage the dbs would be a great
> start for me. we also do have phone call support here and i wonder what
types
> of roles i can pass to them.
> TIA|||thx for all the tips...will start reading
"Uri Dimant" wrote:
> rupart
> I prefer
> <http://vyaskn.tripod.com/sql_server_administration_best_practices.htm#Step1
> > --administaiting best practices
> <http://vyaskn.tripod.com/sql_server_security_best_practices.htm> --se
> curity best practices
>
>
>
> "rupart" <rupart@.discussions.microsoft.com> wrote in message
> news:E7D2A204-7587-4226-B454-206E4E7C301C@.microsoft.com...
> > Folks,
> > I am a new DBA in my co. I would like to have a good practices on how to
> > really keep track and maintain the dbs that we have. We have a lot of dbs
> > around the co.
> > Best practices, tips to how effeciently manage the dbs would be a great
> > start for me. we also do have phone call support here and i wonder what
> types
> > of roles i can pass to them.
> >
> > TIA
>
>
Showing posts with label folks. Show all posts
Showing posts with label folks. Show all posts
Thursday, March 29, 2012
DBA Admin
Folks,
I am a new DBA in my co. I would like to have a good practices on how to
really keep track and maintain the dbs that we have. We have a lot of dbs
around the co.
Best practices, tips to how effeciently manage the dbs would be a great
start for me. we also do have phone call support here and i wonder what type
s
of roles i can pass to them.
TIASQL Server 2000 Operations Guide
http://www.microsoft.com/technet/pr...in/sqlops0.mspx
This is a document that Microsoft put together some time ago but is
still a good best-practices reference. The part of Microsoft's TechNet
website they've dubbed Microsoft SQL Server TechCenter is also a good
source of information around tips & tricks, operations, design/planning,
etc. You can find it here:
http://www.microsoft.com/technet/pr...ql/default.mspx
All that documentation should keep you reading until you're ready to retire.
HTH
*mike hodgson*
/ mallesons stephen jaques/
blog: http://sqlnerd.blogspot.com
rupart wrote:
>Folks,
>I am a new DBA in my co. I would like to have a good practices on how to
>really keep track and maintain the dbs that we have. We have a lot of dbs
>around the co.
>Best practices, tips to how effeciently manage the dbs would be a great
>start for me. we also do have phone call support here and i wonder what typ
es
>of roles i can pass to them.
>TIA
>|||rupart
I prefer
<http://vyaskn.tripod.com/ sql_serve...r />
.htm#Step1
> --administaiting best practices
<http://vyaskn.tripod.com/sql_server...t_practices.htm> --se
curity best practices
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:E7D2A204-7587-4226-B454-206E4E7C301C@.microsoft.com...
> Folks,
> I am a new DBA in my co. I would like to have a good practices on how to
> really keep track and maintain the dbs that we have. We have a lot of dbs
> around the co.
> Best practices, tips to how effeciently manage the dbs would be a great
> start for me. we also do have phone call support here and i wonder what
types
> of roles i can pass to them.
> TIA|||thx for all the tips...will start reading
"Uri Dimant" wrote:
> rupart
> I prefer
> <l]
> <[url]http://vyaskn.tripod.com/sql_server_security_best_practices.htm" target="_blank">http://vyaskn.tripod.com/ sql_serve...t_practices.htm> --
se
> curity best practices
>
>
>
> "rupart" <rupart@.discussions.microsoft.com> wrote in message
> news:E7D2A204-7587-4226-B454-206E4E7C301C@.microsoft.com...
> types
>
>
I am a new DBA in my co. I would like to have a good practices on how to
really keep track and maintain the dbs that we have. We have a lot of dbs
around the co.
Best practices, tips to how effeciently manage the dbs would be a great
start for me. we also do have phone call support here and i wonder what type
s
of roles i can pass to them.
TIASQL Server 2000 Operations Guide
http://www.microsoft.com/technet/pr...in/sqlops0.mspx
This is a document that Microsoft put together some time ago but is
still a good best-practices reference. The part of Microsoft's TechNet
website they've dubbed Microsoft SQL Server TechCenter is also a good
source of information around tips & tricks, operations, design/planning,
etc. You can find it here:
http://www.microsoft.com/technet/pr...ql/default.mspx
All that documentation should keep you reading until you're ready to retire.
HTH
*mike hodgson*
/ mallesons stephen jaques/
blog: http://sqlnerd.blogspot.com
rupart wrote:
>Folks,
>I am a new DBA in my co. I would like to have a good practices on how to
>really keep track and maintain the dbs that we have. We have a lot of dbs
>around the co.
>Best practices, tips to how effeciently manage the dbs would be a great
>start for me. we also do have phone call support here and i wonder what typ
es
>of roles i can pass to them.
>TIA
>|||rupart
I prefer
<http://vyaskn.tripod.com/ sql_serve...r />
.htm#Step1
> --administaiting best practices
<http://vyaskn.tripod.com/sql_server...t_practices.htm> --se
curity best practices
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:E7D2A204-7587-4226-B454-206E4E7C301C@.microsoft.com...
> Folks,
> I am a new DBA in my co. I would like to have a good practices on how to
> really keep track and maintain the dbs that we have. We have a lot of dbs
> around the co.
> Best practices, tips to how effeciently manage the dbs would be a great
> start for me. we also do have phone call support here and i wonder what
types
> of roles i can pass to them.
> TIA|||thx for all the tips...will start reading
"Uri Dimant" wrote:
> rupart
> I prefer
> <l]
> <[url]http://vyaskn.tripod.com/sql_server_security_best_practices.htm" target="_blank">http://vyaskn.tripod.com/ sql_serve...t_practices.htm> --
se
> curity best practices
>
>
>
> "rupart" <rupart@.discussions.microsoft.com> wrote in message
> news:E7D2A204-7587-4226-B454-206E4E7C301C@.microsoft.com...
> types
>
>
DBA Admin
Folks,
I am a new DBA in my co. I would like to have a good practices on how to
really keep track and maintain the dbs that we have. We have a lot of dbs
around the co.
Best practices, tips to how effeciently manage the dbs would be a great
start for me. we also do have phone call support here and i wonder what types
of roles i can pass to them.
TIA
SQL Server 2000 Operations Guide
http://www.microsoft.com/technet/pro...n/sqlops0.mspx
This is a document that Microsoft put together some time ago but is
still a good best-practices reference. The part of Microsoft's TechNet
website they've dubbed Microsoft SQL Server TechCenter is also a good
source of information around tips & tricks, operations, design/planning,
etc. You can find it here:
http://www.microsoft.com/technet/pro...l/default.mspx
All that documentation should keep you reading until you're ready to retire.
HTH
*mike hodgson*
/ mallesons stephen jaques/
blog: http://sqlnerd.blogspot.com
rupart wrote:
>Folks,
>I am a new DBA in my co. I would like to have a good practices on how to
>really keep track and maintain the dbs that we have. We have a lot of dbs
>around the co.
>Best practices, tips to how effeciently manage the dbs would be a great
>start for me. we also do have phone call support here and i wonder what types
>of roles i can pass to them.
>TIA
>
|||rupart
I prefer
<http://vyaskn.tripod.com/sql_server_...ices.htm#Step1
> --administaiting best practices
<http://vyaskn.tripod.com/sql_server_..._practices.htm> --se
curity best practices
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:E7D2A204-7587-4226-B454-206E4E7C301C@.microsoft.com...
> Folks,
> I am a new DBA in my co. I would like to have a good practices on how to
> really keep track and maintain the dbs that we have. We have a lot of dbs
> around the co.
> Best practices, tips to how effeciently manage the dbs would be a great
> start for me. we also do have phone call support here and i wonder what
types
> of roles i can pass to them.
> TIA
|||thx for all the tips...will start reading
"Uri Dimant" wrote:
> rupart
> I prefer
> <http://vyaskn.tripod.com/sql_server_...ices.htm#Step1
> <http://vyaskn.tripod.com/sql_server_..._practices.htm> --se
> curity best practices
>
>
>
> "rupart" <rupart@.discussions.microsoft.com> wrote in message
> news:E7D2A204-7587-4226-B454-206E4E7C301C@.microsoft.com...
> types
>
>
sql
I am a new DBA in my co. I would like to have a good practices on how to
really keep track and maintain the dbs that we have. We have a lot of dbs
around the co.
Best practices, tips to how effeciently manage the dbs would be a great
start for me. we also do have phone call support here and i wonder what types
of roles i can pass to them.
TIA
SQL Server 2000 Operations Guide
http://www.microsoft.com/technet/pro...n/sqlops0.mspx
This is a document that Microsoft put together some time ago but is
still a good best-practices reference. The part of Microsoft's TechNet
website they've dubbed Microsoft SQL Server TechCenter is also a good
source of information around tips & tricks, operations, design/planning,
etc. You can find it here:
http://www.microsoft.com/technet/pro...l/default.mspx
All that documentation should keep you reading until you're ready to retire.
HTH
*mike hodgson*
/ mallesons stephen jaques/
blog: http://sqlnerd.blogspot.com
rupart wrote:
>Folks,
>I am a new DBA in my co. I would like to have a good practices on how to
>really keep track and maintain the dbs that we have. We have a lot of dbs
>around the co.
>Best practices, tips to how effeciently manage the dbs would be a great
>start for me. we also do have phone call support here and i wonder what types
>of roles i can pass to them.
>TIA
>
|||rupart
I prefer
<http://vyaskn.tripod.com/sql_server_...ices.htm#Step1
> --administaiting best practices
<http://vyaskn.tripod.com/sql_server_..._practices.htm> --se
curity best practices
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:E7D2A204-7587-4226-B454-206E4E7C301C@.microsoft.com...
> Folks,
> I am a new DBA in my co. I would like to have a good practices on how to
> really keep track and maintain the dbs that we have. We have a lot of dbs
> around the co.
> Best practices, tips to how effeciently manage the dbs would be a great
> start for me. we also do have phone call support here and i wonder what
types
> of roles i can pass to them.
> TIA
|||thx for all the tips...will start reading
"Uri Dimant" wrote:
> rupart
> I prefer
> <http://vyaskn.tripod.com/sql_server_...ices.htm#Step1
> <http://vyaskn.tripod.com/sql_server_..._practices.htm> --se
> curity best practices
>
>
>
> "rupart" <rupart@.discussions.microsoft.com> wrote in message
> news:E7D2A204-7587-4226-B454-206E4E7C301C@.microsoft.com...
> types
>
>
sql
DB2 Viper 2 beta - Compatibility features, Need your help
Hi folks,
With little more work and you'll be compatible with Oracle. <g>
Not well enough. I hit cancel within 10 seconds of posting to this
group, apparently to late. If you want to flame please do so in c.d.ibm-db2.
Let's leave the SQL Server crowd in peace...
My fellow team mates had some extra time on their hands so we decided to
spice up DB2 with a grab-bag of compatibility features.
We wouldn't mind help validating the semantics match...
So for those of you blessed or cursed with a competitive DBMS here is a
list of what we've added:
1. ** DUAL
Always works without prefixing a schema
2. ** ROWNUM
3. ** (+) outer join syntax
4. LEAST/GREATEST/NVL/DECODE
5. TO_DATE/TO_CHAR improvement
DB2 supports most common patterns except those requiring language
awareness
6. ** CONNECT BY
This is a function drop, performance drop will follow
7. A slew of syntactic sugar like:
Seq.NEXTVAL and seq.CURRVAL notation
UNIQUE instead of DISTINCT
MINUS instead of EXCEPT
Unnamed nested subqueries (aka inline views)
"SELECT * FROM (SELECT * FROM T)"
CROSSJOIN
8. BITAND/BITOR/....
The features marked with ** require a registry setting:
db2set DB2_COMPATIBILITY_VECTOR=3F
should switch everything on.
There are other features those porting apps will value:
GLOBAL VARIABLES
A new ARRAY data type
A new RID() function can be used to map ROWID
Docs: https://publib.boulder.ibm.com/info.../v9r5/index.jsp
Enjoy
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto LabSerge Rielau wrote:
Quote:
Originally Posted by
Hi folks,
>
My fellow team mates had some extra time on their hands so we decided to
spice up DB2 with a grab-bag of compatibility features.
We wouldn't mind help validating the semantics match...
So for those of you blessed or cursed with a competitive DBMS here is a
list of what we've added:
>
1. ** DUAL
Always works without prefixing a schema
2. ** ROWNUM
3. ** (+) outer join syntax
4. LEAST/GREATEST/NVL/DECODE
5. TO_DATE/TO_CHAR improvement
DB2 supports most common patterns except those requiring language
awareness
6. ** CONNECT BY
This is a function drop, performance drop will follow
7. A slew of syntactic sugar like:
Seq.NEXTVAL and seq.CURRVAL notation
UNIQUE instead of DISTINCT
MINUS instead of EXCEPT
Unnamed nested subqueries (aka inline views)
"SELECT * FROM (SELECT * FROM T)"
CROSSJOIN
8. BITAND/BITOR/....
>
The features marked with ** require a registry setting:
db2set DB2_COMPATIBILITY_VECTOR=3F
should switch everything on.
>
There are other features those porting apps will value:
GLOBAL VARIABLES
A new ARRAY data type
A new RID() function can be used to map ROWID
>
Docs: https://publib.boulder.ibm.com/info.../v9r5/index.jsp
>
Enjoy
Serge
With little more work and you'll be compatible with Oracle. <g>
Well done.
--
Daniel A. Morgan
University of Washington
damorgan@.x.washington.edu (replace x with u to respond)|||DA Morgan wrote:
Quote:
Originally Posted by
Well done.
Not well enough. I hit cancel within 10 seconds of posting to this
group, apparently to late. If you want to flame please do so in c.d.ibm-db2.
Let's leave the SQL Server crowd in peace...
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Tuesday, March 27, 2012
DB2 & SQL server?
Hi Folks,
We have a DB2 database on a WAN at work. I want to access the database from
some Visual Basic for Applications code that I have written at work.
The database itself is not directly accessable and as it was described to me
is "buffered"
from the users by a second computer which passes on requests for data.
I assume that this intermediary computer would be whats called a SQL server?
If my assumption above is correct is it possible to get a query to the
server which
it will accept and reply to?
Anyone?
Cheers
-AlYou need to ask whoever is administering your servers what technology is
used for accessing the DB2 database. Microsoft has a product called Host
Integration Server which can connect to DB2 systems. It is also possible to
link Microsoft SQLServer to external data sources such as DB2, but without
more information about what system you have in place it's difficult to give
a useful answer to your question.
Assuming you are provided with an OLEDB or ODBC connection to the database
you can use ADO to access your data from within Visual Basic.
http://msdn.microsoft.com/library/d.../>
rtpage1.asp
http://msdn.microsoft.com/library/d...t_oledb-db2.asp
To do this you'll need information such as the provider name, server name,
database name, user name and password. Your system administrator should be
able to supply that information.
(cross-postings removed)
David Portas
--
Please reply only to the newsgroup
--|||Thanks for the reply.
Currently we can query the database via a webpage interface.
I have looked at the code behind the webpage and it consists of some
javascript.
I am guessing but it looks like the webpage sends the request to the
webserver
which I assume passes it to the SQL server.
Is it possible that the computer i work on cant talk to the sql server
directly?
I need to know where to go from here...
Cheers
-Al
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:ereU30F0DHA.2308@.TK2MSFTNGP11.phx.gbl...
to
give
http://msdn.microsoft.com/library/d...ostartpage1.asp[QUOT
E]
>[/QUOTE]
http://msdn.microsoft.com/library/d...t_oledb-db2.asp[
QUOTE]
> To do this you'll need information such as the provider name, server name,
> database name, user name and password. Your system administrator should be
> able to supply that information.
>
> (cross-postings removed)
> --
> David Portas
> --
> Please reply only to the newsgroup
> --
>[/QUOTE]
We have a DB2 database on a WAN at work. I want to access the database from
some Visual Basic for Applications code that I have written at work.
The database itself is not directly accessable and as it was described to me
is "buffered"
from the users by a second computer which passes on requests for data.
I assume that this intermediary computer would be whats called a SQL server?
If my assumption above is correct is it possible to get a query to the
server which
it will accept and reply to?
Anyone?
Cheers
-AlYou need to ask whoever is administering your servers what technology is
used for accessing the DB2 database. Microsoft has a product called Host
Integration Server which can connect to DB2 systems. It is also possible to
link Microsoft SQLServer to external data sources such as DB2, but without
more information about what system you have in place it's difficult to give
a useful answer to your question.
Assuming you are provided with an OLEDB or ODBC connection to the database
you can use ADO to access your data from within Visual Basic.
http://msdn.microsoft.com/library/d.../>
rtpage1.asp
http://msdn.microsoft.com/library/d...t_oledb-db2.asp
To do this you'll need information such as the provider name, server name,
database name, user name and password. Your system administrator should be
able to supply that information.
(cross-postings removed)
David Portas
--
Please reply only to the newsgroup
--|||Thanks for the reply.
Currently we can query the database via a webpage interface.
I have looked at the code behind the webpage and it consists of some
javascript.
I am guessing but it looks like the webpage sends the request to the
webserver
which I assume passes it to the SQL server.
Is it possible that the computer i work on cant talk to the sql server
directly?
I need to know where to go from here...
Cheers
-Al
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:ereU30F0DHA.2308@.TK2MSFTNGP11.phx.gbl...
quote:
> You need to ask whoever is administering your servers what technology is
> used for accessing the DB2 database. Microsoft has a product called Host
> Integration Server which can connect to DB2 systems. It is also possible
to
quote:
> link Microsoft SQLServer to external data sources such as DB2, but without
> more information about what system you have in place it's difficult to
give
quote:
> a useful answer to your question.
> Assuming you are provided with an OLEDB or ODBC connection to the database
> you can use ADO to access your data from within Visual Basic.
>
http://msdn.microsoft.com/library/d...ostartpage1.asp[QUOT
E]
>[/QUOTE]
http://msdn.microsoft.com/library/d...t_oledb-db2.asp[
QUOTE]
> To do this you'll need information such as the provider name, server name,
> database name, user name and password. Your system administrator should be
> able to supply that information.
>
> (cross-postings removed)
> --
> David Portas
> --
> Please reply only to the newsgroup
> --
>[/QUOTE]
DB2 & SQL server?
Hi Folks,
We have a DB2 database on a WAN at work. I want to access the database from
some Visual Basic for Applications code that I have written at work.
The database itself is not directly accessable and as it was described to me
is "buffered"
from the users by a second computer which passes on requests for data.
I assume that this intermediary computer would be whats called a SQL server?
If my assumption above is correct is it possible to get a query to the
server which
it will accept and reply to?
Anyone?
Cheers
-AlReplied in microsoft.public.sqlserver.connect
--
David Portas
--
Please reply only to the newsgroup
--|||Hi!
I work as a Journalist with PC WORLD magazine. I would like to obtain recent news about
SQL and other news. You can e mail them to me and we would be glad to publish them in
our magazine.
Thanking You,
Anusha Kirubaharan
We have a DB2 database on a WAN at work. I want to access the database from
some Visual Basic for Applications code that I have written at work.
The database itself is not directly accessable and as it was described to me
is "buffered"
from the users by a second computer which passes on requests for data.
I assume that this intermediary computer would be whats called a SQL server?
If my assumption above is correct is it possible to get a query to the
server which
it will accept and reply to?
Anyone?
Cheers
-AlReplied in microsoft.public.sqlserver.connect
--
David Portas
--
Please reply only to the newsgroup
--|||Hi!
I work as a Journalist with PC WORLD magazine. I would like to obtain recent news about
SQL and other news. You can e mail them to me and we would be glad to publish them in
our magazine.
Thanking You,
Anusha Kirubaharan
Sunday, March 11, 2012
Db refresh - Need input on strategy
Hi Folks,
The Need : Refresh a part of local database daily from remote server.
Assumption : All updates in remote are updated in local db as well.
Need inputs on the type of strategy
1) Take full backup of remote, refresh on local
( Downside for us is Network and disk space )
2) DTS ( refresh only the objects required )
Looks good to us but does it take care of my assumption ?? Your suggestions welcome .. I may be wrong
3) replication ( Dont want it implement on the already complicated sceanrio ... so I'll pass)
4) Standy databases ( ? Any help on this)
5) Any other
Thanks so much,
Warm Regards,
Ranjit.
-------------------
The best moments of my life are often things I get paid forI am not too clear on the assumption part. Do you mean all updates on the remote server as of a point in time should be reflected in the local (refreshed) server? Or that a process is updating both outside the refresh process?
If this is a pure Disaster Recovery purpose, you can look into things like Log Shipping (if you have SQL 2000 Enterprise edition), database mirroring (SQL 2005 SP1 only), or a third party hardware or software replication solution. If this is a reporting/snapshot solution, most of the third party replication schemes may not work for you, since the replicated copy will likely have to be offline.|||Thanks Matt.. Yes , it seems we need all updates on the remote server ( at a particular point of time ) to be captured and also reflected in the local (refreshed)server ..
This is actually more of a particular project requirement for cube builds ..
Also, at this point of time , we are on SQL 2000 EE for this requirement .. And logshipping ..Well that's an option I can snoop around for more details .. Any help/pointers ??
Thanks again.
Warm Regards,
Ranjit.
-------------------
The best moments of my life are often things I get paid for|||Logshipping may make the transaction log backups (and more importantly restores) of the remote system a little difficult, so you will need to have a test system to play with. One of the downsides of logshipping is you will get the entire database, and all changes, which it sounds like you do not need.
Snapshot Replication is probably out, due to the size of the database you are looking at (if you are building cubes from it, it must be big).
Transactional Replication can give you either scheduled, or (near) continuous updates on the subscriber system. You can have the distribution job halted during the cube build.
Third party replication schemes (hardware or software) would work in this scenario. You would have to cut the replication and fire up the database, before the cube build, but that can probably be scripted easily enough.
If you have no control over the remote server, the transactional replication of key tables will probably be the easiest politcally.
The Need : Refresh a part of local database daily from remote server.
Assumption : All updates in remote are updated in local db as well.
Need inputs on the type of strategy
1) Take full backup of remote, refresh on local
( Downside for us is Network and disk space )
2) DTS ( refresh only the objects required )
Looks good to us but does it take care of my assumption ?? Your suggestions welcome .. I may be wrong
3) replication ( Dont want it implement on the already complicated sceanrio ... so I'll pass)
4) Standy databases ( ? Any help on this)
5) Any other
Thanks so much,
Warm Regards,
Ranjit.
-------------------
The best moments of my life are often things I get paid forI am not too clear on the assumption part. Do you mean all updates on the remote server as of a point in time should be reflected in the local (refreshed) server? Or that a process is updating both outside the refresh process?
If this is a pure Disaster Recovery purpose, you can look into things like Log Shipping (if you have SQL 2000 Enterprise edition), database mirroring (SQL 2005 SP1 only), or a third party hardware or software replication solution. If this is a reporting/snapshot solution, most of the third party replication schemes may not work for you, since the replicated copy will likely have to be offline.|||Thanks Matt.. Yes , it seems we need all updates on the remote server ( at a particular point of time ) to be captured and also reflected in the local (refreshed)server ..
This is actually more of a particular project requirement for cube builds ..
Also, at this point of time , we are on SQL 2000 EE for this requirement .. And logshipping ..Well that's an option I can snoop around for more details .. Any help/pointers ??
Thanks again.
Warm Regards,
Ranjit.
-------------------
The best moments of my life are often things I get paid for|||Logshipping may make the transaction log backups (and more importantly restores) of the remote system a little difficult, so you will need to have a test system to play with. One of the downsides of logshipping is you will get the entire database, and all changes, which it sounds like you do not need.
Snapshot Replication is probably out, due to the size of the database you are looking at (if you are building cubes from it, it must be big).
Transactional Replication can give you either scheduled, or (near) continuous updates on the subscriber system. You can have the distribution job halted during the cube build.
Third party replication schemes (hardware or software) would work in this scenario. You would have to cut the replication and fire up the database, before the cube build, but that can probably be scripted easily enough.
If you have no control over the remote server, the transactional replication of key tables will probably be the easiest politcally.
Subscribe to:
Posts (Atom)