locked
Is it the reason of shrink operaion get failied? RRS feed

  • Question

  • My shrink operation to MDf file has got failed,I dont know why.

    actually at 11:00 PM I have run the shrink operaion for mdf file,and at 12:00 AM Differential backup job executed for same database.

    Is it the reason of shrink operaion get failied?


    Thanks

    Monday, July 30, 2012 11:08 AM

Answers

All replies

  • What exact error are  you getting? BTW it is considered bad practice to shrink the database, read Tibor's article.

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


    Best Regards,Uri Dimant SQL Server MVP,http://sqlblog.com/blogs/uri_dimant/

    Monday, July 30, 2012 11:26 AM
  • I have run it from GUI ..I have got this error in sp_readerrorlog...

    2012-07-27 10:43:35.110 spid5s SQL Server has encountered 666 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\ARSys.mdf] in database [ARSystem] (5).  The OS file handle is 0x0000000000000910.  The offset of the latest long I/O is: 0x00000cdbfd0000
    2012-07-27 10:50:22.060 spid5s SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\ARSys.mdf] in database [ARSystem] (5).  The OS file handle is 0x0000000000000910.  The offset of the latest long I/O is: 0x00001e0e060000
    2012-07-27 11:00:32.420 Backup Log was backed up. Database: ARSystem, creation date(time): 2011/06/23(20:44:42), first LSN: 21106:323249:1, last LSN: 21108:73871:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'\\10.33.230.51\i$\Backups\Log\ARSystem\ARSystem_backup_2012_07_27_110003_9628117.trn'}). This is an informational message only. No user action is required.
    2012-07-27 11:24:11.160 spid5s SQL Server has encountered 644 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\ARSys.mdf] in database [ARSystem] (5).  The OS file handle is 0x0000000000000910.  The offset of the latest long I/O is: 0x00000d00f70000
    2012-07-27 11:29:54.920 spid5s SQL Server has encountered 108 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\ARSys.mdf] in database [ARSystem] (5).  The OS file handle is 0x0000000000000910.  The offset of the latest long I/O is: 0x00001a3df90000
    2012-07-27 11:35:49.760 spid5s SQL Server has encountered 451 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\ARSys.mdf] in database [ARSystem] (5).  The OS file handle is 0x0000000000000910.  The offset of the latest long I/O is: 0x0000278df50000
    2012-07-27 11:43:20.500 spid5s SQL Server has encountered 395 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\ARSys.mdf] in database [ARSystem] (5).  The OS file handle is 0x0000000000000910.  The offset of the latest long I/O is: 0x00000e61ce4000
    2012-07-27 11:49:37.100 spid5s SQL Server has encountered 252 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\ARSys.mdf] in database [ARSystem] (5).  The OS file handle is 0x0000000000000910.  The offset of the latest long I/O is: 0x00001c1b6c0000
    2012-07-27 11:51:40.450 spid5s SQL Server has encountered 89 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\tempdb.mdf] in database [tempdb] (2).  The OS file handle is 0x0000000000000708.  The offset of the latest long I/O is: 0x000000022b0000
    2012-07-27 12:00:17.320 Backup Log was backed up. Database: ARSystem, creation date(time): 2011/06/23(20:44:42), first LSN: 21108:73871:1, last LSN: 21108:334982:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'\\10.33.230.51\i$\Backups\Log\ARSystem\ARSystem_backup_2012_07_27_120012_3766170.trn'}). This is an informational message only. No user action is required.
    2012-07-27 12:25:49.000 spid5s SQL Server has encountered 31547 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\ARSys.mdf] in database [ARSystem] (5).  The OS file handle is 0x0000000000000910.  The offset of the latest long I/O is: 0x000003dfd26000
    2012-07-27 12:30:47.700 spid5s SQL Server has encountered 4 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\tempdb.mdf] in database [tempdb] (2).  The OS file handle is 0x0000000000000708.  The offset of the latest long I/O is: 0x00000000354000
    2012-07-27 12:30:47.700 spid5s SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\MSDBData.mdf] in database [msdb] (4).  The OS file handle is 0x0000000000000904.  The offset of the latest long I/O is: 0x0000000119c000
    2012-07-27 12:30:57.700 spid5s SQL Server has encountered 5874 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\ARSys.mdf] in database [ARSystem] (5).  The OS file handle is 0x0000000000000910.  The offset of the latest long I/O is: 0x0000436b838000
    2012-07-27 12:38:35.690 spid5s SQL Server has encountered 115 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\ARSys.mdf] in database [ARSystem] (5).  The OS file handle is 0x0000000000000910.  The offset of the latest long I/O is: 0x0000239e43c000


    Thanks

    Monday, July 30, 2012 12:01 PM
  • I think that is something wrong with your disk configuration...

    http://blogs.msdn.com/b/sqlsakthi/archive/2011/02/09/troubleshooting-sql-server-i-o-requests-taking-longer-than-15-seconds-i-o-stalls-amp-disk-latency.aspx


    Best Regards,Uri Dimant SQL Server MVP,http://sqlblog.com/blogs/uri_dimant/

    Monday, July 30, 2012 12:11 PM