GilaMonster (4/2/2009)

---

Restore from scratch each time.

Write a custom sync program or a rather complex SSIS package to do the same thing. This will have a non-trivial impact on production

Replication's the...

GilaMonster (4/2/2009)

---

No need. It's trivial. Add WITH NORECOVERY to all of your restored. However that means that...

GilaMonster (4/2/2009)

---

To restore more backups the database has to be in norecovery, which means it's not readable. Diff backups aren't really suitable for keeping a test server up to date....

Jason Crider (8/15/2008)

---

One other gotcha if you ever have a 64 bit instance of 2005 trying to connect to a linked server that's a 32 bit instance of SQL 2000...

Hi Dosth,

Can u post the complete code on this thread after you corrected it and made it workable?

Tks,

Anukul

Hi,

After creating the SP in server, under a database, when the sp is executed it is giving an error msg:

Invalid object name 'tempdb.sys.objects'.

I removed tempdb and made sys.objects as sysobjects,...

Thanks so much Mike !

Cheers,

Anukul

 

Mike:

I have created 2 of the other functions, in a specific database, in which I have to use the encryption. I modified these functions to lookup the master database for the...

Mike:

Thanks for the response!

So, can the whole set of procedures, extended procedures along with Key Vault tables be installed in one particular database in which this has to be used,...

Hi Mike!

I have been successfull in installing the ToolKit on SQL Server2000. Thanks for your help.

I observed that all the functions are installed in Master database, so all queries...

Hi Mike!

I am getting an error message while installing the DBA ToolKit for SQL 2000. Below is what I receive on executing the Install.sql script. Let me what I can...