Data Lost Automatically?

Apr 17, 2008

hi,
i want to lost data automatically after 3days.
but i don't know how to use job scheduling in sql2000 and how to query to add date to datatime column automatically when the data is inserted.
Plz help me!

View 13 Replies


ADVERTISEMENT

Lost All SQL Data, Help !!

Aug 18, 2004

I used sql 2000 create a data base at home call 'Mysite' several months ago, there are about eight tables and 30 stored procedures. When I run my asp.net program at home yesterday, and found can't connect to database. The error as follow: "Cannot open database requested in login 'Mysite'. Login fails. Login failed for user 'MINGYANG-MSONXHASPNET'. "

When I open the database, very surpriced to found that my database was suspect and not any item inside it. The suspect database include CommunityStarterKit. But Northwind and pubs database still there?

What happen? Last week I just download new Norton antivirus software, does have any relationship with it? Does data really gone? How to solve this problem?

Please help me if you have these experience.

View 2 Replies View Related

Data Lost

Oct 22, 2000

We lost all the data we had in a table. We restored the db and the transaction log up to a point in time, but could still not recover the table. We eventually only do db restore without the transaction log. We recovered the data in the table in question, but lost all the data entered that particular day. Does any body have a solution or suggestion that can help? I will be greatly appreciated.

View 2 Replies View Related

Lost Data

Aug 18, 2004

this morning, one user asked me that she entered a data (only one record,)on the database yesterday, but later she checked that is gone, I check the database, i am sure the data is now there. how do i retrieve the data back, or how do i know whehter this is user problem? Thanks in advance

View 2 Replies View Related

Lost Data

Dec 20, 2005

Hi Guru,This weekend, I migrated SQL Server7.0 to 2000 and below is thescenarios:1.) At exactly 4:00PM on Sturday 17th, do full backup(T-SQL) and put adatabase into single user mode.2.) Copy both Saturday 4PM and Friday night full dump to the SAN.3.) Delete WinNT4.0.4.) Reinstall Win2003 and service pack3a.5.) Copy Saturday 4PM backup file to the server and do restore and douser ID mapping.This database is in full mode and I do log backup every hour. However,after restoring the database, any changes after the 14th were missing.Now, When I restored Friday night backup, we still recovered data tothe 16th. My question is, why the 17th 4PM backup did not copy anychange from 15th to the 17th Saturday?I still had Sturday backup file, howe can I recover the 17th data? Logexplorer or ApexSQLLog?Is this Disk issue?Thanks very much,Silaphet,

View 1 Replies View Related

Data Lost

May 24, 2006

Hi,

I have encountered problem in the merge replication with conflict caused by foreign key constraint. As I did some reseach that it can be avoided by increase the upload and download batch generations.

My question is how can I recover the data which has been lost?



Thanks

View 6 Replies View Related

Data Lost , Help !!!

Dec 6, 2006

i make an application to insert data to sdf file and save it

when i colse the application and open it again i find my stored data on the sdf file well

and if i closed the application 1000 times i'll find my data ok

that's ok and that's not the problem

the problem that when i open this sdf file from sql server management studio and make a select on it i don't find any result and when i try to open the db from my application again i found it empty with no data

i realized that management studio delete's the data from my db

Any Ideas Here ???

View 3 Replies View Related

Retreiving Lost Data

Jan 29, 2005

I Somehow restored the latest database onto the test database. Can I now retrieve the lost data. If Yes , How is it possible.

Akash

View 2 Replies View Related

Recovering Lost Data

Jul 9, 2007

Is there any way to get the deleted records from LDF or MDF file. Today by accidentally I executed one query and that dropped my table Inbox(table name only) from database. And in that table there was more 4,000 records, all these lost. So anybody can help me how to recover this table records?. Is there any way to get these?
I don't have any backup for this table.

shaji

View 3 Replies View Related

Recover Lost Data

Aug 9, 2007



Hello!

Hopefully someone can help me that i have lost my data on my D: drive.

driven shown all folder but in side of the folder there is nothing.

i have lost my Doc, xls, Jpeg etc. all files.

please help me what sould i have to do.

thanks

View 1 Replies View Related

Urgesnt..data Lost When Run The Script

Aug 9, 2005

Urgesnt..data lost when run the script.i generate a script a data base then i run it on query analizer in same data base .But problem is data base and all design view is safe but all data is lose.how can recover it.thanks.

View 2 Replies View Related

Lost Delayed - Write Data

Dec 4, 2001

Hello All,

Thanks in advance for your help.

I am wondering if there is a correlation between the size of a database and the amount of RAM required in the server. Here's what's going on:

NT4.0 SP 6a, SQL 7.0
2-800 MHz Pentium III Processors
512 MB RAM
Swap Files: two, divided evenly between two partitions, min 512 per partition (dynamic)
3- 9.2 GB Drives, RAID 5

SQL Database size: 2.5 GB

The SQL administrators have a scheduled job set to dump the database every four hours, so they have 6 of these dump files per day. Seagate Backup Exec v 6.? backs up those files every evening. Of course, this is a mission-critical application.

As the NT/Hardware administrator, I was tasked to flash upgrade all the hardware that could be flashed. That happened about three weeks ago. Ever since I flashed it, getting the data dumps has been an inconsistent process. Sometimes it works, sometimes it errors out. The error message is " Lost Delayed - Write Data: The system was attempting to transfer file data from buffers to (path). The write operation failed, and only some to the data may have been written to the file."

On and off during the day, you can't even copy a small file on the server without receiving the same message.

Before I flashed the server, it was blue-screening and needing to be rebooted about once every two weeks. Since I flashed it, the server hasn't been rebooted, because it hasn't blue-screened.

The database dumps are about 2 GB. We were thinking that the way the dump process worked was that a snapshot of the data was put into memory before it was written to disk. We thought since the dump size was larger than Physical Memory + Virtual Memory, that that could be causing the error.

What do you guys think?
1. Is dumping the database first the preferred way to get a backup, or should a backup directly to tape be scheduled instead?
2. Do we have enough RAM for the database?
3. Are there special settings we should set for the RAID controller card to maximize throughput for SQL?

Thanks again. I am definitely not a SQL DBA and any information you can provide would be really helpful.

View 2 Replies View Related

Suspend When *.ldf Was Lost ,I Can Repair This Data

Jan 6, 2004

a sql server database always contains two file.*.ldf *.mdf
When *.ldf was deleted the database may suspend.we can repair such database through about 20 steps.

if you want repair your database .please contact me with email:cn9526@163.net or msn/email :paulyang8848@hotmail.com

you can also see our homepage http://www.haou.net/sqlother/

the service price is begin at 200 US DOLLOR.

View 3 Replies View Related

Recover Lost Data Files?

Jul 20, 2005

HiWhen we issue a DBCC SHRINKFILE with empty option, the data fileis removed and the space is alloted back to the OS.Same way when we issue a an ALTER DATABASE to remove a database,all the data files and transaction log files are dropped.But can these files be recovered again by using any of the diskrecovery tools?Achilles

View 1 Replies View Related

Data Lost After INSERT Command

Dec 21, 2006

I have a website that is used to enter dates from a calendar. For example, user A might go to the website and select 20 different days in January. When user A clicks on the Save button the dates are written to the database with an INSERT command. This works fine. However, when user B then goes through the same procedure, say selecting 5 dates that are in the set selected by user A, those dates are properly saved in the database but the rows containing user A's same 5 dates disappear. I suspect this is something simple but I'm new and ignorant. Please help.

View 4 Replies View Related

Excel Source, Lost Some Data

Dec 20, 2007



I have Excel file with data and I need load these data to database. One of the colume consit following data:

1
2
3
4
test5
6
7
8
9


but when I created connection (Excel Source) and click Preview... in Excel Source Editor, I got following data:


1
2
3
4
NULL
6
7
8
9

Why? How can I get all data as string?

View 1 Replies View Related

Importing Carriage Returns - Now LOST DATA

Jun 6, 2007

I am migrating from 2000 to 2005 and in the process of rewriting DTS to SSIS. So far so good.

I have an import of a flat file that I need to reproduce that works fine in DTS but throws SSIS.

The file contains details of products, and has a Long Description field that may contain lots of different chars - CR & LF amongst them. It's source and destination columns are Text type.

The file is tab delimited, text delimited with double quotes, with row delimiters of CRLF and column names on row 1.

The error SSIS throws is "The column delimiter for column "LongDescription" was not found"

I imagine (perhaps wrongly) that this is because of the extra CRLFs but it worked fine in DTS. It also previews fine, and lets me define the column properties OK in SSIS package designer.

Any help greatly appreciated. I am trying to avoid the obvious thing of replacing those chars in that field at this point as currently the export is shared between a live production server, and my test 2005 rig.

Thanks v much.

Chris.

View 1 Replies View Related

Data Contained In A CDATA Section In XML Is Lost

Aug 1, 2006

I know that anything in a CDATA section will be ignored by an XML parser. Does that hold true for the SSIS XML Source?

I am trying to import a large quantity of movie information and all of the reviews, synopsis, etc are contained in CDATA. example:

<synopsis size="100"><![CDATA[Four vignettes feature thugs in a pool hall, a tormented ex-con, a cop and a gangster.]]></synopsis>

Sounds like a good one, no?

The record gets inserted into the database however it contains a NULL in the field for the synopsis text. I would imagine that the reason for this would fall at the feet of CDATA's nature and that SSIS is ignoring it.

Any thoughts would be appreciated. Thanks.

View 4 Replies View Related

Lost Connection To Remote Data On SBS SQL 2005

Aug 21, 2007

I need help!

I have Outlook 2007 w/BCM running on XP Pro workstation connecting to a SBS 2003 R2 hosting my SQL 2005 database. I have two problems: First I can get the BCM to connect to the remote data but periodically the connection is lost and many times it requires a reboot to reconnect. Secondly related to teh first, I can never get MS Accounting 2007 to connect to the same server and database from my client.

I have already set up the server to use port 5356 via TCP amd added a hole through my client windows firewall for the same port. Both client and server are set to share files and printers.

Any suggestions?

View 2 Replies View Related

Data Flow: Decimal Precision Is Lost

Apr 17, 2008

Hello,

Data is being trnasferred from an Oracle view to a SQL Server 2005 table.

Decimals can be previewed in the from the "SQL Command Text Window" but the columns in the target table which are defined as float shows the data being rounded to zero decimal places.

For the Data Source the always use default code page is selected.

Is there a way to retain the decimals?


Thank you,

Rod

View 3 Replies View Related

Each Time I Build Program, Data Is Lost

Sep 8, 2007



I am using visual basic 2008
I am making a program, I used sql server compact edition (sdf) (i think it is no more only for mobile device, I am working for desktop application)which i created with the same visual basic. i update data by using table adapters,

when I close the program and build again, the data previosly updated are deleted, and I get empty database?? why is that. do i need to set some copy to.........properties. i have used copy if new.

View 3 Replies View Related

Automatically Truncate Data To Fit

Jul 5, 2005

When writing an INSERT statement, what code do I pass to the SQL database to automatically truncate a value to fit in to the database if it contains more characters than the field the data is being entered into?

View 7 Replies View Related

SSIS - Data Source Password Lost When Imported Into Integration Services

Apr 17, 2007

After designing a SSIS package in Visual Studio 2005 that had two connection manager defined to keep the password. After I deployed the package to a file system. I then Imported the .dtsx file after making a Integration Services connection in Sql Server Management Studio. When I tried to run the package it failed when it tried to make the connection. When I edited the connection manager connection string and added the password and the package ran fine but it does not retain the password!. I need to have this package scheduled to run daily so I need to know how to have the package keep the password in the connection string. I have seen other posts on this issue but not seen a good solution. Could someone point me to the proper MSDN article that would explain how to implement this ? Is it a SQL Server configuration issue or a property in Visual Studio SSIS design time ?



thanks.

View 4 Replies View Related

Sql Server 2000 Problem - The Data From 17th March To 20th May Is Lost

May 21, 2008

Hi,

I am having following problem in our SQL Server 2000 database €“


Somehow/body accidentally backup (complete) our database back to an old back up from 17th March 2008. So the data from 17th March to 20th May is lost.


And that was the most recent backup that we had for the database because Maintenance Plan was not working from the last march due to some kind of failure and nobody knows about it. L


Using Redgate€™s Log Rescue and Apex Log Rescue tool but we could not find any entry from 17th March to 20th May. Most probably because of the complete back up.

Can any one help me out in this situation? Is there any way possible to retrieve the data? It€™s really important for me.

Thanks in advance. I will be looking forward to you guys reply.

/Adil

View 1 Replies View Related

How To Update(automatically) The Data B/w 2 Sql Severs

Oct 25, 2000

Hi
i have 2 sql servers ie solomon(acounting package) and production server.
so if i'll change the data ie customer info in solomon then it'll be update the data(related tables) in production server automatically.how it'll update the customer info from one server to another server automatically after making changes.
thanx in advance
reddy

View 3 Replies View Related

Regarding Back Up Of A Data Base Automatically

Mar 6, 2008

hi,
is it possible to get the back up of a particular database automatically at fixed interval of time i.e for every two days or two hours etc. i am sql server 2005 as back end of my project. please show me a way in sql express edition too along with sql sever edition.



One can never consent to creep,when one feels an impulse to soar
RAMMOHAN

View 2 Replies View Related

Automatically Duplicating Table Data In 2 Databases

Jun 3, 2015

I am very well versed on manipulating data using passthrough queries through access or the command object in ADO/VBA but this problem requires a sql server side solution and I have been assigned the task

Scenario

Access via an ODBC link cannot view Sql table data that uses a BigInt as a primary key. Access can update the data, insert data ands delete data to these tables - but viewing (by design) returns the actual count of the rows but each field is populated with #deleted.

I can view the table data if I use a passtyhrough query but performing row level and field level edits from there is impossible. Not all people have Studio manager so that is not an option.

We are moving away from our legacy application and the development company has already developed the schema using the BigInt so changing that to a numeric or integer is out of the question. My boss has determined that using a set of bridge tables with identical tables in a different database where we replace the bigint with int will work - we can view the data in the "bridged" database and even update it from select queries and simply by opening the table in view mode from Access.

Here is the hard part (for me) because I have never done this. I can write SQL and understand the security/roles etc, but I have never administered SQL server regarding server side triggers and stored procedures - I have always used the command object or passthrough queries to deal with sql stored procedures. I need to either

A)Create some trigger behind the tables in my bridge table that will fire a stored procedure to replicate the data to the bigint database. They are both on the same sever.

B)Somehow create a "mirror" that always replicates from my bridge database tables (5 of them) to the new database.

View 3 Replies View Related

Creating Tables And Automatically Inserting Data-HELP!!

Jul 20, 2005

I have created a table with the following columns...Date(datetime),Actual (Int),Planned (Int)I need to insert weekending dates starting from 23/04/04 loopingthru'for the next 52weeks automatically into the date column.Then in the actual and planned colums, I need to insert a count ofsome records in the table.I will appreciate help on a SQL query to achieve this!

View 5 Replies View Related

How Can I Automatically Edit A Reports Data Source?

Jan 5, 2008

Scenario:

I have 2 identical Analytics cubes, Cube 1 & 2, my reports point to Cube 1, when Cube 2 is refreshed the reports data source is manually repointed to the updated Cube 2. The following day the Cube 1 is refreshed and again the reports data source is edited and repointed back to Cube 1.

This ensures that if a cube build failes the reports aren't down.

To modify the data source I connect to Reporting Services using SSMS go to the Data source folder and manually edit the Data source.

I have looked through the Reporting database in SQL Server but didn't see anything that resembled the connection string for me to edit.

Are the connection strings for the Data sources stored in the Reporting Database ? Where can I find them?

Here is a Microsoft document that gave me the idea. http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/scoqryas.mspx

It talks about changing the connections strings in the Web UI? But doesn't tell you how or point to any docs that do.

Is there a way to automate this and is anyone else running a similar setup.


I appreciate you help

Thanks

Marcus

View 3 Replies View Related

Either SQL Or VB Is Automatically Applying Time Offsets On My Data

Sep 5, 2006

I have a windows app which is used in australia and uses web services to communicate with the database located in new zealand. I have a problem where dates that are returned from SQL are automatically modified to suit the timezone and i dont know how to turn it off.

For example, i insert the value '10/Jan/2006 20:00' into the database from a PC located in australia. When that data is selected back out, a 4 hour time offset is automatically applied to it and the time is returned as '10/Jan/2006 16:00'.

My current workaround is to modify my queries to say;

"Select convert(varchar, tb_date) tb_date from tablename"

Which returns the date as a string rather than a datetime which means the time offset is not applied.

This is a really poor solution and i'd be really keen to find out a better way...
Thanks

View 1 Replies View Related

Automatically Running Reports Once Data Has Loaded.

Jan 16, 2008



Good Morning,

I am trying to find a way of creating my Repoting Services reports of automatically refreshing once our ETL load has completd. I have created a process that creates a file is a particular directory once the data has completed loading however I am unsure how to make the report look for this file and then refresh the report.

Is this something that can be created?

Thanks in advance.

Steve (Novice!)

View 4 Replies View Related

Import Data From Multiple Excel Sheets Automatically

Apr 9, 2008

at first let me specify my requirement.
a) i have an excel file with more than one sheets
b) i want to import data from that excel file into sqlserver 2000 using asp.net & c#
NOW
 i need a program that automatically realize total sheets of excel file
AND
insert into seperate table
please help me 
 

View 2 Replies View Related

Can Sqldatasource Automatically Sort Retrieved Data From Stored Procedure ?

Jan 6, 2006

Hi,
This is my problem :
     I have  listBox1, listBox2 controls bound to sqldatasource1 and sqldatasource2.
I wrote one stored procedure to retrieve data from my sql database like :
    select Id, Name,Address,Amount from KalakaDB
 
Now I want my listBox1 to display Name By name and my listBox2 to display Amount by decrease order
how can i connect my sqldatacontrol to the stored procedure ?
 
Thanks

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved