|
I'm looking for a solution to archive data that exists in my database. My database is SQL Server 2008 and have approximately 250 tables. I search web and find the below link : http://www.dbazine.com/sql/sql-articles/charran13/
but this solution is not...
Started by masoud ramezani on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Whether a full database backup could suffice or perhaps a purpose built archiving process using SQL Server Integration Services may be more security in place?
Perhaps if you....
For the most suitable archive techniques to be used, i.e.
|
|
Right now I am working on a solution to archive older data from a big working database to a separate archive database with the same schema. I move the data using SQL scripts and SQL Server Management Objects (SMO) from a .Net executable written in C#....
Started by Stefan Haubold on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
You don't even have to change the select statements, only ... .
Yep, use table and index partitioning with filegroups.
I think if you still want/need the data to be accessible, then partitioning some of your biggest or most-used tables could be an option .
|
|
There is a project in flight at my organization to move customer data and all the associated records (billing transactions, etc) from one database to another, if the customer has not had account activity within a certain timeframe.
The total number of...
Started by Chris McCall on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Performing fast SQL Server delete operations
UPDATE: as Remus correctly points out, SSIS can.
|
Ask your Facebook Friends
|
We've currently got four web servers in a farm generating IIS web logs about 100Mb per day. These can be compressed pretty effieciently down to somewhere around 5% of their size.
We are planning to use waRmZip to move them off the servers and onto a SAN...
Started by Dave Anderson on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
If you're only storing 5MB per day,....
Talk to your company's lawyers - legal advice on SO is likely to be worth what you pay for it .
Legal requirements will depend on your country, how much you're logging, and quite possibly the nature of your business .
|
|
Example There is an application that measures temperature in each town of the world. Each measurement is taken every 5 minutes and written in to the Measurement table.
CREATE TABLE [dbo].[Measurement]( [MeasurementID] [int] IDENTITY(1,1) NOT NULL, [Town...
Started by Andrew Rimmer on
, 6 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
On SQL Server - like most solutions, if you have an index on Town, Date, Temp this will be covering.
|
|
I need to allow users to upload a zip file via a web form. The server is running Linux with an Apache web server. Are there advantages to using a module like Archive::Zip to extract this archive or should I just execute a system call to unzip with backticks...
Started by cowgod on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
So while to the Archive::Zip documentation you'd be better off using Archive::Extract :
If you are just going to be extracting zips (and....
Found the hard way (production web server crashed) that Archive::Tar had a memory leak.
|
|
So I have a git repository on my local computer that I want to archive (zip is fine) and upload to my server. Once the file has been uploaded to the server, I will extract the archive. I don't need any of the git information, so I think I need to use ...
Answer Snippets (Read the full thread at superuser):
Any one of the following will work:
git archive --output=../_toDeploy/ArchiveName.zip master git archive -o ../_toDeploy/ArchiveName.zip master
To add a subdirectory inside the archive,
git archive --output=../_toDeploy/ArchiveName....
|
|
I was considering including the source code in my archive file (EAR, JAR, WAR) so we could see what the deployed application looks like. This will obviously make the archive much bigger. Does the size of the archive file affect performance on the application...
Started by AEIOU on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Of course from the source control the exact snapshot from... .
That would be my choice.
It does affect the performance to the extent that there are more entries in the archive's index a source archive and shovel it around with the other files.
|
|
Well recent events in Zeta have revealed that we will protest against certain things. The following are observations that I've made in studying Zeta. Please feel free to add yours as well.
1. Talking trash on the boards without revealing your ingame identity...
Started by Nyx
Lurker on
, 20 posts
by 7 people.
Answer Snippets (Read the full thread at ikariam):
|
|
On the terminal server windows 2003 is 7zip. The problem is that it does not follow the rules of the GPO. And users can use the archive as a explorer. while in Group Policy to use the explorer is prohibited. Can someone suggest how to withdraw from the...
Started by Voland on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
If you need to handle other archive formats, you could try other archivers and their command line.
What do the users need to archive? Do you have to use 7zip? Windows has a native zip functionality.
|
