For the two active nodes to run different installations of SQL would I have to use named instances?

My limited knowledge of access tells me that there is no ldf file...just an .mdb i am not an expert in access though

It seems from what you have said the 3rd party product is not backing up the SQL database but trying to backup the actual files in the file system. which...

Following on from the previuos post, you could save your index rebuilds until the weekend, but if index fragmentation is a problem then you could rebuild online during the...

Hi thanks for the repsonse,

Just a few extra questions.

I thought that C2 was at server level and it captured everything. Is it possible to configure what data is captured or...

I've only really used Redgate's SQL backup aside from the native client...i found it be very good in terms of speed and compression.

yes you should.

Hi Kerry,

Re-installing windows then reinstalling SQL Sever and then restoring the user DB from the BAk file, you will have a database that no users can access, no logins will...

This link might help you start...

http://www.microsoft.com/sql/prodinfo/compare/oracle/default.mspx

don't know too much about Oracle training material though sorry. I'm sure there's a similar range of books out there that SQL Server has.

sorry for stating the obviuos can you not simplydelete files older than two days?

will you need to rebuild/restore the system databases too?

To restore a user database you don't need to create a database first , you can restore straight from the backup...

OK well not th most detailed post but if you want to list all the uset database on a particular server then this will list them also it will provide...

You could drop the indexes before the bulk insert and rebuild after the insertion. the insertion will be quicker becuase it will not have to modify the indexes on each...

you can detach - reatch or even backup and restore. Even though backup and restore will "avoid downtime" there is the possibility of the database not being in sync. i.e....

backing up msdb database will backup your agent jobs, its also a good idea to script them out.