Attaching dbs from remote to local | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Attaching dbs from remote to local

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.
SQL Server won’t let you, and with good reason. Read up on SQL Server basics.
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
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
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.
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

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?
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".
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

Right. But the one I am talking about isn’t in that list, is it? I mean, polite form – there’s no point. Sometimes you have to tell it like it is! Tom Pullen
DBA, Oxfam GB
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
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
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.
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(]
<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 />
<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
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 />
<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=’;)‘ />]
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>
<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 />
<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
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.
You do just fine. How many questions do I answer in the Spanish forum? Tom Pullen
DBA, Oxfam GB
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 />
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
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.
aarosandy, ur problem what ive understood can be overcome by mapping the network drive where the mdf file is located
<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
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.
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.

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.
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |