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 track. Show all posts
Showing posts with label track. 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
Thursday, March 22, 2012
DB Tables Missing - Log Someplace?
Does MSSQL keep track of anything, anywhere related to tables being deleted
(when, by whom, etc.) from a DB if no type of auditing was setup?Hi
Yes, in the database transaction log. You can use 3rd party tools like LogPi
and Log Explorer to look at the transaction logs. this is assuming you have
full logging on and dump your transaction logs on a regular basis.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Absolutely" <abs@.spam.never> wrote in message
news:11aepite0idaacc@.corp.supernews.com...
> Does MSSQL keep track of anything, anywhere related to tables being
> deleted (when, by whom, etc.) from a DB if no type of auditing was setup?
>sql
(when, by whom, etc.) from a DB if no type of auditing was setup?Hi
Yes, in the database transaction log. You can use 3rd party tools like LogPi
and Log Explorer to look at the transaction logs. this is assuming you have
full logging on and dump your transaction logs on a regular basis.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Absolutely" <abs@.spam.never> wrote in message
news:11aepite0idaacc@.corp.supernews.com...
> Does MSSQL keep track of anything, anywhere related to tables being
> deleted (when, by whom, etc.) from a DB if no type of auditing was setup?
>sql
Subscribe to:
Posts (Atom)