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 marked suspect

My primary database is currently marked suspect. I
believe it could be because the transaction log was
deleted. How can I restore the database to be
operational?
Any assistance is greatly appreciated!use this one sp_resetstatus [ @.DBName =3D ] 'database'
See BOL for more information om the same ...
-- HTH,
Vinod Kumar
MCSE, DBA, MCAD
http://www.extremeexperts.com/
"Michelle" <msarna@.starpower.net> wrote in message =news:042c01c3588e$c42cda60$a401280a@.phx.gbl...
> My primary database is currently marked suspect. I > believe it could be because the transaction log was > deleted. How can I restore the database to be > operational?
> > Any assistance is greatly appreciated!

Database Mail

Dear Folks,
I am trying to finish my configuration of Database Mail on my sp1 build 2153 sql server. I believe to have set it up properly but i still can't get a test message through. My error message reads:

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2006-08-09T15:14:00). Exception Message: Cannot send mails to mail server. (Transaction failed. The server response was: Mail from <account email address> rejected for policy reasons.). )

Everything that needs to be enabled, i.e. service broker, SQL Server Agent properties, deafult profile in msdb table, services restarted. Is this message a result of Sql server policy or the smtp server? Is there a process in the transaction Sql server initiates that could be causing the policy violation that i need to tell the email admin about?
Thanks for your reply.
-C
This turned out to be a DNS or relay issue. When i got the right IP address, it worked fine. I tried IP previously, the same message came back. The mail server is in another domain, which complicated the issue.

Database last used?

Is there a way to check how long since a database has been last used?
I have a database which I believe is redundant but I want to be sure before
dropping it.
ThanksSQL Server does not keep such information. You might be able to see when dat
a was last modified in
the database by looking at file modified date etc. An option might be to set
the database to
read-only, restricted user, offline etc and listen for screams...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Anceladux" <Anceladux@.discussions.microsoft.com> wrote in message
news:F56F4735-DF9D-41A8-84CB-C48E600897BB@.microsoft.com...
> Is there a way to check how long since a database has been last used?
> I have a database which I believe is redundant but I want to be sure befor
e
> dropping it.
> Thanks
>|||Thanks for your help Tibor
"Anceladux" wrote:

> Is there a way to check how long since a database has been last used?
> I have a database which I believe is redundant but I want to be sure befor
e
> dropping it.
> Thanks
>|||Unfortunately, there's no easy way to do this.
I created a job that runs hourly and polls the sysprocesses virtual table
to see who's connected to what. I then write this info to a table I've
created.
"Anceladux" <Anceladux@.discussions.microsoft.com> wrote in message
news:F56F4735-DF9D-41A8-84CB-C48E600897BB@.microsoft.com...
> Is there a way to check how long since a database has been last used?
> I have a database which I believe is redundant but I want to be sure
before
> dropping it.
> Thanks
>|||Anceladux,
Perhaps run profiler on the server for a few days, see if anyone logs
into it.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Anceladux wrote:
> Is there a way to check how long since a database has been last used?
> I have a database which I believe is redundant but I want to be sure befor
e
> dropping it.
> Thanks
>|||How about enabling AUTO_CLOSE with ALTER DATABASE. This will release all
resources held by the DB. If anybody tries to access the DB it will open it
causing them no disruption. SQL Errorlog will contain messages whenever the
DB is opened.
"Anceladux" <Anceladux@.discussions.microsoft.com> wrote in message
news:F56F4735-DF9D-41A8-84CB-C48E600897BB@.microsoft.com...
> Is there a way to check how long since a database has been last used?
> I have a database which I believe is redundant but I want to be sure
> before
> dropping it.
> Thanks
>|||Keep in mind that with autoclose, every time you try to access the database
any queries
issued will be bogged down by the amount of time it takes to open the
database
"Stringfellow Hawke" <Stringfellow.Hawke-PleaseNoSpam@.gmail.com.nospam>
wrote in message news:O9MwrScwEHA.3376@.TK2MSFTNGP12.phx.gbl...
> How about enabling AUTO_CLOSE with ALTER DATABASE. This will release all
> resources held by the DB. If anybody tries to access the DB it will open
it
> causing them no disruption. SQL Errorlog will contain messages whenever
the
> DB is opened.
> "Anceladux" <Anceladux@.discussions.microsoft.com> wrote in message
> news:F56F4735-DF9D-41A8-84CB-C48E600897BB@.microsoft.com...
>

Database last used?

Is there a way to check how long since a database has been last used?
I have a database which I believe is redundant but I want to be sure before
dropping it.
Thanks
SQL Server does not keep such information. You might be able to see when data was last modified in
the database by looking at file modified date etc. An option might be to set the database to
read-only, restricted user, offline etc and listen for screams...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Anceladux" <Anceladux@.discussions.microsoft.com> wrote in message
news:F56F4735-DF9D-41A8-84CB-C48E600897BB@.microsoft.com...
> Is there a way to check how long since a database has been last used?
> I have a database which I believe is redundant but I want to be sure before
> dropping it.
> Thanks
>
|||Thanks for your help Tibor
"Anceladux" wrote:

> Is there a way to check how long since a database has been last used?
> I have a database which I believe is redundant but I want to be sure before
> dropping it.
> Thanks
>
|||Unfortunately, there's no easy way to do this.
I created a job that runs hourly and polls the sysprocesses virtual table
to see who's connected to what. I then write this info to a table I've
created.
"Anceladux" <Anceladux@.discussions.microsoft.com> wrote in message
news:F56F4735-DF9D-41A8-84CB-C48E600897BB@.microsoft.com...
> Is there a way to check how long since a database has been last used?
> I have a database which I believe is redundant but I want to be sure
before
> dropping it.
> Thanks
>
|||Anceladux,
Perhaps run profiler on the server for a few days, see if anyone logs
into it.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Anceladux wrote:
> Is there a way to check how long since a database has been last used?
> I have a database which I believe is redundant but I want to be sure before
> dropping it.
> Thanks
>
|||How about enabling AUTO_CLOSE with ALTER DATABASE. This will release all
resources held by the DB. If anybody tries to access the DB it will open it
causing them no disruption. SQL Errorlog will contain messages whenever the
DB is opened.
"Anceladux" <Anceladux@.discussions.microsoft.com> wrote in message
news:F56F4735-DF9D-41A8-84CB-C48E600897BB@.microsoft.com...
> Is there a way to check how long since a database has been last used?
> I have a database which I believe is redundant but I want to be sure
> before
> dropping it.
> Thanks
>
|||Keep in mind that with autoclose, every time you try to access the database
any queries
issued will be bogged down by the amount of time it takes to open the
database
"Stringfellow Hawke" <Stringfellow.Hawke-PleaseNoSpam@.gmail.com.nospam>
wrote in message news:O9MwrScwEHA.3376@.TK2MSFTNGP12.phx.gbl...
> How about enabling AUTO_CLOSE with ALTER DATABASE. This will release all
> resources held by the DB. If anybody tries to access the DB it will open
it
> causing them no disruption. SQL Errorlog will contain messages whenever
the
> DB is opened.
> "Anceladux" <Anceladux@.discussions.microsoft.com> wrote in message
> news:F56F4735-DF9D-41A8-84CB-C48E600897BB@.microsoft.com...
>

Database last used?

Is there a way to check how long since a database has been last used?
I have a database which I believe is redundant but I want to be sure before
dropping it.
ThanksSQL Server does not keep such information. You might be able to see when data was last modified in
the database by looking at file modified date etc. An option might be to set the database to
read-only, restricted user, offline etc and listen for screams...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Anceladux" <Anceladux@.discussions.microsoft.com> wrote in message
news:F56F4735-DF9D-41A8-84CB-C48E600897BB@.microsoft.com...
> Is there a way to check how long since a database has been last used?
> I have a database which I believe is redundant but I want to be sure before
> dropping it.
> Thanks
>|||Thanks for your help Tibor
"Anceladux" wrote:
> Is there a way to check how long since a database has been last used?
> I have a database which I believe is redundant but I want to be sure before
> dropping it.
> Thanks
>|||Unfortunately, there's no easy way to do this.
I created a job that runs hourly and polls the sysprocesses virtual table
to see who's connected to what. I then write this info to a table I've
created.
"Anceladux" <Anceladux@.discussions.microsoft.com> wrote in message
news:F56F4735-DF9D-41A8-84CB-C48E600897BB@.microsoft.com...
> Is there a way to check how long since a database has been last used?
> I have a database which I believe is redundant but I want to be sure
before
> dropping it.
> Thanks
>|||Anceladux,
Perhaps run profiler on the server for a few days, see if anyone logs
into it.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Anceladux wrote:
> Is there a way to check how long since a database has been last used?
> I have a database which I believe is redundant but I want to be sure before
> dropping it.
> Thanks
>|||How about enabling AUTO_CLOSE with ALTER DATABASE. This will release all
resources held by the DB. If anybody tries to access the DB it will open it
causing them no disruption. SQL Errorlog will contain messages whenever the
DB is opened.
"Anceladux" <Anceladux@.discussions.microsoft.com> wrote in message
news:F56F4735-DF9D-41A8-84CB-C48E600897BB@.microsoft.com...
> Is there a way to check how long since a database has been last used?
> I have a database which I believe is redundant but I want to be sure
> before
> dropping it.
> Thanks
>|||Keep in mind that with autoclose, every time you try to access the database
any queries
issued will be bogged down by the amount of time it takes to open the
database
"Stringfellow Hawke" <Stringfellow.Hawke-PleaseNoSpam@.gmail.com.nospam>
wrote in message news:O9MwrScwEHA.3376@.TK2MSFTNGP12.phx.gbl...
> How about enabling AUTO_CLOSE with ALTER DATABASE. This will release all
> resources held by the DB. If anybody tries to access the DB it will open
it
> causing them no disruption. SQL Errorlog will contain messages whenever
the
> DB is opened.
> "Anceladux" <Anceladux@.discussions.microsoft.com> wrote in message
> news:F56F4735-DF9D-41A8-84CB-C48E600897BB@.microsoft.com...
> > Is there a way to check how long since a database has been last used?
> >
> > I have a database which I believe is redundant but I want to be sure
> > before
> > dropping it.
> > Thanks
> >
> >
>