Hi
In my app. i'm using sql server 2000 now I want to move to MSDE2000. I have two Queres. my application environment is Vb.net
1.how to dump my sqlserver database which i was already using to theMSDE and
2.can i connect this MSDE to MSSqlServer2000
Hi,
I need a good suggestion from you.
1. I need to create a replication enviroment. In that i want to snapshot the database as and when i want from my Java program, so that selective tables are updated with latest data. Is there anyway i can do with out creating native replication methods.
2. Is there any way with out creating a snapshot or replication. I need to copy the data from my master database to child database(my reporting database) with out straining much my master database
Thanks in advance
Regards Jagannadh
Hi people
when doing a dump on a Win2000/SQL7 database from and NT4/SQL6 machine I get the following error:
SqlDumpExceptionHandler*****
EXEPTION_ACCESS_VIOLATION. SqlServer is terminating the process.
Can anybody tell me why?
What should I do?
Tks
De waal
Hi all,
When I use "DUMP DATABASE", it will help me to backup both database and
transaction log. However, it will not help me to clean up the transaction log.
Therefore, I am worry that will the following happen?
1. DUMP DATABASE
Start backup database
( there are transactions during the backup process )
Finish backup database
Start backup transaction
Finish backup transaction
2. DUMP TRANSACTION
Start backup transaction and clean up the transaction log
So, will the transactions been backuped twice? If yes, will it cause those
transaction do twice when I restore the database then restore the transaction?
Thanks
Hello, All!
Can anyone explain what happens to Transaction Log
when DUMP DATABASE is issued?
Thanx.
John.
Tried googling, but I guess I have the wrong terminology for MSproducts.Using PostgreSQL, or MySQL, if I wanted to tranfer a database from onemachine to another, I'd do a "dump" with a single command, such as:mysqldump [databasename] > [path/filename]Then I'd take the file generated and dump it back onto a new machine.What's the process with MS SQL Server? Can someone point me in theright direction to a webpage dealing with this?--[ Sugapablo ][ http://www.sugapablo.com <--music ][ http://www.sugapablo.net <--personal ][ Join Bytes! <--jabber IM ]
View 3 Replies View RelatedI am trying to backup database on a network disk using isql
dump database <DBNAME> to disk = 'servernamepathfile.ext' with INIT
but this does not work and gives an error device off line.
How can I do this??
Thanks
Hello,
I have a SQL database dump with me. I would like to create a database using the dump. Could somebody help me with the steps?
Thanks :)
Both "dump database" and "sqlmaint.exe -bkupdb" would be able to backup database, one important advantage I can see from "sqlmaint" is that it has the option to cleanup the very old generations of backups by using -delbkups option in a scheduled maintenance backup job, while the "dump database" would first create a dump device and it'll grow with time.
Is there any suggested way to use the "dump transaction" but still we can get control on the size of dasd used ?
Any negative part of using "sqlmaint" utitity to backup database as compared to the "dump database " utility ?
Anthony
We run SQLMaint hourly ( as a scheduled task ) to clear our transaction logs. Last night our hard drive filled up during a log dump, causing SQLMaint to fail, and a subsequent transaction filled up the log.
We succeeded in manually truncating and clearing the log, but SQLMaint still insists on us doing a DUMP DATABASE to clear the logs before it will run again. Unfortunately, we do not have enough space left on our hard drive to do a full database dump.
Is there any way of fooling SQLMaint into believing that a DUMP has been run? Some flag in a system table somewhere, or maybe a registry entry?
John Morrison
Hurst, TX
I am attempting to remember the string to dump/restore a database to a different physical server.
I have the database on Server 1 and want to back it up to server 2. Can anyone refresh my memory?
Thanks
Hi there,
I'm a newbie. I've installed a replication between 2 NT4 servers, with SQL 6.5. My logreader tasks has crashed "Can't allocate space for objects 'syslogs' in database 'distribution' etc...". With a DBCC SQLPERF(LOGSPACE) I can see that the log is 100% full, but I can't dump it : when I use DUMP TRAN DISTRIBUTION WITH NO_LOG, my distribution log is still 100% full. So how can I do to dump it and what can I do to prevent it from filling up ? Do I need to dump it like I do for my database but how could it work if a DUMP TRAN doesn't work ?
Thanks in advance.
Sorry for the English, it's not my native language.
I am fairly new to SQL server and am having a problem getting the SQL backup or "dump" to do what I need it to do. My desired end result is to have a database backup every night to a backup device on the same server as SQL is running, and keep one weeks worth of databases in the backup device, overwriting the database backup from 7 days before. This device is then transferred sometime later to another server using the NT AT scheduler. The first time I tried to accomplish this I used Enterprise manager to schedule a full backup to be run each night at midnight. The backup device was set to be initialized and retained for 7 days. This procedure worked once, the first night. There after it failed. In looking at books on line it said that I needed to change the transact -SQL command from INIT to NOINIT as the INIT instruction was the cause of the failure. I changed the statement in the Scheduled Task manager to NOINIT. That seemed to do the trick as I checked the backup device each of the next few days and saw that it was indeed performing the backup and retainng the databases. A week later I checked the backup device again and found that it is still adding database dumps to the file, but it is not overwriting the dumps that are 7 days old. I am told that I need the INIT statement in the dumpdevice command in order for the RETAIN DAYS = command to kick in. However, this did not work before. I can not continue adding to the dump device as it will get too large and take up too much disk space on the server. The only way I can get the device to a reasonable size is to do a backup and initialize the device, which gets rid of all of the older databases. This seems like a catch 22. Is there any way I can make this work. I am running SQL 6.5 on the latest service pack (5a). Any help would be greatly appreciated.
View 4 Replies View Relatedhi,There is facility to do backup of the database. I can use thatfacility to backup the database. But before i do a backup i want tocheck if the disk space available enough to backup that database. Ihave a 22gb database mdf file, when i took a backup of that its only3gb. SO i cannot use the size of mdf file to determine the databasedump file. Is there any facility available to find out the backupdatabase dump size before doing the backup?ThanksNabhonil.
View 1 Replies View RelatedHi Every bdy,
I have a database which is in mysql. Now we want to port that database to Sql Server 2005. Please tell the steps to do this.
With Regards
Ravinder Reddy.K
We are running sql 6.5 with Serv. pack 4. All of our Prod. database are backedup weekly via scheduled tasks. On occasion the dump of a particular database will cause 1 of 2 things:
1. The db dump seems to work correctly but stops sql executive service.
2. The db dump seems to work correctly but sends an alert email msg to me indicating that it failed. The msg in the email is "NO Message".
Has anyone experienced either of these 2 problems or have any solutions?
I have a database dump using mysqldump. Now I want to import a table from the dump file. How would one do this?
I've used mysqlimport < table.sql, but what if I have databasedump.sql which includes all the tables, but I only want to import ONE table?
-D
can a database dump created from one database be used in another database? what are the procedures?
thanks in advance
I have a medical records system, SoapWare v4.90, that uses MSDE (SQL2000) databases. Due to the 2gb limitation, I am trying to migrate over to SQL 2005 (Standard or Express) which I have heard works fine. The SoapWare has a datamanager that allows me to log in to the MSDE instance, detach the SoapWare databases from msde (as well as do backups, etc) which I can confirm are detached.
Then I log back into a SQL2005 database instance using the datamanager and try to attach the database. This is what their pictured instructions demonstrate. However, I get the following error:
Database 'sw_charts' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery.
Of course, some of the entries will be read only, since doctors have to sign off the charts and are not allowed to subsequently change them. But I should still be able to switch over to sql 2005?!?!?!?
Or... is there a way to attach the databases to SQLExpress manually?
Help pls?
Hi all,Here is my situation.I have an application that uses SQL 2000. The client has a programthat uses MSDE. The client MUST have the MSDE version of the Database.What I have done is to create a SQL 2000 Database that is exactly likethe MSDE version. What I wish to do, is at regularly scheduledintervals, update the SQL 2000 Data with the newest MSDE Data.On my clients server, they have both MSDE and SQL 2000 installedthe msde has a user name and password to access it, whereas the SQL2000 uses authenticated mode to access it.What I'm trying to do is to write a bunch of SQL Queries, that I canrun that will copy over the new Data, but I'm having problems accessingthe msde database in query analyzer from the SQL DatabaseCan anyone give me hints on the best way to try thisThanksScott
View 1 Replies View RelatedI have a medical records system, SoapWare v4.90, that uses MSDE (SQL2000) databases. Due to the 2gb limitation, I am trying to migrate over to SQL 2005 (Standard or Express) which the company says works fine. The SoapWare has a datamanager that allows me to log in to the MSDE instance, detach the SoapWare databases from msde (as well as do backups, etc) which I can confirm are detached.
Then I log back into a SQL2005 database instance using the datamanager and try to attach the database. This is what their pictured instructions demonstrate. However, I get an error:
Database 'sw_charts' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery.
Or... is there a way to attach the databases to SQLExpress manually?
Help pls?
Downloaded and installed MSDE and just finished creating a
website using the Community Starter Kit. I'm used to working with Access
Databases and this is my first experience with anything SQL. Can someone
provide my with some guidance as to what I need to do to upload the MSDE
Database to a server. Can I just upload the files like an Access Database
or is this more involved. Thanks for you help.
I'm using Visual Studio.Net enviroment, i have SQL desktop Engine installed and everything is working great. I have a problem that whenever i create a new database connections i can NOT delete it. I know that i have to select the node containing the connection and then press the DEL Key, but it seems that the delete option is not valid!
Any Suggestion?
OK
I've loaded MSDE and its running OK
I've run config.exe to install the sample .net databases,
......but I cannot find northwind or anyother db on the server!
I've never done any db work befor so may be I'm being a bit of a tit!!! sorry in advance if i am...
stuart
Hi, I am new to .net, I installed .net sdk and framework.
now I downloaded MSDE and installed it, I got this directory : C:MSDERelA
but when I double click in the setup file nothing happened, please help me on what should I do .
thanks
Hi,
I installed MSDE and the sample databases with it. They work fine.
Well I am using the server explorer of visaula studio standard 2002. I can see all the sample databases there and connect to them as well.
1.
--------------------------------------------------------------------
Now i created a new database named "testDb" and in a similar fashion i am using windows login thingy.
When i write my connection string in the program now it doesnt work
string connectionStr =@"Server=IMRANNetSDK;" + "Integrated Security=SSPI;" + "Connection Timeout=7;" + "Database=testDB;";
If i replace my Database clause to Northwind it works absolutely fine.
The ERROR it gives is:
Cannot open database requested in login 'testDB'. Login fails. Login failed for user 'IMRANASPNET'.
Why is this happenning? :(.
============================================
2.
-------------------------
How can i configure the MSDE to use the SQL Authentication.
It doesnt allow me to do that?
Thanx Heaps,
Imran
I'm running Windows 2003 .NET server (1
year trial) and I have the latest version of MSDE installed. I have
WebMatriX II installed.
I want to create an MSDE database I can use with a DSN so can use in .ASP or APS.NET.
I've successfully created a test
database (in Webmatrix II) via Windows Authentication security and have
created a DSN via ODBC/Windows Authentication security but don't know
how to access in ASP or ASP.NET web page.
All the SQL databases I use in .ASP have a DSN, User, Password as connection parameters. I want to continue this process.
I ran the command list: setup
SAPWD=**secret** SecurityMode=SQL after setting up MSDE SP3. I log into
the server as "Administrator" with a password.
Question:
1. What am I supposed to use as a ID and
Pass if I want to setup a MSDE database in WebMatrix II using SQL
Server authentication? Everything I try fails. I was never asked to
provide a beginning ID and Pass for SQL(MSDE) Server.
2. What does the connection string look
like to access the database in ASP.NET for Windows Authentication
security? Like this: ConnectionString= "server='localhost';
trusted_connection=true; database='ichapter_test'".
3. What would it look like in .ASP?
Thanks in advance!
JurekWorks
HiI am just starting my first .NET project using the web matrix and an MSDE database. I am pretty much at the limit of my knowledge - all very interesting. I have some data in an Access spreadsheet (6 columns and 365 rows) which in the past I have copied and pasted into an Access database table. How do I get it into a MSDE database table? This process does not need to be automated/programmed as I will only have to do it once a year. Any ideas on the easiest way forward would be much appreciated.Thanks in advance.Mike
View 2 Replies View RelatedI'm trying to build a record update form and I'm
going off the "Build Your Own ASP.NET Website" book. I'm not getting
any compilation errors; the database just doesn't update.
void Update(Object s, EventArgs e) {
SqlConnection upConn = new SqlConnection(
"Server=****\netsdk; database=CLASSIFIEDS; User ID=****; Password=****;");
SqlCommand upCmd;
upCmd = new SqlCommand("UPDATE CLASSIFIEDUSER SET
ITEMHEADLINE=@ITEMHEADLINE, ITEMDESCRIPTION=@ITEMDESCRIPTION,
CONTACTNAME=@CONTACTNAME, EMAIL=@EMAIL, HOMEPHONE=@HOMEPHONE,
WORKPHONE=@WORKPHONE, CELLPHONE=@CELLPHONE, BUILDING=@BUILDING,
ROOM=@ROOM, PRICE=@PRICE WHERE ID=@ID", upConn);
upCmd.Parameters.Add("@ITEMHEADLINE", headline.Text);
upCmd.Parameters.Add("@ITEMDESCRIPTION", description.Text);
upCmd.Parameters.Add("@CONTACTNAME", contact.Text);
upCmd.Parameters.Add("@EMAIL", email.Text);
upCmd.Parameters.Add("@HOMEPHONE", home.Text);
upCmd.Parameters.Add("@WORKPHONE", work.Text);
upCmd.Parameters.Add("@CELLPHONE", cell.Text);
upCmd.Parameters.Add("@BUILDING", building.Text);
upCmd.Parameters.Add("@ROOM", room.Text);
upCmd.Parameters.Add("@PRICE", price.Text);
upCmd.Parameters.Add("@ID", Request.QueryString["id"]);
upConn.Open();
upCmd.ExecuteNonQuery();
upConn.Close();
Response.Redirect("preview.aspx?id=" + Request.QueryString["id"]);
}
The Response.Redirect works so I'm thinking there must be an SQL syntax error or something but I can't see it.
I have installed the MSDE from Office 2002 CD and MSDE is running. I can see the SQL Server Icon in tray with green arrow. CAn ne body help me how to create database in the MSDE. I am new to this. Is there any query manager or entrprise tool by which I can create database and table in it. Also I am not able ro install the Starter Kit .Please help me in this.
View 1 Replies View RelatedHi all
I have MSDE installed on my machine to support off-line use of a web application.
The database (MDF) file in question is stored on an encrypted area of my hard drive, which must be unlocked each time the machine starts up by the user entering a password.
Unfortunately, by this time the SQL Server service has already started, and although it still lists the database along with master, etc, it cannot access it. I believe the error mentions that some files are unavailable.
Stopping and restarting SQL Server using Service Manager fixes this problem. However, this can only be done when logged in as Administrator. I need to find a solution for normal users without Admin privileges.
Is there any other way of making the now-unlocked MDF file available to SQL Server? I thought about using SQLDMO to Refresh databases, but no joy.
This is a real show stopper for my application, which I've spent three years developing! It goes without saying that I'm writing this message with a long face. If anybody has any suggestions I would be very happy to hear from you!
Best wishes
Rob
I installed MSDE on a pc with no problems, but now I realise I want to create another instance and set DISABLENETWORKPROTOCOLS=1 so I can use Enterprise Manager over the network from another PC.
If I create another instance of MSDE on the PC, can I remove / uninstall the first instance?
Is it any big deal if I leave the first instance?
and last but not least...
If I create a new instance will it see the database I created on the first instance?
told you so...
Can anyone recomend some good literature to explain about instances please :D
Hi,
we have about 12 databases in an MSDE server.
We can install the enterprise manager, but cant get the maintenance plans to work. (fields stay empty and setting dont get saved)
I've searched a bit, but couldn't fix it.
No problem, i created a job, with 12 T-SQL commands, and the backups are working perfect.
Now we wanne backup with a history (we take a backup every 4 hours of the day), because now they always get overwritten.
So im trying to change my transactSQL to create dynamic files.
The code i'm using right now :
BACKUP DATABASE PW0001A00 TO DISK = 'C:SQLBACKUPPW0001A00.BAK' WITH INIT, NOUNLOAD, NOSKIP, STATS=10, NOFORMAT
I've tried different things like
BACKUP DATABASE PW0001A00 TO DISK = 'C:SQLBACKUPPW0001A00' + DATEPART(month, GETDATE()) + '.BAK' WITH INIT, NOUNLOAD, NOSKIP, STATS=10, NOFORMAT
but nothing worked.
so basically I wanne be able to create dynamic filenames in the above command.
You got any ideas/solutions.
tnx.