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)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy