INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Microsoft SQL Server: Setup and Administration FAQ Index

FAQ Index

Backups

FAQ Title Author Date Rating/#
Backing up your database and keeping multiple copies around.  faq962-5722 mrdenny 19 Mar 10 9.3 / 7
How do I automate the backups of my Databases and Transaction Logs?   faq962-3646 ecobb 1 Jul 03 6.2 / 13
How to write your own Log Shipping  faq962-5754 mrdenny 12 Apr 06 9.8 / 6
SQL Server Backups - Frequently Asked Questions and Best Practices  faq962-5742 Catadmin 11 Mar 05 9.4 / 5
 

Encryption

FAQ Title Author Date Rating/#
Sample SQL 2005 Encryption Code   faq962-5964 mrdenny 6 Jul 05 10.0 / 1
 

Enterprise Manager

FAQ Title Author Date Rating/#
Enterprise Manager has Application Error on Startup   faq962-5746 Catadmin 11 Mar 05 7.0 / 1
How do I change the account Enterprise Manager uses to access SQL Server?   faq962-3685 ecobb 5 Jun 03 10.0 / 1
My SQL Server log files keep showing "Starting up database", how do I correct this?   faq962-3690 ecobb 21 Jun 03 7.5 / 6
 

General Information

FAQ Title Author Date Rating/#
A Guide to SQL Severity and Error levels.  faq962-6652 ptheriault 21 May 07 --
Custom Version of sp_who2 called sp_who3  faq962-6561 mrdenny 15 Oct 07 10.0 / 2
Deciding the best disk configuration for your SQL Server  faq962-5747 mrdenny 1 Jun 05 9.0 / 30
SQL Server 2005 Books Online: Download & Internet Site   faq962-6514 Catadmin 17 Jan 07 10.0 / 1
SQL Server Version Differences   faq962-4344 JayKusch 24 Oct 03 7.8 / 4
Stopping other Services from starting until SQL Server is running   faq962-5509 mrdenny 5 Nov 04 1.0 / 1
Submitting ideas for SQL Design features   faq962-6459 Catadmin 7 Nov 06 --
Troubleshooting Connections to SQL Server  faq962-5481 mrdenny 9 Feb 05 5.7 / 12
 

Licensing

FAQ Title Author Date Rating/#
Finding the number of SQL Licenses in use  faq962-5480 mrdenny 19 Oct 04 10.0 / 1
Help deciding how to license your SQL server  faq962-5153 mrdenny 6 Feb 08 9.3 / 10
 

Mail Configuration

FAQ Title Author Date Rating/#
How do I setup my SQL Server to use outlook to send and receive mail?   faq962-4452 mrdenny 19 Nov 03 5.1 / 8
 

Maintaining Indexes

FAQ Title Author Date Rating/#
Setup a configurable Re-Index Solution   faq962-5367 hmckillop 10 Aug 04 9.0 / 1
 

Recovery

FAQ Title Author Date Rating/#
Recovering From A Suspect Database   faq962-4210 JayKusch 22 Sep 03 8.7 / 6
Recovering when LDF is lost/corrupted   faq962-6260 Jamfool 23 Mar 06 --
ReEstablish SQL Server after Physical Server Name Change   faq962-4395 JayKusch 5 Nov 03 8.0 / 4
 

Replication

FAQ Title Author Date Rating/#
How to Move a Database That is Configured for Snapshot Replication   faq962-6057 JohnBates 15 Sep 05 --
Using Service Broker to update a Reporting Database in Real Time   faq962-6581 mrdenny 23 Feb 07 --
 

Synchronizing Servers

FAQ Title Author Date Rating/#
Database Mirroring for Newbies in SQL 2005   faq962-6755 Stevehewitt 17 Oct 07 9.0 / 1
How do you keep SQL logins and pw's synched between servers?   faq962-3374 Flloyd 25 Mar 03 8.3 / 3
 

User Management

FAQ Title Author Date Rating/#
How to audit the failed logons?   faq962-5777 maswien 26 Mar 05 --
How to find out what roles a user has.   faq962-5411 mrdenny 31 Aug 04 10.0 / 1
How to Mirgrate logins from one server to another.  faq962-6608 ptheriault 15 Jun 07 --
 

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close