|
To add to Bob's reply. Not only should you always do backups you should also make sure you can restore them.
Once worked in a place that did backups every day. When a hard disk crashed they discovered that the backups would not restore. Three months accounts data lost and had to be manually re-entered from documents.
Regards
David R
|
|
|
|
|
Thank you for all of your replies, it seems that I have lost all of the data and as you said I have learnt the hard way that we should keep on top of ALL our backups. Thankfully it shouldn't take too long to recreate the tasks, just means by busy couple of months just got a whole lot busier.
Thanks again
David
|
|
|
|
|
Good Day All
I have Used Red Gate to Synchronise the SQl Database in 200 and the other in 2005. and it went well, now i have a SP that is Running in my application that restores the Database like this
RESTORE DATABASE LOV FROM DISK = 'C:\DATABASES\MasterDatabase'
WITH MOVE 'oBooking_Data' TO 'C:\DATABASES\LOV.mdf',
MOVE 'oBooking_Log' TO 'C:\DATABASES\LOV_log.ldf',
REPLACE,RECOVERY;[/
Now My Application Halt and gives me the Following Error, i have tried to run it manually from the T-SQL and i got this
Processed 368 pages for database 'LOV', file 'oBooking_Data' on file 1.
Processed 1 pages for database 'LOV', file 'oBooking_Log' on file 1.
Converting database 'LOV' from version 539 to the current version 611.
Database 'LOV' running the upgrade step from version 539 to version 551.
Database 'LOV' running the upgrade step from version 551 to version 552.
Database 'LOV' running the upgrade step from version 552 to version 553.
Database 'LOV' running the upgrade step from version 553 to version 554.
Database 'LOV' running the upgrade step from version 554 to version 589.
Database 'LOV' running the upgrade step from version 589 to version 590.
Database 'LOV' running the upgrade step from version 590 to version 593.
Database 'LOV' running the upgrade step from version 593 to version 597.
Database 'LOV' running the upgrade step from version 597 to version 604.
Database 'LOV' running the upgrade step from version 604 to version 605.
Database 'LOV' running the upgrade step from version 605 to version 606.
Database 'LOV' running the upgrade step from version 606 to version 607.
Database 'LOV' running the upgrade step from version 607 to version 608.
Database 'LOV' running the upgrade step from version 608 to version 609.
Database 'LOV' running the upgrade step from version 609 to version 610.
Database 'LOV' running the upgrade step from version 610 to version 611.
RESTORE DATABASE successfully processed 369 pages in 0.204 seconds (14.782 MB/sec).
Thank you
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
Hi to all,
I have a mail table with the fields like id,to,receiver,subject,description,date etc..
when i fill the to field with multiple receipient seperated by comma, i want to store in the table for all members.
How it is possible?
|
|
|
|
|
So split the recipeints by comma and repeat the insert for each one.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Yes. Can u tell how to split and insert for each receipient?
|
|
|
|
|
I just did, split the recipients using text.split
Insert each record using your current insert method, changing the recipeint each time.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I cant get.Can u describe briefly?
|
|
|
|
|
What are you doing over here - go back to the ASP forum where they may have more patience with fools - you obviously have no idea what you are doing.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Dear All,
I am looking for the best data modeling tool,
Objective: I have an SQL database up and running, i want to have the best tool in order to architecture and document my DB.
Regards,
Muhammad Nauman
"Mess with the Best, Die like the rest"
|
|
|
|
|
Try googling for "database reverse engineering" - 400K+ hits.
Regards
David R
|
|
|
|
|
Try D-Softs database compare tool
|
|
|
|
|
Hi, I have been trying this for two days.
Is it possible to load the calculated Excel fields in to dataset.
I am using Ado.Net and Oledb to read excel.
Thanks,
Nagaraj
|
|
|
|
|
What is calculated excel fields?
|
|
|
|
|
Excel cell which is having Excel Formula instead of value.
Thanks,
Nagaraj
|
|
|
|
|
We've used Intellisync in the past for synchronizing databases ... they've basically gone out of busines, and I'm interested in knowing what software others use to synchronize ms sql databases.
The software has to be capable of implementing rules for synchronization, so I can sync select data / tables.
Thanks!
Paul Brower
|
|
|
|
|
What about writing your own using Sync Framework?
|
|
|
|
|
Hi i try to insert 195 countries at a time in sql. For that i have used BULK insert query. My Query is
BULK INSERT hrmsuser.country FROM 'C:\data.txt'WITH (
DATAFILETYPE = 'char', FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' )
MYPROBLEM:
Cannot bulk load. The file "C:\data.txt" does not exist.
Pls Anyone Help Me........
|
|
|
|
|
Hemalatha.A.M. wrote: The file "C:\data.txt" does not exist.
Those 195 countries are listed in a file? I'll bet that the file isn't called "C:\Data.txt"..
I are troll
|
|
|
|
|
what is it called then?
|
|
|
|
|
|
pagefile is locked
|
|
|
|
|
Luc Pattyn wrote: pagefile is locked
My bad, the file is indeed locked whilst Windows' runs. That's quite easy to patch though, may I kindly suggest these steps;
* Put your swapfile on an USB-stick
Right-click "My Computer", choose "Properties", Tabpage "Advanced", button "Settings" of the groupbox "Performance", Tabpage "Advanced", button "Change" of the groupbox "Virtual Memory".
* Load the textfile into your favorite webbrowser. You can either view it locally, or find a good host for this file, preferably with FTP-access and high uptime.
* Minimize the browser, and load a 4 Gb movie on Kiwi's (the bird, not the fruit) into MovieMaker. This might cause the contents of the browser to be swapped to virtual memory. I say might, as one never can be sure whether God is or isn't addicted to playing dice.
* Yank out the USB-stick as quickly as you can, so that only a minimum amount of bits will spill out of the USB-port. You now have a crashed Windows-system and a pagefile on USB-disk.
* Reinstall Windows, and when done, run chkdsk.exe on your USB-stick. Pray to Codd, while sacrificing a HP-calculator during the first Googledance.
There you have it; a "pagefile.sys", that may or may not contain a complete or partial list in a non-readable format, ready to be peek 'd, poke 'd and goes very well with mayonaise
I are troll
|
|
|
|
|
So now I have to order:
- a PC with USB (making sure I have a Win install disk)
- a USB stick (easily yankable)
- a Kiwi movie (any recommendation?)
- a set of napkins to clean up spilled bits
- an HP calculator
[ADDED] No mayonaise; still have some [/ADDED]
I think I'd rather spend half an hour looking up countries in Wikipedia and recreating the list myself. Actually I could write a program to do just that...
modified on Monday, April 20, 2009 5:38 PM
|
|
|
|
|
It does sound like a good idea to create an application to automate the task of reading the Wikipedia. I'm looking forward to your article
I are troll
|
|
|
|