Database 'model' corrupted

Hi, my 'model' database corrupted and my SQL Server 2005 Express can't be started.

I believe I have the SAME problem as his:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=455524&SiteID=1

but when I try the command start sqlservr.exe -c -T3608, an error message appeared:

"Your SQL Server installation is either corrupt of has been tampered

with (Error getting instance ID from name). Please uninstal then re-run

setup to correct this problem"

Well, the problem is that I have an ActiveBPEL database inside, and I really need a way without reinstalling it.

Any solution?

Thanks,

Edwin

Hi Edwin,

Although I can't really comment on your issue (as it would be quite hard to troubleshoot), if you un-install mssql, you will not lose your user databases - just retian the *.mdf/ldf files and re-attatch the databases after you have re-installed mssql.

Cheers

Rob

|||

The difference is that your Express installation is not a default instance of SQL.

Try starting sqlsrvr by explicitly specifying the instance name:

sqlservr.exe -s<ComputerName>$SQLEXPRESS -c -T3608

|||PLEASE help, i am getting the same error
"error getting instance ID from name"

but I just installed it, and I tried reinstalling already,
doing the sqlservr.exe -s.... did not work, it said the specified file name could not be found.|||

As it happens, I wrote a blog post on exactly this situation not long ago.

Although the way model got corrupted is different, the resolution applies.

http://blogs.msdn.com/sqlserverstorageengine/archive/2006/09/26/772550.aspx

sql

Database 'model' corrupted

Hi, my 'model' database corrupted and my SQL Server 2005 Express can't be started.

I believe I have the SAME problem as his:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=455524&SiteID=1

but when I try the command start sqlservr.exe -c -T3608, an error message appeared:

"Your SQL Server installation is either corrupt of has been tampered

with (Error getting instance ID from name). Please uninstal then re-run

setup to correct this problem"

Well, the problem is that I have an ActiveBPEL database inside, and I really need a way without reinstalling it.

Any solution?

Thanks,

Edwin

Hi Edwin,

Although I can't really comment on your issue (as it would be quite hard to troubleshoot), if you un-install mssql, you will not lose your user databases - just retian the *.mdf/ldf files and re-attatch the databases after you have re-installed mssql.

Cheers

Rob

|||

The difference is that your Express installation is not a default instance of SQL.

Try starting sqlsrvr by explicitly specifying the instance name:

sqlservr.exe -s<ComputerName>$SQLEXPRESS -c -T3608

|||PLEASE help, i am getting the same error
"error getting instance ID from name"

but I just installed it, and I tried reinstalling already,
doing the sqlservr.exe -s.... did not work, it said the specified file name could not be found.|||

As it happens, I wrote a blog post on exactly this situation not long ago.

Although the way model got corrupted is different, the resolution applies.

http://blogs.msdn.com/sqlserverstorageengine/archive/2006/09/26/772550.aspx

Database 'model' cannot be opened. It is in the middle of a restore

http://support.microsoft.com/kb/822852
how do i run this if my database is msde?I didn't see anything in the article which shouldn't work on msde except for replacing Query
Analyzer with OSQL.EXE.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"nobody" <nobody@.nobody.com> wrote in message news:Ow4degdMIHA.4476@.TK2MSFTNGP06.phx.gbl...
> http://support.microsoft.com/kb/822852
>
> how do i run this if my database is msde?
>

Database 'model' cannot be opened. It is in the middle of a restore

http://support.microsoft.com/kb/822852
how do i run this if my database is msde?I didn't see anything in the article which shouldn't work on msde except for
replacing Query
Analyzer with OSQL.EXE.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"nobody" <nobody@.nobody.com> wrote in message news:Ow4degdMIHA.4476@.TK2MSFTNGP06.phx.gbl...[
vbcol=seagreen]
> http://support.microsoft.com/kb/822852
>
> how do i run this if my database is msde?
>[/vbcol]

Database mirroring with truncate log on checkpoint

Hi All,
Understand that database mirroring need to use FULL recovery model, meaning
that all transaction detail will be save into log file. Hence the log file
will increase tremendously.
Can I enable truncate log on checkpoint on principle database and mirror
database? so the log file size will under control.
Thanks.
--
Regards,
VenedictHello There!
You have to set FULL recovery model for database mirroring.
To learn more about this, you can refer to the following document:
http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx
Also, when you try to dump \ truncate your log file which is used by
Database Mirroring, you'll get an error and operation will not be completed
successfully.
To keep log file's size under control, you may try to setup a job to take
it's backup regularly for example every 10-20 mins and disable it's
autogrowth and set some size manually. However, be wise while configuring
it.
Ekrem Ã?nsoy
http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT
"Venedict" <Venedict@.discussions.microsoft.com> wrote in message
news:36A23B54-820D-4B0E-9DA9-8A37A850D7F8@.microsoft.com...
> Hi All,
> Understand that database mirroring need to use FULL recovery model,
> meaning
> that all transaction detail will be save into log file. Hence the log file
> will increase tremendously.
> Can I enable truncate log on checkpoint on principle database and mirror
> database? so the log file size will under control.
> Thanks.
> --
> Regards,
> Venedict

Database Maintenance Plan Wizard

I used the Database Maintenance Plan Wizard to create backup plans for the
master, msdb, and model databases. The model database backs up just fine, but
I get the following error for the master and msdb:
SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
'DB Maintenance Plan master, msdb'' (0x27C15923C7908543B33AADC8F4379A07) -
Status: Failed - Invoked on: 2004-12-17 00:00:01 - Message: The job failed.
The Job was invoked by Schedule 72 (Schedule 1). The last step to run was
step 1 (Step 1).
John Schuster
That is because they are set to SIMPLE mode and you can not backup the log
on a db that is in SIMPLE mode. Create a new plan just for the system db's
and don't issue log backups. Bythe way you don't need to do log backups on
the Model either since it is only a template for new databases.
Andrew J. Kelly SQL MVP
"John Schuster" <JohnSchuster@.discussions.microsoft.com> wrote in message
news:9B4E59C1-9C94-4D20-939E-AD96527A80BE@.microsoft.com...
>I used the Database Maintenance Plan Wizard to create backup plans for the
> master, msdb, and model databases. The model database backs up just fine,
> but
> I get the following error for the master and msdb:
> SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance
> Plan
> 'DB Maintenance Plan master, msdb'' (0x27C15923C7908543B33AADC8F4379A07) -
> Status: Failed - Invoked on: 2004-12-17 00:00:01 - Message: The job
> failed.
> The Job was invoked by Schedule 72 (Schedule 1). The last step to run was
> step 1 (Step 1).
> --
> John Schuster
|||Thank you very much.
"Andrew J. Kelly" wrote:

> That is because they are set to SIMPLE mode and you can not backup the log
> on a db that is in SIMPLE mode. Create a new plan just for the system db's
> and don't issue log backups. Bythe way you don't need to do log backups on
> the Model either since it is only a template for new databases.
> --
> Andrew J. Kelly SQL MVP
>
> "John Schuster" <JohnSchuster@.discussions.microsoft.com> wrote in message
> news:9B4E59C1-9C94-4D20-939E-AD96527A80BE@.microsoft.com...
>
>

Database log truncated: Database: MyDatabase.

Hi,

My Database recovery model is set to Bulk Logged. I recently got this error in the Application Event Log.

EVENT LOG Application
EVENT TYPE Error
SOURCE MSSQLSERVER
CATEGORY Backup
EVENT ID 17055
MESSAGE 18278 :
Database log truncated: Database: MyDatabase.

I've checked the MS Knowledgebase, however article 818202 relates to Full Recovery model not Bulk Logged. I would like to know why this error has occurred and what it really means.

Cheers

DamianThis is not an error, it's just information only message. It's no different than when you issue a Truncate_only log backup.

Database log truncated: Database: MyDatabase.

Hi,
My Database recovery model is set to Bulk Logged. I
recently got this error in the Application Event Log.
EVENT LOG Application
EVENT TYPE Error
SOURCE MSSQLSERVER
CATEGORY Backup
EVENT ID 17055
MESSAGE 18278 :
Database log truncated: Database: MyDatabase.
I've checked the MS Knowledgebase, however article 818202
relates to Full Recovery model not Bulk Logged. I would
like to know why this error has occurred and what it really
means.
Cheers
DamianIt means you (or someone) did a BACKUP LOG WITH TRUNCATE_ONLY or =similar statement. And the log files can not be used for recovery until =the next full db backup is taken.
Mike John
"Damian Jolly" <damian.jolly@.sageautomation.com> wrote in message =news:38fe01c3c8dc$ba792e10$7d02280a@.phx.gbl...
> Hi,
> > My Database recovery model is set to Bulk Logged. I
> recently got this error in the Application Event Log.
> > EVENT LOG Application > EVENT TYPE Error > SOURCE MSSQLSERVER > CATEGORY Backup > EVENT ID 17055 > MESSAGE 18278 :
> Database log truncated: Database: MyDatabase.
> > I've checked the MS Knowledgebase, however article 818202
> relates to Full Recovery model not Bulk Logged. I would
> like to know why this error has occurred and what it really
> means.
> > Cheers
> > Damian|||To add to Mike's response, I ran the repro script in the MSKB article but
with the recovery model set to BULK_LOGGED. The error also appeared in the
log with BULK_LOGGED recovery.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Damian Jolly" <damian.jolly@.sageautomation.com> wrote in message
news:38fe01c3c8dc$ba792e10$7d02280a@.phx.gbl...
> Hi,
> My Database recovery model is set to Bulk Logged. I
> recently got this error in the Application Event Log.
> EVENT LOG Application
> EVENT TYPE Error
> SOURCE MSSQLSERVER
> CATEGORY Backup
> EVENT ID 17055
> MESSAGE 18278 :
> Database log truncated: Database: MyDatabase.
> I've checked the MS Knowledgebase, however article 818202
> relates to Full Recovery model not Bulk Logged. I would
> like to know why this error has occurred and what it really
> means.
> Cheers
> Damian