Hi guys, I don't own a copy of Enterprise Manager and I need to remotely restore a database on my local machine to my hosted machine, can you guys recommend an application that can do remote restores?
Or is there a way to convert a Database into a long set of Transact SQL statements that I can run on the remote server (ala MySQL's MySQLDump)?
Thanks
GP
Hi i need some insistance with Backing up and Restoring database in SQL Enterprise Manager.
I have SQL installed on my local machine, and there is also an instance of the database on the Actual Server.
What i want to do is backup a dbase on the server called 'DATA1' let's call it, and want to then restore it to a new dbase on my local server called 'DATA2'.
What is the best way of doing this, through the wizard in:
What menu's do i go through.
I think where i may have the problem is when i try to RESTORE to my local...That part i an confused at.
Please Help with both Backing up and Restoring, using best practices in Enterprise Manager.
THANK YOU for your help
uno_turko
Hi Everybody,I use MS SQL server 2000 enterprise manager on a windows server 2003.I created a new database in enterprise manager, and try to restore the new database from a .bak file. I went to ---->restore database. I checked "from device" and select the right path to the .bak file.Then I click ok, but there is an error pop up." tend to override existing database", so I went to --->option, and checked "force override existing database". then I click ok, but get an error look like this http://ewwa.lo7.net/error.JPGI thought it was a problem with my .bak file. So I try to use another .bak file which I am sure it is 100% good. It prompt the restore is sucessfully. But when I checked the db, there nothing there(No tables).I think there must be something wrong with my enterprise manager's configuration.Do you know what happen with my enterprise manager? Thank you a lot in advance:)!!
View 2 Replies View RelatedWe just installed an application, WhatsUpGold, to monitor our servers. Management won't let me host that on my primary SQL box. So, we are using MSDE on the local machine (call that box my_netmon).
I can access the db with very basic functionality using osql while on the my_netmon machine. I've added my domain user account as a System Admin using the following commands.
exec sp_grantlogin @name
go
exec sp_addsrvrolemember @name, 'sysadmin'
But when I go to the my_sql machine and try to attach to it with Enterprise Manager I get an error that the server does not exist.
What gives??? Is it just not possible, or am I missing something here?
My goal is to just be able to see the data stored in the MSDE db. Write views, etc...
Please advise,
Marc
Hi All,
Recently had to rebuild our SQLServer installation from scratch! major pain!! We had a remote server running a replicated version of the internal database system for the website. We also have a SQL DB hosted with a new ISP which is in test mode. All managed via EM.
Re-installed software, upgaded tp SP3, new MDAC. Set up the references for the two external DB's with the Client Network Utility. In EM set up a connection to DB on the new ISP, works perfectly, tried on the old DB and get 'SQL Server is not running or access denied' error message.
I confirmed the server is running, as its our live site. Cant connect using Query Analyser. I can ping the adress successfully. I've created new user logings that mach on both machines/servers, still no luck!
Can anyone suggest what the problem is/might be or how to fix... I'm flat out of ideas!
Major THANKS! for any gems...
Davej
Hi,In case of a remastering of a client, I need to backup the EnterpriseManager configuration (the groups, the declared servers in thegroups), instead of registering all servers manually once again.Does anyone know how it could be done ?TYArjp
View 2 Replies View RelatedHere is what I knew: usr/pwd, Domain, Server and Database.
How to set Enterprise Manager, then can I connect to DB ?
Hello Guys,
I have just put up an Webserver with SQL Server 2000. Everything is working fine on the remote machine Thru TS .. i can do every administrative things .. But i m facing problem to connect my remote databse server thru the Enterprise Manager .. It Gives me Cant Connect Database Server " Connection Failiure " when i try to connect my remote database server thru Ip address ,.. Please some one help me out to make connecting database server thru Enterprise Manager ..
Thanks
Hi all,I need to gain access to a remote SQL Server 2000 storing my data.The remote SQL machine can only be accessed via an internet connection,that is - it is not part of my network.I know Enterprise Manager can do the job, but EM only comes bundled inMS SQL Server, which is not installed on the client machine.Please let me know which other (preferably free) tools can performsuch remote access.Thanks,Gilad Haimov
View 1 Replies View RelatedHi
I amtrying to register remote database server with my local machine Enterprise Manager. It says server doesnot exist or not available.
I am putting server name,Tcp/Ip, i.p,port in Sql client configuration utility
and then trying to register it with Enterprise Manager.
Pl help me out.
Thanks
Shaurav
When I select All Actions>Backup Database and then click the ... button to choose a location on the hard drive, SQL Enterprise Manager Hangs and I have to kill it from Task Manager.
All other areas of EM browse the disk drive without a problem. (DTS, File Groups, etc.)
Anyone ever run into a similair problem?
Thanks
On one of our machines, all of the SQL Server 2000components except for the main Server component (SQL Servercore) itself were installed (Management tools, etc) a while agoand everything was running fine. Now I go and add/install theServer component and then Service Pack 3a.It seems that Service Manager won't start up (I get an hourglass cursor)and now I find that Enterprise Manager won't run as well. No errormessages appeared and I don't think I saw anything unusual inthe log file.However, I can use Enterprise Manager on a differentmachine and connect to the database (so the databaseitself seems to be running).Any suggestions as to what the problem might be and how tofix it? I like to see if I can repair this without havingto do a reinstall.Thanks.PF
View 2 Replies View RelatedIF someone can assist me. Everytime I load up enterprise manager the service manager turns off. And the enterprise manager can't connect to the local database. But everytime i turn it back on and try to connect again it shuts it off and around and around we go. Help would be appreciated. Thanks.
View 2 Replies View RelatedWhile migrating Report services in SQL Server 2005 to 2014, I am trying to restore the Encryption Key in RS Configuration Manager in2014. But I cannot click the 'Restore' button in RS Configuration Manager. So if I should be grant more right to do so or any other action?
View 2 Replies View RelatedHi
has anyone used this tool to upload sql databases to a web host
i'm struggling
cheers!!!
Adrian
I installed SQL Server MSDE 2000 but I can't find how to start it. Does this package include an Enterprise Manager or not? I thought that maybe it was a standard XP Pro feature. I had no problem finding it in W2000 Pro.
View 1 Replies View RelatedWhen I open databases, there is nothing there - not even Master, Model, Temp, Pubs, etc.
When I open the query analyzer, however, they all appear in the drop down.
What is up with that? and how can I remedy?
OP sys:Win98
SQL Server 7
Has anyone encountered this error: When you are in Enterprise manager and you select a database then the tables tab and then you select a table and go to open table- select all rows, I get an error--An unexpected error happened during this operation-Query Designer encountered a query error! Please let me know if you have seen this. Also, when I access this from one networked computer I get the same error, then when I access it from another I do not!! The servers are interacting with Pivotal. The one that works does not!!
View 3 Replies View RelatedHi all,
I have SQL 7.0 desktop addition installed on my local win NT workstation. I am able to connect to my local server using Quary Analyser but when i am trying to connect using EM, i am not able to connect. I am receiveing the following error message.
__________________________________________________ ___________________________
A conncetion could not be established to "servername" - Specified SQL Server not found. ConnectionOpen(CreateFile()).
Please verify SQL server is running and check your SQL Server registration properties(by right clicking "servername" node) and try again.
__________________________________________________ ___________________________
I have tried as said in the error message and also tried connecting with "sa" but its not working. I can see that the server is running and i am able to connect through QA.
any help is highly appriciated.
We can no longer open tables in EM. The error message is;
An unexpected error happened during this operation
[Query] - Query Designer encountered a Query error:
Unspecified error
The tables are fine - can access them other ways.It looks as if the fault is in the script used by EM. Anyway to clear this ??
I am fairly new sql dba in a company and I am sure Enterprise Manager is installed on PC's and it shouldn't. Is there a way of finding out other then visiting each workstation. Thanks in advance..
View 1 Replies View RelatedI am considering upsizing my Access 2000 DB to a SQL 7 server. I was told that having SQL 7 Enterprise Manager is highly prefferd but not essential as I can maintain the upsized DB with Access 2000. The only way that I have been able to find JUST enterprise manager seems to be with purchasing the whole SQL 7 program for $1300! Microsoft cannot be that cruel, that you have to buy the whole program just for Enterprise Manager!
My questions are:
Can I download just MS SQL 7 Enterprise Manager anywhere for a reasonable fee or free?
and
if not, can I continue to use Access 2000 to maintain the SQL 7 upsized DB?
I have access to a SQL 7 server via my ISP Hosting account. I know Enterprise manager comes with the server software, but how can I get a copy of JUST Enterprise Manager?
JD
Is non-SA account able to view the SQL Enterprise Manager?
Thanks in advance!
Plum
Is it possible to administer both 6.5 and 7.0 databases from the same SQL Enterprise Manager? I have read that you cannot do this because the 7.0 "plug-in" to the MMC wont work with 6.5 databases.
View 2 Replies View RelatedWe had database corruption and cannot access the Enterprise Manager. DBCC returned errors 9000 to 9999 which I can't get any suggestions on how to handle from BOL. Any ideas!!!!! Thanks.
View 4 Replies View RelatedHi,
I would like to know if we can present users to access details database information about the databases on a server through Enterprise Manager.
If you create a SQL login and do NOT give it access to any database, if someone logons on your server with enterprise manager, even though he does not have access to any database, he will still see the list of all database on your servers plus tons of sensitive information like database owner.
Is is possible to limit enterprise manager to only view information about database that the user has access to?
Thanks
Mark
How can I force users of Ent Manager 6.5 to enter a name/password when connecting to a server that has been registered? I dont want to use the sa name and password so that anyone could use my workstation to access our servers.
View 2 Replies View RelatedDoes anyone know how to turn off or disable the auto discovery for Enterprise Manager. Apparently our Network group is complaining that Enterprise Manager is generating noise on the network, it is not signifcant in volume but they complain it impacts there ability to detect hacking attempts on our network because it causes some false positives. I generally keep Enterprise Manager running because I will always have some manual job running from it and we have so many servers it takes awhile for them to all load when I first fire it up.
Thomas
Hello guys,
Just wondering if i can use CPU, Memory usage, I/O or wait events for SQL trace. I am having difficulty in finding theses events on SQL trace.
Also is it possible to show the SQL trace file output in graphical format.
Thanks
Hi,
I have SQL server 2000 client machine on my XP desktop which worked fine
until yesterday.
Yesterday, I tried to set up client access (a tool from IBM to access AS400) unsuccesfully. Since ever, Each time I try to open a table in enterprise manager, I get the following error message
"The query cannot be executed because some files are either missing or not
registered. Run setup again to make sure the required files are registered".
While when I issue a query in analyzer it works fine.
I did that several times without success. Even, I removed the whole SQL 2000
setup, rebooted my machine, ran set up again for client tools which gave the
same result. Also, I re-setup MDAC2.6 SP2 but no way.
Which files are corrupted ?and I don't understand after doing all that,
setup goes smoothly without indicating any errors, but still when you open a
table in enterprise manager, it gives the same error.
Thanks in advance
Hi,
Using MS SQL Server 7. When I go into a table in design view and order by date created, it only orders on the day and not the date (Enterprise Manager) e.g.
29/08/1981, 11/12/2004, 31/12/2003
should be
11/12/2004
31/12/2003
29/08/1981
but it's this instead
31/12/2003
29/08/1981
11/12/2004
Please help.... is this a bug
Hi,
My Question is regarding the Query Analyzer.
When we click on the Query Analyzer Shortcut, it will prompt for a user id and password.but when we expand the databases node from EM and clicks on Tools->Query Analyzer Menu, after selecting a database node, the QA does not prompt for the user id and password. Can any one explain this behaviour of QA..
I am using Mixed mode authentication for my db server.