| Author |
Topic |
|
CSK
Constraint Violating Yak Guru
489 Posts |
 Posted - 2008-04-02 : 12:52:17
|
| Gurus,I dont have EM and Query analyser on my Server! Even i cant register the server on other sql server also.I want to move my database in diffrent location.How can i move my databasae..?Please help me. It is bit urgent.ThanksKrishna |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-02 : 12:56:28
|
| Did you install SQL server correctly?What you get if you put : SQLWB.EXE in run |
 |
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2008-04-02 : 12:59:37
|
quote:
Originally posted by X002548
Do you have client tools?Is the server on a network?Do you know what osql/sqlcmd is?What version of SQL Server are you using?Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam
Do you have client tools?NoIs the server on a networkYesWhat version of SQL Server are you usingSQL 2000 (I dont know the service pack)Do you know what osql/sqlcmd isNo. I never worked on OSQL. I havnt find SQLcmd command in the server |
|
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2008-04-02 : 13:01:32
|
quote:
Originally posted by sodeep
Did you install SQL server correctly?What you get if you put : SQLWB.EXE in run
Sodeep, I haven't install the sql server. Which was installed two years ago. today only i come to know about the server. This is SQL 2000. I tried with isqlw . Its saying Windows can not find "ISQLW". |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2008-04-02 : 13:11:44
|
| I know the Server name. But i am not sure about the Accoutn whether its a SQL server account or Trusted account. I am bit cofused about this link. which one i have to go. wolud you please tell me.Thanks-- Krishna |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2008-04-02 : 13:45:27
|
| I am not kidding you. I dont know which exe i have to download. |
|
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2008-04-02 : 14:39:43
|
| Problem solved!!! Thanks for your valuable suggestions.-- Krishna |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-04-02 : 14:42:54
|
| It sounds like SQL is not installed on the server you're looking at. Under Program Files, do you see Microsoft SQL Server? When looking at services, is MSSQL running? Can you find your .mdf and .ldf files on that server? I don't believe Brett was pointing you to an exe but to some self-help documents. And some good advice from him as well: if you're sure SQL is running on that box, install the client tools. You're asking for advice, receiving it but not paying attention to the suggested solutions.Terry |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-04-02 : 14:45:52
|
| Brett, what is Frapper?? I'm at work and it's blocked here but I can get to informational sites such as these.Terry |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-04-02 : 14:47:16
|
| Looks like you solved it before I could finish typing. How did you resolve the issue? If you post your resolution, others can learn.Terry |
|
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2008-04-02 : 14:59:08
|
| I installed toad client tool. I just added my trusted connection, then I can able to log in thru OSQL.I used attach and detach. Its working fine. |
|
|
|
|
No Query analyser and EM