Date parsed: 21/10/2007 23:30:03
Date: Mon, 22 Oct 2007 06:30:03 -0700

>1) I noticed on one of the servers the .LDF is large, almost 3 mb, and
>almost bigger then the actual DB, >is there a way to shrink it down in
>size, or designate a max size of that file? What is the actual LDF file?

The .LDF is the transaction log file. And frankly, 3MB is nothing. Now if it
were 3 GB ...
See: http://www.karaszi.com/SQLServer/info_dont_shrink.asp

FWIW, large T-LOG/.LDF files are probably the #1 problem in a SQL Server
install.

>2) On some of the servers the databases are set to a 'Simple' recovery mode
>and some are set to Full. >What is the differenece and what is the
>preferred way?

There are very good descriptions in BOL, you should read them. Simply put,
"Simple Recovery" will mark the log space as reusable as soon as the
transaction commits, full & bulk-logged will wait till you back it up.

>Someone mentioned to me that you can split the database files, what does
>that mean? Store the .mdf >and .ldf files in different locations?

This could mean a few things, including your guess. What I would take it to
mean is that a 2nd filegroup was created (being suported by an .NDF file -
same as .MDF, but secondary) and that some tables were placed on it.

It could also have to do with DPV's (Distributed Partition Views), but I
kinda doubt it.

Good luck, you'll need it.

Jay

Date parsed: 22/10/2007 00:20:01
Date: Mon, 22 Oct 2007 07:20:01 -0700

I'm in a similar situation. Our company has a small IT Department.
There is only one DBA and our systems are mission critical, running
24/7 with no option to crash! Anyways, my boss, the DBA, suggested
that I take some classes (the microsoft ones for the DBA track) and
said that the company would pay for them. However, there was a catch,
we would have to wait for grant money. Meanwhile, I didn't want to
look like a donkey so I went ahead and purchased 3 books from
Microsoft Press. They are the training kit books for the exams
70-431, 70-443, 70-444 (basically the MCITP DBA track). I registered
for this google group as well as others. Did reading online in my
spare time at work. Continued to do what I was hired for at a faster
pace (db development and reporting basically) so that I would have
some time to explore SQL server more and show that I'm getting the
work done. Here I am, I'm completely for one server (not a production
critical one but it is our archive/reporting server which is
important). I assist as a "DBA" with regards to the other servers,
making sure replication is still working, etc. I get to suggest
upgrade methods and technologies based on my studies and research. So
really the team has come to depend on me more now, and I'm technically
at the "DBA" position. The main advantage I have over you however is
that we still have our DBA and I'm kind of shadowing him. However, I
don't have that much db experience, I graduated college 2 years ago.
I think you can benefit by getting a collection of easy to use books
like the self-paced training kit I mentioned which gives you hands on
experience. Maybe you could eventually keep that DBA position, you
never know. I would advise you to get those books, and install the
version of SQL provided to start playing around in an area where you
can make and break things at will. It really helped me a lot and like
I said, now my advise is sought when it comes to SQL Server 2005
upgrades, installs, etc.

Hope that helps.

http://www.amazon.com/Self-Paced-Training-70-431-70-443-70-444/dp/0735623775/ref=pd_bxgy_b_img_b/105-5703406-7753224

Put out $90 for that and you could keep that promotion.

Date parsed: 22/10/2007 00:46:03
Date: Mon, 22 Oct 2007 07:46:03 -0700


Check out those Microsoft Books I listed, they're more than decent. If
you are a good SQL Developer then you should have a good foundation.
The DBA skill set can mostly be done through the tools provided by
Microsoft. It's not as simple as ABC, but anyone with a good
understanding of the core fundamentals of DBs, and has experience,
should be able to grasp it.

Date parsed: 22/10/2007 05:20:56
Date: Mon, 22 Oct 2007 09:20:56 -0400

Right now hiring a DBA is not an option (hence the reason I'm doing it for
now) and so far I'm able to do about 90% of the task list that is remaining,
but now I'm onto the performance, optimization piece of the list.




"Hate_orphaned_users" <Hateorphanedusers@discussions.microsoft.com> wrote in
message news:BF18888E-7D6A-47FB-8716-9853125E6C74@microsoft.com...
> Tell youre boss to hire a real DBA . If you ask such simple questions . i
> fear for the upcoming upgrade.
>
> Don't get me wrong. It's good that you wan't to learn it.
> In my opinion the compnay uses you to fill in a function you are not
> really
> ready for.
> Not youre fault.They underestimate the knowledge you need to be a DBA.
>
>

Date parsed: 22/10/2007 05:50:52
Date: Mon, 22 Oct 2007 09:50:52 -0400

I'm not underestimating a DBA's work load, Its just I don't want to do it
nor have I ever done DBA work.
I was thrown into the slot for now and maybe for the future. So I'm learning
as I go with it and so far its been good, no major issues at all. I've
upgraded several servers to SQL 05 and had no issues, its just now I'm in
the performance/optimizing phase of it and I'm not sure how to go about it
all, so I'm asking some questions about it all.






"Ekrem Önsoy" <ekrem@btegitim.com> wrote in message
news:9CD3A11B-803A-4227-B2D7-8A69ED8564B0@microsoft.com...
> My friend is right, you should not underestimate a DBA's tasks...
>
> However, you can learn more about Files and Filegroups from the following
> link:
> http://msdn2.microsoft.com/en-us/library/aa933064(SQL.80).aspx
>
> Recovery Models:
> http://msdn2.microsoft.com/en-us/library/aa173678(SQL.80).aspx
>
> First, you should take transaction log's backup to reduce it's size using
> "shrinkfile" command. Taking backup will clear the passive virtual log
> records in the ldf and shrink will reduce the size of the ldf roughly.
>
> You may want to read an article about Shrinking by Tibor:
> http://www.karaszi.com/SQLServer/info_dont_shrink.asp
>
> --
> Ekrem Önsoy
> http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
> MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT
>
>
>
> "Mike" <Mike@community.nospam.com> wrote in message
> news:efCih5KFIHA.4748@TK2MSFTNGP06.phx.gbl...
>> Right now hiring a DBA is not an option (hence the reason I'm doing it
>> for now) and so far I'm able to do about 90% of the task list that is
>> remaining, but now I'm onto the performance, optimization piece of the
>> list.
>>
>>
>>
>>
>> "Hate_orphaned_users" <Hateorphanedusers@discussions.microsoft.com> wrote
>> in message news:BF18888E-7D6A-47FB-8716-9853125E6C74@microsoft.com...
>>> Tell youre boss to hire a real DBA . If you ask such simple questions .
>>> i
>>> fear for the upcoming upgrade.
>>>
>>> Don't get me wrong. It's good that you wan't to learn it.
>>> In my opinion the compnay uses you to fill in a function you are not
>>> really
>>> ready for.
>>> Not youre fault.They underestimate the knowledge you need to be a DBA.
>>>
>>>
>>
>>
>

Date parsed: 22/10/2007 06:31:14
Date: Mon, 22 Oct 2007 10:31:14 -0400

This is a multi-part message in MIME format.

------=_NextPart_000_00B1_01C81496.AC264BE0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Plug my name into Amazon.com. I have a list of recommended books for =
SQL 2005. For SQL 2000, the first book you need to purchase and =
memorize is "Inside SQL Server 2000" by Kalen Delaney.

--=20
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Mike" <Mike@community.nospam.com> wrote in message =
news:%238028SLFIHA.484@TK2MSFTNGP06.phx.gbl...
Thanks,=20

So far I am able to restore databases and restore the entire server in =
case of failure (had to do this last week actually and it wasn't a =
test.)
So bringing the db backup isn't an issue for me (it was prior to last =
week.) I'm actually backing up all the databases to a NAS device instead =
of the local box as all the database servers were doing, so if the =
server died they lost the databases as well. So I fixed that portion of =
the problem.


I do see this as an opportunity and a way to span my skillset, but =
also, I don't want to 'fail'. I'm actaully looking at some books online =
now, can you recommend any good books for a developer turning DBA?



"Geoff N. Hiten" <SQLCraftsman@gmail.com> wrote in message =
news:Oyq5PHLFIHA.4748@TK2MSFTNGP06.phx.gbl...
You are not the first person to have such an "opportunity" dumped in =
their lap. Treat it as a real opportunity to grow your skills and =
resposibilities.

The first job of a DBA is to protect your company's data. Make sure =
you can restore or replace a system no matter what. Verify and test =
your recovery strategy. =20

FULL recovery, coupled with log backups, will allow you to recover a =
database to a "point-in-time" of your choosing. SIMPLE recovery only =
allows you to revocer to the last full backup. I suggest you read the =
section in BOL (Books Online, the FM part of RTFM) on backup nd =
recovery.

After you can guarantee data recovery that is appropriate for each =
database, then start looking at performance, capacity planning, =
upgrading, etc. =20

Definitely get a book budget and start reading. If your employer =
won't do that, then you are just being set up for failure. =20

--=20
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Mike" <Mike@community.nospam.com> wrote in message =
news:OmnVIsKFIHA.280@TK2MSFTNGP03.phx.gbl...
I'm kind of in a 'pickle' here. Let me start by saying I'm no DBA, =
that I'm a developer that was just put into the DBA role a few months =
back when the actaul DBA person left and so now, I'm assigned his =
remaining tasks for the year and I'm kind of stuck on some of them and =
looking for some help.

one of his tasks is to optimize the SQL servers across the board,=20

1) I noticed on one of the servers the .LDF is large, almost 3 mb, =
and almost bigger then the actual DB, is there a way to shrink it down =
in size, or designate a max size of that file? What is the actual LDF =
file?

2) On some of the servers the databases are set to a 'Simple' =
recovery mode and some are set to Full. What is the differenece and what =
is the preferred way?


Currently all of the database servers are SQL 2000 and I'm looking =
to upgrade them to SQl 2005 shortly

Someone mentioned to me that you can split the database files, =
what does that mean? Store the .mdf and .ldf files in different =
locations?

Again, I'm not a DBA and I'm learning as I go and so far I've been =
successful in the remaining former DBA tasks but some I'm getting stuck =
on and not sure how to go about it.=20

any help is apprecaited.
------=_NextPart_000_00B1_01C81496.AC264BE0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.6000.16546" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Plug my name into Amazon.com.&nbsp; I =
have a list=20
of recommended books for SQL 2005.&nbsp; For SQL 2000, the first book =
you need=20
to purchase and memorize is "Inside SQL Server 2000" by Kalen=20
Delaney.</FONT></DIV><FONT face=3DArial size=3D2>
<DIV><BR>-- <BR>Geoff N. Hiten<BR>Senior SQL Infrastructure=20
Consultant<BR>Microsoft SQL Server MVP</DIV>
<DIV>&nbsp;</DIV>
<DIV></FONT>&nbsp;</DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Mike" &lt;<A=20
=
href=3D"mailto:Mike@community.nospam.com">Mike@community.nospam.com</A>&g=
t;=20
wrote in message <A=20
=
href=3D"news:%238028SLFIHA.484@TK2MSFTNGP06.phx.gbl">news:%238028SLFIHA.4=
84@TK2MSFTNGP06.phx.gbl</A>...</DIV>
<DIV><FONT size=3D2>Thanks, </FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>So far I am able to restore databases and restore =
the entire=20
server in case of failure (had to do this last week actually and it =
wasn't a=20
test.)</FONT></DIV>
<DIV><FONT size=3D2>So bringing the db backup isn't an issue for me =
(it was=20
prior to last week.) I'm actually backing up all the databases to a =
NAS device=20
instead of the local box as all the database servers were doing, so if =
the=20
server died they lost the databases as well. So I fixed that portion =
of the=20
problem.</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>I do see this as an opportunity and a way to span =
my=20
skillset, but also, I don't want to 'fail'. I'm actaully looking at =
some books=20
online now, can you recommend any good books for a developer turning=20
DBA?</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Geoff N. Hiten" &lt;<A=20
=
href=3D"mailto:SQLCraftsman@gmail.com">SQLCraftsman@gmail.com</A>&gt; =
wrote in=20
message <A=20
=
href=3D"news:Oyq5PHLFIHA.4748@TK2MSFTNGP06.phx.gbl">news:Oyq5PHLFIHA.4748=
@TK2MSFTNGP06.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>You are not the first person to =
have such an=20
"opportunity" dumped in their lap.&nbsp; Treat it as a real =
opportunity to=20
grow your skills and resposibilities.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>The first job of a DBA is to =
protect your=20
company's data.&nbsp; Make sure you can restore or replace&nbsp;a =
system no=20
matter what.&nbsp;&nbsp; Verify and test your recovery =
strategy.&nbsp;=20
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>FULL recovery, coupled with log =
backups, will=20
allow you to recover a database to a "point-in-time" of your =
choosing.&nbsp;=20
SIMPLE recovery only allows you to revocer to the last full =
backup.&nbsp; I=20
suggest you read the section in BOL (Books Online, the FM part of =
RTFM) on=20
backup nd recovery.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>After you can guarantee data =
recovery that is=20
appropriate for each database, then start looking at performance, =
capacity=20
planning, upgrading, etc.&nbsp; </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Definitely get a book budget and =
start=20
reading.&nbsp; If your employer won't do that, then you are just =
being set=20
up for failure.&nbsp; </FONT></DIV><FONT face=3DArial size=3D2>
<DIV><BR>-- <BR>Geoff N. Hiten<BR>Senior SQL Infrastructure=20
Consultant<BR>Microsoft SQL Server MVP</DIV>
<DIV>&nbsp;</DIV>
<DIV></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV>"Mike" &lt;<A=20
=
href=3D"mailto:Mike@community.nospam.com">Mike@community.nospam.com</A>&g=
t;=20
wrote in message <A=20
=
href=3D"news:OmnVIsKFIHA.280@TK2MSFTNGP03.phx.gbl">news:OmnVIsKFIHA.280@T=
K2MSFTNGP03.phx.gbl</A>...</DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV><FONT size=3D2>I'm kind of in a 'pickle' here. Let me start =
by saying=20
I'm no DBA, that I'm a developer that was just put into the DBA =
role a few=20
months back when the actaul DBA person left and so now, I'm =
assigned his=20
remaining tasks for the year and I'm kind of stuck on some of them =
and=20
looking for some help.</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>one of his tasks is to optimize the SQL =
servers across=20
the board, </FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>1) I noticed on one of the servers the .LDF is =
large,=20
almost 3 mb, and almost bigger then the actual DB, is there a way =
to=20
shrink it down in size, or designate a max size of that =
file?&nbsp; What=20
is the actual LDF file?</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>2) On some of the servers the databases are =
set to a=20
'Simple' recovery mode and some are set to Full. What is the =
differenece=20
and what is the preferred way?</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>Currently all of the database servers are SQL =
2000 and=20
I'm looking to upgrade them to SQl 2005 shortly</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>Someone mentioned to me that you can split the =
database=20
files, what does that mean? Store the .mdf and .ldf files in =
different=20
locations?</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>Again, I'm not a DBA and I'm learning as I go =
and so far=20
I've been successful in the remaining former DBA tasks but some =
I'm=20
getting stuck on and not sure how to go about it. </FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>any help is=20
=
apprecaited.</FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></=
HTML>

------=_NextPart_000_00B1_01C81496.AC264BE0--

Date parsed: 22/10/2007 06:36:56
Date: Mon, 22 Oct 2007 10:36:56 -0400

Thanks, yeah our cases are similiar but different

our dba left
our systems are non critical apps, so the db can be down for a day or two
(though I'm not doing that, if its down I want it back up and running
quickly)

I've been doing some stuff with SQL 2000 and SQL 2005 as a developer and at
a developer level and not a true DBA level, but I'll be reading more in
depth on the books I have and doing more reading in the SQL newsgroups.




"SQL BI CI GUY" <aymantg@gmail.com> wrote in message
news:1193062801.665263.168090@e9g2000prf.googlegroups.com...
> I'm in a similar situation. Our company has a small IT Department.
> There is only one DBA and our systems are mission critical, running
> 24/7 with no option to crash! Anyways, my boss, the DBA, suggested
> that I take some classes (the microsoft ones for the DBA track) and
> said that the company would pay for them. However, there was a catch,
> we would have to wait for grant money. Meanwhile, I didn't want to
> look like a donkey so I went ahead and purchased 3 books from
> Microsoft Press. They are the training kit books for the exams
> 70-431, 70-443, 70-444 (basically the MCITP DBA track). I registered
> for this google group as well as others. Did reading online in my
> spare time at work. Continued to do what I was hired for at a faster
> pace (db development and reporting basically) so that I would have
> some time to explore SQL server more and show that I'm getting the
> work done. Here I am, I'm completely for one server (not a production
> critical one but it is our archive/reporting server which is
> important). I assist as a "DBA" with regards to the other servers,
> making sure replication is still working, etc. I get to suggest
> upgrade methods and technologies based on my studies and research. So
> really the team has come to depend on me more now, and I'm technically
> at the "DBA" position. The main advantage I have over you however is
> that we still have our DBA and I'm kind of shadowing him. However, I
> don't have that much db experience, I graduated college 2 years ago.
> I think you can benefit by getting a collection of easy to use books
> like the self-paced training kit I mentioned which gives you hands on
> experience. Maybe you could eventually keep that DBA position, you
> never know. I would advise you to get those books, and install the
> version of SQL provided to start playing around in an area where you
> can make and break things at will. It really helped me a lot and like
> I said, now my advise is sought when it comes to SQL Server 2005
> upgrades, installs, etc.
>
> Hope that helps.
>
> http://www.amazon.com/Self-Paced-Training-70-431-70-443-70-444/dp/0735623775/ref=pd_bxgy_b_img_b/105-5703406-7753224
>
> Put out $90 for that and you could keep that promotion.
>

Date parsed: 22/10/2007 07:41:31
Date: Mon, 22 Oct 2007 11:41:31 -0400

thanks, thats kind of were I'm at, I'm not a true DBA but I can create new
database, triggers, indexes, stored procedures, security, etc. Its the
performance, recovery models, replication, etc I'm new at.






"SQL BI CI GUY" <aymantg@gmail.com> wrote in message
news:1193064363.740081.50900@k35g2000prh.googlegroups.com...
>
> Check out those Microsoft Books I listed, they're more than decent. If
> you are a good SQL Developer then you should have a good foundation.
> The DBA skill set can mostly be done through the tools provided by
> Microsoft. It's not as simple as ABC, but anyone with a good
> understanding of the core fundamentals of DBs, and has experience,
> should be able to grasp it.
>

Date parsed: 23/10/2007 00:27:57
Date: Mon, 22 Oct 2007 21:27:57 +0300

In my previous post, I just wanted to stress the point. And I see that you
already know about the story.

I hope the links and info I gave is useful to you.

You may keep asking anytime. There are a lot of people here who are willing
to share their experiences and knowledge. Your questions are welcome.

--
Ekrem Önsoy



"Mike" <Mike@community.nospam.com> wrote in message
news:uHx9PKLFIHA.4140@TK2MSFTNGP03.phx.gbl...
> I'm not underestimating a DBA's work load, Its just I don't want to do it
> nor have I ever done DBA work.
> I was thrown into the slot for now and maybe for the future. So I'm
> learning as I go with it and so far its been good, no major issues at all.
> I've upgraded several servers to SQL 05 and had no issues, its just now
> I'm in the performance/optimizing phase of it and I'm not sure how to go
> about it all, so I'm asking some questions about it all.
>
>
>
>
>
>
> "Ekrem Önsoy" <ekrem@btegitim.com> wrote in message
> news:9CD3A11B-803A-4227-B2D7-8A69ED8564B0@microsoft.com...
>> My friend is right, you should not underestimate a DBA's tasks...
>>
>> However, you can learn more about Files and Filegroups from the following
>> link:
>> http://msdn2.microsoft.com/en-us/library/aa933064(SQL.80).aspx
>>
>> Recovery Models:
>> http://msdn2.microsoft.com/en-us/library/aa173678(SQL.80).aspx
>>
>> First, you should take transaction log's backup to reduce it's size using
>> "shrinkfile" command. Taking backup will clear the passive virtual log
>> records in the ldf and shrink will reduce the size of the ldf roughly.
>>
>> You may want to read an article about Shrinking by Tibor:
>> http://www.karaszi.com/SQLServer/info_dont_shrink.asp
>>
>> --
>> Ekrem Önsoy
>> http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
>> MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT
>>
>>
>>
>> "Mike" <Mike@community.nospam.com> wrote in message
>> news:efCih5KFIHA.4748@TK2MSFTNGP06.phx.gbl...
>>> Right now hiring a DBA is not an option (hence the reason I'm doing it
>>> for now) and so far I'm able to do about 90% of the task list that is
>>> remaining, but now I'm onto the performance, optimization piece of the
>>> list.
>>>
>>>
>>>
>>>
>>> "Hate_orphaned_users" <Hateorphanedusers@discussions.microsoft.com>
>>> wrote in message
>>> news:BF18888E-7D6A-47FB-8716-9853125E6C74@microsoft.com...
>>>> Tell youre boss to hire a real DBA . If you ask such simple questions .
>>>> i
>>>> fear for the upcoming upgrade.
>>>>
>>>> Don't get me wrong. It's good that you wan't to learn it.
>>>> In my opinion the compnay uses you to fill in a function you are not
>>>> really
>>>> ready for.
>>>> Not youre fault.They underestimate the knowledge you need to be a DBA.
>>>>
>>>>
>>>
>>>
>>
>
>