I am slightly confused about the meaning of a 'device cal'
(specifically for sql server but I guess the same applies to other ms
licences)
In the examples about device cals, there is a picture of a number of
windows desktops connected to a database server. each desktop can
potentially be used by a number of users and requires one device cal.
All well and good.
Now, say I have a web application hosted hosted on a different machine
and connecting to SQL server. the SQL server licencing FAQ says
"A device CAL covers multiple users' access to server software from a
single, shared device."
is my web server a shared device? so does the web server require a
single device CAL no matter how many users use it?
This seems like a simple question but I still haven't been able to get an answer from Microsoft Canada. We're looking at buying 75 device cals to connect to a single instance of SQL Server Standard Edition. Our question is on how those licenses are assigned and/or activated.
Do we need to manually do something for each station or is it an automated process done the first time a station connects to the server? We also wat to understand what happens when a workstation dies and is replaced by another one. Do you have to do something on the server to transfer the license to the new station ?
In other words, when using device cals (and/or user cals), do you have to do any type of license management or is it all transparent ?
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?
I have live application in Greece with 300 users. VB5 with SQL Server 6.5 SP5a. The system is being totally upgrade to use SQL Server 7, the application has also been upgraded.
The client therefore has 300 CALs for SQL Server 6.5.
If SQL Server 7 is being installed, do the clients need to purchase another 300 CALs for SQL Server 7, or do the existing CALs allow for access to SQL Server 7. (i.e are they transferable). In what blocks can these be purchased in, can you provide a website URL for reference.
An urgent response to this would be appreciated as I have technical people (not DBAs, nor am I a DBA !) on site.
My company has Windows Small Business Server 2003 Premium Edition installed. I am wondering if we need additional SQL CALs (besides the SBS CALs) for the SQL 2000 that is installed with SBS 2003 Premium Edition.
Hallo are CALs bought for SQL2000 valid for SQL 2005? We're going to move the database servers from 2000 to 2005, and would like to know if we need to buy new CALs too. thanks
I didn't find any other forum to ask this and I didn't find any matching post for my question, so I post it here:
We have an application that is running on 2 web servers connected to a sql2000 server with a 2-processor license ... so I think there we have no problem no matter how many users are using our web application.
But the web application is producing a huge amount of logs that we want to analyze on a distinct multi-proc sql2000 server with a huge amount of harddisk space that's running with CAL licensing (not really sure how many we have for that server).
In a perfect solution we will provide access to the logs via our 2 web servers using the same application, but only for a given number of users (the number of users we hav CALs for). I think using that approach we get into licensing trouble.
Would it be ok to start a second web site on the same servers with an IP restriction allowing only "n" predefined IP endpoints so that only these machines can access the sql-Server that is running in CAL mode?
I'm not really sure what the CAL model really wants to allow - "n" physical users (persons), "n" end user computers, "n" database connections, max "n" of all together and is it concurrent, in a time of one day, the lifetime of the server? Maybe there's a document with some real world examples that I didn't find.
I have some problem locating the program to remove/add cals in SQL 2005 standard, previously for SQL 2000 there is a program in the controlpanel to do that. But for SQL 2005, I can't find any, can anyone advice?
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.
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 . !!
On my test database I have log device size grown to 4 GB from 2 GB. Is there anyway to reduce it? I have truncate log on checkpoint option on. I tried dbcc shrinkdatafile. Didn't help.. Any suggestions???
I have a Device of 6GB and a Transaction logof device of 1.5Gb , the database of the associated device had gone suspect.so i dropped the database , now i a m trying to delete the device it says cannot delete as its in use by some database , i have checked all the Dbs butits not associted with anything what shold i do????
Hi all, hope someone can give me some guidence on this.
We have a database on SQL 6.5 sp5a that is 25GB in size. The transaction log is 10GB in size. We do transaction log dumps every hour throughout the day. On a very heavy day the transaction log backup device will be just over 2GB in size. Around 8GB wasted because no-one knew how much space would be used.
Is there an easy way to resize the transaction log so we can reclaim some space. I was thinking of creating a new smaller database device, then using sp_logdevice to use the smaller device as the log and get rid of the 10GB device.
We have a 6.5 database that is comprised of 4 device files. As the database grows over time a new device is created for the space expansion. The last one was created on the wrong partition and the database was expanded onto it. I now need to move the device to the correct partition/directory. My question is; what is the easiest way to accomplish this move? Is it possible to move the device file and manually modify sysdevices? If so, what order of events should be followed?
I want to expand a log device and am having a problem. When in Edit Database Device, the `Change Now` button is disabled and the size of the device is shown as a negative number.
On occasion, I notice that some of my backup devices have become "offline" and the scheduled tasks associated with them will no longer run.
I get this error: Can`t open dump device `d:MSSQLBACKUPdvbk_AFISlog.DAT`, device error or device off line. Please consult the SQL Server error log for more details. (Message 3201)
Does anyone know how to get them back online without having to create a new device? Thanks in advance...
Hi, I am trying to take a dump on to a disk with one of device A..its a transaction log dump every 15 minuter with no init and from the same device which is connected to my standy server i am doing the load, the time diffrence is 15 minutes between standy and production in terms of dump and load i am getting this error very frequently the device is offline the message is "Can't open dump device 'j:ABC.DAT', device error or device off line. Please consult the SQL Server error log for more details. (Message 3201)"
Now can this error come when the dump and load is happing at the same time tru the same device...???????
I would like to free up some space on a SQL 6.5 server. My tempdb is on a second device (other than master) that is 500M. I don't need tempdb to be this large anymore. What would happen if I shut down SQL, renamed this device so that SQL Server wouldn't use it, and restarted SQL Server. Could I then create a new, much smaller device for tempdb? Would this work?
I want to store bakup file on the computer on netword, so make a backup device on the other computer, it ok. after that i make an full backup, there is an error : "Can not open the bakup device " . please show me, best regard.
I need your precious expertise in resolving one problem . I have transaction log file devices created on on two drives i.e c and d drives .
I want to move the the log device from d drive to c drive or vice versa . How can i do it . Can somebody help with detailed steps pl .
What are the things necessary to check after the device has been moved to either of the locations , to ensure that everythingh works well . I have SQL Server 7.0 with SP 3 .
Will the database be marked suspect ? I that case what should i do ?
Any kind of help on the issue will help me a lot .
I have taken ownership of a SQL 7 Server that has many DB's with each DB's devices spread all over the 6 disks that exists in the Server.
e.g.
DB - Reference has
Data devices on D (20mb), E(40mb) , F(60mb) drives
and Logs having a similar spread.
Now what I want to do is to restore a full backup of the database into a new db but with only one data device and one log. So that basically the server is tidied up. The reason the devices are spread is not due to performance reasons.
The QUESTION IS : How do I restore a full back up of a db with many devices in to a NEW db with only 1 data device and 1 log device.
I have a transaction log which is backed up 5 times a day to a device. The Transaction log is growing quite quickly in between each backup. The backup device is also growing at a much quicker rate. realistically i would like to only keep 2 weeks worth of transaction log backups in the device.
for the transaction log backup i have tried the following transact-Sql 'Backup Log [imsv23] to [imsv23_TL_2] with RetainDays = 7, Init, NoUnload, Name = N'imsv23 TL V2', NoSkip,Stats=10,Noformat'
but due to all of the contents in the backup set not having expired the backup fails.
i need to reduce the size of the backup device. all of the backup sets have expiry dates but none of them are being deleted from device.
so my problem is 1 i need to remove the excessive backups from the device 2 i need to set up the automatic backups so that these datasets are removed when the expiry date is reached.
