what do you want to do with the tools? MSSQL databases can be administered perfectly well using the tools that come with the product.

As for backups a third party tool...

http://msdn.microsoft.com/en-us/library/ms190224.aspx

from google search - log shipping+"SQL"

Ray Mond (9/15/2010)

---

The PASSWORD option in the BACKUP command simply requires that you provide a password during the restore process. It does nothing to obfuscate the contents of the...

I would say that is the only way to be 100% sure yes.

a backup file can be password protected but i don't know the effect of that on opening through...

looks like me and david agree 🙂

I would hazard an educated guess that the pages are merely marked for reuse, not actually overwritten with binary zeros, which would obviously really slow up any delete operations.

I think...

yes you will under the same license. You will only need another license if you intend to install SSRS on another server.

Only a restore of the .bak file will tell you whats contained in .bak file, opening it in notepad is just not relevant.

no way detach/attach affects number of tables.

SQL2005 splits tables up into separate headings - system tables and non system, is that it?

It can take new databases into account - just specify 'all user databases'

thanks for the feedback

In terms of software versions the only pre-req is windows 2008

See also http://technet.microsoft.com/en-us/library/dd197575(WS.10).aspx

and google for this white paper 'SQL Server 2008 Failover Clustering'

Max connections set to 0 means use...

dtipser (9/15/2010)

---

Hi,

We are going to start a project in a Client Server architecture. Client will be running in Citrix on Virtual Machine, Windows 2008 configuration servers (about 200 VM). The...

In SQL2008 notruncate and truncateonly are not applicable to log files. So in fact what is happening is notruncate and truncateonly are ignored when it is a log file. ...

Use this process to move SSRS to another server, this is by far the best description of the process out there.

http://support.microsoft.com/kb/842425

You MUST have the encryption key from the source SSRS...