The mssql-maintenance tag has no wiki summary.
0
votes
1answer
43 views
+50
MBSA fails MSSQL folder permissions because MSSQL$SQLEXPRESS has access
I am not sure what exactly it's expecting. If you remove this user the check passes, but the server fails.
How can it be resolved so the check passes, yet it has the limited permissions MBSA is ...
0
votes
1answer
109 views
SQL Server database refuses to back up to USB disk
I have few databases on a SQL Server 2005/WS 2003 platform, and I have a curious situation that has arisen.
I have been manually backing up the databases to a USB hard disk until about a week ago ...
2
votes
4answers
1k views
Windows Server 2008 R2 + MSSQL Server R2 crashes once a week, suggestions?
Can someone give me pointers where to look in order to debug why this fresh install of Windows Server 2008 R2 with an untweaked MS SQL-Server R2 which is serving just one ~5GB db to 2 clients crashes ...
-1
votes
2answers
112 views
Server Monitoring Options
I'm trying to find the best way to monitor my MS SQL server. I have been using pingdom for my web server and want to look at something else. I have done a lot of googleing but they all seem to be the ...
1
vote
1answer
106 views
Removed SQLServerAgent account What should I do ?
I have removed by accident SQLServerAgent account and now I cant get access to the database. Connecting from management studio throws me error 26 and system log shows: SQLServerAgent could not be ...
12
votes
3answers
1k views
DBA who is worried reorganizing or rebuidling indexes may cause data loss?
We have some databases with index fragmentation that is > 95%. As best I can tell the indexes have never been rebuilt much less reorganized. In years.
(In fairness, these tables do seem to have ...
0
votes
3answers
163 views
MSSQL Certification 70-432
I work for a small software company and once I'm certified in implementing and maintaining MSSQL, I have the opportunity to move over to implementation from support.
My question is what do you ...
0
votes
1answer
78 views
advice on database index maintenance
I have a fairly large table, which I have to keep up, with some very, very fragmented indices. This seems to be causing problems with performance. I would like to have neat fresh crisp indices on this ...
0
votes
3answers
177 views
MSSQL2005 database hanging during maintenance
Our database server has a maintenance plan which runs each night:
Back up databases & logs (10-20GB max)
Check Database Integrity
Rebuild Indexes
Update Statistics
Normally this all executes ...
2
votes
7answers
534 views
MSSQL Server 10 runaway log growth, 100GB/week
I have started as an IT Manager and my remit covers MSSQL server. A database that I have inherited uses around 100GB of HD in the space of a week, in the LDF file. This in turn uses all available disk ...
0
votes
2answers
392 views
How to export a MSSQL table in MSSQL studio express 2005?
is there any way to export a table to a file without any additional tools? I can't install anything on that server.
0
votes
3answers
1k views
Error when trying to open SQL Maintenance Plan - SSMS 2008
If I open SSMS on my client machine, connect to our SQL server, and try and open a maintenance plan on there, I get this error:
TITLE: Microsoft SQL Server Management
Studio
Could not ...
1
vote
1answer
328 views
SQL restore from single file db to filegroup
I have a 180GB MOSS 2007 database whose maintenance (i.e. backups and restores) are becoming a problem. Part of the issue can be resolved by splitting the three content sites down into their own site ...
0
votes
2answers
85 views
Realtime MS SQL Database transfer
I have MS SQL 2005 Standard that is used actively (new data is added every minute).
I need to transfer it to another server (new hosting provider), without losing the data and without downtime.
Is ...
