Re: Missing data recovery - Database Discussion Boards

Re: Save ROWCOUNT value in a variable

Eddy Vluggen21-Apr-09 6:39

Eddy Vluggen

21-Apr-09 6:39

Try this one;

DECLARE @TotalIntRow AS INT
    SET @TotalIntRow = (SELECT COUNT(*) 
                          FROM Rcount)
PRINT @TotalIntRow

Don't forget that the DECLARE statement should be used to declare the variable, before using it.

Hope this helps Smile | :)

I are troll Smile | :)

Re: Save ROWCOUNT value in a variable

nt_virus21-Apr-09 7:43

nt_virus

21-Apr-09 7:43

Awesome mate.

But I cant understand one thing, if I do these steps individually I got scalar error something. why so ? just curious about it. Ain't the values are stored permanently in it?

BTW.. If even I run the above scripts do the variable takes additional space or they get removed after application shutdown?

Begin
DECLARE @TotalIntRow AS INT
    SET @TotalIntRow = (SELECT COUNT(*) 
                          FROM Rcount)
print @TotalIntRow + 1
Insert into Rcount Values(@TotalIntRow)
End

I m getting my partial desired result. I want to add prefix 'A' with the result set .. When I did .. I got , can't convert (variable declared for storing A) to int data type..

Re: Save ROWCOUNT value in a variable

nt_virus21-Apr-09 7:56

nt_virus

21-Apr-09 7:56

Oh my god, I can't believe I did it..

Begin
DECLARE @TotalIntRow AS INT
    SET @TotalIntRow = (SELECT COUNT(*) 
                          FROM Rcount)
print @TotalIntRow + 1
Insert into Rcount Values('A'+ Convert(varchar, @TotalIntRow))
End

Re: Save ROWCOUNT value in a variable

Eddy Vluggen21-Apr-09 8:33

Eddy Vluggen

21-Apr-09 8:33

Well done dude Cool | :cool:

nt_virus wrote:
But I cant understand one thing, if I do these steps individually I got scalar error something. why so ? just curious about it. Ain't the values are stored permanently in it?

Not permanent, they are 'lost' once the command is finished executing. (In this case, once it passes the END statement) That's also the reason why they can't be executed separate, they are interpreted as separate commands if you execute them line by line separately.

nt_virus wrote:
BTW.. If even I run the above scripts do the variable takes additional space or they get removed after application shutdown?

They are gone as soon as the script (the complete collection of lines) are finished, unless you store them in a table somewhere. Most applications execute their script and close the connection to the database when done.

Good work Smile | :)

I are troll Smile | :)

Missing data recovery

Shrimpersfan21-Apr-09 1:15

Shrimpersfan

21-Apr-09 1:15

I am using a piece of automation software called Taskcentre, this has it's own database. This morning we were having issues with the software and it turns out that an essntial table has been cleared of all data.

There are currently no backups for the database and all tasks that have been created over the past year are now gone unless i can find a way of restoring the database to 2 - 7 days ago.

I was wondering if anyone had any ideas.

David

Re: Missing data recovery

Ashfield21-Apr-09 1:33

Ashfield

21-Apr-09 1:33

Any audit tables you could use?

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Re: Missing data recovery

Shrimpersfan21-Apr-09 1:38

Shrimpersfan

21-Apr-09 1:38

Hi Bob

How do you mean Audit table?

Re: Missing data recovery

Ashfield21-Apr-09 8:31

Ashfield

21-Apr-09 8:31

Is there any automatic auditing going on to record actions on the table - you know, who added/changed/deleted a record. If so, you may be able to recover your data that way. If there is nothing obvious you could contact the vendor and ask them if they have any suggestions. Otherwise, I'm afraid you have learnt the hard way that you should always do backups.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Re: Missing data recovery

riced21-Apr-09 23:50

riced

21-Apr-09 23:50

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. Smile | :)

Regards
David R

Re: Missing data recovery

Shrimpersfan21-Apr-09 23:54

Shrimpersfan

21-Apr-09 23:54

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

Running the upgrade step from version 539 to version 551

Vimalsoft(Pty) Ltd21-Apr-09 1:03

Vimalsoft(Pty) Ltd

21-Apr-09 1:03

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/

Table insertion?

Karthick_gc20-Apr-09 23:09

Karthick_gc

20-Apr-09 23:09

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?

Re: Table insertion?

Mycroft Holmes20-Apr-09 23:14

Mycroft Holmes

20-Apr-09 23:14

So split the recipeints by comma and repeat the insert for each one.

Never underestimate the power of human stupidity
RAH

Re: Table insertion?

Karthick_gc20-Apr-09 23:17

Karthick_gc

20-Apr-09 23:17

Yes. Can u tell how to split and insert for each receipient?

Re: Table insertion?

Mycroft Holmes20-Apr-09 23:27

Mycroft Holmes

20-Apr-09 23:27

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

Re: Table insertion?

Karthick_gc20-Apr-09 23:44

Karthick_gc

20-Apr-09 23:44

I cant get.Can u describe briefly?

Re: Table insertion?

Mycroft Holmes21-Apr-09 0:34

Mycroft Holmes

21-Apr-09 0:34

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

Data Modeling

Muhammad Nauman Yousuf20-Apr-09 19:37

Muhammad Nauman Yousuf

20-Apr-09 19:37

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"

Re: Data Modeling

riced20-Apr-09 22:14

riced

20-Apr-09 22:14

Try googling for "database reverse engineering" - 400K+ hits. Smile | :)

Regards
David R

Re: Data Modeling

dingoishere23-Feb-11 22:36

dingoishere

23-Feb-11 22:36

Try D-Softs database compare tool

How to read values from excel formula fields?

Nagaraj Muthuchamy20-Apr-09 7:53

Nagaraj Muthuchamy

20-Apr-09 7:53

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

Umbraco Developer

Re: How to read values from excel formula fields?

N a v a n e e t h20-Apr-09 17:06

N a v a n e e t h

20-Apr-09 17:06

What is calculated excel fields?

Navaneeth

How to use google | Ask smart questions

Re: How to read values from excel formula fields?

Nagaraj Muthuchamy20-Apr-09 21:49

Nagaraj Muthuchamy

20-Apr-09 21:49

Excel cell which is having Excel Formula instead of value.

Thanks,
Nagaraj

Umbraco Developer

MS Sql Database synchronization

Paul Brower20-Apr-09 5:55

Paul Brower

20-Apr-09 5:55

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

Re: MS Sql Database synchronization

Giorgi Dalakishvili20-Apr-09 6:10

Giorgi Dalakishvili

20-Apr-09 6:10

What about writing your own using Sync Framework?

Giorgi Dalakishvili

#region signature
My Articles

Asynchronous Registry Notification Using Strongly-typed WMI Classes in .NET [^]

My blog
#endregion

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.