Repair or Reinstall

Hi Peoples
Is their any way to preferably repair a sql server 2005 - specifically the
database services option. If not what is the best way for me to reinstall and
retain all the config?
_________________________
Adam Simmonds
Systems Administrator
Doesn't it depend on the nature of the problem you are trying to solve?
Linchi
"Adam Simmonds (SimAda00)" wrote:

> Hi Peoples
> Is their any way to preferably repair a sql server 2005 - specifically the
> database services option. If not what is the best way for me to reinstall and
> retain all the config?
> --
> _________________________
> Adam Simmonds
> Systems Administrator
|||Their is just a problem with it and our backup software, which we have
reinstalled. Im not to bothered about uninstalling and reinstalling sql. Was
just trying to see if their was a quick way ie a repair/reinstall option
rather than having to do it as 2 seperate stages.
_________________________
Adam Simmonds
Systems Administrator
"Linchi Shea" wrote:
[vbcol=seagreen]
> Doesn't it depend on the nature of the problem you are trying to solve?
> Linchi
> "Adam Simmonds (SimAda00)" wrote:
|||So what is the problem exactly? If there is an error message or log would
you share it with us? Or do you mind if you tell us about the problem?
Ekrem ?nsoy
"Adam Simmonds (SimAda00)" <AdamSimmondsSimAda00@.discussions.microsoft.com>
wrote in message news:4DB75A6F-E8EC-4E50-B9C0-67F1B42011EC@.microsoft.com...[vbcol=seagreen]
> Their is just a problem with it and our backup software, which we have
> reinstalled. Im not to bothered about uninstalling and reinstalling sql.
> Was
> just trying to see if their was a quick way ie a repair/reinstall option
> rather than having to do it as 2 seperate stages.
> --
> _________________________
> Adam Simmonds
> Systems Administrator
>
> "Linchi Shea" wrote:
|||Sorry i have been abit vague.
Basically we still had elements of sql2000 installed. so we uninstalled. and
as they had not all gone someone manually deleted all the remaining files
left in program files.
SQL2005 its self works fine, but our backup system seems to not be able to
backup databases while they are in use, but it is set to use VSS to snapshot
the databases while online for the backups. This stopped working a few weeks
ago . Either it is a update to our backup system. Which is unlikely as i have
jsut reinstalled that, and the problem still exists. So i think its somehting
to do with SQL server. but as the error just appears in the backup logs and
not on sql its a small pain to pinpoint
_________________________
Adam Simmonds
Systems Administrator
"Ekrem ?nsoy" wrote:

> So what is the problem exactly? If there is an error message or log would
> you share it with us? Or do you mind if you tell us about the problem?
> --
> Ekrem ?nsoy
>
> "Adam Simmonds (SimAda00)" <AdamSimmondsSimAda00@.discussions.microsoft.com>
> wrote in message news:4DB75A6F-E8EC-4E50-B9C0-67F1B42011EC@.microsoft.com...
>
|||I don't know which 3th party backup software you use however it seems that,
that backup software does not have "SQL Server Agent" module integrated with
it.
Third party backup softwares (Such as HP DataProtector) has their agents for
softwares like SQL Server, Exchange Server etc. You'll need "SQL Server
Agent" module for your backup software.
Also, if you are trying to backup database files (such as mdf, ndf, ldf
etc.) they can not be copied while they are in use (attached to) by a SQL
Server instance.
So, I think your problem is not about SQL Server itself; this problem must
be about lacking of SQL Server Agent for your backup software \ system
whatever it is.
Ekrem ?nsoy
"Adam Simmonds (SimAda00)" <AdamSimmondsSimAda00@.discussions.microsoft.com>
wrote in message news:5DDAD115-07AA-4F4A-9B5C-895A42EEF4F1@.microsoft.com...[vbcol=seagreen]
> Sorry i have been abit vague.
> Basically we still had elements of sql2000 installed. so we uninstalled.
> and
> as they had not all gone someone manually deleted all the remaining files
> left in program files.
> SQL2005 its self works fine, but our backup system seems to not be able to
> backup databases while they are in use, but it is set to use VSS to
> snapshot
> the databases while online for the backups. This stopped working a few
> weeks
> ago . Either it is a update to our backup system. Which is unlikely as i
> have
> jsut reinstalled that, and the problem still exists. So i think its
> somehting
> to do with SQL server. but as the error just appears in the backup logs
> and
> not on sql its a small pain to pinpoint
> --
> _________________________
> Adam Simmonds
> Systems Administrator
>
> "Ekrem ?nsoy" wrote: