I'm thinking of storing a lot of images, Word documetns, PDF, and emails as media in SQL Server 2005. Is it equiped to handle a lot of media? Or is it still preferred to store media separately on a file server?
View 6 RepliesDear All,
I know the basic defiinition of these two options, but i am not very clear why would someone choose one over another,
currently I am using Append to Media option, and every day backup, I see my backup files growing in size.
can someone give me nice example about these two options,
Thanks,
We have a software assurance contract, and we getour media from a Microsoft Certified Partner.Our MCP hasn't been able to provide us with media forSQL Server 2005.It's been 7 weeks since the launch; I expected the product tobe in the channel by now.Anybody else (especially software assurance customers) havingtrouble getting the goods from MCPs and/or resellers?
View 1 Replies View RelatedI am new to the forums, so hopefully this is the correct place for this question.
Is there somewhere to download the media for SQL Server 2005 Standard? I already have my licensing, and am wondering if you can avoid purchasing the media discs. I have done this with Windows Vista and Office 2007 in the past.
I'm not finding a definitive answer to my question as to whether or not I can run the development edition of SQL Server 2005 on my brand new pc with this operating system. No one seems to know for sure and I can't afford to pay for tech. support. It should be supported but I don't know where to get a 'real' answer.
thx,
Kat
Hiya,
We were recently let down by our software supplier who have happily provided us with a single processor license for SQL Server 2005 before the weekend.. but haven't been able to provide any installation media.
I notice on the website that there is a trial edition of the Enterprise edition for download, that can be converted into a full installation by using a valid license key.
My question is.. would I be able to use that trial edition with my license key? Or are they fundamentally different?
If that isn't an option.. is there anywhere where I can obtain installation files for standard edition?
Thanks in advance,
--
Tim
I am trying to restore a 2005 backup to a 2005 database on another server. This has worked for me before. I have tried to take the backup 5 times now and each time I get the error media family incorrectly formed. Since I have successfully backed up and restored before between these same two databases I do not understand what is wrong now.
I found other questions with this error; however, they were taking a 2000 backup to a 2005 database. I am using a backup of a 2005 database to a 2005 restore.
How should I begin to debug this problem?
Thanks
We are getting error and we are aware that there should be 2 files but we are able to find the second file,how to search all files(2) so that we may restore DB.
View 4 Replies View RelatedHi, I'm from Argentina. I made a backup of my database from ServerA (SQL 2000) and trying to restore it to ServerB (SQL 2005) I'm getting the following error: "The media set has 2 media families but only 1 are provided".
Any ideas? Thanks.
My company is planning to purchase a SQL2005 standard Processor license (unlimited users - about $5000)
Does anyone know if we can obtain SQL2000 media along with the purchase. Because of the app we are running and its stage of development, we have to install and run SQL2000 for about 6 months before we can run Sql2005. We dont want to purchase SQL2000 for such a short term use.
I asked a DELL rep to help me with this over a month ago and he still has no answers for me.
Any help with this would be greatly appreciated.
We have several jobs that if any step fails, we need to continue with the next step. Due to this we have the both 'On Success Action' and 'On Failure Action' set to 'Go to the next step'. Our only issue is that when all the steps are done we still require the job itself to fail.
So my question is this, is there anyway the status of a job can be queried to determine if any of it's steps failed?
Hi, hope someone can help...
I'm trying to install SQL Server 2000 on my XP Media Center laptop and keep getting the "this operting system is not supported message"
Any ideas?
Many thanks....
Greetings
I have a scenario where a table's after insert & after update triggers write to a history table. On this particular table, the history rows are quite small, so the occassional deadlock condition is inevitable.
In SQL Server 2000, I taught the application guys to handle these kinds of exceptions themselves, sleep a second, and retry. In 2005 (and I assume 2008) we now have TRY CATCH in T/SQL.
What are the pro's and con's of catching deadlocks in your T/SQL code (triggers or sprocs) .vs. the "old way" of catching it at the application level? I'm sure this has been discussed before, but search returns a lot of unrelated postings...
I'm thinking it's better to catch this at the application level, under the assumption that it's better to make the client(s) do the work than the database, but I'm sure there are considerations I'm not taking into account here. What experiences do you folks have to share on this?
Thanks!!
I want to refer in a table quotes to customers and itemes from another table.
here is my table list in database:
"Customers"
"PriceList"
I want to create another table which through it I can create qoutes for customers suing a collection of items in PriceList table.
for example I want to be able to create something like this:
Title:
my quote example
QuoteID:
46543
Items (retrieved from PriceList table):
370
474
456
belongsTo (a relation to CustomerID in Cstomers table):
6234876
Discount, Date, WrittenBy, etc.
how many tables do I have to use for it, and what queries I have to write, and do I have to create any special relationships?
regards
currently if I want to restore 1 db to another i do
RESTORE DATABASE userr
FROM DISK = 'd:sqlbackupsuser.bak'
WITH MOVE 'user' TO 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAuserr.mdf',
MOVE 'user_log' TO 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAuserr_log.ldf',
REPLACE
now I am backing up my db to a media - How can I do the same restore above but from that media (I don't remember what I made the media point to -- how can I find this out)
Hi Folks..I have a question i want's to make a website where people can upload mediafiles like movies short movies of a minut or 3 max. Can i store those mediafiles like mp3, mpg etc.. for instance in a sql-server database, or is thisnot wise to do?Thanx in advance..
View 1 Replies View RelatedHelp, I'm trying to burn a CD using Windows Media Player 10. I keep getting the message-interface not registered. I tried to download WMP, and it says it cannot because there is already a more recent version already installed. Should I uninstall WMP, and then reinstall it. If so, how do i do that, I cannot find it on the control panel!
Thank You for your help
Hi i have a video file path stored in my sql database and i have an embedded media player in my web page, how can i load up a different video file into the embedded media player based on movie id or movie name, this is the code i have written so far but im unsure if im in the right direction, thanks
View 2 Replies View RelatedDoes anyone out there work with databases created using sp_create_removable?
I am encountering a situation that is a difference between 6.5 and 7.0 handling of these types of databases. In 6.5, our product creates a removable database on a fixed hard drive. When the user is ready to move the database to a jazz or zip drive, we set the database readonly and remove the log file. No problems. We can use sp_dbinstall witout a log file and everything works just fine.
In 7.0 we do the same thing, however, when we attach the database via sp_attach_db (which replaced sp_dbinstall), SQL Server 7 creates a new log file.
Is there any way to make SQL Server NOT re-create this log file?
We are doing a full backup at night. During the day we are doing a backup of the log every hour. How do I delete the log backups from the media without deleting the device itself. I would like to do this once we have a full backup for the day. The media we are backing up the logs to is disk.
View 3 Replies View RelatedHey All,
I am currently backing up a SQL 2000 Database by doing full backups everynight. I would like to cut this back to once a week and do differential backups during the week. BUT... How can I do differential backups without appending or overwriting the night befores backup? I'm sure this can be done through command line but im not exactly sure of the process. If anyone can help please post...
Thanks,
Jared
Hi all , hope my post finds u all well.
Currently I was reading about how to create a backup and i have some questions and i hope to find helpful answers..
what is back up media ,device and tape ?
how to initialize the media and what is the need for something like that ?
what about media headers that must be written ?
thanks in advance
Davids Maguire
We have jumped straight to 64 bit SQL 2005 with no 32 bit 2005 inbetween.
However this means the tools we have cannot be installed on windows XP/2000 32 bit.
Is there some way to get the 32 bit tools as it appears strange that 32 bit tools were not provided for remote access.
Cheers
Julian
can you help me ? i want watch television on internet , good quality screen , no tracking , good audio , fast stream , can you show me ? or fix or update ,, thank you very much ,,,, have a nice day ,,,,,
View 1 Replies View RelatedIt was difficult to enter a subject that coveres what I want to ask and also the explanation isn't trivial.
The question is for SQL server 2000 (I can't upgrade so solutions should be feasable on 2000). If patch level is an issue it chouldn't be a problem to patch to the level needed if it isn't there already.
The database has in full logged recovery mode and its .mdf filel and .ldf files are on 2 seperate disk locations (lets name these M: for the .mdf files and L: for the .ldf files).
Now whenever I read something about media failure it's allways about a failure of M: and how you then can backup you latest log file and have an 'up to the time of distaster' recovery. And that works fine. I played around a bit by putting M: and L: on a test machine on USB sticks, so that I could simulate media failures.
When I yank L: and simulate a media failure of the .ldf files the problem starts. You can't handle that database anymore since it becomes suspect and making a backup is not possible anymore (neither dbf nor ldf backup)
What I was able to do to get as close as possible to the time of failure was this:
1. Detach the database
2. Move the current .mdf file to a different location
(3. here I do whatever is needed to get the physical system working again)
4. Restore the database from the last full backup
5. Change the database to simple recovery model (needed to perform step 8)
6. Detach the database
7. change the restored .mdf file with the one set asside in step 2
8. attach the database
9. return to full logged
I then have a (and thats the main question actually) seemingly working database again with more data in it then I would have when doing the recovery by restoring the last full backup and all transaction log backups. To emphasis this: if I would have a weekly full and daily transaction log backups, if could lose up to a day of data, with the outlined method I would have much more data.
Now I know that the data are firstly written to the .ldf files and then to the .mdf files whenever the server has time for it (at least that is how I understand it) and so I should get more data then doing it the 'traditional' way.
How correct is that assumption and if so: how consistent are the data in that 'recovered' .mdf file?
My company is planning to purchase a SQL2005 standard Processor license (unlimited users - about $5000)
Does anyone know if we can obtain SQL2000 media along with the purchase. Because of the app we are running and its stage of development, we have to install and run SQL2000 for about 6 months before we can run Sql2005. We dont want to purchase SQL2000 for such a short term use.
I asked a DELL rep to help me with this over a month ago and he still has no answers for me.
Any help with this would be greatly appreciated.
I'm having no success install SSMS on a 32 bit workstation from 64 bit media.
I'm aware from researching that the SSMS is 32 bit, in fact I see it run as a 32 bit app on the server.
However, when i try and install from the 64 bit CD or DVD I get errors such as not a valid Win32 application, or when i tre random msi's guessing as to which is ssms I get "This installation package is not supported by this processor type. Contact yoru product vendor."
I run a Pent D 2.8 on 32 bit XP
Any assisstance on how to install SSMS on a 32 bit workstation from the 64 bit media would be greatly appreciated.
Hi,
This is my first post. I am trying to install SQL express on my PC but it keeps on having this error:
"encountered an unexpected error in datastore. The action is setdialogs..."
I have searched far and wide for a solution to this problem. Some solutions worked for others, but none worked for me so far.
I don't have a previously installed sql version on my laptop. But just to check, I followed the steps in using msiinv.exe to detect any previously installed software. I am pretty sure that there was no sql server entry in the output file.
I have all the requirements, installed (.net framework 2.0,etc). I have all the latest Windows updates (except XP SP3).
My laptop is well above the minimum requirements for sql express ( Core 2 processor, 2 gigs ram, 7Gigs free space).
I have the Protected Storage service running (which I found out was required to install sql server).
I even followed the directions to fix Cryptograhical services.
I am runninng out of options here.
Thank you for your replies.
Here's my log:
[code]
Microsoft SQL Server 2005 Setup beginning at Fri May 30 11:20:48 2008
Process ID : 564
c:487084033731d74b14setup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2008/4/30 11:20:48
Complete: LoadResourcesAction at: 2008/4/30 11:20:48, returned true
Running: ParseBootstrapOptionsAction at: 2008/4/30 11:20:48
Loaded DLL:c:487084033731d74b14xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2008/4/30 11:20:48, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 124
----------------------------------------------------------
writeEncryptedString() failed
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 123
----------------------------------------------------------
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: cryptohelpercryptsameusersamemachine.cpp
Compiler Timestamp: Wed Jun 14 16:28:04 2006
Function Name: sqls::CryptSameUserSameMachine:rotectData
Source Line Number: 50
2
Could not skip Component update due to datastore exception.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "564"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2008/4/30 11:20:48
Complete: ValidateWinNTAction at: 2008/4/30 11:20:48, returned true
Running: ValidateMinOSAction at: 2008/4/30 11:20:48
Complete: ValidateMinOSAction at: 2008/4/30 11:20:48, returned true
Running: PerformSCCAction at: 2008/4/30 11:20:48
Complete: PerformSCCAction at: 2008/4/30 11:20:48, returned true
Running: ActivateLoggingAction at: 2008/4/30 11:20:48
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupStateScope"
00E4CFC0Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
Class not registered.
Failed to create CAB file due to datastore exception
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "564"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2
[/code]
Hello,
I want the server to check validation rules and not the user application
is this possible???
I want to send my own messages to the user and dont want the user to see the
servers messages.
Thank you in advance
Eran
How to capture errors occured in stored procedures in case SQL SERVER7?
View 1 Replies View RelatedHi I think by virtue of not being able to find reference to this I have my answer however.... You trap an error, check it and know that you are happy with it - it isn't an issue. Is it possible to prevent that specific error (number, message - the lot) being passed to the client so developers don't need to handle the error a second time? Ta db chucks :D
View 9 Replies View RelatedI have a field in one of my tables called renew_date. The renew_date is always the first of every month. My requirement is to have a query that's run on the first of every month to select records that have renew_date coming up in the next 150 days.(5 months from today).
ANY help is really appreciated.
I am new to SQL 2005. I have setup and new maintanaince plan of making backup on to different paths but i encountered an error saying
Executing the query "BACKUP DATABASE [promis_05] TO DISK = N'E:\ERP Database\ERP Backup\Promis_05', DISK = N'\\backupsrv\ERP Backup\Promis_05' WITH NOFORMAT, INIT, NAME = N'promis_05_backup_20061111181236', SKIP, REWIND, NOUNLOAD, STATS = 10
" failed with the following error: "The volume on device 'E:\ERP Database\ERP Backup\Promis_05' is not part of a multiple family media set. BACKUP WITH FORMAT can be used to form a new media set.
BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
We did not know what to make of this.
1) Is it bcoz i am backing up the database on 2 locations same time.
2) What is BACKUP WITH FORMAT?
3) Why won't it let me add a new file that is not part of the 'family' ?
4) How does it get to be part of the family?
Thought and ideas are highly appreciated!