need book reccommendation

I have just accepted a new position where a new role of mine will be
managing SQL servers. I don't need to know how to write code and what have
you, just set up databases and admin type stuff. Can someone please
reccommend a book that I can read to get me familiar with terms and
procedures. I just need to develope a good understanding as quick as
possible. Thanks
Brandon Baker
A+, Net+, MCSA, MCSE
Others will have some actual text recommendations, but I firmly believe the
best reference anywhere is Books Online, which is installed as part of the
client tools along with SQL Server.
Or, you can view online here:
http://msdn.microsoft.com/library/de...start_4fht.asp
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Brandon Baker" <mrmoneymatters@.nospam.postalias> wrote in message
news:OXXq5073FHA.3292@.tk2msftngp13.phx.gbl...
>I have just accepted a new position where a new role of mine will be
>managing SQL servers. I don't need to know how to write code and what have
>you, just set up databases and admin type stuff. Can someone please
>reccommend a book that I can read to get me familiar with terms and
>procedures. I just need to develope a good understanding as quick as
>possible. Thanks
> --
> Brandon Baker
> A+, Net+, MCSA, MCSE
>
|||"Brandon Baker" <mrmoneymatters@.nospam.postalias> wrote in
news:OXXq5073FHA.3292@.tk2msftngp13.phx.gbl:

> I have just accepted a new position where a new role of mine will be
> managing SQL servers. I don't need to know how to write code and what
> have you, just set up databases and admin type stuff. Can someone
> please reccommend a book that I can read to get me familiar with terms
> and procedures. I just need to develope a good understanding as quick
> as possible. Thanks
Perhaps SQL Server 2000 Administrators Companion is what you look for. At
least I'm glad to have it in my bookshelf.
Ole Kristian Bangs
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging
|||"Brandon Baker" <mrmoneymatters@.nospam.postalias> wrote in message
news:OXXq5073FHA.3292@.tk2msftngp13.phx.gbl...
> I have just accepted a new position where a new role of mine will be
> managing SQL servers. I don't need to know how to write code and what have
> you, just set up databases and admin type stuff. Can someone please
> reccommend a book that I can read to get me familiar with terms and
> procedures. I just need to develope a good understanding as quick as
> possible. Thanks
> --
> Brandon Baker
> A+, Net+, MCSA, MCSE
I've found this book invaluable: Microsoft SQL Server 2000 DBA Survival
Guide, Second Edition (Paperback)
by Mark Spenik, Orryn Sledge

need book reccommendation

I have just accepted a new position where a new role of mine will be
managing SQL servers. I don't need to know how to write code and what have
you, just set up databases and admin type stuff. Can someone please
reccommend a book that I can read to get me familiar with terms and
procedures. I just need to develope a good understanding as quick as
possible. Thanks
Brandon Baker
A+, Net+, MCSA, MCSEOthers will have some actual text recommendations, but I firmly believe the
best reference anywhere is Books Online, which is installed as part of the
client tools along with SQL Server.
Or, you can view online here:
http://msdn.microsoft.com/library/d...r />
_4fht.asp
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Brandon Baker" <mrmoneymatters@.nospam.postalias> wrote in message
news:OXXq5073FHA.3292@.tk2msftngp13.phx.gbl...
>I have just accepted a new position where a new role of mine will be
>managing SQL servers. I don't need to know how to write code and what have
>you, just set up databases and admin type stuff. Can someone please
>reccommend a book that I can read to get me familiar with terms and
>procedures. I just need to develope a good understanding as quick as
>possible. Thanks
> --
> Brandon Baker
> A+, Net+, MCSA, MCSE
>|||"Brandon Baker" <mrmoneymatters@.nospam.postalias> wrote in
news:OXXq5073FHA.3292@.tk2msftngp13.phx.gbl:

> I have just accepted a new position where a new role of mine will be
> managing SQL servers. I don't need to know how to write code and what
> have you, just set up databases and admin type stuff. Can someone
> please reccommend a book that I can read to get me familiar with terms
> and procedures. I just need to develope a good understanding as quick
> as possible. Thanks
Perhaps SQL Server 2000 Administrators Companion is what you look for. At
least I'm glad to have it in my bookshelf.
Ole Kristian Bangs
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging|||"Brandon Baker" <mrmoneymatters@.nospam.postalias> wrote in message
news:OXXq5073FHA.3292@.tk2msftngp13.phx.gbl...
> I have just accepted a new position where a new role of mine will be
> managing SQL servers. I don't need to know how to write code and what have
> you, just set up databases and admin type stuff. Can someone please
> reccommend a book that I can read to get me familiar with terms and
> procedures. I just need to develope a good understanding as quick as
> possible. Thanks
> --
> Brandon Baker
> A+, Net+, MCSA, MCSE
I've found this book invaluable: Microsoft SQL Server 2000 DBA Survival
Guide, Second Edition (Paperback)
by Mark Spenik, Orryn Sledge

need book reccommendation

I have just accepted a new position where a new role of mine will be
managing SQL servers. I don't need to know how to write code and what have
you, just set up databases and admin type stuff. Can someone please
reccommend a book that I can read to get me familiar with terms and
procedures. I just need to develope a good understanding as quick as
possible. Thanks
--
Brandon Baker
A+, Net+, MCSA, MCSEOthers will have some actual text recommendations, but I firmly believe the
best reference anywhere is Books Online, which is installed as part of the
client tools along with SQL Server.
Or, you can view online here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/startsql/getstart_4fht.asp
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Brandon Baker" <mrmoneymatters@.nospam.postalias> wrote in message
news:OXXq5073FHA.3292@.tk2msftngp13.phx.gbl...
>I have just accepted a new position where a new role of mine will be
>managing SQL servers. I don't need to know how to write code and what have
>you, just set up databases and admin type stuff. Can someone please
>reccommend a book that I can read to get me familiar with terms and
>procedures. I just need to develope a good understanding as quick as
>possible. Thanks
> --
> Brandon Baker
> A+, Net+, MCSA, MCSE
>|||"Brandon Baker" <mrmoneymatters@.nospam.postalias> wrote in
news:OXXq5073FHA.3292@.tk2msftngp13.phx.gbl:
> I have just accepted a new position where a new role of mine will be
> managing SQL servers. I don't need to know how to write code and what
> have you, just set up databases and admin type stuff. Can someone
> please reccommend a book that I can read to get me familiar with terms
> and procedures. I just need to develope a good understanding as quick
> as possible. Thanks
Perhaps SQL Server 2000 Administrators Companion is what you look for. At
least I'm glad to have it in my bookshelf.
--
Ole Kristian Bangås
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging|||"Brandon Baker" <mrmoneymatters@.nospam.postalias> wrote in message
news:OXXq5073FHA.3292@.tk2msftngp13.phx.gbl...
> I have just accepted a new position where a new role of mine will be
> managing SQL servers. I don't need to know how to write code and what have
> you, just set up databases and admin type stuff. Can someone please
> reccommend a book that I can read to get me familiar with terms and
> procedures. I just need to develope a good understanding as quick as
> possible. Thanks
> --
> Brandon Baker
> A+, Net+, MCSA, MCSE
I've found this book invaluable: Microsoft SQL Server 2000 DBA Survival
Guide, Second Edition (Paperback)
by Mark Spenik, Orryn Sledge

Need a sysadmin login

We’re running mixed mode authentication on our SQL Servers.To make the server “safer” builtin\admininstrators no longer have sysadmin role on the sql server.If there is only one login with sysadmin role, and we lose track of the password, is there any way to recover it?How could we reset the password or create a new sa account with a new password?This situation has not occurred, but I’m worried about how to recover from it should it occur.This question relates to SQL 2000 and SQL 2005.

David Zokaites,

DBA & Software Engineer

If you deleted the users and have no available sysadmin user you will be locked out of your server for the sysadmin work. Therefore I always suggest to create a user which is not used and only available for these scenarios. Depending on the kind of security level the password can be stored somewhere in a safe or at a secure place.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Jens,

Thanks for the information. I thought the scenario might lock me out of sysadmin on the sql server. I will certainly make sure we have a secondary sysadmin account to prevent such a disaster.

David

|||

Jens is right as far as SQL Server 2000 is concerned. For SQL Server 2000, you can get locked out; if that would happen, you can recover other databases than master by reattaching them on a different SQL Server instance.

However, in SQL Server 2005, by restarting the server in single-user mode, a local administrator can get access to SQL Server as a sysadmin, so you cannot get yourself locked out of the SQL Server instance.

Thanks
Laurentiu