join the club :w00t::alien:

USE [master]

GO

CREATE CREDENTIAL [CMDShellSQLAgentPROXY] WITH IDENTITY = N'awindowsdomain\account', SECRET = N'itspassword'

GO

USE [msdb]

GO

/****** Object: ProxyAccount [CMDShellPROXY] Script Date: 02/06/2007 11:30:44 ******/

EXEC msdb.dbo.sp_add_proxy @proxy_name=N'CMDShellPROXY',@credential_name=N'CMDShellSQLAgentPROXY',

@enabled=1,

@description=N'Provides CMDShell functionality...

can you post the results of :

restore filelistonly

FROM DISK = 'yourbackuppath and file'

?

- What statement are you using ?

did you test using :

BULK INSERT mydb.myschema.myobject

from '\\UNC_path\myobjectdata.txt'

WITH

( FIELDTERMINATOR = ''

--,CODEPAGE = 'raw'

...

- you need to keep in mind it takes +- 30 seconds to fail over a sql instance.

- Applications will have to reconnect.

- Let's hope your applications can cope with...

maybe 😉

We schedule index rebuilds on most of our server on a weekly basis.

(during low usage hours)

On some servers it is scheduled every day because we are not allowed

to change...

- can you provide some sqlserver version info ? (+ sp + cu )

- how much memory is available for sqlserver ?

- did you set a min or max memory...

check out the nice art :http://www.sqlservercentral.com/columnists/chawkins/dedupingdatainsqlserver2005.asp

with sql2005 you nee to enable xp_cmdshell !

This is not advized !

You'd be better off by shifting this action to a sqlagent job,

and run that job with a proxy...

how about using the dts.events.FireError in your script ?

Keep in mind you 'll also need to enable the "FailPackageOnFailure" property.

you may want to set the deadlockpriority for your job to low:

SET DEADLOCKPRIORITY LOW

So if a job is canceled, it will be yours.

Best is to start a trace (sql...

You need the same space volume as the original MDF, ndf and LDF files !

If they were allocated e.g. mdf 50Gb and ldf 10G , even if you only have...

This is concerning SQL2005 right ?

You may want to check on these new join methodes:

EXCEPT and INTERSECT

http://msdn2.microsoft.com/en-us/library/ms188055.aspx

Hi Andy,

Thank you for the script.

It's this kind of "simple" scripts that make this site such a great resource !

Can you post it in the contribution center ?

If I'm correct there is a SSMS setting that is used 'show system objects'

For the moment I don't have SSMS available, but I guess BOL will have a ref for...