| Author |
Topic |
|
juliano.net
Starting Member
10 Posts |
 Posted - 2006-10-20 : 07:50:32
|
| Hi,Today one of my company's client reported that his server is having a problem with data that misteriously disappear. What can be this?Is a good practice to split a 2GB data file into two or more data files? And a log file with the same size?Sometime we need to get the database from our client and restore into our company database server to analyze it locally. But when restoring it, it creates datafiles with the same size as it was on the other server. How can I restore using just the necessary space?Thanks.[]'sJuliano.Net Developer |
|
|
Luis Martin
Yak Posting Veteran
54 Posts |
Posted - 2006-10-20 : 18:01:38
|
| "Today one of my company's client reported that his server is having a problem with data that misteriously disappear. What can be this?"No way. Except because user action."Sometime we need to get the database from our client and restore into our company database server to analyze it locally. But when restoring it, it creates datafiles with the same size as it was on the other server. How can I restore using just the necessary space?"No way also. After restore (I did it a lot of times because I'm free lance) you can shrink or alter database.All in Love is Fair Stevie Wonder |
 |
|
|
juliano.net
Starting Member
10 Posts |
Posted - 2006-10-20 : 18:32:03
|
| I've had an idea.I can Attach the database using its media (DVD or another kind), so after this I use DTS or other import type. Of course this would be extremely slow, but its a way to solve this problem of large database files.[]'sJuliano.Net Developer |
|
|
|
juliano.net
Starting Member
10 Posts |
Posted - 2006-10-21 : 17:22:09
|
| My client told me that the registries aren't being accidentally or on purpose deleted. They are being automatically deleted by the SQL Server, so I supposed that this would be because of DataFiles without blank space.Do all you suggest spliting these data and log files into new files?[]'sJuliano.Net Developer |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-10-21 : 17:57:40
|
quote:
Originally posted by juliano.net
My client told me that the registries aren't being accidentally or on purpose deleted. They are being automatically deleted by the SQL Server, so I supposed that this would be because of DataFiles without blank space.Do all you suggest spliting these data and log files into new files?[]'sJuliano.Net Developer
SQL Server does not automatically delete data.If the data is not there, it is because it never was there, or because some application process removed it.CODO ERGO SUM |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-10-21 : 18:03:19
|
quote:
Originally posted by juliano.net
I've had an idea.I can Attach the database using its media (DVD or another kind), so after this I use DTS or other import type. Of course this would be extremely slow, but its a way to solve this problem of large database files.[]'sJuliano.Net Developer
You cannot process a database backup file with DTS. Just restore the database and then shrink it.If disk space is such an issue that you cannot do this, than you aren't really in the position to provide this support. If so you need to get more disk.CODO ERGO SUM |
|
|
|
juliano.net
Starting Member
10 Posts |
Posted - 2006-10-24 : 07:05:25
|
I won't import data from a backup file, but from a data and log file in a DVD (for example) that will be attached on SQL Server, maintaining it's storage. Of course this DVD or other media must be configured to be writable as any disc. But this were just an idea.Let's get back to the main problem. I don't know if the issue with the data is accidental or a data corruption problem. I've just downloaded SQLIO Performance Test tool and SQLIOStress utility, so I'll test the database IO.Do you have a whitepaper or an article or something like that, about SQL Server 2000 performance increasing?What do you recomend? The server I'm talking about should be an Intel Pentium 4 2.8Ghz and 2GB DDR RAM. It's not a dual core or multiple-processor server and it's disk, isn't a SCSI disk.  What do you recomend on this simple scenario? (PS: my client is not planning to spend money with hardware upgrades at this time).[]'sJuliano.Net Developer |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-10-24 : 07:36:52
|
first of all add auditing for all tables.that way you'll be able to see who, when and what gets deleted/inserted/updated.Run DBCC checkdb to see if there is any corruption in the db.You might have torn pages of data ot something like that.> Do you have a whitepaper or an article or something like that, about SQL Server 2000 performance increasing?What exactly do you mean with this statement?Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
|
juliano.net
Starting Member
10 Posts |
Posted - 2006-10-24 : 08:36:35
|
quote:
Originally posted by spirit1
first of all add auditing for all tables.that way you'll be able to see who, when and what gets deleted/inserted/updated.Run DBCC checkdb to see if there is any corruption in the db.You might have torn pages of data ot something like that.> Do you have a whitepaper or an article or something like that, about SQL Server 2000 performance increasing?What exactly do you mean with this statement?Go with the flow & have fun! Else fight the flow blog thingie: http://weblogs.sqlteam.com/mladenp
I mean, any tutorial about SQL Server performance improvement.[]'sJuliano.Net Developer |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-10-24 : 08:48:19
|
| there is no such thing.Performance improvment is a problem specific thing.Adding proper indexes usually helps and rewriting queries to set based instead of cursor based also helps.Go with the flow & have fun! Else fight the flow blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
|
propanecan
Yak Posting Veteran
60 Posts |
Posted - 2006-10-24 : 09:38:57
|
| Not sure what type of applicatio you are running, but many times when I've had client concerns about 'disappearing' data it was from users/developers working in the wrong environment, Test instead of Production for example. I once had a developer screaming at me that SQL Server kept deleting her data...eventually she was found to be the root cause. Just a thought. |
|
|
|
|
MSSQL 2000-data disappearing and performance tips