Backup SQL Database Without Using Enterprise Manager?

May 2, 2004

Hello,





Is there a way where I can backup SQL database without using Enterprise Manager? If there is, may I know how?

View 3 Replies


ADVERTISEMENT

Database Backup Failed With Timeout Expired From Enterprise Manager

Apr 13, 2007

Hi,



I have SQL Server 2000 with SP4. When we take backup from Enterprise manager its fails with error "timeout expired". But when we take backup from query analyzer it works.



It seems that through enterprise manager 30 sec is the non configurable timeout parameter set. Checked sysprocesses table during backup but there was no blocking during that time at least for that spid.



Is there a way to find out which process is blocking the database backup? Also, what are the possible scenarios where database backup can be blocked.



Thanks,

Ramesh

View 4 Replies View Related

Backup And Restore With Enterprise Manager

Aug 2, 2005

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

View 2 Replies View Related

Enterprise Manager Backup Wizard Question

Feb 9, 2004

Is it possible, using the Database Maintenance Plan in Enterprise Manager, to save the backups to another server? It appears that it isn't.

I guess that I was curious as to why you can create a Backup Device and use that functionality when you run the Backup Database option when right clicking a database, but cannot use it within the context of the Maintenance Plan function.

Am I missing something?

Thanks,
Steve

View 2 Replies View Related

Physical Path For Backup Device From Enterprise Manager

Jan 20, 2000

View 1 Replies View Related

How To Backup/restore The Server List In Enterprise Manager

Jul 20, 2005

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 Related

SQL Enterprise Manager Hangs When Choosing A Location On Disk For A Backup Or Restore

Sep 15, 2004

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

View 2 Replies View Related

Database Stats In Enterprise Manager

Mar 1, 1999

We recently upgraded to Version 7.0 and the Enterprise Manager on the client is not showing the database size or the information in regards to the last backups.
Has anyone else experienced this that can offer a solution?

View 2 Replies View Related

I Can't Connect To My SQL Database Using Enterprise Manager :(

Sep 9, 2004

Hello,

I am trying to solve this problem for the past 1.5 weeks and it is driving me crazy :(

I can't connect to my SQL database using Enterprise Manager, Query Analyzer, Visual Studio 2003 .NET or a .aspx that I created for testing.. it runs perfectly on my domain but it doesnt work on my computer, on the browser I get this message: SQL Server unavailable or access denied. It is the same message I get when I try connecting to my db using EM, QA, VS.NET etc :(

I can ping my sql domain, so I know I have access to it and it is working.. I can successfully connect to my personal SQL server running on my machine. (SQL Server Personal Edition running on Windows XP )

I tried doing everything I could,

I already selected TCP/IP as my client only protocol;
I tried installing the lastest MDAC (v 2.8);
I tried every other port on my TCP/IP client setup like 14333 or 11433 or 11143 etc;
I tried every other port on the alias I set for my sql address;
I tried downloading the evaluation version of MS SQL2000 and updating it to SP3;
I tried reinstalling several times my MS SQL2000 (I use the personal edition on my windows XP) and updating it to SP3;
I tried connecting to my sql address domain and directly to its IP;
And I tried a lot more resolutions that I can't remember right now, but it didn't work :(

I've been searching all forums/google etc looking for someone with my problem but I still didnt, everyone who had a problem connecting to their DB using EM or QA resolved it by doing "this or that", I did exactly the same "this or that" on my computer/config and it didn't resolve my problem. :(

What am I doing wrong? I can't connect to my database from my personal computer :(

I have never used enterprise manager before, so I don't know if it is a problem on my personal computer or on my sql server address on internet.. Is there anyway to find a free test ms sql database with like 1mb just to try and find out if I can connect to a sql database at all using EM or if the problem is here on my computer?

Thanks in advance for any help,
Xande

View 3 Replies View Related

Cannot Connect To Database Using Enterprise Manager

Jul 4, 2007

I cannot seem to connect to this Instance locally which was i able toin the past. I can connect to the instance from out side. The instanceis running and the DBs in the instance are available and usedsuccessfully by the applications but i cannot connect to the instanceusing the enterprise manager.the error i get isSQL Server does not exist or access deniedrubeel

View 1 Replies View Related

Can't Restore Database From .a .bak File In Enterprise Manager

May 29, 2006

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 Related

Create UTF-8 Database Using Enterprise Manager Sqlserver2000

Mar 10, 2004

Friends

I know how to create a database using enterprise manager in sql server 7 or 2000.
But i want to create a database where i have to set the unicode as UTF8 for the whole database.
is it possible?
if yes, how can i do that.

thanks
sathyguy

View 3 Replies View Related

Viewing Database Via Query Analyzer And/or Enterprise Manager

Sep 20, 2004

We are running SQL 2000 SP3 on a Win2K server with multiple user databases. Our current problem is the ability of users to view the database objects via the native tools.

Example: User Bob
Bob has the following rights:
DB A – datareader/datawriter
DB B – datareader/datawriter
DB C – datareader
DB D – datareader
DB E – datareader/datawriter

The user has no builder rights or server roles.

In Enterprise Manager, the user can not see any databases. In Query Analyzer, the user can only see DB A, B, and C. Anyone seen this problem before and/or have suggestions?

Thanks in advance!

View 3 Replies View Related

Connecting To Online Database Using Local Enterprise Manager

Jul 23, 2005

I have Enterprise Manager on my local machine. For the last twelvemonths it has been connecting without problem to my online SQL Serverdatabase provided by my ISP.Three weeks ago the ISP applied some sort of extra securityarrangements to their SQL Server to allow access only through port1433. they have told me to configure an alias using Network Client andto register this alias in the usual way using my Enterprise Manager.My problem is that despite creating the alias in exactly the wayinstructed I just cannot connect to online database. I keep gettingthe SQL Server does not exist or access denied when I try to connect.As a result of advice obtained I have tried using the lite version ofthe 'littleADmin' tool available fromhttp://www.mylittletools.net/scripts/en/mla_sql/Using this useful looking software I find I cannot connect to theonline SQL database when it is installed on my own local machine butif I install it on my website it does connect without problem to myonline SQL. Server databaseHowever I need to use my more powerful Enterprise Manager to connect,my question (at last!) is:1. Is there likely to be a problem trying to connect to my onlinedatabase from Enterprise Manager on my local machine as a result ofthe new security arrangements. In other words, is there somethinganalagous to what is happening with the 'littleAdmin tool' wherebyusing Enterprise Manager I cannot connect from my local machine forsome reason obvious to everyone except myself??or2. Is it possible that there is some problem arising from Net Client?(the aliases appear in Enterprise Manager OK)I know my ISP should be answering this sort of question but they justdon't seem to know. I need to connect even if only to download mydatabase and take it to another ISP,Best wishes, John Morgan

View 4 Replies View Related

Negative File Size On Database Device In Enterprise Manager

Apr 28, 1999

I have several clients who are reporting a negative file size on their database devices in Enterprise Manager. The sp_helpdevice procedure reports the size correctly. Any suggestions?

View 1 Replies View Related

Problem COnnecting Remote Database Server Thru Enterprise Manager

Sep 6, 2003

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

View 10 Replies View Related

Query Analyzer Does Not See Enterprise Manager Database And Vise Versa

Jul 23, 2005

I am using SQL Server 2000.I have created a new database in Query Analyzer but I cannot see it inEnterprise Manager.I then created a new database in Enterprise Manager, but I can't see it inQuery Analyzer.How do I get these applications to see the databases that the other creates?Thanks,Greg

View 1 Replies View Related

Database Name Not Found In The Edit Job Step In SQL Server Enterprise Manager

May 1, 2006

Hi,I need help. I transferred my database from one server to another byusing attach detach process.I created all the jobs which existed in theold server in the new server. Everything looked fine but a couple ofjobs is a giving me some problems. When I try to edit the job step Icould see that the database dropdown list doesn't contain the databasename(which I transferred from the old server)Does anyone have any idea about it.ThanksArun

View 1 Replies View Related

How To Delete/drop All The Tables From SQL Server Database Without Using Enterprise Manager?

Sep 13, 2006

How to delete/drop all the tables from SQL Server Database without using Enterprise Manager?
I tried using DROP Tables, Truncate Database, Delete and many more but it is not working. I want to delete all tables using Query Analyzer, i.e. through SQL Query.Please help me out in this concern.Nishith Shah

View 34 Replies View Related

Registering Remote Database Server With Local Dbserver Enterprise Manager

Nov 15, 1999

Hi
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

View 1 Replies View Related

Problems Running Enterprise Manager And Service Manager

Jul 20, 2005

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 Related

Help! Enterprise Manager Turns SQL Server Service Manager Off

Dec 6, 2006

IF 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 Related

View SQL Sever 2005 Express Database On SQL Sever Enterprise Manager

Apr 25, 2006

Is it possible to connect SQL Sever 2005 Express from SQL Sever 2000 Enterprise Manager? Tried to connect but got the error message "must use SQL Server management tools to connect this sever"

Thanks

View 3 Replies View Related

Asp.net Enterprise Manager

Nov 30, 2006

Hi
has anyone used this tool to upload sql databases to a web host
i'm struggling
cheers!!!
Adrian
 

View 2 Replies View Related

Where Is Enterprise Manager?

Sep 10, 2005

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 Related

Enterprise Manager

Mar 21, 2001

When 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

View 2 Replies View Related

Enterprise Manager

Jun 11, 2001

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 Related

Enterprise Manager

Jun 12, 2001

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

View 1 Replies View Related

Enterprise Manager

Jun 20, 2001

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

View 2 Replies View Related

Enterprise Manager

Sep 26, 2001

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 Related

SQL 7 Enterprise Manager

Jul 28, 2000

I 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?

View 5 Replies View Related

SQL Enterprise Manager

Jan 25, 2001

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

View 1 Replies View Related

SQL Enterprise Manager

Apr 17, 2000

Is non-SA account able to view the SQL Enterprise Manager?

Thanks in advance!
Plum

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved