SQL Server Performance

Attaching dbs from remote to local

Discussion in 'General DBA Questions' started by aaronsandy, Feb 15, 2005.

  1. aaronsandy New Member

    I have few databases in mdf and ldf on a remote server.now i want to attach these dbs in my machine via EM ..can it be possible.i m using vncon for accessing file remotely.I dont want to copy these database folder from remote server to my machine and then attach it, as it will consume my systems memory uselessly.The total size of these databases is 7 Gb approx..Further the remote system has no SQL server .Only the mdf and ldf are arranged in suitable folder and kept.
  2. Adriaan New Member

    SQL Server won't let you, and with good reason. Read up on SQL Server basics.
  3. gkrishn New Member

    As per ur Question, u want SQLserver in ur machine and database in remote server which is not possible.
    you have to copy the files to desired locations in ur machine and reattach .
    Copyin through network share is common practice,or transportable media,disk etc...



    Rajiv
    SQL-DBA
  4. thomas New Member

    quote:Originally posted by Adriaan

    SQL Server won't let you, and with good reason. Read up on SQL Server basics.

    WORD. Maybe someone needs to explain to Aaron what the acronym R.T.F.M. means.

    Tom Pullen
    DBA, Oxfam GB
  5. Adriaan New Member

    quote:I dont want to copy these database folder from remote server to my machine and then attach it, as it will consume my systems memory uselessly.
    (1) Bringing the database online by attaching MDF and LDF files does consume system memory, but look here - this is a database server, so there is software running in memory that will provide the data to a client application that puts in a request for data. What are you expecting?
    (2) In order to improve performance, the server software very cleverly uses system memory to cache oft-requested data. If you think that's a waste of system resources then I'm afraid you're not getting any of this anyway.
    (3) You're confusing volatile memory with disk space.
    (4) I'm having trouble understanding your angle on all this.
  6. FrankKalis Moderator

  7. mmarovic Active Member

    Hi aaronsandy. I don't want to offend you, but it is obvious that you are trying to manage software you don't have basic understanding about. The purpose of this message board is knowledge share, which in most cases means more experienced/knowledgeable users help one who is not at that level yet. However, before trying to accomplish anything mssql server related and posting question about it, try to read and understand mssql server basics. Books on-line is great source of information but you may need some kind of beginners guide first. Can anyone recommend a good introductory guide, article or training material?
  8. Adriaan New Member

    quote:Originally posted by FrankKalis

    The polite definition of RTFM can one find here:
    http://www.acronymfinder.com/af-query.asp?String=exact&Acronym=rtfm

    --
    Frank
    http://www.insidesql.de

    Thanks Frank, polite seems to be your middle finger name. And "Read The FAQ 'n Manual" is certainly one to remember.

    The equivalent in Dutch for the F word sounds roughly the same as the English "cut", so I help out colleagues who use the term by adding "and paste".
  9. thomas New Member

  10. thomas New Member

    quote:Originally posted by mmarovic

    Can anyone recommend a good introductory guide, article or training material?

    More to the point, can anyone be BOTHERED to?

    Tom Pullen
    DBA, Oxfam GB
  11. thomas New Member

    quote:The equivalent in Dutch for the F word sounds roughly the same as the English "cut", so I help out colleagues who use the term by adding "and paste".

    Ha ha ha. I am never going to be able think about "cut and paste" in the same way again, ever. Thanks, adriaan!!

    Tom Pullen
    DBA, Oxfam GB
  12. satya Moderator

    Play nice guys....

    In addition to the books online I suggest the following....
    http://www.sqlcourse.com/
    http://www.w3schools.com/sql/sql_intro.asp
    http://www.webdevelopersnotes.com/tutorials/sql/index.php3

    I'm sure Frank will tuck in more relevant links.

    Aaron, do not mis-understand what was referred by other peers and it saves your time and interest in gaining knowledge in SQL Server and this forum is always available to help you out.


    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  13. Adriaan New Member

    quote:Originally posted by thomas


    quote:The equivalent in Dutch for the F word sounds roughly the same as the English "cut", so I help out colleagues who use the term by adding "and paste".

    Ha ha ha. I am never going to be able think about "cut and paste" in the same way again, ever. Thanks, adriaan!!

    Tom Pullen
    DBA, Oxfam GB
    I don't think this qualifies as one of Dr Phil's "life changing moments", but I'm happy for you. Ah, such joy one can bring into one another's heart.[xx(]
  14. Adriaan New Member

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by satya</i><br /><br />Play nice guys....<br />&lt;......&gt;<hr noshade size="1"><b>Satya SKJ</b><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">Of course, Satya.[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br />
  15. thomas New Member

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by satya</i><br /><br />Play nice guys....<br /><br />In addition to the books online I suggest the following....<br /<a target="_blank" href=http://www.sqlcourse.com/>http://www.sqlcourse.com/</a><br /<a target="_blank" href=http://www.w3schools.com/sql/sql_intro.asp>http://www.w3schools.com/sql/sql_intro.asp</a><br /<a target="_blank" href=http://www.webdevelopersnotes.com/tutorials/sql/index.php3>http://www.webdevelopersnotes.com/tutorials/sql/index.php3</a><br /><br />I'm sure Frank will tuck in more relevant links.<br /><br />Aaron, do not mis-understand what was referred by other peers and it saves your time and interest in gaining knowledge in SQL Server and this forum is always available to help you out.<br /><br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com/forum>http://www.SQL-Server-Performance.Com/forum</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS” with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />Ah, Satya, maybe you're right, maybe you have more patience than I. However when I got the "<img src='/community/emoticons/emotion-6.gif' alt=':(' /> not satisfied" reply, I must admit, mine ran out.<br /><br />Tom Pullen<br />DBA, Oxfam GB
  16. Luis Martin Moderator

    Young people..........[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Luis Martin<br />Moderator<br />SQL-Server-Performance.com<br /><br /><font size="1">One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important<br />Bertrand Russell<br /></font id="size1"><br /><br /><font size="1">All postings are provided “AS IS” with no warranties for accuracy.</font id="size1"><br /><br /><br /><br />
  17. Adriaan New Member

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by LuisMartin</i><br /><br />Young people..........[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">Says who?[<img src='/community/emoticons/emotion-5.gif' alt=';)' />]
  18. satya Moderator

    Tom<br /><br />[<img src='/community/emoticons/emotion-2.gif' alt=':D' />] Even that too have a breaking point...<br />I can understand your frustation as the originator may not have tolerance what it meant and on the subject.<br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by thomas</i><br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by satya</i><br /><br />Play nice guys....<br />...<br /><br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com/forum>http://www.SQL-Server-Performance.Com/forum</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS” with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />Ah, Satya, maybe you're right, maybe you have more patience than I. However when I got the "<img src='/community/emoticons/emotion-6.gif' alt=':(' /> not satisfied" reply, I must admit, mine ran out.<br /><br />Tom Pullen<br />DBA, Oxfam GB<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com/forum>http://www.SQL-Server-Performance.Com/forum</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS” with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>
  19. mmarovic Active Member

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote">Ah, Satya, maybe you're right, maybe you have more patience than I. However when I got the "<img src='/community/emoticons/emotion-6.gif' alt=':(' /> not satisfied" reply, I must admit, mine ran out.<hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">I remember when my english was even worst then it is now, I used to create just a few words sentences to avoid to look stupid. Occassionaly it was just the opposite.<br />
  20. thomas New Member

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by mmarovic</i><br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote">Ah, Satya, maybe you're right, maybe you have more patience than I. However when I got the "<img src='/community/emoticons/emotion-6.gif' alt=':(' /> not satisfied" reply, I must admit, mine ran out.<hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">I remember when my english was even worst then it is now, I used to create just a few words sentences to avoid to look stupid. Occassionaly it was just the opposite.<br /><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />That's fine though -- we accommodate people who are making the <i>effort</i> to learn (e.g. a foreign language), but I don't think English-as-a-second-language accommodations apply in this case.<br /><br />Tom Pullen<br />DBA, Oxfam GB
  21. Luis Martin Moderator

    Agree, if your English is bad (like mine) you have to be carefully when write something.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell


    All postings are provided “AS IS” with no warranties for accuracy.



  22. thomas New Member

    You do just fine. How many questions do I answer in the Spanish forum?

    Tom Pullen
    DBA, Oxfam GB
  23. Luis Martin Moderator

    When I read you first post about original one, I was thinking: If Tom has to answer in Spanish forum his signature will: READ BOL[<img src='/community/emoticons/emotion-2.gif' alt=':D' />][<img src='/community/emoticons/emotion-2.gif' alt=':D' />][<img src='/community/emoticons/emotion-2.gif' alt=':D' />].<br /><br /><br />Luis Martin<br />Moderator<br />SQL-Server-Performance.com<br /><br /><font size="1">One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important<br />Bertrand Russell<br /></font id="size1"><br /><br /><font size="1">All postings are provided “AS IS” with no warranties for accuracy.</font id="size1"><br /><br /><br /><br />
  24. thomas New Member

    You should have read it BEFORE I edited it in advance of pressing "submit". I think one of the phrases I edited out was "*slaps forehead*".

    Tom Pullen
    DBA, Oxfam GB
  25. ranjitjain New Member

    quote:Originally posted by mmarovic

    Hi aaronsandy. I don't want to offend you, but it is obvious that you are trying to manage software you don't have basic understanding about. The purpose of this message board is knowledge share, which in most cases means more experienced/knowledgeable users help one who is not at that level yet. However, before trying to accomplish anything mssql server related and posting question about it, try to read and understand mssql server basics. Books on-line is great source of information but you may need some kind of beginners guide first. Can anyone recommend a good introductory guide, article or training material?

    I agree that aarosandy is new and he shld read books online, but whats wrong if he post
    his qs on this message board. he has not forced anyone to ans him.
    may be he must have found easier posting than finding any ans in books.
    So by this way he is sharing his knowledge too.
    [:I]
    quote:Knowledge Comes from mistakes. right sire.
    so plz dont discourage him.
  26. ranjitjain New Member

    aarosandy, ur problem what ive understood can be overcome by mapping the network drive where the mdf file is located
  27. thomas New Member

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by ranjitjain</i><br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by mmarovic</i><br /><br />Hi aaronsandy. I don't want to offend you, but it is obvious that you are trying to manage software you don't have basic understanding about. The purpose of this message board is knowledge share, which in most cases means more experienced/knowledgeable users help one who is not at that level yet. However, before trying to accomplish anything mssql server related and posting question about it, try to read and understand mssql server basics. Books on-line is great source of information but you may need some kind of beginners guide first. Can anyone recommend a good introductory guide, article or training material?<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />I agree that aarosandy is new and he shld read books online, but whats wrong if he post <br />his qs on this message board. he has not forced anyone to ans him.<br />may be he must have found easier posting than finding any ans in books.<br />So by this way he is sharing his knowledge too.<br />[:I]<hr noshade size="1"> <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote">Knowledge Comes from mistakes. right sire.<hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />so plz dont discourage him.<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />You have a point, but he does nothing to endear himself to those who obviously have an inclination to be helpful, by making comments like "<img src='/community/emoticons/emotion-6.gif' alt=':(' /> not satisfied", when someone gives him an honest answer he could have found out by reading BOL for 10 minutes. Anyway, I'm going to shut up now, before I bore the pants off you all.<br /><br />Tom Pullen<br />DBA, Oxfam GB
  28. mmarovic Active Member

    quote:That's fine though -- we accommodate people who are making the effort to learn (e.g. a foreign language), but I don't think English-as-a-second-language accommodations apply in this case.
    I respect you as English language expert, at least from my point of view. Not having information about originator's country and reading original post I came up to conclusion that he is not native english speaker. I may be wrong however.


    quote:I agree that aarosandy is new and he shld read books online, but whats wrong if he post
    his qs on this message board. he has not forced anyone to ans him.
    Formally nothing wrong. I just tried to really help him instead of answering concrete question. My point was to discourage him from managing production sql server before he gains basic undersanding about it. Also from his qusetions I came up to conclusion that he asks for tips about "how to" details without effort to understand rdbms first, which is not good approach IMO. To summarize: Better read first, then ask what you don't understand.

    Anyway, I also don't want to comment on this topic anymore. You are right that I don't have to answer every question and it is not my job to comment about one who asked, his knowledge and his motives.
  29. ranjitjain New Member

    quote:Originally posted by mmarovic


    quote:That's fine though -- we accommodate people who are making the effort to learn (e.g. a foreign language), but I don't think English-as-a-second-language accommodations apply in this case.
    I respect you as English language expert, at least from my point of view. Not having information about originator's country and reading original post I came up to conclusion that he is not native english speaker. I may be wrong however.


    quote:I agree that aarosandy is new and he shld read books online, but whats wrong if he post
    his qs on this message board. he has not forced anyone to ans him.
    Formally nothing wrong. I just tried to really help him instead of answering concrete question. My point was to discourage him from managing production sql server before he gains basic undersanding about it. Also from his qusetions I came up to conclusion that he asks for tips about "how to" details without effort to understand rdbms first, which is not good approach IMO. To summarize: Better read first, then ask what you don't understand.

    Anyway, I also don't want to comment on this topic anymore. You are right that I don't have to answer every question and it is not my job to comment about one who asked, his knowledge and hit motives.

    I think aarosandy understands that he shld read book first and he shld ask only those which he dont get in his head properly. But many people have posted same messages to him still he doent want to read books. So for this comment also we cant force him.
  30. satya Moderator

    Folks

    The matter is slipping into the side tracks and as per the Forum's policies I'm forced to lock the thread.

    To Aaron

    If you need to continue the discussion about the issue then kindly open another thread and do not pass wicked comments for the replies to your thread. The forum is here to help and everybody participation is voluntary to share the knowledge.

    Thanks guys.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page