Monday, March 19, 2012
Differential Restore
This is my current backup schedule
Sunday FULL
M-Sat Differential
TranLogs Backups every hour
I am trying to restore to a point in time, specifically to the time
right after my last Differentail backup. I am using Ent Manager for
this. I have restored the Full with no recovery and then I select just
the last Differential Backup for restore and I get the message
Cannot apply the backup on device 'd:\abcd\diff' to database 'TEST'
restore database is terminated abnormally
Is there something wrong with my restore process. This is a qa
environment that I am testing this on. I have added a lot of data to
the database and then manual run the diffential job. Now I am trying
to restore to this point but I keep getting this error. Any help would
be appreciated.Please check the backup file you are using.
Thanks
Ajay Rengunthwar|||Ajay, Not sure what you mean exactly. I was able to restore my last
full backup. Both with and without recovery. I am just having trouble
restoring the differentials backup after that.
Friday, March 9, 2012
Differential Backup
Enterprise Edition with the Database Maintenance Plan?
If not how would I create a differential backup job that I
create a full backup on Sunday and daily differentials and
transaction logs every 3 hours.
Database Name : NewOrleans_Sales
Backup Directory : K:\NewOrleans_Sales
Please help me resolve this backup issue.
Thank You,
Mark E.
Hello Mark
Database Maintenance Plan does not provide facility to create differential
backups. If you would like to include differential backups in your disaster
recovery plan then you can configure a simple T-SQL job that can run a
BACKUP DATABASE command to perform the differential backup. You can still
use the Maintenance plan to create the complete and transaction log backups
as you desire.
The command text would be something like :
BACKUP DATABASE NewOrleans_Sales TO DISK = 'K:\NewOrleans_Sales\Diff.Bak'
WITH DIFFERENTIAL
Please note that the above command will create a file Diff.bak and will
continue to append to this same file each time a backup is performed. At
some point you should refresh this file, so as not to fill up the drive.
Please refer to BOOKS ONLINE topic on Backup for more information on this
command and other options that can be used.
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
Differential Backup
Enterprise Edition with the Database Maintenance Plan?
If not how would I create a differential backup job that I
create a full backup on Sunday and daily differentials and
transaction logs every 3 hours.
Database Name : NewOrleans_Sales
Backup Directory : K:\NewOrleans_Sales
Please help me resolve this backup issue.
Thank You,
Mark E.Hello Mark
Database Maintenance Plan does not provide facility to create differential
backups. If you would like to include differential backups in your disaster
recovery plan then you can configure a simple T-SQL job that can run a
BACKUP DATABASE command to perform the differential backup. You can still
use the Maintenance plan to create the complete and transaction log backups
as you desire.
The command text would be something like :
BACKUP DATABASE NewOrleans_Sales TO DISK = 'K:\NewOrleans_Sales\Diff.Bak'
WITH DIFFERENTIAL
Please note that the above command will create a file Diff.bak and will
continue to append to this same file each time a backup is performed. At
some point you should refresh this file, so as not to fill up the drive.
Please refer to BOOKS ONLINE topic on Backup for more information on this
command and other options that can be used.
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
Differential Backup
Enterprise Edition with the Database Maintenance Plan?
If not how would I create a differential backup job that I
create a full backup on Sunday and daily differentials and
transaction logs every 3 hours.
Database Name : NewOrleans_Sales
Backup Directory : K:\NewOrleans_Sales
Please help me resolve this backup issue.
Thank You,
Mark E.Hello Mark
Database Maintenance Plan does not provide facility to create differential
backups. If you would like to include differential backups in your disaster
recovery plan then you can configure a simple T-SQL job that can run a
BACKUP DATABASE command to perform the differential backup. You can still
use the Maintenance plan to create the complete and transaction log backups
as you desire.
The command text would be something like :
BACKUP DATABASE NewOrleans_Sales TO DISK = 'K:\NewOrleans_Sales\Diff.Bak'
WITH DIFFERENTIAL
Please note that the above command will create a file Diff.bak and will
continue to append to this same file each time a backup is performed. At
some point you should refresh this file, so as not to fill up the drive.
Please refer to BOOKS ONLINE topic on Backup for more information on this
command and other options that can be used.
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
Wednesday, March 7, 2012
Different SQL server 2005 Editions from the same Installation CD?!
Hi
I have the SQL Server 2005 Enterprise Edition CD and have succesfully installed this on my desktop.
When I install this on my Laptop the version is 2000(print @.@.version) is only Desktop version (2gb db limit!)....
Any ideas on why the full enterprise edition is not installing on the laptop?!!
Version on my Desktop:
MICROSOFT SQL SERVER 2005-9.00.1399.06 (INTEL X86)
OCT 14 2005 00.33.37
1988-2005 microsoft corp
enterprise edition on windows NT 5.2 (build 3790-service pack)
Version on my laptop:
MICROSOFT SQL SERVER 2000-8.00.2039(INTEL X86)
May 14 2005 23:18:38
Copyright (c) 1988-2005 Microsoft Corporation
desktop engine on windows NT 5.1 (build 2600: service pack 2)
The Laptop spec is:
Intel 1.66Ghz, 1 Gb Ram, 50 Gb HDD, Windows XP SP2
The Desktop spec is:
Intel 2.8 Ghz Dual Core, 2 Gb Ram, 320 Gb HDD, Windows XP SP2
Both SQL Server 2005 versions are installed from the same CD so why would there be a difference?
I understand that you cannot have Enterprise edition on XP but it has installed on the desktop, not the laptop?
Thanks in advance!
EE does not support Windows XP as a OS. Could it be that you have developer edition installed ?
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
Based on the information you provided, your laptop has Windows XP SP2. SQL Server enterprise edition requires a server OS and will not install on Windows XP, which is a client OS. Thus, you can not install it on your laptop.
Look closely at your @.@.version information from your desktop. It indicates that your desktop computer has Windows 5.2, which is Windows 2003 Server, NOT Windows XP. Windows 2003 Server will support an installation of SQL Server 2005 enterprise edition. Thus, I would expect you to be able to install SQL Server 2005 enterprise edition on your desktop, but not on your laptop.
I do not understand the statement... "Both SQL Server 2005 versions are installed from the same CD so why would there be a difference?"
Looking at the @.@.version information on your desktop and laptop indicate that SQL 2005 is install on your desktop, but SQL 2000 is install on your laptop. I do not see any indication that SQL 2005 is install on the laptop.
Tom
This posting is provided "AS IS" with no warranties, and confers no rights.
Different Server Name
I have a database created with MS SQL 2000 and I want to restore the database in SQL 2005 Express Edition. The problem is that both of the Sql servers are located on different computers so they have different server names. Is that possible to do it? I have tried to restore using the usual way and it failed. Thank you very much for your help.
Yes, you should be able to restore the database on a new machine (regardless of machine name). Are you hitting an error? If so, what does it say?
Thanks,
Sam Lester (MSFT)
Restore failed for Server 'KID\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'Inventory List' database. (Microsoft.SqlServer.Express.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476
BUTTONS:
OK
The error message is something like above. Any idea how to solve that? Thanks a lot|||
Here's a thread showing how to work around this error:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=694693&SiteID=1
Thanks,
Sam Lester (MSFT)
Hi Sam,
Thank you very much for the link. Now, I have understood what the problem is.
Friday, February 24, 2012
Different Edition of SSIS
We have an application that needs SSIS on the application server to upload data to our SQL database server which runs enterprise edition. Do I need to install the same editon of SSIS on the application server? Can SQL 2005 Standard editon SSIS communicate with the Enterprise Edition? Thanks.
Yes, you can use any SQL Server edition that includes an SSIS license on your application server.|||
isd83 wrote:
We have an application that needs SSIS on the application server to upload data to our SQL database server which runs enterprise edition. Do I need to install the same editon of SSIS on the application server? Can SQL 2005 Standard editon SSIS communicate with the Enterprise Edition? Thanks.
Yep, the standard or enterprise versions of SQL Server are required. Either will work in this case.
|||Thank you Phil and JayH for you help.Friday, February 17, 2012
Different behaviors when writing Database file into the SD Memory card.
Hi All,
I have seen some different behaviors when I am writing SQL Server compact edition Database file into SD Memory card or any user removable storage media.
The following Steps for reproducing these behaviors.
1. Set your database location is in the SD Memory card.
2. Create a database and establish session.
3. Writing first record into the database is done
4. Remove your SD card manually from the system
5. Try to write a Second record into the database
6. You will get the error from this "SqlCeWriteRecordProps" API call - This is fine.
7. Put your SD card back into the system.
8. Writing Second record again into the database is done - This is fine.
So far the behaviors are good after that
9. Remove your SD card manually from the system again
10. Try to write a Third record into the database
11. You will suppose to get the error from this "SqlCeWriteRecordProps" API call but you won’t get that error – I don’t know why?
12. Then Try to write a Forth record into the database
13. You won't get any error from the API call "SqlCeWriteRecordProps" and return status is success.
14. Now put your SD card back into the system.
15. Then write Fifth record but this time its writing record Third, Fourth and Fifth into the database.
Note:
I am clearing (means Free) my record structure everything after calling this function "SqlCeWriteRecordProps". So I don’t know why its wring Third, fourth and fifth record into the database.
Please Let me know your feedback.
Thanks,
Rajendran
This must be related to at what point of time the changes are flushed to SD card. It could be that during 2nd record write there is an attempt to flush the changes and the disk missing error. The next attempt to write records happens only during 5th write.
By default the flush interval is set to 10 seconds. This can be varied through connection string.
[If your question is answered, please mark it as answered]
-Thanks
Differences in clustered system db's vs standalone system db's?
We have a standalone Enterprise edition sql 2000 server that we want to
migrate to a cluster and make it a virtual sql server, for high availability
reasons.
We do not want to change the name of the SQL Server, as hundreds of
databases are on this server, and hundreds of applications refer to this SQL
Server name. Because of these requirements, we cannot use the steps in BOL
to upgrade our standalone to a cluster (that includes changing the sql server
name)
We are moving to two new servers (the current server will be retired)
Does anyone know the following two questions...
Is it possible to take the system databases from a standalone version of SQL
Server, and restore them to a clustered SQL Server?
Are there differences in the system databases on a stand alone SQL Server
vs. a clustered virtual SQL Server?
Here is a high level idea of what we would like to do:
- Stop SQL on the standalone server
- Rename the standalone server
- Install sql on the cluster, and give the virtual sql server the orignal
name of my standalone server
- shutdown sql on the cluster
- copy the data and log files for all system and user databases to the
cluster from the standalone server
- start up sql on the cluster
Thanks for your help and time!
I wouldn't try and copy the system databases from one server to another,
much less from a non-clustered instance to a clustered instance. You are
likely much better off aliasing the old name to the new name using a DNS
record or a client-side alias. Even if you do manage to copy the system
databases, the network name presented to the outside world by the Cluster
won't change so you will not solve your initial problem.
Geoff N.Hiten
Microsoft SQL Server MVP
"KellyVV" <KellyVV@.discussions.microsoft.com> wrote in message
news:6BC09EC5-ACC9-4493-8E89-43684AC9A82E@.microsoft.com...
> Hello,
> We have a standalone Enterprise edition sql 2000 server that we want to
> migrate to a cluster and make it a virtual sql server, for high
> availability
> reasons.
> We do not want to change the name of the SQL Server, as hundreds of
> databases are on this server, and hundreds of applications refer to this
> SQL
> Server name. Because of these requirements, we cannot use the steps in
> BOL
> to upgrade our standalone to a cluster (that includes changing the sql
> server
> name)
> We are moving to two new servers (the current server will be retired)
> Does anyone know the following two questions...
> Is it possible to take the system databases from a standalone version of
> SQL
> Server, and restore them to a clustered SQL Server?
> Are there differences in the system databases on a stand alone SQL Server
> vs. a clustered virtual SQL Server?
> Here is a high level idea of what we would like to do:
> - Stop SQL on the standalone server
> - Rename the standalone server
> - Install sql on the cluster, and give the virtual sql server the orignal
> name of my standalone server
> - shutdown sql on the cluster
> - copy the data and log files for all system and user databases to the
> cluster from the standalone server
> - start up sql on the cluster
> Thanks for your help and time!
|||The ability to move the system and user databases between a standalone
Enterprise instance and clustered Enterprise server instance as you are
proposing is perfectly possible.
I have not noticed any difference between clustered and non-clustered system
databases, I however have not conducted any comprehensive comparison.
The issues you will more likely encounter here are the same issues as
migrating system databases between standalone instances of SQL.
Have a look at 224071. http://support.microsoft.com/kb/224071.
You may want to evaluate the possibility of migrating your user databases
and specific system information (Logins etc) as an alternative to ensure
your new setup clean.
Your assumptions about the SQL instance names are correct, if I understand
you correctly, are correct: You have a default standalone instance on
ServerX (which will be removed from the network) which you wish to replace
with a ServerX virtual server default instance. The only consideration here
would be that there can not be another preexisting default instance of SQL
installed on the cluster.
Regards
Gary Hope
iSolve Business Solutions
South Africa
"KellyVV" <KellyVV@.discussions.microsoft.com> wrote in message
news:6BC09EC5-ACC9-4493-8E89-43684AC9A82E@.microsoft.com...
> Hello,
> We have a standalone Enterprise edition sql 2000 server that we want to
> migrate to a cluster and make it a virtual sql server, for high
> availability
> reasons.
> We do not want to change the name of the SQL Server, as hundreds of
> databases are on this server, and hundreds of applications refer to this
> SQL
> Server name. Because of these requirements, we cannot use the steps in
> BOL
> to upgrade our standalone to a cluster (that includes changing the sql
> server
> name)
> We are moving to two new servers (the current server will be retired)
> Does anyone know the following two questions...
> Is it possible to take the system databases from a standalone version of
> SQL
> Server, and restore them to a clustered SQL Server?
> Are there differences in the system databases on a stand alone SQL Server
> vs. a clustered virtual SQL Server?
> Here is a high level idea of what we would like to do:
> - Stop SQL on the standalone server
> - Rename the standalone server
> - Install sql on the cluster, and give the virtual sql server the orignal
> name of my standalone server
> - shutdown sql on the cluster
> - copy the data and log files for all system and user databases to the
> cluster from the standalone server
> - start up sql on the cluster
> Thanks for your help and time!
differences between versions of SQL serve2005
$1000 each. It comes with 5 CALs. I had been using SQLExpress 2005 but
decided to use the full version prior to shipping the deliverable. When I
went to install the software (on a michine with SQL Express already
installed) I was essentially told that everything that I wanted to install
was already there!
So what did I gain for my $1000?
Actually I believe I am going backwards. I do not know the limits for
concurrent connections for SQLExpress but I had vereral clients connected
and it never complained. Byt I am now limited to 5 seats!
This is a reasonably low duty server running on WinNT with a simple dual
core processor. It is not critical. I was able to stress the SQL Express
server by sending it data at a 30X rate of normal operation without any
problems.
The server goes out with a $275K piece of equipment so I did not mind the
expenditure but if I gain nothing...well it is hard to justify.
Or am I missing something?
Thanks
I don't know what the actual message stated but Express and Std are not the
same things. Yes they share the same code base etc but Std comes with SSMS
and Express does not. Actually you can download SSMS express. But Std gives
you unlimited memory usage, up to 4 procs (not counting cores) and unlimited
db size plus a lot more. Express is limited to 1GB memory, 4GB db and 1 Proc
plus some others like does not include SQL Agent etc. See more here:
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
As long as you don't need any of those missing features or won't exceed the
limits of Express it would have been just fine. By the way Workgroup may
also have been an option and it's half the cost of Std.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Larry Killen" <lkillen@.charter.net> wrote in message
news:JAI3j.260$9x7.116@.newsfe05.lga...
>I just purchased 2 copies of SQL Server 2005 standard edition at the tune
>of
> $1000 each. It comes with 5 CALs. I had been using SQLExpress 2005 but
> decided to use the full version prior to shipping the deliverable. When I
> went to install the software (on a michine with SQL Express already
> installed) I was essentially told that everything that I wanted to install
> was already there!
> So what did I gain for my $1000?
> Actually I believe I am going backwards. I do not know the limits for
> concurrent connections for SQLExpress but I had vereral clients connected
> and it never complained. Byt I am now limited to 5 seats!
> This is a reasonably low duty server running on WinNT with a simple dual
> core processor. It is not critical. I was able to stress the SQL Express
> server by sending it data at a 30X rate of normal operation without any
> problems.
> The server goes out with a $275K piece of equipment so I did not mind the
> expenditure but if I gain nothing...well it is hard to justify.
> Or am I missing something?
> Thanks
>
>
|||Thanks Andrew,
I was aware of the memory llimitation though I did not know about the memory
limit. Considering that we replaced Paradox with MSDE and now Express, I
think Express will suffice.
I am unsure what you mean by "1 Proc ". Do you mean Stored Procedure? I
have several running under both MSDE and SQLExpress.
Thanks
Larry
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:uEu5$8uMIHA.5224@.TK2MSFTNGP02.phx.gbl...
>I don't know what the actual message stated but Express and Std are not the
>same things. Yes they share the same code base etc but Std comes with SSMS
>and Express does not. Actually you can download SSMS express. But Std
>gives you unlimited memory usage, up to 4 procs (not counting cores) and
>unlimited db size plus a lot more. Express is limited to 1GB memory, 4GB db
>and 1 Proc plus some others like does not include SQL Agent etc. See more
>here:
> http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
> As long as you don't need any of those missing features or won't exceed
> the limits of Express it would have been just fine. By the way Workgroup
> may also have been an option and it's half the cost of Std.
>
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "Larry Killen" <lkillen@.charter.net> wrote in message
> news:JAI3j.260$9x7.116@.newsfe05.lga...
>
|||Hi Larry
1 Proc means 1 Processor.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Larry Killen" <lkillen@.charter.net> wrote in message
news:5FK3j.127$Wl1.49@.newsfe06.lga...
> Thanks Andrew,
> I was aware of the memory llimitation though I did not know about the
> memory limit. Considering that we replaced Paradox with MSDE and now
> Express, I think Express will suffice.
> I am unsure what you mean by "1 Proc ". Do you mean Stored Procedure? I
> have several running under both MSDE and SQLExpress.
> Thanks
> Larry
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:uEu5$8uMIHA.5224@.TK2MSFTNGP02.phx.gbl...
>
|||The thing that surprized me that you did not even bother yourself to take a
look at the differences between editions of SQL Server before buying its
licenses and now your are complaining. This is weird indeed.
Ekrem nsoy
"Larry Killen" <lkillen@.charter.net> wrote in message
news:5FK3j.127$Wl1.49@.newsfe06.lga...
> Thanks Andrew,
> I was aware of the memory llimitation though I did not know about the
> memory limit. Considering that we replaced Paradox with MSDE and now
> Express, I think Express will suffice.
> I am unsure what you mean by "1 Proc ". Do you mean Stored Procedure? I
> have several running under both MSDE and SQLExpress.
> Thanks
> Larry
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:uEu5$8uMIHA.5224@.TK2MSFTNGP02.phx.gbl...
>
|||I am the developer. Others make the purchasing decision. We are a
manufacturing company and do a lot of things the "wierd" way. Thank you,
"Ekrem nsoy" <ekrem@.btegitim.com> wrote in message
news:52F09469-E27E-419E-960F-44BEAC5C0AEE@.microsoft.com...
> The thing that surprized me that you did not even bother yourself to take
> a look at the differences between editions of SQL Server before buying its
> licenses and now your are complaining. This is weird indeed.
> --
> Ekrem nsoy
>
> "Larry Killen" <lkillen@.charter.net> wrote in message
> news:5FK3j.127$Wl1.49@.newsfe06.lga...
>
|||Larry,
As Kalen pointed out I meant Processor. But I highly recommend you review
the document I listed for all the differences.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Larry Killen" <lkillen@.charter.net> wrote in message
news:5FK3j.127$Wl1.49@.newsfe06.lga...
> Thanks Andrew,
> I was aware of the memory llimitation though I did not know about the
> memory limit. Considering that we replaced Paradox with MSDE and now
> Express, I think Express will suffice.
> I am unsure what you mean by "1 Proc ". Do you mean Stored Procedure? I
> have several running under both MSDE and SQLExpress.
> Thanks
> Larry
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:uEu5$8uMIHA.5224@.TK2MSFTNGP02.phx.gbl...
>
differences between versions of SQL serve2005
$1000 each. It comes with 5 CALs. I had been using SQLExpress 2005 but
decided to use the full version prior to shipping the deliverable. When I
went to install the software (on a michine with SQL Express already
installed) I was essentially told that everything that I wanted to install
was already there!
So what did I gain for my $1000'
Actually I believe I am going backwards. I do not know the limits for
concurrent connections for SQLExpress but I had vereral clients connected
and it never complained. Byt I am now limited to 5 seats!
This is a reasonably low duty server running on WinNT with a simple dual
core processor. It is not critical. I was able to stress the SQL Express
server by sending it data at a 30X rate of normal operation without any
problems.
The server goes out with a $275K piece of equipment so I did not mind the
expenditure but if I gain nothing...well it is hard to justify.
Or am I missing something?
ThanksI don't know what the actual message stated but Express and Std are not the
same things. Yes they share the same code base etc but Std comes with SSMS
and Express does not. Actually you can download SSMS express. But Std gives
you unlimited memory usage, up to 4 procs (not counting cores) and unlimited
db size plus a lot more. Express is limited to 1GB memory, 4GB db and 1 Proc
plus some others like does not include SQL Agent etc. See more here:
http://www.microsoft.com/sql/prodin...e-features.mspx
As long as you don't need any of those missing features or won't exceed the
limits of Express it would have been just fine. By the way Workgroup may
also have been an option and it's half the cost of Std.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Larry Killen" <lkillen@.charter.net> wrote in message
news:JAI3j.260$9x7.116@.newsfe05.lga...
>I just purchased 2 copies of SQL Server 2005 standard edition at the tune
>of
> $1000 each. It comes with 5 CALs. I had been using SQLExpress 2005 but
> decided to use the full version prior to shipping the deliverable. When I
> went to install the software (on a michine with SQL Express already
> installed) I was essentially told that everything that I wanted to install
> was already there!
> So what did I gain for my $1000'
> Actually I believe I am going backwards. I do not know the limits for
> concurrent connections for SQLExpress but I had vereral clients connected
> and it never complained. Byt I am now limited to 5 seats!
> This is a reasonably low duty server running on WinNT with a simple dual
> core processor. It is not critical. I was able to stress the SQL Express
> server by sending it data at a 30X rate of normal operation without any
> problems.
> The server goes out with a $275K piece of equipment so I did not mind the
> expenditure but if I gain nothing...well it is hard to justify.
> Or am I missing something?
> Thanks
>
>|||Thanks Andrew,
I was aware of the memory llimitation though I did not know about the memory
limit. Considering that we replaced Paradox with MSDE and now Express, I
think Express will suffice.
I am unsure what you mean by "1 Proc ". Do you mean Stored Procedure? I
have several running under both MSDE and SQLExpress.
Thanks
Larry
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:uEu5$8uMIHA.5224@.TK2MSFTNGP02.phx.gbl...
>I don't know what the actual message stated but Express and Std are not the
>same things. Yes they share the same code base etc but Std comes with SSMS
>and Express does not. Actually you can download SSMS express. But Std
>gives you unlimited memory usage, up to 4 procs (not counting cores) and
>unlimited db size plus a lot more. Express is limited to 1GB memory, 4GB db
>and 1 Proc plus some others like does not include SQL Agent etc. See more
>here:
> http://www.microsoft.com/sql/prodin...e-features.mspx
> As long as you don't need any of those missing features or won't exceed
> the limits of Express it would have been just fine. By the way Workgroup
> may also have been an option and it's half the cost of Std.
>
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "Larry Killen" <lkillen@.charter.net> wrote in message
> news:JAI3j.260$9x7.116@.newsfe05.lga...
>|||Hi Larry
1 Proc means 1 Processor.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Larry Killen" <lkillen@.charter.net> wrote in message
news:5FK3j.127$Wl1.49@.newsfe06.lga...
> Thanks Andrew,
> I was aware of the memory llimitation though I did not know about the
> memory limit. Considering that we replaced Paradox with MSDE and now
> Express, I think Express will suffice.
> I am unsure what you mean by "1 Proc ". Do you mean Stored Procedure? I
> have several running under both MSDE and SQLExpress.
> Thanks
> Larry
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:uEu5$8uMIHA.5224@.TK2MSFTNGP02.phx.gbl...
>|||The thing that surprized me that you did not even bother yourself to take a
look at the differences between editions of SQL Server before buying its
licenses and now your are complaining. This is weird indeed.
Ekrem nsoy
"Larry Killen" <lkillen@.charter.net> wrote in message
news:5FK3j.127$Wl1.49@.newsfe06.lga...
> Thanks Andrew,
> I was aware of the memory llimitation though I did not know about the
> memory limit. Considering that we replaced Paradox with MSDE and now
> Express, I think Express will suffice.
> I am unsure what you mean by "1 Proc ". Do you mean Stored Procedure? I
> have several running under both MSDE and SQLExpress.
> Thanks
> Larry
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:uEu5$8uMIHA.5224@.TK2MSFTNGP02.phx.gbl...
>|||I am the developer. Others make the purchasing decision. We are a
manufacturing company and do a lot of things the "wierd" way. Thank you,
"Ekrem nsoy" <ekrem@.btegitim.com> wrote in message
news:52F09469-E27E-419E-960F-44BEAC5C0AEE@.microsoft.com...
> The thing that surprized me that you did not even bother yourself to take
> a look at the differences between editions of SQL Server before buying its
> licenses and now your are complaining. This is weird indeed.
> --
> Ekrem nsoy
>
> "Larry Killen" <lkillen@.charter.net> wrote in message
> news:5FK3j.127$Wl1.49@.newsfe06.lga...
>|||Larry,
As Kalen pointed out I meant Processor. But I highly recommend you review
the document I listed for all the differences.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Larry Killen" <lkillen@.charter.net> wrote in message
news:5FK3j.127$Wl1.49@.newsfe06.lga...
> Thanks Andrew,
> I was aware of the memory llimitation though I did not know about the
> memory limit. Considering that we replaced Paradox with MSDE and now
> Express, I think Express will suffice.
> I am unsure what you mean by "1 Proc ". Do you mean Stored Procedure? I
> have several running under both MSDE and SQLExpress.
> Thanks
> Larry
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:uEu5$8uMIHA.5224@.TK2MSFTNGP02.phx.gbl...
>
differences between versions of SQL serve2005
$1000 each. It comes with 5 CALs. I had been using SQLExpress 2005 but
decided to use the full version prior to shipping the deliverable. When I
went to install the software (on a michine with SQL Express already
installed) I was essentially told that everything that I wanted to install
was already there!
So what did I gain for my $1000'
Actually I believe I am going backwards. I do not know the limits for
concurrent connections for SQLExpress but I had vereral clients connected
and it never complained. Byt I am now limited to 5 seats!
This is a reasonably low duty server running on WinNT with a simple dual
core processor. It is not critical. I was able to stress the SQL Express
server by sending it data at a 30X rate of normal operation without any
problems.
The server goes out with a $275K piece of equipment so I did not mind the
expenditure but if I gain nothing...well it is hard to justify.
Or am I missing something?
ThanksI don't know what the actual message stated but Express and Std are not the
same things. Yes they share the same code base etc but Std comes with SSMS
and Express does not. Actually you can download SSMS express. But Std gives
you unlimited memory usage, up to 4 procs (not counting cores) and unlimited
db size plus a lot more. Express is limited to 1GB memory, 4GB db and 1 Proc
plus some others like does not include SQL Agent etc. See more here:
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
As long as you don't need any of those missing features or won't exceed the
limits of Express it would have been just fine. By the way Workgroup may
also have been an option and it's half the cost of Std.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Larry Killen" <lkillen@.charter.net> wrote in message
news:JAI3j.260$9x7.116@.newsfe05.lga...
>I just purchased 2 copies of SQL Server 2005 standard edition at the tune
>of
> $1000 each. It comes with 5 CALs. I had been using SQLExpress 2005 but
> decided to use the full version prior to shipping the deliverable. When I
> went to install the software (on a michine with SQL Express already
> installed) I was essentially told that everything that I wanted to install
> was already there!
> So what did I gain for my $1000'
> Actually I believe I am going backwards. I do not know the limits for
> concurrent connections for SQLExpress but I had vereral clients connected
> and it never complained. Byt I am now limited to 5 seats!
> This is a reasonably low duty server running on WinNT with a simple dual
> core processor. It is not critical. I was able to stress the SQL Express
> server by sending it data at a 30X rate of normal operation without any
> problems.
> The server goes out with a $275K piece of equipment so I did not mind the
> expenditure but if I gain nothing...well it is hard to justify.
> Or am I missing something?
> Thanks
>
>|||Thanks Andrew,
I was aware of the memory llimitation though I did not know about the memory
limit. Considering that we replaced Paradox with MSDE and now Express, I
think Express will suffice.
I am unsure what you mean by "1 Proc ". Do you mean Stored Procedure? I
have several running under both MSDE and SQLExpress.
Thanks
Larry
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:uEu5$8uMIHA.5224@.TK2MSFTNGP02.phx.gbl...
>I don't know what the actual message stated but Express and Std are not the
>same things. Yes they share the same code base etc but Std comes with SSMS
>and Express does not. Actually you can download SSMS express. But Std
>gives you unlimited memory usage, up to 4 procs (not counting cores) and
>unlimited db size plus a lot more. Express is limited to 1GB memory, 4GB db
>and 1 Proc plus some others like does not include SQL Agent etc. See more
>here:
> http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
> As long as you don't need any of those missing features or won't exceed
> the limits of Express it would have been just fine. By the way Workgroup
> may also have been an option and it's half the cost of Std.
>
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "Larry Killen" <lkillen@.charter.net> wrote in message
> news:JAI3j.260$9x7.116@.newsfe05.lga...
>>I just purchased 2 copies of SQL Server 2005 standard edition at the tune
>>of
>> $1000 each. It comes with 5 CALs. I had been using SQLExpress 2005 but
>> decided to use the full version prior to shipping the deliverable. When
>> I
>> went to install the software (on a michine with SQL Express already
>> installed) I was essentially told that everything that I wanted to
>> install
>> was already there!
>> So what did I gain for my $1000'
>> Actually I believe I am going backwards. I do not know the limits for
>> concurrent connections for SQLExpress but I had vereral clients connected
>> and it never complained. Byt I am now limited to 5 seats!
>> This is a reasonably low duty server running on WinNT with a simple dual
>> core processor. It is not critical. I was able to stress the SQL
>> Express
>> server by sending it data at a 30X rate of normal operation without any
>> problems.
>> The server goes out with a $275K piece of equipment so I did not mind the
>> expenditure but if I gain nothing...well it is hard to justify.
>> Or am I missing something?
>> Thanks
>>
>|||Hi Larry
1 Proc means 1 Processor.
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Larry Killen" <lkillen@.charter.net> wrote in message
news:5FK3j.127$Wl1.49@.newsfe06.lga...
> Thanks Andrew,
> I was aware of the memory llimitation though I did not know about the
> memory limit. Considering that we replaced Paradox with MSDE and now
> Express, I think Express will suffice.
> I am unsure what you mean by "1 Proc ". Do you mean Stored Procedure? I
> have several running under both MSDE and SQLExpress.
> Thanks
> Larry
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:uEu5$8uMIHA.5224@.TK2MSFTNGP02.phx.gbl...
>>I don't know what the actual message stated but Express and Std are not
>>the same things. Yes they share the same code base etc but Std comes with
>>SSMS and Express does not. Actually you can download SSMS express. But
>>Std gives you unlimited memory usage, up to 4 procs (not counting cores)
>>and unlimited db size plus a lot more. Express is limited to 1GB memory,
>>4GB db and 1 Proc plus some others like does not include SQL Agent etc.
>>See more here:
>> http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
>> As long as you don't need any of those missing features or won't exceed
>> the limits of Express it would have been just fine. By the way Workgroup
>> may also have been an option and it's half the cost of Std.
>>
>> --
>> Andrew J. Kelly SQL MVP
>> Solid Quality Mentors
>>
>> "Larry Killen" <lkillen@.charter.net> wrote in message
>> news:JAI3j.260$9x7.116@.newsfe05.lga...
>>I just purchased 2 copies of SQL Server 2005 standard edition at the tune
>>of
>> $1000 each. It comes with 5 CALs. I had been using SQLExpress 2005 but
>> decided to use the full version prior to shipping the deliverable. When
>> I
>> went to install the software (on a michine with SQL Express already
>> installed) I was essentially told that everything that I wanted to
>> install
>> was already there!
>> So what did I gain for my $1000'
>> Actually I believe I am going backwards. I do not know the limits for
>> concurrent connections for SQLExpress but I had vereral clients
>> connected
>> and it never complained. Byt I am now limited to 5 seats!
>> This is a reasonably low duty server running on WinNT with a simple dual
>> core processor. It is not critical. I was able to stress the SQL
>> Express
>> server by sending it data at a 30X rate of normal operation without any
>> problems.
>> The server goes out with a $275K piece of equipment so I did not mind
>> the
>> expenditure but if I gain nothing...well it is hard to justify.
>> Or am I missing something?
>> Thanks
>>
>>
>|||The thing that surprized me that you did not even bother yourself to take a
look at the differences between editions of SQL Server before buying its
licenses and now your are complaining. This is weird indeed.
--
Ekrem Önsoy
"Larry Killen" <lkillen@.charter.net> wrote in message
news:5FK3j.127$Wl1.49@.newsfe06.lga...
> Thanks Andrew,
> I was aware of the memory llimitation though I did not know about the
> memory limit. Considering that we replaced Paradox with MSDE and now
> Express, I think Express will suffice.
> I am unsure what you mean by "1 Proc ". Do you mean Stored Procedure? I
> have several running under both MSDE and SQLExpress.
> Thanks
> Larry
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:uEu5$8uMIHA.5224@.TK2MSFTNGP02.phx.gbl...
>>I don't know what the actual message stated but Express and Std are not
>>the same things. Yes they share the same code base etc but Std comes with
>>SSMS and Express does not. Actually you can download SSMS express. But
>>Std gives you unlimited memory usage, up to 4 procs (not counting cores)
>>and unlimited db size plus a lot more. Express is limited to 1GB memory,
>>4GB db and 1 Proc plus some others like does not include SQL Agent etc.
>>See more here:
>> http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
>> As long as you don't need any of those missing features or won't exceed
>> the limits of Express it would have been just fine. By the way Workgroup
>> may also have been an option and it's half the cost of Std.
>>
>> --
>> Andrew J. Kelly SQL MVP
>> Solid Quality Mentors
>>
>> "Larry Killen" <lkillen@.charter.net> wrote in message
>> news:JAI3j.260$9x7.116@.newsfe05.lga...
>>I just purchased 2 copies of SQL Server 2005 standard edition at the tune
>>of
>> $1000 each. It comes with 5 CALs. I had been using SQLExpress 2005 but
>> decided to use the full version prior to shipping the deliverable. When
>> I
>> went to install the software (on a michine with SQL Express already
>> installed) I was essentially told that everything that I wanted to
>> install
>> was already there!
>> So what did I gain for my $1000'
>> Actually I believe I am going backwards. I do not know the limits for
>> concurrent connections for SQLExpress but I had vereral clients
>> connected
>> and it never complained. Byt I am now limited to 5 seats!
>> This is a reasonably low duty server running on WinNT with a simple dual
>> core processor. It is not critical. I was able to stress the SQL
>> Express
>> server by sending it data at a 30X rate of normal operation without any
>> problems.
>> The server goes out with a $275K piece of equipment so I did not mind
>> the
>> expenditure but if I gain nothing...well it is hard to justify.
>> Or am I missing something?
>> Thanks
>>
>>
>|||I am the developer. Others make the purchasing decision. We are a
manufacturing company and do a lot of things the "wierd" way. Thank you,
"Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
news:52F09469-E27E-419E-960F-44BEAC5C0AEE@.microsoft.com...
> The thing that surprized me that you did not even bother yourself to take
> a look at the differences between editions of SQL Server before buying its
> licenses and now your are complaining. This is weird indeed.
> --
> Ekrem Önsoy
>
> "Larry Killen" <lkillen@.charter.net> wrote in message
> news:5FK3j.127$Wl1.49@.newsfe06.lga...
>> Thanks Andrew,
>> I was aware of the memory llimitation though I did not know about the
>> memory limit. Considering that we replaced Paradox with MSDE and now
>> Express, I think Express will suffice.
>> I am unsure what you mean by "1 Proc ". Do you mean Stored Procedure? I
>> have several running under both MSDE and SQLExpress.
>> Thanks
>> Larry
>>
>> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
>> news:uEu5$8uMIHA.5224@.TK2MSFTNGP02.phx.gbl...
>>I don't know what the actual message stated but Express and Std are not
>>the same things. Yes they share the same code base etc but Std comes with
>>SSMS and Express does not. Actually you can download SSMS express. But
>>Std gives you unlimited memory usage, up to 4 procs (not counting cores)
>>and unlimited db size plus a lot more. Express is limited to 1GB memory,
>>4GB db and 1 Proc plus some others like does not include SQL Agent etc.
>>See more here:
>> http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
>> As long as you don't need any of those missing features or won't exceed
>> the limits of Express it would have been just fine. By the way Workgroup
>> may also have been an option and it's half the cost of Std.
>>
>> --
>> Andrew J. Kelly SQL MVP
>> Solid Quality Mentors
>>
>> "Larry Killen" <lkillen@.charter.net> wrote in message
>> news:JAI3j.260$9x7.116@.newsfe05.lga...
>>I just purchased 2 copies of SQL Server 2005 standard edition at the
>>tune of
>> $1000 each. It comes with 5 CALs. I had been using SQLExpress 2005
>> but
>> decided to use the full version prior to shipping the deliverable.
>> When I
>> went to install the software (on a michine with SQL Express already
>> installed) I was essentially told that everything that I wanted to
>> install
>> was already there!
>> So what did I gain for my $1000'
>> Actually I believe I am going backwards. I do not know the limits for
>> concurrent connections for SQLExpress but I had vereral clients
>> connected
>> and it never complained. Byt I am now limited to 5 seats!
>> This is a reasonably low duty server running on WinNT with a simple
>> dual
>> core processor. It is not critical. I was able to stress the SQL
>> Express
>> server by sending it data at a 30X rate of normal operation without any
>> problems.
>> The server goes out with a $275K piece of equipment so I did not mind
>> the
>> expenditure but if I gain nothing...well it is hard to justify.
>> Or am I missing something?
>> Thanks
>>
>>
>>
>|||Larry,
As Kalen pointed out I meant Processor. But I highly recommend you review
the document I listed for all the differences.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Larry Killen" <lkillen@.charter.net> wrote in message
news:5FK3j.127$Wl1.49@.newsfe06.lga...
> Thanks Andrew,
> I was aware of the memory llimitation though I did not know about the
> memory limit. Considering that we replaced Paradox with MSDE and now
> Express, I think Express will suffice.
> I am unsure what you mean by "1 Proc ". Do you mean Stored Procedure? I
> have several running under both MSDE and SQLExpress.
> Thanks
> Larry
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:uEu5$8uMIHA.5224@.TK2MSFTNGP02.phx.gbl...
>>I don't know what the actual message stated but Express and Std are not
>>the same things. Yes they share the same code base etc but Std comes with
>>SSMS and Express does not. Actually you can download SSMS express. But
>>Std gives you unlimited memory usage, up to 4 procs (not counting cores)
>>and unlimited db size plus a lot more. Express is limited to 1GB memory,
>>4GB db and 1 Proc plus some others like does not include SQL Agent etc.
>>See more here:
>> http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
>> As long as you don't need any of those missing features or won't exceed
>> the limits of Express it would have been just fine. By the way Workgroup
>> may also have been an option and it's half the cost of Std.
>>
>> --
>> Andrew J. Kelly SQL MVP
>> Solid Quality Mentors
>>
>> "Larry Killen" <lkillen@.charter.net> wrote in message
>> news:JAI3j.260$9x7.116@.newsfe05.lga...
>>I just purchased 2 copies of SQL Server 2005 standard edition at the tune
>>of
>> $1000 each. It comes with 5 CALs. I had been using SQLExpress 2005 but
>> decided to use the full version prior to shipping the deliverable. When
>> I
>> went to install the software (on a michine with SQL Express already
>> installed) I was essentially told that everything that I wanted to
>> install
>> was already there!
>> So what did I gain for my $1000'
>> Actually I believe I am going backwards. I do not know the limits for
>> concurrent connections for SQLExpress but I had vereral clients
>> connected
>> and it never complained. Byt I am now limited to 5 seats!
>> This is a reasonably low duty server running on WinNT with a simple dual
>> core processor. It is not critical. I was able to stress the SQL
>> Express
>> server by sending it data at a 30X rate of normal operation without any
>> problems.
>> The server goes out with a $275K piece of equipment so I did not mind
>> the
>> expenditure but if I gain nothing...well it is hard to justify.
>> Or am I missing something?
>> Thanks
>>
>>
>
Tuesday, February 14, 2012
Differences between SQL2000 Dev. Edition & SQL2005 Dev. Edition
Can anyone tell me or suggest links about differences of SQL Server
2000 Developer Edition & SQL Server 2005 Developer Edition?
Specifically, I need to know about the licencing policy.
So far I know that SQL Server 2005 Developer Edition is licenced for
develpoment (what else), test and demo use. Each licence entitles only
one developer to use the software on as many systems as necessary and
additional developers can use the software by parchasing additional
licences (some sentences borrowed by microsoft's presentation of the
product).
Does 2000 Edition has more functions than the latest one? In other
words, what the advantages and disadvantages of these 2 Versions?
Thanks in advance?
PS: Shoul I post this here?x-rays wrote:
> Hello all,
> Can anyone tell me or suggest links about differences of SQL Server
> 2000 Developer Edition & SQL Server 2005 Developer Edition?
> Specifically, I need to know about the licencing policy.
> So far I know that SQL Server 2005 Developer Edition is licenced for
> develpoment (what else), test and demo use. Each licence entitles only
> one developer to use the software on as many systems as necessary and
> additional developers can use the software by parchasing additional
> licences (some sentences borrowed by microsoft's presentation of the
> product).
http://www.microsoft.com/sql/howtobuy/development.mspx
> Does 2000 Edition has more functions than the latest one?
No. SQL Server 2005 Dev Edition is feature equivalent to SQL Server
2005 Enterprise. Other than the licence the only difference I'm aware
of is that Dev works on the desktop Windows OS whereas Enterprise
doesn't
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/...US,SQL.90).aspx
--|||Hello David,
thanks for replying, my last question was a bit thick I suppose "Does
2000 Edition has more functions than the latest one?", a newer version
is always better. What was the licence policy of SQL Server 2000 Dev.
Edition? Do you remember?
And a 2nd one, did microsoft stop selling SQL Server 2000 Editions?
PS: Please excuse my english.
Thanks in advance!
David Portas wrote:
> x-rays wrote:
> > Hello all,
> > Can anyone tell me or suggest links about differences of SQL Server
> > 2000 Developer Edition & SQL Server 2005 Developer Edition?
> > Specifically, I need to know about the licencing policy.
> > So far I know that SQL Server 2005 Developer Edition is licenced for
> > develpoment (what else), test and demo use. Each licence entitles only
> > one developer to use the software on as many systems as necessary and
> > additional developers can use the software by parchasing additional
> > licences (some sentences borrowed by microsoft's presentation of the
> > product).
> http://www.microsoft.com/sql/howtobuy/development.mspx
> > Does 2000 Edition has more functions than the latest one?
> No. SQL Server 2005 Dev Edition is feature equivalent to SQL Server
> 2005 Enterprise. Other than the licence the only difference I'm aware
> of is that Dev works on the desktop Windows OS whereas Enterprise
> doesn't
> --
> David Portas, SQL Server MVP
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/...US,SQL.90).aspx
> --
Differences between Desktop and Server Edition
I have a query concerning SQL server 7. We currently have an NT server 4.0
using SQL server, but however recently
we have been getting alot freezes from branches. I have noticed that the in
stallation on that server is desktop editon. I am not sure if this the like
y reason.
What are the differences between desktop and server edition?
Should'v the server be installed as SQL server - server edition?
Is there any optimising we can there?
ThanksThe desktop edition is required for non-server OS's (like NT workstation, or
windows xp).
The functionality is the same, but there is a limit on the number of threads
( maybe 10 I think). When there are more connections than worker threads,
then multiple connections share the same thread and response time
increases... This prevents users from putting Desktop Edition into
production when the full server should be used.
The desktop edition has lower cost than servers, but is intended ONLY for
small small number of users...To increase throughput , you buy and install
the Server Edition.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rakesh" <anonymous@.discussions.microsoft.com> wrote in message
news:59E83439-70FE-4C64-B2C6-164E9B6A39D6@.microsoft.com...
> Hi
> I have a query concerning SQL server 7. We currently have an NT server
4.0 using SQL server, but however recently
> we have been getting alot freezes from branches. I have noticed that the
installation on that server is desktop editon. I am not sure if this the
likey reason.
> What are the differences between desktop and server edition?
> Should'v the server be installed as SQL server - server edition?
> Is there any optimising we can there?
> Thanks|||Do you reckon that SQL server - server edition be installed.
Would we have to uninstall the SQL sever deskop edition and install SQL - se
rver edition ?
How does SQL server optimise its memory management system?
Thanks
Differences between Desktop and Server Edition
I have a query concerning SQL server 7. We currently have an NT server 4.0 using SQL server, but however recentl
we have been getting alot freezes from branches. I have noticed that the installation on that server is desktop editon. I am not sure if this the likey reason
What are the differences between desktop and server edition
Should'v the server be installed as SQL server - server edition
Is there any optimising we can there
ThanksThe desktop edition is required for non-server OS's (like NT workstation, or
windows xp).
The functionality is the same, but there is a limit on the number of threads
( maybe 10 I think). When there are more connections than worker threads,
then multiple connections share the same thread and response time
increases... This prevents users from putting Desktop Edition into
production when the full server should be used.
The desktop edition has lower cost than servers, but is intended ONLY for
small small number of users...To increase throughput , you buy and install
the Server Edition.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rakesh" <anonymous@.discussions.microsoft.com> wrote in message
news:59E83439-70FE-4C64-B2C6-164E9B6A39D6@.microsoft.com...
> Hi
> I have a query concerning SQL server 7. We currently have an NT server
4.0 using SQL server, but however recently
> we have been getting alot freezes from branches. I have noticed that the
installation on that server is desktop editon. I am not sure if this the
likey reason.
> What are the differences between desktop and server edition?
> Should'v the server be installed as SQL server - server edition?
> Is there any optimising we can there?
> Thanks|||Do you reckon that SQL server - server edition be installed
Would we have to uninstall the SQL sever deskop edition and install SQL - server edition
How does SQL server optimise its memory management system
Thanks
Differences between Desktop and Server Edition
I have a query concerning SQL server 7. We currently have an NT server 4.0 using SQL server, but however recently
we have been getting alot freezes from branches. I have noticed that the installation on that server is desktop editon. I am not sure if this the likey reason.
What are the differences between desktop and server edition?
Should'v the server be installed as SQL server - server edition?
Is there any optimising we can there?
Thanks
The desktop edition is required for non-server OS's (like NT workstation, or
windows xp).
The functionality is the same, but there is a limit on the number of threads
( maybe 10 I think). When there are more connections than worker threads,
then multiple connections share the same thread and response time
increases... This prevents users from putting Desktop Edition into
production when the full server should be used.
The desktop edition has lower cost than servers, but is intended ONLY for
small small number of users...To increase throughput , you buy and install
the Server Edition.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rakesh" <anonymous@.discussions.microsoft.com> wrote in message
news:59E83439-70FE-4C64-B2C6-164E9B6A39D6@.microsoft.com...
> Hi
> I have a query concerning SQL server 7. We currently have an NT server
4.0 using SQL server, but however recently
> we have been getting alot freezes from branches. I have noticed that the
installation on that server is desktop editon. I am not sure if this the
likey reason.
> What are the differences between desktop and server edition?
> Should'v the server be installed as SQL server - server edition?
> Is there any optimising we can there?
> Thanks
|||Do you reckon that SQL server - server edition be installed.
Would we have to uninstall the SQL sever deskop edition and install SQL - server edition ?
How does SQL server optimise its memory management system?
Thanks
Differences between 2000 and 2005
Just installed 2005 Enterprise Edition on an XP Media computer... I am blown away because nothing looks familiar to me. Anyone else feel lost?
Where is the best site for specific changes from 1 version to another... it appears that Enterprise Manager is gone, Query Analyzer is gone, my brain is gone
thx
Kat
hi kat,
install the sql management express to make things easier
http://go.microsoft.com/fwlink/?LinkId=65110.
http://msdn.microsoft.com/vstudio/express/sql/download/
QA and enterprise manager is now integrated as one UI
which is called the management studio (SQL-MS). Since you are using express
you need the MS express.
regards,
joey
|||
Kat,
Just have a look into the following product info article which will help you in knowing What's New in SQL Server 2005.
http://www.microsoft.com/sql/prodinfo/overview/whats-new-in-sqlserver2005.mspx
HTH,
Rajesh
|||Hi Joey,
Do you mean that I shouldn't be using the Enterprise Edition? I need to learn the reporting services that aren't in the Express Edition. I'm not sure I understand your answer.
thx,
Kat
|||
Thx Much Rajesh!
Kat
|||sorry my fault. I've got a hell of a week. my pc bug-ged down so
is my brains. hahaha
i though you were using sql express. just a bit too busy these days
any way if your looking for QA and EM its no longer around.
They are now in the new UI the SQL management Studio.
and yes reporting service is only found in the enterprise version
|||
Thanks Joey,
I'm trying to find out if anyone is running 2005 on an xp media machine. I did get the enterprise edition installed (not the db's yet but someone gave me a link to that). I also installed IIS but know nothing about configuring it. I'm lost in space... interview in 2.5 hours. I bought this machine without knowing that the xp media operating system is an upgrade from xp professional. I'll lose all the programs if I downgrade to professional and since this was a floor model, there aren't any cd's to replace those programs. Microsoft will charge me a wonderful 285 for tech support but I want to find out first if it is even going to be possible. Can you recommend a site to ask, post, whatever?
thx much!
Kat
|||
hi kat,
Use the developer edition. enterprise edition works best on servers.
developer edition works better in Xp. developer edition
have the same functionallity as the enterprise except that the
are used in development environment.
good luck with your interview
regards,
joey
|||
SQL Server Enterprise Edition is supposed to only be installable on server operating systems. XP Media Center is a workstation operating system, so I'm surprised you could install Enterprise on it at all.
SQL Server Developer Edition is functionally equivalent to Enterprise Edition, except it can be installed on Windows XP or Windows Vista. Note that the Developer Edition license doesn't let you use the Developer Edition server for production use.
Hope this helps,
Steve
I spoke with Microsoft and they said I couldn't install 2005 on a XP media machine. I'm not sure now about the other versions. All versions of 2005 require 2000, xp, etc. Nothing is listed as working with the Media version operating system. I was told I had to upgrade to the full version of XP professional. Nice huh? Or I could get rid of all of the programs installed and bring it to another operating system. Oh well, once my XP Pro laptop is fixed, I'll probably try the Express version. I just wanted to work on the reporting services which is available only in the Enterprise Edition as far as I can tell.
Kat
|||try the 2005 developer edition
i'm prettry sure express will install
Differences between 2000 and 2005
Just installed 2005 Enterprise Edition on an XP Media computer... I am blown away because nothing looks familiar to me. Anyone else feel lost?
Where is the best site for specific changes from 1 version to another... it appears that Enterprise Manager is gone, Query Analyzer is gone, my brain is gone
thx
Kat
hi kat,
install the sql management express to make things easier
http://go.microsoft.com/fwlink/?LinkId=65110.
http://msdn.microsoft.com/vstudio/express/sql/download/
QA and enterprise manager is now integrated as one UI
which is called the management studio (SQL-MS). Since you are using express
you need the MS express.
regards,
joey
|||
Kat,
Just have a look into the following product info article which will help you in knowing What's New in SQL Server 2005.
http://www.microsoft.com/sql/prodinfo/overview/whats-new-in-sqlserver2005.mspx
HTH,
Rajesh
|||Hi Joey,
Do you mean that I shouldn't be using the Enterprise Edition? I need to learn the reporting services that aren't in the Express Edition. I'm not sure I understand your answer.
thx,
Kat
|||Thx Much Rajesh!
Kat
|||sorry my fault. I've got a hell of a week. my pc bug-ged down so
is my brains. hahaha
i though you were using sql express. just a bit too busy these days
any way if your looking for QA and EM its no longer around.
They are now in the new UI the SQL management Studio.
and yes reporting service is only found in the enterprise version
|||
Thanks Joey,
I'm trying to find out if anyone is running 2005 on an xp media machine. I did get the enterprise edition installed (not the db's yet but someone gave me a link to that). I also installed IIS but know nothing about configuring it. I'm lost in space... interview in 2.5 hours. I bought this machine without knowing that the xp media operating system is an upgrade from xp professional. I'll lose all the programs if I downgrade to professional and since this was a floor model, there aren't any cd's to replace those programs. Microsoft will charge me a wonderful 285 for tech support but I want to find out first if it is even going to be possible. Can you recommend a site to ask, post, whatever?
thx much!
Kat
|||hi kat,
Use the developer edition. enterprise edition works best on servers.
developer edition works better in Xp. developer edition
have the same functionallity as the enterprise except that the
are used in development environment.
good luck with your interview
regards,
joey
|||
SQL Server Enterprise Edition is supposed to only be installable on server operating systems. XP Media Center is a workstation operating system, so I'm surprised you could install Enterprise on it at all.
SQL Server Developer Edition is functionally equivalent to Enterprise Edition, except it can be installed on Windows XP or Windows Vista. Note that the Developer Edition license doesn't let you use the Developer Edition server for production use.
Hope this helps,
Steve
I spoke with Microsoft and they said I couldn't install 2005 on a XP media machine. I'm not sure now about the other versions. All versions of 2005 require 2000, xp, etc. Nothing is listed as working with the Media version operating system. I was told I had to upgrade to the full version of XP professional. Nice huh? Or I could get rid of all of the programs installed and bring it to another operating system. Oh well, once my XP Pro laptop is fixed, I'll probably try the Express version. I just wanted to work on the reporting services which is available only in the Enterprise Edition as far as I can tell.
Kat
|||try the 2005 developer edition
i'm prettry sure express will install
Differences between 2000 and 2005
Just installed 2005 Enterprise Edition on an XP Media computer... I am blown away because nothing looks familiar to me. Anyone else feel lost?
Where is the best site for specific changes from 1 version to another... it appears that Enterprise Manager is gone, Query Analyzer is gone, my brain is gone
thx
Kat
hi kat,
install the sql management express to make things easier
http://go.microsoft.com/fwlink/?LinkId=65110.
http://msdn.microsoft.com/vstudio/express/sql/download/
QA and enterprise manager is now integrated as one UI
which is called the management studio (SQL-MS). Since you are using express
you need the MS express.
regards,
joey
|||
Kat,
Just have a look into the following product info article which will help you in knowing What's New in SQL Server 2005.
http://www.microsoft.com/sql/prodinfo/overview/whats-new-in-sqlserver2005.mspx
HTH,
Rajesh
|||Hi Joey,
Do you mean that I shouldn't be using the Enterprise Edition? I need to learn the reporting services that aren't in the Express Edition. I'm not sure I understand your answer.
thx,
Kat
|||Thx Much Rajesh!
Kat
|||sorry my fault. I've got a hell of a week. my pc bug-ged down so
is my brains. hahaha
i though you were using sql express. just a bit too busy these days
any way if your looking for QA and EM its no longer around.
They are now in the new UI the SQL management Studio.
and yes reporting service is only found in the enterprise version
|||
Thanks Joey,
I'm trying to find out if anyone is running 2005 on an xp media machine. I did get the enterprise edition installed (not the db's yet but someone gave me a link to that). I also installed IIS but know nothing about configuring it. I'm lost in space... interview in 2.5 hours. I bought this machine without knowing that the xp media operating system is an upgrade from xp professional. I'll lose all the programs if I downgrade to professional and since this was a floor model, there aren't any cd's to replace those programs. Microsoft will charge me a wonderful 285 for tech support but I want to find out first if it is even going to be possible. Can you recommend a site to ask, post, whatever?
thx much!
Kat
|||hi kat,
Use the developer edition. enterprise edition works best on servers.
developer edition works better in Xp. developer edition
have the same functionallity as the enterprise except that the
are used in development environment.
good luck with your interview
regards,
joey
|||
SQL Server Enterprise Edition is supposed to only be installable on server operating systems. XP Media Center is a workstation operating system, so I'm surprised you could install Enterprise on it at all.
SQL Server Developer Edition is functionally equivalent to Enterprise Edition, except it can be installed on Windows XP or Windows Vista. Note that the Developer Edition license doesn't let you use the Developer Edition server for production use.
Hope this helps,
Steve
I spoke with Microsoft and they said I couldn't install 2005 on a XP media machine. I'm not sure now about the other versions. All versions of 2005 require 2000, xp, etc. Nothing is listed as working with the Media version operating system. I was told I had to upgrade to the full version of XP professional. Nice huh? Or I could get rid of all of the programs installed and bring it to another operating system. Oh well, once my XP Pro laptop is fixed, I'll probably try the Express version. I just wanted to work on the reporting services which is available only in the Enterprise Edition as far as I can tell.
Kat
|||try the 2005 developer edition
i'm prettry sure express will install
Differences between 2000 and 2005
Just installed 2005 Enterprise Edition on an XP Media computer... I am blown away because nothing looks familiar to me. Anyone else feel lost?
Where is the best site for specific changes from 1 version to another... it appears that Enterprise Manager is gone, Query Analyzer is gone, my brain is gone
thx
Kat
hi kat,
install the sql management express to make things easier
http://go.microsoft.com/fwlink/?LinkId=65110.
http://msdn.microsoft.com/vstudio/express/sql/download/
QA and enterprise manager is now integrated as one UI
which is called the management studio (SQL-MS). Since you are using express
you need the MS express.
regards,
joey
|||
Kat,
Just have a look into the following product info article which will help you in knowing What's New in SQL Server 2005.
http://www.microsoft.com/sql/prodinfo/overview/whats-new-in-sqlserver2005.mspx
HTH,
Rajesh
|||Hi Joey,
Do you mean that I shouldn't be using the Enterprise Edition? I need to learn the reporting services that aren't in the Express Edition. I'm not sure I understand your answer.
thx,
Kat
|||
Thx Much Rajesh!
Kat
|||sorry my fault. I've got a hell of a week. my pc bug-ged down so
is my brains. hahaha
i though you were using sql express. just a bit too busy these days
any way if your looking for QA and EM its no longer around.
They are now in the new UI the SQL management Studio.
and yes reporting service is only found in the enterprise version
|||
Thanks Joey,
I'm trying to find out if anyone is running 2005 on an xp media machine. I did get the enterprise edition installed (not the db's yet but someone gave me a link to that). I also installed IIS but know nothing about configuring it. I'm lost in space... interview in 2.5 hours. I bought this machine without knowing that the xp media operating system is an upgrade from xp professional. I'll lose all the programs if I downgrade to professional and since this was a floor model, there aren't any cd's to replace those programs. Microsoft will charge me a wonderful 285 for tech support but I want to find out first if it is even going to be possible. Can you recommend a site to ask, post, whatever?
thx much!
Kat
|||
hi kat,
Use the developer edition. enterprise edition works best on servers.
developer edition works better in Xp. developer edition
have the same functionallity as the enterprise except that the
are used in development environment.
good luck with your interview
regards,
joey
|||
SQL Server Enterprise Edition is supposed to only be installable on server operating systems. XP Media Center is a workstation operating system, so I'm surprised you could install Enterprise on it at all.
SQL Server Developer Edition is functionally equivalent to Enterprise Edition, except it can be installed on Windows XP or Windows Vista. Note that the Developer Edition license doesn't let you use the Developer Edition server for production use.
Hope this helps,
Steve
I spoke with Microsoft and they said I couldn't install 2005 on a XP media machine. I'm not sure now about the other versions. All versions of 2005 require 2000, xp, etc. Nothing is listed as working with the Media version operating system. I was told I had to upgrade to the full version of XP professional. Nice huh? Or I could get rid of all of the programs installed and bring it to another operating system. Oh well, once my XP Pro laptop is fixed, I'll probably try the Express version. I just wanted to work on the reporting services which is available only in the Enterprise Edition as far as I can tell.
Kat
|||try the 2005 developer edition
i'm prettry sure express will install