Couldnt agree more! Litespeed or SQLBackup are both great products.

Redgate offer generous discounts too which make the product affordable and it has great features. I use it and recommend it!

if you only want a 2 node cluster Std edition should suffice. You will lose a few other features but its still an option

to further my point and using Pauls kind example

the following would fail and hence, would only allow a single NULL value

USE tempdb;

GO

CREATE TABLE dbo.Parent

...

sorry my bad that is only for SQL 2005 onwards

just out of interest what version SQL server are we talking here?

WayneS (4/20/2010)

I was just thinking about...

mate, your keen this thread is over a year and a half old 🙂

are you seeing this on all databases that are having indexes rebuilt??

run this on each server and it will create an alter login script with the old password

select 'alter login [sa] with password = ' +

sys.fn_varbintohexstr(password_hash) +

' hashed' +...

create index and alter index rebuild are both minimally logged.

What is it leads you to believe they're not?

hi

can you post a screenshot of the server logins from management studio

in my opinion only when using a windows workgroup

local accounts work even on a domain, but you have to replicate them from machine to machine using the same username and password, much the same as you do in...

either perform a

RESTORE FILELISTONLY FROM DISK = 'diskpath\filename.bak'

or use the following against the original database

Use yourdb

exec sys.sp_spaceused

this will give you an idea of the space used\required

If you're using VMWare ESX\VI then VMWare don't recommend 4 vCPU's. In extreme cases it can cause the host CPU to max out. All VM's are generally created with 1...