Rendering report: repair

Showing posts with label repair. Show all posts

Wednesday, March 7, 2012

repair_allow_data_loss Repair statement not processed. Database needs to be in single user

I have to repair a database with repair_allow_data_loss level, so I start
SQL Server on single-user mode with the following command
sqlservr.exe -c -m
and run the repair command:
dbcc checkdb ('blade', repair_allow_data_loss)
I get the following error that doesn't make sense, since I am already in
single user mode:
Server: Msg 7919, Level 16, State 2, Line 1
Repair statement not processed. Database needs to be in single user mode.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
Anyone can help?You don't need to start the server in single user mode for the DBCC, just
place the *database* in single-user-mode. You can do this with ALTER
DATABASE:
ALTER DATABASE MyDaabase
SET SINGLE_USER
Note that it's usually better to restore from backup than resort to DBCC
CHECKDB ... REPAIR_ALLOW_DATA_LOSS. However, the option is useful if you
have no backup.
Hope this helps.
Dan Guzman
SQL Server MVP
"savvas" <savvas@.blade.com.cy> wrote in message
news:uI0sdJFLGHA.3944@.tk2msftngp13.phx.gbl...
>I have to repair a database with repair_allow_data_loss level, so I start
> SQL Server on single-user mode with the following command
> sqlservr.exe -c -m
> and run the repair command:
> dbcc checkdb ('blade', repair_allow_data_loss)
> I get the following error that doesn't make sense, since I am already in
> single user mode:
> Server: Msg 7919, Level 16, State 2, Line 1
> Repair statement not processed. Database needs to be in single user mode.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
>
> Anyone can help?
>

repair_allow_data_loss Repair statement not processed. Database needs to be in single

Repair/Recreate MSDB

Hi,
in addition to my inconsistent user Db. The msdb is also inconsistent.
What's the easiest way to create a new msdb. Do I need the content of the
old one? (I don't worry about the maintenance plans. I can setup them again)
Thanks for any advice
Graham
Graham SmithHi
If you did a regular BACKUP of the system databases you can just perfom
RESTORE of MSDB.
If you did not , you are probaly about to install SQL Server and then
RESTORE all of your user databases.
"Graham Smith" <graham.smith@.bbank.com> wrote in message
news:OlP5niu3FHA.3260@.TK2MSFTNGP10.phx.gbl...
> Hi,
> in addition to my inconsistent user Db. The msdb is also inconsistent.
> What's the easiest way to create a new msdb. Do I need the content of the
> old one? (I don't worry about the maintenance plans. I can setup them
> again)
> Thanks for any advice
> Graham
> --
> Graham Smith
>|||Hi,

> RESTORE of MSDB.
do I have to consider something? Like setting the server into a special
mode?
Thanks again
Graham Smith

repair torn page?

I have inherited a poorly administered/maintained database that
contains the following error:

"I/O error (torn page) detected during read at offset 0x000018ee23e000
in file 'F:\Program Files\ISS\RealSecure SiteProtector\Site
Database\Data\RealSecureDB.mdf"

I do not have database backups and so therefore cannot restore from
them. I want to move the database to a new platform and somehow
repair the torn page. Is this possible?
>I have inherited a poorly administered/maintained database that
>contains the following error:
>"I/O error (torn page) detected during read at offset 0x000018ee23e000
>in file 'F:\Program Files\ISS\RealSecure SiteProtector\Site
>Database\Data\RealSecureDB.mdf"
>I do not have database backups and so therefore cannot restore from
>them. I want to move the database to a new platform and somehow
>repair the torn page. Is this possible?

If you want to get your data out of this damaged database, we can help
you. Have a look at www.sql-server-repair.com

The error message you got indicates that a data page (8kByte) has not
been written completely. So at this page will be some data loss.

Regards

Thilo Immel
The SQL Sevrer Druid www.sql-server-repair.com|||You might try DBCC CHECKDB, if you haven't already done so. The end of the
report will suggest the DBCC CHECKDB repair option needed to correct the
problem. As Thilo said, this will likely be REPAIR_ALLOW_DATA_LOSS due to
the torn page. See the Books Online for more information.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"bbbad_999" <bericks999@.yahoo.com> wrote in message
news:6c6096fb.0408201308.7e1a5645@.posting.google.c om...
> I have inherited a poorly administered/maintained database that
> contains the following error:
> "I/O error (torn page) detected during read at offset 0x000018ee23e000
> in file 'F:\Program Files\ISS\RealSecure SiteProtector\Site
> Database\Data\RealSecureDB.mdf"
> I do not have database backups and so therefore cannot restore from
> them. I want to move the database to a new platform and somehow
> repair the torn page. Is this possible?|||see
http://www.nigelrivett.net/RecoverCorruptDatabase.html

Nigel Rivett
www.nigelrivett.net

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Repair SQL database that has been marked suspect

I woke up this morning to find my company's SQL database inaccessible and marked suspect.

I have used various t-sql commands to bring it into Emergency mode.

Now it is labelled Loading\Offline\Read-Only\Emergency Mode.

I'm using SQL Server 2000

I do not have a backup and I need to get the database up and running as soon as yesterday.

Help

first of all what version of SQL Server are u using?

Second ..There can be many reason for database being suspect.Please see in to the SQL Server error log and send if you see something unusual/error .It is very importent to look in to error log before anything can be done

run this on master

select status from sysdatabases and send it.

Thanks

|||

Recommended actions for corrupt or suspect databases

http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp

AMB

|||

it is very tough to get a suspect db back. try this link http://www.myitforum.com/articles/18/view.asp?id=7381

Madhu

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 AdministratorDoesn'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:
> 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|||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...
> 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:
>> 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|||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...
> > 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:
> >
> >> 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
>|||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...
> 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...
>> > 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:
>> >
>> >> 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

Repair or Reinstall

Repair Northwind Database in SQL Server Management Studio Express

Hi all,

Long time ago, I downloaded the Northwind and pubs databases from the Microsoft website (I do not remember the details of it) and installed these two databases together into the SQL Server Management Studio Express of my PC (Microsoft Windows XP Pro). I tried to learn an example of using "User Instance" (source code was from a book) on the Northwind database located in my SQL Server Management Studio Express. I just find out that my Northwind database has the title only and no tables at all. If I click on the "+" in front of the "Northwind", I got the following error message:

Microsoft SQL Server Management Studio Express

Failed to retrieve data for this request.(Microsoft SqlServer.Express.SmoEnum)

Additional information:

One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupted and should be restored from backup. (Microsoft SQL Server, Error: 5173)..

Please help and tell me how I can repair this Northwind database in my SQL Server Management Studio Express.

Scott Chang

P. S.

I deleted the name 'Northwind' in my SQL Server Management Studio Express, executed the "SQL2005DBScripts\Instnwind" program and I got the following error message: Msg 1802, Level 16, State 4, Line 1

CREATE DATABASE failed. Some file name listed could not be created. Checked related errors.

Msg 5170, Level 16, state 1, Line 1

Cannot create file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\DATA\northwind\northwind.ldf' because it already exist. Change the file path or the file name, and retry the operation.

Msg 15100, Level 16, State 1, Procedure sp_dboption, Line 64

The database 'Northwind' does not exist. Use sp_helpdb to show available database.

Msg 911, Level 16, State 1, Line 1

Could not locate entry in sysdatabases for database 'Northwind'. No entry found with that name. Make sure that name is entered correctly

Delete both Northwind files located at: 'c:\Program Files\Microsoft SQL Server\MSSQL.1\DATA\northwind\'

AND

DELETE any Northwind files located at: 'c:\Program Files\Microsoft SQL Server\MSSQL.1\DATA\'

Then try the (SQL2005DBScripts\Instnwind) installation again.

|||

Hi Arnie, Thanks for your response.

I am not quite sure about your instructions, because I have C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data that has northwnd.ldf, northwnd.mdf and NORTHWND_log.ldf and I do not have 'c:\Program Files\Microsoft SQL Server\MSSQL.1\DATA\northwind\' as you said. Please kindly clarify your instructions for me, so I can do the correct repair work in my PC.

Thanks,

Scott Chang

|||

Scott,

The error message you posted indicated that there was file located in:

Cannot create file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\DATA\northwind\northwind.ldf' because it already exist.

It seems you 'should' delete the Northwind_log.ldf.

Then ATTACH the Northwind.mdf. When you attach the file, verify the filepath of the ldf file, and correct it if necessary.

Apparently, there is some confusion about the path/folder where the northwind files are located. (It is sometimes a confusing process...)

Repair Master db

Today, while working on repairing another issue, I managed to cause an even
bigger issue. Of course, I was not smart enough to backup the db before
touching it...
I have a new instance of SQL Server 2000 running on a Windows 2003 machine.
I ran into some issues with logins and, following instructions from an
article I found, I was trying to delete a single row from the
master.sysxlogins table. Well, I failed to add "WHERE name = ''" to the
statement and ended up deleting everything in that table. Now I can't
connect at all.
Is there any solution besides reinstalling SQL Server?
Thank You,
Jason Williard
Read up on rebuildm.exe in Books Online.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jason Williard" <jason@.pcsafe.net> wrote in message news:6KKdnVSBcNmIjLnfRVn-tA@.comcast.com...
> Today, while working on repairing another issue, I managed to cause an even bigger issue. Of
> course, I was not smart enough to backup the db before touching it...
> I have a new instance of SQL Server 2000 running on a Windows 2003 machine. I ran into some issues
> with logins and, following instructions from an article I found, I was trying to delete a single
> row from the master.sysxlogins table. Well, I failed to add "WHERE name = ''" to the statement
> and ended up deleting everything in that table. Now I can't connect at all.
> Is there any solution besides reinstalling SQL Server?
> Thank You,
> Jason Williard
>
|||You can run Rebuildm.exe in the \80\tools\binn to rebuild master database.
-oj
"Jason Williard" <jason@.pcsafe.net> wrote in message
news:6KKdnVSBcNmIjLnfRVn-tA@.comcast.com...
> Today, while working on repairing another issue, I managed to cause an
> even bigger issue. Of course, I was not smart enough to backup the db
> before touching it...
> I have a new instance of SQL Server 2000 running on a Windows 2003
> machine. I ran into some issues with logins and, following instructions
> from an article I found, I was trying to delete a single row from the
> master.sysxlogins table. Well, I failed to add "WHERE name = ''" to the
> statement and ended up deleting everything in that table. Now I can't
> connect at all.
> Is there any solution besides reinstalling SQL Server?
> Thank You,
> Jason Williard
>

Repair Master db

Today, while working on repairing another issue, I managed to cause an even
bigger issue. Of course, I was not smart enough to backup the db before
touching it...
I have a new instance of SQL Server 2000 running on a Windows 2003 machine.
I ran into some issues with logins and, following instructions from an
article I found, I was trying to delete a single row from the
master.sysxlogins table. Well, I failed to add "WHERE name = ''" to the
statement and ended up deleting everything in that table. Now I can't
connect at all.
Is there any solution besides reinstalling SQL Server?
Thank You,
Jason WilliardRead up on rebuildm.exe in Books Online.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jason Williard" <jason@.pcsafe.net> wrote in message news:6KKdnVSBcNmIjLnfRVn-tA@.comcast.com...
> Today, while working on repairing another issue, I managed to cause an even bigger issue. Of
> course, I was not smart enough to backup the db before touching it...
> I have a new instance of SQL Server 2000 running on a Windows 2003 machine. I ran into some issues
> with logins and, following instructions from an article I found, I was trying to delete a single
> row from the master.sysxlogins table. Well, I failed to add "WHERE name = ''" to the statement
> and ended up deleting everything in that table. Now I can't connect at all.
> Is there any solution besides reinstalling SQL Server?
> Thank You,
> Jason Williard
>|||You can run Rebuildm.exe in the \80\tools\binn to rebuild master database.
--
-oj
"Jason Williard" <jason@.pcsafe.net> wrote in message
news:6KKdnVSBcNmIjLnfRVn-tA@.comcast.com...
> Today, while working on repairing another issue, I managed to cause an
> even bigger issue. Of course, I was not smart enough to backup the db
> before touching it...
> I have a new instance of SQL Server 2000 running on a Windows 2003
> machine. I ran into some issues with logins and, following instructions
> from an article I found, I was trying to delete a single row from the
> master.sysxlogins table. Well, I failed to add "WHERE name = ''" to the
> statement and ended up deleting everything in that table. Now I can't
> connect at all.
> Is there any solution besides reinstalling SQL Server?
> Thank You,
> Jason Williard
>

Repair Master db

Today, while working on repairing another issue, I managed to cause an even
bigger issue. Of course, I was not smart enough to backup the db before
touching it...
I have a new instance of SQL Server 2000 running on a Windows 2003 machine.
I ran into some issues with logins and, following instructions from an
article I found, I was trying to delete a single row from the
master.sysxlogins table. Well, I failed to add "WHERE name = ''" to the
statement and ended up deleting everything in that table. Now I can't
connect at all.
Is there any solution besides reinstalling SQL Server?
Thank You,
Jason WilliardRead up on rebuildm.exe in Books Online.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jason Williard" <jason@.pcsafe.net> wrote in message news:6KKdnVSBcNmIjLnfRVn-tA@.comcast.com
..
> Today, while working on repairing another issue, I managed to cause an eve
n bigger issue. Of
> course, I was not smart enough to backup the db before touching it...
> I have a new instance of SQL Server 2000 running on a Windows 2003 machine
. I ran into some issues
> with logins and, following instructions from an article I found, I was try
ing to delete a single
> row from the master.sysxlogins table. Well, I failed to add "WHERE name =
''" to the statement
> and ended up deleting everything in that table. Now I can't connect at al
l.
> Is there any solution besides reinstalling SQL Server?
> Thank You,
> Jason Williard
>|||You can run Rebuildm.exe in the \80\tools\binn to rebuild master database.
-oj
"Jason Williard" <jason@.pcsafe.net> wrote in message
news:6KKdnVSBcNmIjLnfRVn-tA@.comcast.com...
> Today, while working on repairing another issue, I managed to cause an
> even bigger issue. Of course, I was not smart enough to backup the db
> before touching it...
> I have a new instance of SQL Server 2000 running on a Windows 2003
> machine. I ran into some issues with logins and, following instructions
> from an article I found, I was trying to delete a single row from the
> master.sysxlogins table. Well, I failed to add "WHERE name = ''" to the
> statement and ended up deleting everything in that table. Now I can't
> connect at all.
> Is there any solution besides reinstalling SQL Server?
> Thank You,
> Jason Williard
>

Repair database that grew over 2 GB

Because of a configuration error by field engineer who didn't check the
error logs before leaving, an error logging table in an MSDE database has
made it grow to 2GB in a couple of days.
The result is that the database status became "suspect" (I had to connect
through enterprise manager to see that) and it can no longer be opened.
At the same time, I noticed that the $&*$##% has renamed the computer after
installing MSDE and initializing the database, despite my urging him never
to do so: as a result the backup schedule that's created along with the
database was no longer executed, the last backup dates from last April
instead of a few hours before it stopped working.
Needless to say that the customer is very happy.
Now I think I made an additional error by trying to detach and re-attach
the database: MSDE won't even re-attach it anymore, with an error "the
primary file group is full".
Is there a way to force MSDE to load it anyway so the extraneous data can
be deleted?
Can the file be attached to a full SQL server, the runaway table purged
there, and then re-attached to MSDE?
On Tue, 28 Dec 2004 12:14:46 +0100, Lucvdv <replace_name@.null.net> wrote:

> Because of a configuration error by field engineer who didn't check the
> error logs before leaving, an error logging table in an MSDE database has
> made it grow to 2GB in a couple of days.
I just tried to recreate the problem on a test machine: the .mdf file grew
to 1869 MB (1.82 GB), then it stopped with "PRIMARY file group full", but
the database remains accessible, only inserts fail.
In the problem case, the .mdf file was slightly over 2 GB (2.03GB or so, I
don't remember exactly.)
Is there an explanation for this?
|||On Tue, 28 Dec 2004 12:14:46 +0100, Lucvdv <replace_name@.null.net> wrote:

> Can the file be attached to a full SQL server, the runaway table purged
> there, and then re-attached to MSDE?
Relief all around: after copying and attaching the database to a full SQL
Server, shrinking it there and then moving it back to MSDE, everything is
up and running again.
|||hi,
"Lucvdv" <replace_name@.null.net> ha scritto nel messaggio
news:ivf2t0ln44sb9r9ll8ucnknidv4pg4ppad@.4ax.com
> ...
> Can the file be attached to a full SQL server, the runaway table
> purged there, and then re-attached to MSDE?
yes... you can get the mdf (+ ndf if present) + ldf database files set,
take them to your office, purge the "extra" data and shrink the database
data file(s) to a size allowed by MSDE..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||On Tue, 28 Dec 2004 17:12:37 +0100, "Andrea Montanari"
<andrea.sqlDMO@.virgilio.it> wrote:

> hi,
> "Lucvdv" <replace_name@.null.net> ha scritto nel messaggio
> news:ivf2t0ln44sb9r9ll8ucnknidv4pg4ppad@.4ax.com
> yes... you can get the mdf (+ ndf if present) + ldf database files set,
> take them to your office, purge the "extra" data and shrink the database
> data file(s) to a size allowed by MSDE..
Thanks. I had tried and found that it worked shortly before you replied.
I tried to repeat it on a test machine later, but couldn't make the .mdf
grow above 2GB: all inserts started failing when the final file grow step
had to be done. It actually stopped around 1850 MB with % growth steps, it
refused to go closer to 2G until I changed that to 5MB fixed increments,
and then it stopped at 2044 MB.
The database remained usable, I could detach and attach it, only inserts
failed.
Yet in the problem case it was 2.03GB or something like that (slightly
above 2GB anyway), and MSDE refused to use it any further.
Do you have an idea how that might have happened?
I also noticed when I changed the file growth settings from % to fixed
size, that the change didn't take effect until I had detached and
re-attached the database (rebooting or restarting the service would
probably have done it too, what I mean is that inserts didn't start working
again by just changing the setting).
Is that something known?
|||hi Lucvdv,
"Lucvdv" <replace_name@.null.net> ha scritto nel messaggio
news:94r4t0p6bvclndb2l8gjuhogmd9ho8hq00@.4ax.com
> ...
> I tried to repeat it on a test machine later, but couldn't make the
> .mdf grow above 2GB: all inserts started failing when the final file
> grow step had to be done. It actually stopped around 1850 MB with %
> growth steps, it refused to go closer to 2G until I changed that to
> 5MB fixed increments, and then it stopped at 2044 MB.
> The database remained usable, I could detach and attach it, only
> inserts failed.
> Yet in the problem case it was 2.03GB or something like that (slightly
> above 2GB anyway), and MSDE refused to use it any further.
> Do you have an idea how that might have happened?
>
> I also noticed when I changed the file growth settings from % to fixed
> size, that the change didn't take effect until I had detached and
> re-attached the database (rebooting or restarting the service would
> probably have done it too, what I mean is that inserts didn't start
> working again by just changing the setting).
> Is that something known?
AFAIK the Storage engine should throw an exception when the 2gb limit is
reached, but should not set the db in suspect mode... this is what I've been
always told, as I never pushed MSDE to that upper limit :D ...
and this is the very first time I hear about growth setting affect such a
behaviour.. will try investigating this...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Repair Corrupted MDF & LDF Files ?

Hi All

I am looking for repair tools for corrupted mdf and ldf files,

( These files beeing corrupted after i restore them using Easy Recovery Profissional after formatting c drive by mistake. )

Remark : one file of my 3 databases work perfectly when i use attach database.

Any Help will Be appreciated.

thanks

What errors comes back while attaching the database ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

repair corrupt database?

Hi,
How can I repair a corrupt database? The situation is that I
have the first 2.8gig of a 3.3gb database, the rest couldn't be read
because of a faulty hard drive.
I have the actual backup, and the .mdf file, but both would hold
the same amount of data.
Any help please?
ThanksAssuming the db is suspect and you are indeed performing regular log backups:
Do a log backup using the NO_TRUNCATE option, then restore the latest clean db backup and all
subsequent log backups.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"jekZ" <jekz@.nospam.com> wrote in message news:NxmdnV8LEsanSeeiU-KYuQ@.is.co.za...
> Hi,
> How can I repair a corrupt database? The situation is that I
> have the first 2.8gig of a 3.3gb database, the rest couldn't be read
> because of a faulty hard drive.
> I have the actual backup, and the .mdf file, but both would hold
> the same amount of data.
> Any help please?
> Thanks
>

Repair an SQL Server 2005 installation.

Hi,

Some part of my system registry seens corrupted, and I can not run the report services configuration tool, it gave me the following error:

0x80010002: RCP_E_CALL_CANCELED

1) Does a repair of the installation will register back the COM Servers?

2) After a repair does the report services encription key will be affected.

My main problem is to perform a backup of the report services encription key on a server that is not very stable.

3) Is there another way to backup the encription key without using the report services configuration tool?

Thanks

Hi, found my answers... and it solve my problem.

Performing a Windows 2003 Server repair (not repair console) has fix my registry problem and was able to connect back with the report services configuration tool.

Also I found the following cmd line to backup the encryption key: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\RSKeyMgmt.exe

Repair a Sql Server

Hi,
I have an instance of Sql Server 2000 on a Windows Server 2000
The server has 2 mirror hard disk
On disk failed and we replace it by a new one
Since than, some DTS does not work because the connection to another
database on the same server failed
Also the Console Entreprise Manager can not connect to all database
If a create a new registration from a remote computer the registration work
and I can see all the database
It seem's that some files are corrupted on the server
Is there a way to do a repair on SqlServer 2000?
If yes How can I do that?
Or what should I do to resolve the problem?
Thanks in advance?firstly to be sure if SQL server databases are corrupted, you can check
by doing DBCC CheckDB on all the databases|||It sounds like your redundant disk array isn't. Find and fix any disk
corruption issues, then you can restore the SQL Server. I have found that
fixing databases in place with underlying file system corruption to have
very poor success rates.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"GC" <GC@.discussions.microsoft.com> wrote in message
news:B7E33597-020E-49BB-B91A-3D181A020FF5@.microsoft.com...
> Hi,
> I have an instance of Sql Server 2000 on a Windows Server 2000
> The server has 2 mirror hard disk
> On disk failed and we replace it by a new one
> Since than, some DTS does not work because the connection to another
> database on the same server failed
> Also the Console Entreprise Manager can not connect to all database
> If a create a new registration from a remote computer the registration
> work
> and I can see all the database
> It seem's that some files are corrupted on the server
> Is there a way to do a repair on SqlServer 2000?
> If yes How can I do that?
> Or what should I do to resolve the problem?
> Thanks in advance?

Repair a Sql Server

Hi,
I have an instance of Sql Server 2000 on a Windows Server 2000
The server has 2 mirror hard disk
On disk failed and we replace it by a new one
Since than, some DTS does not work because the connection to another
database on the same server failed
Also the Console Entreprise Manager can not connect to all database
If a create a new registration from a remote computer the registration work
and I can see all the database
It seem's that some files are corrupted on the server
Is there a way to do a repair on SqlServer 2000?
If yes How can I do that?
Or what should I do to resolve the problem?
Thanks in advance?
firstly to be sure if SQL server databases are corrupted, you can check
by doing DBCC CheckDB on all the databases
|||It sounds like your redundant disk array isn't. Find and fix any disk
corruption issues, then you can restore the SQL Server. I have found that
fixing databases in place with underlying file system corruption to have
very poor success rates.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"GC" <GC@.discussions.microsoft.com> wrote in message
news:B7E33597-020E-49BB-B91A-3D181A020FF5@.microsoft.com...
> Hi,
> I have an instance of Sql Server 2000 on a Windows Server 2000
> The server has 2 mirror hard disk
> On disk failed and we replace it by a new one
> Since than, some DTS does not work because the connection to another
> database on the same server failed
> Also the Console Entreprise Manager can not connect to all database
> If a create a new registration from a remote computer the registration
> work
> and I can see all the database
> It seem's that some files are corrupted on the server
> Is there a way to do a repair on SqlServer 2000?
> If yes How can I do that?
> Or what should I do to resolve the problem?
> Thanks in advance?

Repair a Sql Server

Hi,
I have an instance of Sql Server 2000 on a Windows Server 2000
The server has 2 mirror hard disk
On disk failed and we replace it by a new one
Since than, some DTS does not work because the connection to another
database on the same server failed
Also the Console Entreprise Manager can not connect to all database
If a create a new registration from a remote computer the registration work
and I can see all the database
It seem's that some files are corrupted on the server
Is there a way to do a repair on SqlServer 2000?
If yes How can I do that?
Or what should I do to resolve the problem?
Thanks in advance?firstly to be sure if SQL server databases are corrupted, you can check
by doing DBCC CheckDB on all the databases|||It sounds like your redundant disk array isn't. Find and fix any disk
corruption issues, then you can restore the SQL Server. I have found that
fixing databases in place with underlying file system corruption to have
very poor success rates.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"GC" <GC@.discussions.microsoft.com> wrote in message
news:B7E33597-020E-49BB-B91A-3D181A020FF5@.microsoft.com...
> Hi,
> I have an instance of Sql Server 2000 on a Windows Server 2000
> The server has 2 mirror hard disk
> On disk failed and we replace it by a new one
> Since than, some DTS does not work because the connection to another
> database on the same server failed
> Also the Console Entreprise Manager can not connect to all database
> If a create a new registration from a remote computer the registration
> work
> and I can see all the database
> It seem's that some files are corrupted on the server
> Is there a way to do a repair on SqlServer 2000?
> If yes How can I do that?
> Or what should I do to resolve the problem?
> Thanks in advance?

Wednesday, March 7, 2012

repair_allow_data_loss Repair statement not processed. Database needs to be in single user

repair_allow_data_loss Repair statement not processed. Database needs to be in single

Repair/Recreate MSDB

repair torn page?

Repair SQL database that has been marked suspect

Repair or Reinstall

Repair or Reinstall

Repair or Reinstall

Repair Northwind Database in SQL Server Management Studio Express

Repair Master db

Repair Master db

Repair Master db

Repair database that grew over 2 GB

Repair database that grew over 2 GB

Repair Corrupted MDF & LDF Files ?

repair corrupt database?

Repair an SQL Server 2005 installation.

Repair a Sql Server

Repair a Sql Server

Repair a Sql Server

Rendering report

Blog Archive

About Me