• SQLCrazyCertified (3/19/2013)


    anoop.mig29 (3/19/2013)


    Hi for last two days at one of our client side we have been trying figure out a why its taking two days two restore database backup files on secondary server. restore process is till going on and is stuck at 98% and no other process are there on secondary server.

    using sp_who2 i could find only two lastwaittypes as BACKUPTHREAD and BACKUPIO. how should i proceed ahead with analysis . i mean does disk has some bottleneck problem ?/

    the database of which we are trying to restore has file group.does it had to anything with filegropu

    How big is this database?, are you getting any errors?, or it's just stuck at 98%?

    SueTons.

    database is something around 400GB and We are not getting error but just that two waittypes and it is just stuck at 98 % increase marginally. DiskIO changes but after some time interval

    bhushan_juare (3/20/2013)


    [font="Courier New"]Hi Anoop,

    Kindly check disk space where ur database files are resides or another way is you can take primary sever database files restore that .bak on secondary server.. try dis and let me know what happen..? [/font]

    There is enough space on dive on secondary server