Database Device Is Getting Full...
Nov 30, 1998
Hello,
I have two databases, Database1 and Database2 both have same set of tables.
Database1 has a saperate Log file, i.e. it uses different Device for its Logs.
There are two processes running using this database,
Process 1 will keep on dumping records in to database1. Here it uses Rollback and commit operations.
Process2 will take a backup of Database1 after every minute to Datavase2.
What is hapening is, after some time later, if i check the Space availabe for data then Database1 will have used 5 to 10 times more space that database2.
Can any body tell me why this is hapening. because for the same data both databases uses different size of space.
ThanX
__Vijay VM
View 3 Replies
ADVERTISEMENT
Nov 8, 2000
Hi
I need to ask a realy dumb question.
I have a database whereby both the devices for the tran log & the database
are full.
Does SQL 6.5 grab all the space so the devices appear to be full, or does full mean full ( and no further transactions are possible? )
Any help would be great
Thanks.
View 2 Replies
View Related
Mar 3, 1999
I issued the following statement on my database as my log file showed 100% full.
However after running this command and also running it again after expanding the size
to almost double the value of both my database log and data devices it still shows the log as being 100% full.
DUMP TRANSACTION <database> WITH TRUNCATE_ONLY (and also used the NO_LOG option).
So can anyone tell me whats going wrong here? I should note that I am still able to enter data into the database without
any errors.
View 1 Replies
View Related
Jan 26, 2004
I am using 6.5 .
Here is the error that i get
Think that tempdb is small how do i change that or what is this error about'
--------------------------
AIMSMan
---------------------------
Application-defined or object-defined error 40002
37000: [Microsoft][ODBC SQL Server Driver][SQL Server]Can't allocate space for object '##RevByNetSALIMJUMMA' in database 'tempdb' because the 'default' segment is full. If you ran out of space in Syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase the size of the segment.( 1105)
ODBC
I only have data and log device how do i increase the tempdb device
let me know
SEJ
View 4 Replies
View Related
Sep 26, 2006
Dear All,
i have a question abt winCE 4.2 and SQL server CE.
i am using VB.net of Visual Studio 2005
My platform is using a PDA with winCE 4.2 and SQL server CE. The Host program is using dbf files on desktop side.
I got a problem of how to sync / read the sql CE data from a windows application.
so, i wanna ask,
1. any method to access the data from winCE data by windows application? or can i convert the sdf file to windows readable files? or any others?
2. Can i use a MDB to sync with SQL server CE?
can i synchronize the mobile device which has a SQL Server CE database with the Access database on the desktop?
last question,
3. is that windows CE .net 4.2 not support pocket access (cdb) anymore?
please help me out
View 1 Replies
View Related
Nov 17, 1998
I have a database in development in SQL Server 6.5 that needs to be occasionally deleted and rebuilt from a script when table structures are changed. I found that when very complex queries were performed, the 2 MB default size of tempdb filled up and returned errors, so I went to the Enterprise Manager to expand tempdb, learned that I had to first expand a device to expand tempdb into, and foolishly chose to expand tempdb into the same device space used by my application, instead of into one of the system databases. Now when I try to delete the device in preparation for its rebuild, the Enterprise Manager responds with an error message saying the device can't be deleted because it contains system tables. Is there any way to get the expanded portion of tempdb out of my application device so that the device can be deleted, without reinstalling SQL Server?
View 1 Replies
View Related
Jun 25, 1999
hi, is there a way to find out what which database resides in which Database device.....
thanks
Ali
View 1 Replies
View Related
Jan 30, 2002
Hello Everybody ..
Can anyone help me with some information or procedure as to how to mirror database devices in SQL Server 7.0 & SQL 2000 servers ?
SQL Server 6.5 has mirror utility built in the Enterprise manager .
Is there any way to do it on SQL 7.0 and SQL 2000 Servers ?
Any help will be appreciated .
Many thanks
Yatin.
View 1 Replies
View Related
Oct 31, 2000
Is it possible to relocate the master database device to another drive?
View 3 Replies
View Related
Sep 3, 1999
When running Enterprise Manager from my desktop pc to try and expand a database device I am unable to do so. The size shown is negative, and the max size is the same, with the 'Change Now' box greyed out.
When I log on directly onto the server I can easily expand the db device. There is lots of free space on the server.
Our set up is quite small with four NT workstations and two NT servers with SQL Server 6.5 on them. All these six machines are in the same workgroup. The workstations are on a separate floor to the servers, which are in the computer room. I have a feeling this is a networking issue. Can anyone suggest why this is happening?
View 3 Replies
View Related
Jul 26, 1999
My question has to do with the ability to recover a suspect database in the event that the transaction log device file becomes corrupt or is deleted.
Specifically, consider the case where a user database has it's data device on one hard disk and the log device file on a 2nd hard disk. The database is set to truncate log on checkpoint.
If the disk fails on which the log device file resides, the user database will be marked as suspect. Assume this disk is replaced and rebuilt from a tape backup, including the log device file (which was backed up to tape during off hours.)
Will SQL Server have any problems with this? Will database recovery have any problems with this (assuming the restored transaction log was empty)? Any other issues?
Thanks in advance!
View 2 Replies
View Related
Dec 23, 2006
Hi all, I'm new to mobile devices.
I have a desktop application that uses SQL Server Compact Edition. I will soon have a mobile application that will use the same database. How can I (at runtime of the desktop app, say when the user clicks a button) transfer the sdf file to the mobile device? I'm not necessarily interested in synchronizing the databases, simply overwriting the database on the mobile device with the one on the desktop would suffice.
Is something like this possible?
Thanks!
View 3 Replies
View Related
Jan 19, 2007
Hi Everybody:
I'm writting an standar application in c# that comunnicates with a sql server 2005 in a mobile device. The mobile device is connected to the pc with an usb wire. In the sample I've made, I've inserted in the form main a datagridview. I go on the wizard to select the data source. I choose a Microsoft SQL Server Mobile Edition data connection. The data source is tge activesync mobile device. I create a new database in the mobile device called test.sdf. The wizard has a button to check the conecttion and it rules. A new connection appears in the server explorer. I add rows through a query. I build the solution and no problem, but when I start the debug session an sqlceexception occurs: Data Source not found. In the database connection that the project has created the connection string is: Data Source ="Mobile Device est.sdf";
I didn't write any code. I just went on the wizards. All the code has been inserted by visual studio 2005.
Any idea?
View 3 Replies
View Related
Nov 28, 2005
In VS2005 RTM using
View 15 Replies
View Related
Aug 19, 2007
Hello,
VS 2005 & SQL server 2005
I developed a mobile application PDA using the Compact Framework 2.0. And using typed datasets
I have also developed a web service. When the PDA is connected to the Internet it can access the web service and get all the data that is in the sql database. The user can add new records, update existing records, and delete them. So the web service acts like a middle man.
In the PDA the data is filled using typed datasets.
However, the customer now wants to be able to interact with there data on the PDA, currently they have to be connected to the Internet. But if there is no internet connection, then they will still like to add, update, and delete the records. Then once they have a connection, all these would be updates with the sql database.
What is the most efficient method to do this.
Many thanks for any suggestions,
Steve
View 4 Replies
View Related
Jun 19, 2006
Basically I've been using Visual Studio 2005 for a few weeks now moving a Pocket PC project from 2003 to 2005. When I hit the Start Debugging Button every time until today the project would rebuild and deploy to my pocket PC allowing me to debug etc but now I get
The remote connection to the device has been lost.
Please verify the device conection and restart debugging.
I used to get this problem in VS2003 sometimes and just like the numerous posts on different sites that I've looked at the problem eventually goes away and I'm none the wiser. One guy said that he found that if he went to bed the problem was resolved when he came back!
My PDA running Windows 2003 2nd Edition is directly connected to my PC via a USB port. I've rebooted my PC and done a soft reset on the PDA but it didn't help. I'm using ActiveSync 4.1.
Does anyone know how to resolve this problem?
View 54 Replies
View Related
Dec 7, 2004
Hello,
Every hour I make a backup of the log files of a database to a backup device. Each backup is appended to this backup device.
Now to restore at a point in time I normally use the following script;
RESTORE DATABASE mcs_carolus
FROM disk='E:sqlserver_databasesmcs_carolus_data.bak'
WITH REPLACE,
NORECOVERY
go
RESTORE LOG MCS_CAROLUS
FROM disk='E:sqlserver_databasesmcs_carolus_log.bak'
WITH FILE = 1, NORECOVERY
GO
RESTORE LOG MCS_CAROLUS
FROM disk='E:sqlserver_databasesmcs_carolus_log.bak'
WITH FILE = 2, NORECOVERY
GO
RESTORE LOG MCS_CAROLUS
FROM disk='E:sqlserver_databasesmcs_carolus_log.bak'
WITH FILE = 3, NORECOVERY
GO
RESTORE LOG MCS_CAROLUS
FROM disk='E:sqlserver_databasesmcs_carolus_log.bak'
WITH FILE = 4, NORECOVERY
GO
RESTORE LOG MCS_CAROLUS
FROM disk='E:sqlserver_databasesmcs_carolus_log.bak'
WITH FILE = 5, NORECOVERY
GO
RESTORE LOG MCS_CAROLUS
FROM disk='E:sqlserver_databasesmcs_carolus_log.bak'
WITH FILE = 6, NORECOVERY
GO
RESTORE LOG MCS_CAROLUS
FROM disk='E:sqlserver_databasesmcs_carolus_log.bak'
WITH FILE = 7, RECOVERY,STOPAT = 'Nov 25, 2004 11:59 AM'
Is there a simpler way of restoring without going through this long process.
Regards,
Albert
View 1 Replies
View Related
Nov 29, 2007
I ran into a problem today where I had to pull a backup file from an older tape. The file was originally is a backup that was stored in a device like :
EXEC sp_addumpdevice
'disk', --type
'c2000_BackupDevice', --logical name
'\UNCPathackupFile.bak' --physical location
I put the file from the tape on a File Server and then tried to create a new backup device pointing to the file. That's easy enough, but when I try to restore from it I get an device error saying it's offline.
How can I get that device attached to my server and then extract the backup files stored inside it?
Please advise b/c this is an interesting problem I hadn't anticipated and it argues that I should change my backup strategy .
Thanks for any advice/experience you can provide,
alex8675
View 2 Replies
View Related
Apr 4, 2008
Hey guys,
So I started an SQL CE database for use inside a mobile application. I used SSMS to create a .sdf file (because if I let Visual Studio do it, SSMS can't open it because it will be version 3.5).
The reason I wanted to use SSMS is because I wanted to be able to design the database in design view, and populate it with initial information for the application to use. That means adding tables and rows.
The problem is, SSMS doesn't seem to have a design view available when working with CE databases. It also doesn't seem to have a feature for adding rows into tables. It's essentially as useless as VS2008 for designing my mobile database. It only lets me add tables, and I can't even do that visually in design view. I have to use those cumbersome forms.
Is there any way to design a CE database in design view? And add rows of data into tables? It feels like I'm overlooking something.
Note: I dont need to subscribe or publish the database. The mobile application just needs to use the database as a repository.
View 7 Replies
View Related
Dec 9, 2006
Hi, Guys
I read a lot of your post about the mobile device connecting SQL Server. I try to solve my problem, but i still in trouble of Mobile database application.
The following is my development enviroment
Visual Studio .net 2005
Sql Server 2005
Windows CE.Net 4.2
Microsoft ActiveSync 4.2
First i can run some simple application on the Mobile Device( Symbol MC9060G Mobile Device), all the connection between develop PC and Mobile Device is fine. All the develop SDK for the Mobile device without problem.
Secont, i can develop a simple normal windows database application, work fine, can get data from SQL Server 2005. the connection to database server is fine.
I used VS2005 develop a simple database with DataGrid on the form( all the code generated by the VS 2005), when run the program, got error at " int returnValue = this.Adapter.Fill(dataTable)"
error "PlatformNotSupportedException". I don't know what's going on.
I think the connection to the database no problem. Maybe the Mobile device has problem. I insatlled sql.ppc.wce4.armv4.cab file to mobile device.
Can someone help me out?
Thanks.
View 4 Replies
View Related
May 24, 2007
i m developping a smart device application with vb.net
i m using the following code from:
http://msdn2.microsoft.com/en-us/library/aa454892.aspx
(i still working on the first exercice and i'm following it step by step)
everything is working properly
i was advised to add this code when closing the form1
Try
Me.ContactsBindingSource1.EndEdit()
Me.ContactsTableAdapter1.Update(Me.TestDataSet1.contacts)
MsgBox("Update successful")
Catch ex As Exception
MsgBox("Update failed")
End Try
the problem is:
should this code update the database created with sql server 2005
if yes why isnt it working here
and should the database be replicated on my emulator before it is updated
(in this exercice i do not have a database storerd in the emulator)
plz i urgently need the answer
View 4 Replies
View Related
Apr 14, 2006
Hi to All
when i m trying to execute following code
backup database web
to disk = 'c:inetpubwwwrootackupmybakup.bak'
with format
I m Getting Error like :
Server: Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'c:inetpubwwwrootackupmybakup.bak'. Device error or device off-line. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
This error is Generated only when i m trying to access folders within "wwwroot" but not in any other folders , even command runs success fully for "wwwroot" folder . !!
but not for any subfolders of wwwroot.
Can Any One Help Me ??
View 6 Replies
View Related
Jun 6, 2000
I had a major disk failure, and the only SQL Server files I was able to recover were master.dat, msdb.dat,msdblog.dat, two text files and two database devices. My question, is it possible in SQL 6.5 to restore a database from just the database device, and if so, how? Thank you.
MH
View 1 Replies
View Related
Mar 3, 2005
Can anyone help me to recreate the .NDF file if it was lost and not restorable? I have a stored procedure written that will then help me rebuild all indexes on all tables, but I can't seem to figure out how to create the index file again so I can run it. I have tried index files from other databases to no avail. There is no backup to go to.
View 10 Replies
View Related
Apr 4, 2006
Hi,
I am developing an application for a Pocket PC (PPC). I am using Visual studio 2005, and the Operating system on this PPC is Window Mobile 2003 SE. The followings are my codes to connect PPC with the database on my PC with sql server 2005. But when I cick the button1, the error with "SQL Server does not exist or access denied." Any ideas? Thanks a lot.
Imports System.IO
Imports System.Data
Imports System.Data.SqlClient
Imports System.Math
Imports System.Drawing
Imports System
Public Class Form1
Dim strConnection As String = "Server=localhost;Integrated Security=SSPI;database=AdventureWorks"
Dim strQuery As String
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Label1.Text = "Hello, Clicking after."
ReadOrderData()
End Sub
Private Sub ReadOrderData()
Dim queryString As String = "select * from Person.Address where AddressID < '10'"
Using connection As New SqlConnection(strConnection)
Dim command As New SqlCommand(queryString, connection)
connection.Open()
Dim reader As SqlDataReader = command.ExecuteReader()
While reader.Read()
MsgBox(String.Format("{0}, {1}", _
reader(0), reader(1)))
End While
reader.Close()
End Using
End Sub
End Class
View 15 Replies
View Related
Nov 15, 2007
We replicate a SQL2000 database (DataBaseA) to a SQL2000 database (DataBaseB) by using the Restore function and hasn't change its logical name but only the physical data path and file name. It is running fine for a year. We use the same way to migrate the DataBaseB to a new SQL2005 server with the Restore function and the daily operation is running perfect. However, when we do the Backup of DatabaseB in the SQL2005, it just prompt the error message
System.Data.SqlClient.SqlError: The backup of full-text catalog 'DataBaseA' is not permitted because it is not online. Check errorlog file for the reason that full-text catalog became offline and bring it online. Or BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. (Microsoft.SqlServer.Smo)
Please note we left the DataBaseA in the old SQL2000 server.
Please help on how we can delete the Full-text catalog from DatabaseB so we can do a backup
Many Thanks
View 1 Replies
View Related
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
Nov 10, 2007
I am trying to attach to aMDF and LDF file that are on the remote location. When you try to do this though getting an error..
"File filename.mdf is on a network device not supported for database files."
How to do this.
Could you please help me to sort out this problem.
Thanks in advance
WillSmith
mail2willsmith@yahoo.com
View 3 Replies
View Related
Jul 24, 2007
Hi,
I am using web service to synchronize data between SQL Server 2005 on a desktop and a SQL Server Mobile Edition on a mobile device.
Initially, when i added the data source to my mobile application, my .sdf only has 3 records. I am then supposed to retrieve 97 more records from the desktop server when my mobile application runs. After performing merging, I clicked (on my device emulator) on the .sdf deployed under my mobile application and the query analyzer showed all 100 records.
Does this mean my mobile database has been successfully updated with all 100 records? If not, how do I check that? The reason why I am asking this is that the file size of this .sdf with 100 records is still the same as the initial .sdf with only 3 records. How is this possible?
Am I missing anything or getting some concepts wrong? Please enlighten. Thanks.
View 4 Replies
View Related
Sep 25, 2007
Hi,
Please provide some help regarding the "Interface Defining Error: IID_IDBDataSourceAdmin" error while trying to create a SDF database using Query Analyzer on a Windows CE 5.0 mobile device (Symbol MC3000).
Error: 0x80004005 E_FAIL
Native Error: 28558
Description: SQL Mobile encountered problems when creating database [,,,,]
Param. 0: 0
Param. 1: 0
Param. 2: 0
Param. 3:
Param. 4:
Param. 5:
A list of (related) installed packages:
NETCFv2.wce5.armv4i.cab
sqlce30.dev.ENU.wce5.armv4i.CAB
sqlce30.repl.wce5.armv4i.CAB
sqlce30.wce5.armv4i.CAB
PS.
Basically I have developed a mobile application that programmatically creates the database, the code worked on a similar device (Win CE 50), trying to run the application on a new device resulted in database creation errors. I tried creating a test database manually .. and this is what I got.
Browsing MSDN or searching on the Forum did not help.
~Zarko Gajic
View 3 Replies
View Related
Jul 12, 2006
Hi,
I experienced this problems on both Windows Mobile 2003 SE and Windows Mobile 5.0.
Its native development (c++, oledb, atl and mfc).
It's quite simple to reproduce...
1. open a database
2. open a rowset on table A (whatever, valid of course and with both IOpenRowset and ICommandText), read datas and close rowset
3. power off
4. power on
5. try step 2 with another table (failed on openrowset with error 0x80004005) or try table A (sometimes working because of cached memory, sometims failed on Read Datas).
6. being stuck ;-)
Our work-around was, in case we loose our connection (identified by error 0x80004005 on openrowset), we close it and re-open database... ugly for sure, but working.
What I'm looking now is to use some kind of "detection method" like what people in .Net develoment are using "if ConnectionState.Open <> ...) for reopening my database only on demand...
Thanks in advance for any hints,
Fabien.
View 5 Replies
View Related
Feb 4, 2008
Hi all
Iam working in Prodcution ENV,Please help how make space
The log file for database 'Home_alone' is full. Back up the transaction log for the database to free up some log space.
View 10 Replies
View Related
May 12, 2000
Hi:
We are running SQL 6.5 & SMS 1.2 in the same server. And we're having problem with the SQL server that error log 1105 appreared.
SQL inidicated msdb and tempdb log size were full. I used dump trans with no_log but ISQL response:
" This command did not return data, and it did not return any rows". Then we recovered the SMS data space available is 0 mb.
I expanded the SMS database but the data space still shown 0 mb. Restart and reboot did not helped. I used DBCC Checkdb but
it did not show any error. Please any advice or suggestion are appreciate!
Philip
View 1 Replies
View Related
