1
vote
1answer
52 views

Sql Server - Minimum rights to be able to grant other people similar rights

I would like to grant someone on our web dev team the ability to grant other users (other web developers as well as application users they create) datareader, datawriter, and exec sproc in our Dev and ...
0
votes
2answers
119 views

The Transactional Log is Full

I am getting below error. The transaction log for database 'CRM_QA_V6' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases likely ...
3
votes
4answers
169 views

Moving SQL Server database from old production server to new server

We had single production server for website and SQL Server database. We have plan to have a new production server for website and SQL Server. We need to move the SQL Server database from the old ...
0
votes
1answer
125 views

SQL server port is blocked on client machine [duplicate]

Possible Duplicate: SQL server port is blocked on client machine I have a client machine on which sql server is installed. This machine is using the internet though a proxy machine. On the ...
1
vote
1answer
493 views

sp_reset_connection taking a long time to run

I've got an application where all the sprocs are running nice and quick, but the sp_reset_connection calls between them are taking anything up to 20 seconds. I've looked at locking and blocking but ...
6
votes
3answers
6k views

Becoming a DBA, what do I need to know?

Im sure this has been asked, but times change and so do SQL preferences etc... I figure this place would be the best place to ask this im sure many DBA's come here. But what do I need to know ...
0
votes
2answers
256 views

shrink database or file

Does anyone know the diff between shrink database or file? and what would the pros and cons? in what circumstances you wish to do either one? thanks
0
votes
1answer
219 views

Does index fill factor become meaningless on large tables?

At work we have a 250GB database with several very large tables. One of the maintenance plans that runs every 48 hours performs a reindex on all tables. This takes about four hours, and is currently ...
6
votes
3answers
373 views

when is it time to hire another SQL Server DBA?

Been searching the web and asking my contacts, but other than some opinions, I'm not finding any kind of numbers nor matrix nor formula to guide on when it's time to add another DBA. Are there any ...
0
votes
3answers
542 views

sql server 2005 instance unresponsive and all db's are 'in recovery'

we've got a sql server 2005 instance that one of our guys messed up, i believe they killed the sql server service and restarted the computer, and when it came back all of our databases are "in ...
1
vote
1answer
920 views

“Classic” activity monitor in SQL Server Management Studio 2008?

Right now I'm using SQL Server Management Studio 2005 to manage all my SQL servers (2000, 2005, 2008). I'd love to be able to take advantage of all the cool new features in SSMS 2008, the only thing ...
6
votes
5answers
412 views

What proportion of DBA skills are platform-independent?

Problem: we've grown to the point where we need a real DBA. Real DBAs are hard to find. Possible solution: I know someone with extensive experience (currently working on MSSQL) who is looking for a ...
0
votes
1answer
83 views

SQL Server 2000 Backups Not Writing to Local Disk

I have several databases on a server. This is the only database backup that fails. It fails from maintenance plans (full backup and transaction log backups) It fails from T-SQL BACKUP commands. ...
1
vote
7answers
152 views

SQL Environment Backup Question

DBAs out there, We have a SQL environment that needs a backup solution upgrade, and we are looking for some input from the community. There are 8DBs spread across 4 servers total in 100GB of size, ...
3
votes
8answers
378 views

Should a DBA store and retrieve passwords

Should a DBA record passwords for application logins, or should this be a responsibility of developers/analysts? By application login, I mean the login which an application uses for access to the ...
2
votes
2answers
1k views

Can't see progress of rolling back SPID with KILL WITH STATUSONLY

I have a SPID on SQL 2005 that shows in Activity Monitor as "ROLLBACK" mode (because a transaction log filled up, not because it was manually killed). I tried to see how much time it has left to roll ...
3
votes
2answers
1k views

Skip log backup if full backup is running

On some of my SQL2000 servers, I have occasional blocking and weird conflicts between our full backup and log backup jobs. Based on The answers to this SF question, I need to figure out how to prevent ...
1
vote
3answers
3k views

Recovering a specific job definition from an MSDB backup?

We've been asked to recover a specific SQL 2005 job from how it existed at a certain time in the past. We have MSDB database backups from that time period, but I can't overwrite the current MSDB ...
7
votes
3answers
7k views

Current wisdom on SQL Server and Hyperthreading?

Lots of articles out there (see Slava Oks's original SQL 2000 article and Kevin Kline's SQL 2005 update) recommend disabling hyperthreading on SQL servers, or at least testing your specific workload ...
3
votes
4answers
5k views

Does restoring a SQL database from backup rebuild its indexes?

Does restoring a SQL database from backup rebuild its tables and indexes from scratch? Or does it keep it in the same internal physical order it was in at the time of backup? We're using SQL 2000 ...
16
votes
6answers
7k views

SQL Database physical file fragmentation

I know that there are really three kinds of fragmentation that I need to be concerned about as a DBA: Index Fragmentation in the SQL data files, including clustered index (table) fragmentation. ...
10
votes
6answers
12k views

How does changing Windows SID affect SQL Server?

Our Windows admins have identified an issue with the way that they clone OS. Apparently, some of the cloned servers end up with the same SID at the OS level. I hear MSFT doesn't support computers that ...
16
votes
6answers
953 views

Resources for the accidental DBA

Within the Microsoft platform, most of the enterprise level programs (SharePoint, any of the System Center apps, any of the Dyamics apps, etc) all run on top of SQL Server. For administrators of ...
4
votes
4answers
3k views

SQL transaction log backups conflicting with full backups?

On our SQL servers (2000, 2005, and 2008), we run full backups once a day in the evening, and transaction log backups every 2 hrs. We haven't really worried about these two processes conflicting, but ...
1
vote
2answers
635 views

How to remove dead SQL Server registrations from SQL Server 2000 Enterprise Manager?

We had some databases decommissioned recently, and my SQL Server 2000 Enterprise Manager still shows the server group I originally created containing those servers. I tried deleting the entire server ...
7
votes
8answers
561 views

SQL Server performance triage? [closed]

If you get a call/page about a SQL server performance issue, what do you do first? Start a trace? Pop up Perfmon? Open activity monitor? Each of these are useful tools, but what's your "sequence" of ...