Post reply

In which book is log shipping .wrk files mentioned?

  • July 23, 2015 at 11:33 am

    #300570

    I have read the MCTS book, Books Online but did not find mention of .wrk files anywhere. Could you please let me know in which book this is covered.Interviewers are asking these kind of questions in interviews and hence i want to know where i can find it(source/book)

  • July 23, 2015 at 11:56 am

    #1814485

    it might not be mentioned, as it's a transitory file extension:

    [http://fileinfo.com/extension/wrk

    File TypeSQL Server Log Shipping File

    DeveloperMicrosoft

    Popularity

    2.0 (1 Vote)

    CategoryDatabase Files

    File Format Description

    Database backup file created by SQL Server, a relational database management system (RDBMS); saves a backup of transaction logs while they are being copied to secondary storage; renamed to ".trn" when the backup is complete.

    The ".wrk" extension is assigned to the transaction log backup file temporarily during the backup operation. Therefore, if you see a WRK file that has not changed for a long period of time, it is possible that the backup operation failed.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • July 24, 2015 at 2:42 am

    #1814663

    Thanks for the reply

  • July 24, 2015 at 4:38 am

    #1814683

    coolchaitu (7/23/2015)

    I have read the MCTS book, Books Online but did not find mention of .wrk files anywhere. Could you please let me know in which book this is covered.Interviewers are asking these kind of questions in interviews and hence i want to know where i can find it(source/book)

    That would be a very cheeky question by an interviewer hah - learnt something new though 🙂

  • August 2, 2015 at 9:21 am

    #1816660

    If these info are not found any books, how does the person who answers the question gets to know such things? Just curious to know

  • August 2, 2015 at 9:50 am

    #1816665

    if the interviewer asked "which book" then he probably is not the best person to interview candidates but on ther other hand if he just wanted to know if you are aware of the file extension and by extension the behaviour of log shipping then its a good question to ask.

    Where do you find answers for qustions like these , in your server is the best answer I can give you. No amount of book knowlegde is enough to replace hands on

    Jayanth Kurup[/url]

  • August 2, 2015 at 10:15 am

    #1816674

    Thanks a lot for replying Jayant. You said "In your server", actually i did not understand that.

  • August 2, 2015 at 12:35 pm

    #1816692

    Lowell Sir,

    If these info are not found any books, how does the person who answers the question gets to know such things? Just curious to know. Please share the links, if any

  • August 2, 2015 at 12:49 pm

    #1816694

    coolchaitu (8/2/2015)

    Lowell Sir,

    If these info are not found any books, how does the person who answers the question gets to know such things? Just curious to know. Please share the links, if any

    Im rather well rounded as far as sql and replication goes, and i did not know this. I just googled wrk files and found the answer.

    I would challenge this as unimportant and trivial compared to knowing how to set up some replication. Anyone asking this level of sql trivia is not asking the right questions.

    This ranks there with having to k ow that google downloads are named .crcdownload until complete, or something similar.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • August 2, 2015 at 1:04 pm

    #1816696

    You are right sir. However here in India, due to high number of job seekers, interviewers are asking such kind of questions. I was not selected for not being able to answer this question and felt very sad.

  • August 2, 2015 at 1:14 pm

    #1816698

    Tbh, it's a stupid question which tells nothing about a candidate's ability to do the job (unless they are being hired to develop a Trivial Pursuit game)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 4, 2015 at 1:28 am

    #1817010

    Dear Gail Shaw Sir,

    As i am a junior dba, i want to learn advanced dba internals and would like to become expert. Could you please suggest a good book/material

  • August 4, 2015 at 2:53 am

    #1817041

    All of them, and at least 5 years.

    Seriously, there's no one book that's going to make you an expert. Read everything you can get your hands on. Test everything out that the books describe, try everything that they show.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 5, 2015 at 7:25 am

    #1817507

    What I meant with In your server is , if you have set up log shipping and monitored it regulalry your likely to have come across this file type atleast once. Basically At your server = Hands ON i.e not in a book

    Jayanth Kurup[/url]

  • August 5, 2015 at 9:46 am

    #1817608

    Jayanth sir,

    Thanks. Can you please suggest me a good book where i can gain knowledge of dba internals(mirroring internals,log shipping internals)

Viewing 15 posts - 1 through 15 (of 21 total)

You must be logged in to reply to this topic. Login to reply