Hi,
I recently joined a small company as a DBA.
I have a situation,my company has one Server which is an application server windows Server 2003, and having SQL Server 2005 instance .
The SQL Server contains around 83 databases. The problem here is most of the databases are running out of space and my company wanted to add the space, but they cannot take down the server even for a minute.
Most of the databases are set up on SIMPLE recovery model and it seems that they are not setup properly for backup and recovery. Also the previous person who worked here did not set up for backup and transaction log and differential back ups failed every time.
Can someone please tell me how to add the space without taking down the server. Also this server is not clustered so I cant use clustering services.
that server up and running.
Please suggest the possible solutions.
I would be grateful if someone suggest solution which would be easy to execute. The company can have one standby server.