database backup with encryption

Hi,

I want to backup my database at regular intervals and encrypt it. Also I want to verify the back up. How do I do it?

I want the back ups to run every fortnight.

Thanks.

For encrypting backups, you have a few different options. Some would include:

Backup or move the backup to an encrypted folder.

Write your own file encryption routine.

Use a third party backup utility that will backup and encrypt. Tools like

Red Gate's SQL Backup

http://www.red-gate.com/products/SQL_Backup/index.htm

or

Quest's LiteSpeed

http://www.quest.com/litespeed-for-sql-server/

In terms of verifying, that depends on what you mean by verify. You can use the restore verifyonly option on backups. That will tell you if the backup file is complete and readable by SQL Server. If you need verification beyond that, you need to test this by restoring the backup to another server (or another database name if using the same server)

-Sue

Database availability issue

I have a large db that goes through regular maintenanceevery week. The problem seems to be that while the db is re-indexing some of mykey tables I get time out errors. Are there any suggestions on how I can combatthis problem. Management has tasked mewith having 24 hour access to the db because if people aren't completing theretransactions we don't get paid. I havealso noticed the timeout issue when we are running in files that create newrecords. Is this a basic problem withthe way the db is structured? Are theyany tools that I can use to change our process so that we can maintain the 24hour access to the db. How are othercompanies maintaining 24 hour access to there db?

Thanks in advance.

Don

When you are reindexing the tables do get locked and are inaccessible. You should request for a downtime window, let the users know and do your maintenance during the window. In 2005, there's online indexing available that might be of interest to you.

Data warehouse and a data base? difference?

I need someone to give me a small briefieng on how a enterprise data warehouse (EDW)
differs from a regular database?

Currently we have an appplication that accesses a database with about 18 tables. We also have
a Data Warehouse. For some reason I was thinking that it would be possibly to migrate the
database into the data warehouse. The reason is that in looking at the schematic design for
the data warehouse there are some data tables that could also be used by our application
that uses the DB.

I guess I am confused because I am not sure if a data warehouse is used in the same way
as a database?

Datawarehouse and Databases setup and uses differ. A database is traditionally used to store normalized data for a transactional based system. A datawarehouse is a way to abstract the database tables in such a way as to allow denormalization. Think of it this way: I would use a warehouse to store data in such a way as to query the data for reporting purposes. I would use a database for this reason because I would want some user or users running a 20 minute report on my core database. Hope this helps.

|||

Ok, thank you. I also found this info which is pretty good.

http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96520/concept.htm