0
votes
1answer
154 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 ...
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
218 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 ...
0
votes
2answers
86 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 ...