Database Connection

Still new here, please be gentle.

I created a database inside SQL. I made my tables,etc.

When I try to connect to it from VBE I cannot open it!

I get an error stating that I cannot connect to it.

Am I doing the right thing?

If I create an SQL db from within VBE, I run into issues. I would rather not install the db's into my project since this will be a shared app.

Could some give me a little advice or point me in the right direction, please.

Davids Learning

IF I HAD ONLY TOOK ABOUT 8 HOURS

I COULD HAVE SOLVE MY OWN PROBLEM

READ BLOGS MORE

Davids Learning

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