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.
Server A = primary SQL DBs (mirroring origination)
Server B = failover SQL DBs (mirroring destination)
For database mirroring a witness is required.
Can the witness live in another instance of SQL on server B?
Using SQL Server 2008, we would like propose mirroring between two servers of a critical database. Since we initiate, may require to clarify on its purpose and also required changes from application end.Any changes required from OS Level? (I believe both servers IP or Host name should be added in host entries. Mirroring ports should be allowed/open including Principal and mirror server IP Addresses): Windows Team.Any changes required from Application? (Instance name, authentication: user name and its password should be added in web config files): Application Team.Any changes required from Network Team?Also for mirroring both the principal and mirror servers should be with same version, does it only mean SQL Server 2008 versions are enough or does it also mean to say build numbers 10.00.4000 should also be same.URL....
View 5 Replies View RelatedDear 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
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 Relatedhi, is there a way to find out what which database resides in which Database device.....
thanks
Ali
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
Is it possible to relocate the master database device to another drive?
View 3 Replies View RelatedWhen 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?
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!
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!
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?
In VS2005 RTM using
View 15 Replies View Related 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
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?
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
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
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.
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.
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
I have just finished configuring my first test mirrored environment (High safety mode). I setup the database engine service accounts on each of the servers with domainuser. I inherited a production mirrored environment set up by someone else. On the production servers the database engine service account is NT Authorityuser a local account. I am trying to practice installing Windows updates within a mirrored environment and I not sure how to proceed when the service account is NT Authority user account. should I change the service account to a domainuser?
View 2 Replies View RelatedHi 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 ??
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
When I issue this command:
ALTER DATABASE foo set PARTNER = 'TCP://10.3.3.1:1234'
I get this error message:
The database is being closed before database mirroring is fully initialized. The ALTER DATABASE command failed.
What does that mean, and how do I fix it?
Hi,
View 6 Replies View RelatedCan 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 RelatedHi,
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
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
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
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.
I set up a new mirror server. Everything is good except that the Database Mirroring Monitor is not working for one of the databases. In the monitor the principal data is showing up as blank
If I look at dbm_monitor_data on the principal most of the data columns (e.g. Send_queue_size) are null where as they have data for the other databases.
Both servers are SQL Server 9.0.2047 Enterprise Edition.
Any idea what might be going on here?
Thanks in advance.
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
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.