Viewing 15 posts - 1 through 15 (of 130 total)
Hi Gail,
The Vendor has confirmed the issue was with the disk after I got back to them after your feedback.
Thanks once again for the timely help. :-):-):-)
January 14, 2014 at 5:05 am
Thanks a lot Gail for Guidance & Feedback.
Will the DB be in a usable state when DBCC is performed?
Not sure how to tackle the IO subsystem. Any suggestions ?
January 13, 2014 at 9:48 am
USE MyDB1
GO
ALTER DATABASE MyDB1 SET SINGLE_USER;
DBCC CHECKTABLE (Table1,REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE MyDB1 SET MULTI_USER;
Is the above option safe? Will I lose only the data that is corrupted or will I...
January 13, 2014 at 7:57 am
Unfortunately we don't have a backup for the DB. We have set deletion of the Backup every 4 days.
Hence all the backups have been deleted . Is there a...
January 13, 2014 at 5:33 am
The table is high transaction table with hourly job to delete unwanted data. Could this be the issue?
January 13, 2014 at 4:47 am
I was checking the logs & found that the Full & Differential backups were failing.
I ran the command DBCC CHECKDB('MyDB1') WITH NO_INFOMSGS,ALL_ERRORMSGS.
Attached is the output of DBCC.
Please advise what...
January 13, 2014 at 3:27 am
The problem has resurfaced again. This time the insertion into the table from the application stopped when the DB size was 33 GB . Whereas i am able to manually...
February 25, 2013 at 2:49 am
The problem has resurfaced again. This time the insertion into the table from the application stopped when the DB size was 33 GB . Whereas i am able to manually...
February 25, 2013 at 2:43 am
When I backed up the DB . The size of the compressed backup was 7 GB compared to the 42 GB of the DB. So ideally shrink should work. Right?
February 1, 2013 at 6:04 am
I even tried shrinking the DB as well as the Files. The query got executed within seconds, but the DB size remained the same.
As an alternative I created a new...
February 1, 2013 at 4:45 am
I detached the dB & attached it without the log file. Out of the 6 tables insertion is happening on 2 tables right now. So I tried rebuilding indexes. which...
January 31, 2013 at 9:05 am
The data & log file have different logical names FSB & FSB_LOG. It was a typo error.
I tried the ALTER DATABASE FSH MODIFY FILE (NAME = FSH_data, SIZE = 100000MB);....
January 31, 2013 at 8:54 am
Viewing 15 posts - 1 through 15 (of 130 total)