Hey Matthew,

You've got a few options really.

1) Log Shipping

2) Replication

3) DTS/Stored Procs

Replication and Log Shipping will basically provide a direct copy so you would have two copies.  You would then...

Was looking for possible bug issues and thought I'd post something I spotted today...

When you execute a query in QA, a qag*.tmp file is created in Local Settings\Temp.  When you...

Didn't realise that SQLRecon was based on SQLPing!

I guess in the job merry-go-round I missed that one.  Will check it out!

Hi Erik,

Do you mean delete the transaction logs that were taken before the last full backup?

If you run a full backup at say 10pm daily and you delete all of...

Another tool you can use is SQL Ping.

http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=26

Also, for the books...There are loads out there....Are you after any specific area's?  But one I could not be without is Microsoft's Inside SQL Server 2000 by Kalen Delaney.

Hi Erik,

If you want to restore to a point in time, you do need the transaction logs!  If you discard the transaction logs and you have a failure, you can...

Sounds like you need to run a backup!

Basically you should not need to really run shrinkdb.  If you have a daily backup running and then transaction log backups executing at...

Hi dsql,

In DTS, you can map column to column.  Its a drag and drop scenario.

With regards to the identity column, you can use the function SET IDENTITY_INSERT <Table> ON|OFF.  This...

I had to do something similar.  I created a DTS package, that had some VBScript in it.  The VBScript would pick up the last full backup and copy it to...

What error message are you getting when you look at the scheduled job failure?

Are there any other jobs running at the same time?  Somthing like a database/log backup?

Hi,

First question would be, aside from splitting the database into two databases on the test server, have you altered any of the tables?  I notice you have altered permissions, but...

I would never hard code a password in a compiled app!  As you say, a password name change would require a recompilation.

You have two options really.  If you must use...

Hi there,

It could be that the first time you were running the statement, the execution plan was being created and then subsequent queries were using the same execution plan.

However, it...

Hi Helen,

Do you mean you are running remote queries on a different server?  What kind of query?