when setting up log shipping ensure the logshipping directory is a share and make that share a cluster resource. Then both nodes in the cluster can access the directory...

with just the \PAE switch you are only enabling SQL to use memory above the 4GB line. the \3Gb switch enables the use of more than 2GB BELOW the 4GB...

setting to simple mode will break the log chain, so that is out for log shipping. I suggest you maintain the database to whatever degree it requires and ignore the...

I think there needs to be some trust here between the SA and the dBA. Hopefully your SQL servers are just that, servers supporting SQL only, so as the DBA...

Austin, basically, yes you can use bulk-logged. the bulk logged operation is repayable when restoring the log, so it will work.

when you create the temp table, use the 'as collation' clause so collation exactly matches that of the user db.

HTH

george

Mohamed, the code supplied definitely works in SQL 2000.

regards

george

Easiest way to do this if this is just another file in the same filegroup is to use the emptyfile option of shrinkfile:

use dbname

go

dbcc shrinkfile(data2.ndf,emptyfile)

alter database whatever remove...

Phil, Graham, full text indexes are not stored in the database, so am not sure they get shipped over? :unsure:

Basically anything that gets recorded in the tran log will get...

every log restore will be recorded in the errorlog, so go back through that and see which actual logs were restored.

they must have been restored in order else the log...

are you shrinking the files as much as possible before producing the final backup to be passed to the developers machines?

sorry, same result. I have ttries every feasible value for the instance name I can think of (i.e. mssql$SQLExpress) with the same result.

reporting of this behaviour as a block was introduced in SP4. I have noticed it is prevelent on I/O intensive operations such as indexdefrags and bulk inserts. It CAN be...

yes, it stops and starts the SQL services as part of the install, and then requests a server reboot at the end.

Vivien,

I have applied 2187 a number of times to standalone servers (W2003) and it has requested a server reboot each time. It has also been unable to restart the...