MS SQL Server - sqlserver start fails because db model is in the middle of a restore

Author

sqlserver start fails because db model is in the middle of a restore

Tobias@Olbort.de

2005-12-31, 11:23 am

Hello,

i've problem with a sqlserver use by Symantec/Veritas Backup Exec.

Because of a wrong setting within Backup Exec, databases are marked for
restore and the server won't start with a error.

I succeed starting the server with the traceflag 3807. After that the
setting for restore in sysdatabases should set to 0. But I cannot log
into the server, because I don't know the passwort for the sa, because
this is set from Backup Exec.

Can anybody help me with this problem. Is there a traceflag which
resets the restore setting of a database permanently on startup?

Thanks
Tobias

John Bell

2005-12-31, 11:23 am

Hi Tobias

I assume the trace flag was 3607 and not 3807?

If you have mixed mode authentication you may want to try logging on as a
local administrator and logging on to sql server with windows
authentication. You should then be able to change the sa password.

If space is available you may want to change the backup strategy so that you
back up to disc and then to tape as this will remove the need for the backup
agents.

John

<Tobias@Olbort.de> wrote in message
news:1136045272.817634.224990@g43g2000cwa.googlegroups.com...
> Hello,
>
> i've problem with a sqlserver use by Symantec/Veritas Backup Exec.
>
> Because of a wrong setting within Backup Exec, databases are marked for
> restore and the server won't start with a error.
>
> I succeed starting the server with the traceflag 3807. After that the
> setting for restore in sysdatabases should set to 0. But I cannot log
> into the server, because I don't know the passwort for the sa, because
> this is set from Backup Exec.
>
> Can anybody help me with this problem. Is there a traceflag which
> resets the restore setting of a database permanently on startup?
>
> Thanks
> Tobias
>

Michael Hotek

2005-12-31, 8:23 pm

As long as you have not removed local admins from the SQL Server, you can
always created a "trusted connection" to a SQL Server if you have Windows
admin authority.

--
Mike
Mentor
Solid Quality Learning
http://www. solidqualitylearning
.com

<Tobias@Olbort.de> wrote in message
news:1136045272.817634.224990@g43g2000cwa.googlegroups.com...
> Hello,
>
> i've problem with a sqlserver use by Symantec/Veritas Backup Exec.
>
> Because of a wrong setting within Backup Exec, databases are marked for
> restore and the server won't start with a error.
>
> I succeed starting the server with the traceflag 3807. After that the
> setting for restore in sysdatabases should set to 0. But I cannot log
> into the server, because I don't know the passwort for the sa, because
> this is set from Backup Exec.
>
> Can anybody help me with this problem. Is there a traceflag which
> resets the restore setting of a database permanently on startup?
>
> Thanks
> Tobias
>

Sponsored Links