Hi All,
During the past couple of years I have been maintaining the company's
Access databases, in the coming weeks I will be migrating data to SQL
server, I will be using the Access forms as a frontend to access data
while we developed a new front end through VB.Net.
I was wondering if anyone will recommend an application that makes an
exact replica or backup of the SQL server in the case the SQL server
fails. With MS Access, if a record is corrupted we needed to go back
to the previous day backup of the database, we cant afford to have
this issue any longer.
If there are 2 different web application connecting to a sql server database through ODBC connection, both of them have full privilege to update , create , add column etc. Would there any issues of SQL server impacts when actually on live.
I am running SQL Server 2005 Dev x86 with SSRS SP1 on Windows2003 Svr SP1.
My SQL Server is running and SSRS is working. When I come to run certain installs though, my Server name is not present in the dropdowns or in the browse for installed server lists.
I entered the name of my SQL server manually, but when I ran the application, it gave me an error: 00250 unable to run dtabase locator service.
Our company wants to run web based application in folowing way.
Browser --> WebServer -->Sql Server
Sql server is part part of corporation domain and has about 25 more databases
Should we dedicate extra SQL server to run Web apps , or it would be safe to run web apps on corporation Sql Server? or If any one can point on links on this subject?. Thank you
Good morning,After long hours of search on the subject, I could not find a clear answer to my question.I understand what are ths physical limit fo the express version (1Gb or Ram, 4Gb database, 64 bit WOW).My configuration is as follow, windows webserver 64bit, I have 4 database of 10Mb each for 4 web-application. The maximum concurent connection is a total fo about 8 for all the web-application together.Therefore due to the cost of buying a workgroup of standard license, I was hoping to be able to use the express edition.Please let me know your thought.ThanksArno
Does anyone know if two different database belong to two different applications stay in the same physical SQL server 7.0 with one server license would affect their performance?
Would the performance be better off if each database stored in different physical SQL Server 7.0 with different server license?
Is it ok to use SQL Server 2005 CE as an embedded DBMS inside a desktop (Windows XP / w2k3 / Vista) application?
The whitepaper available here: http://download.microsoft.com/download/A/4/7/A47B7B0E-976D-4F49-B15D-F02ADE638EBE/Compact_Express_Comparison.doc describes this as one of the primary usages of the product. However, I've seen information elsewhere on this forum that seems to imply that SQL Server 2005 CE is not allowed in desktop applications.
Can you please clarify this, and specify any limitations of this usage?
Also, the whitepaper refers to an online redistribution agreement that needs to be signed in order to freely redistribute SQL Server 2005 CE inside a commercial application. Can you please point to this agreement?
Can I develop applications with SQL Server Express that I have more than one user in several computers working with the same database on a server, or I can only develop applications with only one user with a local database with SQL Server Express?
When I registered SQL Server Express I received an e-mail back showing all of the resources available to get started. There were 6 Starter Kits available, Teacher, Colection Manager, Amazon Enabled Movie Collection, and three others. When I click on the links to download the Starter Kits, the link comes back as invalid. Can you provide the correct links to use to get the Starter Applications, or can you e-mail me code? Thanks for you attention to this matter. Charlie Cappello CIGNA
1. I have 2 sets of CDs, one is called Sql Server 2005 Developer Edition, Applications Developer Tools, and another one called Sql Server 2005 Developer Edition Servers Server Applications.
I installed the Applications Developer Tools on my development pc, and I was able to use create and populate a database, and use Sql Server Management Studio fine. I wonders what 's the Servers Server Applications set of cds for.
2. I just like to install Sql Server 2005 on a test pc also. Can I use my Developer Edition Applications Developer Tools to install it ?
We want to install 2 applications that run on SQL server 2005 but the requirement of database installation are different Collation setting ( One require Dictionary order, case-insensitive, for use with 1252 Character Set and other require Dictionary order, case-sensitive, for use with the 437 (US English) Character set). So the question here could I install both two applications successfully on same platform ? and if yes how?
Hi, Is it advisable to use full text search on asp.net live applications? Will live database servers allow full text search?. If so what are the problems we could face in future. My DB server is SQL Server2000 and ASP version is 1.1. Thanks in advance Hamlin Stephen
Teacher Starter Kit VB http://msdn.microsoft.com/vstudio/eula.aspx?id=4d31bb50-22da-411f-b747-a7b2288fc720 C# http://msdn.microsoft.com/vstudio/eula.aspx?id=06b20449-cbba-4f2f-ab8c-b99c1266cc7e Collection Manager Starter Kit http://msdn.microsoft.com/vstudio/eula.aspx?id=98c8074d-d28e-49e1-be44-94f0114f372a Club Web Site EventCalendar control source code http://www.asp.net/starterkits/downloads/eventcalendar.zip
2. None of the download links shown below for the Sample Applications found at this URL work:
SQL Server 2008 r2 - 6 GB memory...I attempted a backup on a 500GB database but it was taking way too long. I checked the resources on the box and saw the CPU at 100%. I checked the SQL Server activity log and saw a hung query (user was not even logged on) that had multiple threads so I killed it and now the CPU utilization is back to normal.
Trouble is, now all of the threads in the activity monitor for the backup show 'suspended' and the backup appears to be not doing anything.
Data got deleted on Friday evening, need to have database restored to FRiday afternoon and also some data has been entered on Monday, which needs to be there.
Windows 2003 backup utility uses the shadow copy option that allows it to copy open files. Therefore, can I use this utility to backup the .mdf and .ldf files for my SQL 2000 database? I can then attach the .mdf files if I need to restore the database to another server. Can anyone tell me if this is safe? I've tried it and it worked but I'm worried there maybe some lurking danger in using this approach.
I've written a custom script to delete backup files from location. But unable to modify now to count the number of files are deleted. How to modify the script...
/* Script to delete older than N days backup from a specific directory */
USE [db_admin] GO IF OBJECT_ID('usp_DeleteBackup', 'P') IS NOT NULL DROP PROC usp_DeleteBackup GO
I am using ASP.NET 2.0 login control. this control connect to ASPNET.MDF database. I built another application using windows service, and this application also connects to ASPNET.MDF database. problem is that the first application that connects to the database, locks the database, and so the other application cannot use the database untill the other application is closed. I am going on circles about this, and just don't know what to do. Please please please. love me do.
I have a SQLexpress db that i would like to be able to access from both a windows app and web app (both running on the same machine) at the same time. Is this possible. I've been able to connect either one or the other, but not both at the same time. Thanks
Hi to all.. Does anyone know about some useful resources of programming Accounting and General Ledger applications..SQL scripts,books..etc. Thanks to all..
i am a computer sciences engineering student and and we have an assignment to create a web project with a database.
Our lecturers will store our submissions on a db server but they want our projects enable the restoring our own databases..
that is, they wanna be able to have a copy of our databases to a new db that they have just created.. and they want us to enable this feature in an install.aspx page in our project.. the new db is guaranteed that will have the same name as ours..
so now what i am supposed to include in install.aspx?
I want to know how people are backup up their win2k system and SQL 2000 server. If you want a run backup once a night and first backup win2k file system and then run backup using sql agent will that work? Thanks.
SQL 7.0 SP1. We do SQL Server backup and also third part backup (with SQL agent active) of SQL Server databases. Sometimes happen this situation:
01.00 SQL Server backup of DB1 01.00 third part backup of DB1 02.00 SQL Server T-LOG backup of DB1 03.00 SQL Server T-LOG backup of DB1 03.30 SQL Server differnatial DB backup of DB1 04.00 SQL Server T-LOG backup of DB1
or this situation:
01.00 SQL Server backup of DB1 02.00 SQL Server T-LOG backup of DB1 03.00 SQL Server T-LOG backup of DB1 03.10 third part backup of DB1 03.30 SQL Server differnatial DB backup of DB1 04.00 SQL Server T-LOG backup of DB1
My questions now are: Are my SQL Server backups valid (DB,Differenatial and T-LOG)? In case of a restore operation, can I use my SQL Server backups without problem? In other words, can we leave the third part backup tool active or it should be taken away?
Can anybody clarify this for me? Thank you in advance. Franco
Hi All.. I have an 3 tier web applications and I want to use sql transactions but not in each class. Example : I have 3 clases who need to update each table in one transaction how I do use sql transactions. I try to do in this way but not work: sub cmdupdate_click dim a as new class1 dim b as new class2 dim c as new class3 dim cn as new sqlconnection...... cn.open .....transactions.... scripts a.cn =cn ...I pass the same connection via property to each class a.update b.cn=cn.... b.update c.cn=cn..... c.update Transaction...scripts to commit cn.closeend sub maybe that logic is incorrect. I dont now is my explain is clear.
There is a possibility of a unique database for various applications. Example users of a table that has the name, email, registro.Uma application included in a user table and other application also included in this table.
What is the correct way to move applications from one server (2000) to another server(SQL 2005). I have to move all the databases as well as applications from one server to another.Here is my procedure: 1) Backup all 65 databases in first server(600GB total) 2)copy all the backup files from one server to another(destination) 3)Make all database(single user)and take transaction Log backup 4) Restore all database to destination server in norecovery mode and restore all transaction log in Recovery mode) 5)stop server 1 and point the application to another server
So how much downtime i have to face since it is 24/7 production server. and Can you please give the correct details so i can apply.