I would not drop/recreate the indexes - I would disable the non clustered indexes before the load and rebuild them after the load.

To disable: ALTER INDEX {index name} ON {table}...

Steve Jones - SSC Editor (1/15/2011)

---

Does that 28 days matter if the old primary node then becomes the inactive one? Isn't it OK as long as you always have one...

joshtheflame (1/9/2011)

---

this is what i did. the WHERE condition was the problem which was filtering right after grouping so removed where thats it:)

DECLARE @startDate varchar(20)

DECLARE @endDate...

I believe it does - as long as you...

Is there an issue with space that you are trying to fix? At those sizes, I would just leave the databases at that size and let SQL Server use...

You can use a tool like WinDirStat to identify what is using the space.

If you install the tool on your local workstation, you can then create a mapped drive to...

If all you need to do is shrink the backup file, look into the backup utilites that provide compression - or use a compression tool on the backup file (e.g....

smile_netz (1/14/2011)

---

Can somebody please enlighten me regarding the licensing using clusters?

Currently, we have a Production server that has a clustering with 2 SQL 2008 instances.

In the future, we are planning...

I have a 1TB database that I restore nightly to a report server. The process I use is:

Split the backup BCV backup volume

Mount the BCV volume on the report...

When you say 'consistent' I am assuming you want the databases to be backed up at exactly the same time.

I am not familiar with NTBackup and how it implements VSS...

I would recommend that you not use locale specific formats for your dates. Instead, you should use one of the non-ambiguous formats.

The best option would probably be YYYYMMDD -...

Roy, I know this is a really, really stupid question - but can you confirm what the max memory setting is? It should be 262144 for 256GB of memory...

piet.kouwer (1/12/2011)

---

at the moment the recovery model is simple, but I can change it easily. I want to backup databases every 4 hours. I always thought that when I create...

Yes - that is correct. Now, the problem you are having is that the backup was performed from SQL Server 2008 R2 and you are running SQL Server 2008.

You...

Even with minimal logging...