The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
2answers
43 views

MSSQL-Server: rebuild vs reorganize Index and Update Statistics

We had a database which was very slow (MS SQL SERVER). Now we figured out, that the indexes were never rebuild oder reorganised. (At the moment it is not clear if this really was the problem but we ...
0
votes
1answer
22 views

MS-SQL Server Implicit_transaction on table

I'm trying to experiment with implicit_transaction on sql server. However, after executing: SET IMPLICIT_TRANSACTIONS ON; INSERT INTO [Interface].[dbo].[Log] ([String], [Time], [theUser]) VALUES ...
1
vote
1answer
54 views

What maintenance tasks should I run on my MS-SQL 2008/2012 servers?

The servers are using database mirroring for high-availability running SQL server standard on newer hardware. The existing plans were setup by a DBA many years ago and are using the built in ...
1
vote
1answer
56 views

Azure SQL Data Sync between SQL Azure and Azure VM

I used two have 2 SQL Azure databases and they were automatically synced using this service: http://www.windowsazure.com/en-us/documentation/articles/sql-database-get-started-sql-data-sync/ Now one ...
1
vote
1answer
36 views

SQL: name without a login name

I have noticed that when I open SQL server enterprise manager and I navigate to the list of users under a specific DB, I found users with"Name" but some have no "Login Name" value. What does this ...
0
votes
1answer
62 views

SQL Server 2012 Management Studio Connect after some time (File not found error)

I've a root server with Window Server 2008 R2 where MS SQL Server 2012 is installed. Get a error while connecting. Management Studio Error Message File not found This error only occur directly after ...
1
vote
1answer
220 views

MSSqlServer 2008 how to migrate sys.message to another server ? (eventID 18054)

Recently I've replaced a sql server (2008R2). I've reinstalled hosted apps and restored backups of databases. All seems to work as expected except that these events are shown in the eventlog : id ...
0
votes
1answer
178 views

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
230 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
2k 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
3answers
138 views

Server Monitoring Options [duplicate]

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
117 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
3k 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
176 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
81 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
238 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
644 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
555 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.
1
vote
3answers
2k 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
349 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
87 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 ...