This can be done. Search 'Failover clustering , SQL server' in google... You will know.

Do u have IIS installed on the box? SSRS will require IIS to run.

Maybe it decides to not show the SSR because it didn't see IIS on your...

Nothing is found probably because the traces for those dropping operations have been cleaned up..which is bad.

Did you just try one trace file? there are usually at least 3...

Does this return anything?

SELECT * FROM ::fn_trace_getinfo(0)

If this shows something... then you have a trace running... and there is hope to find out what u are looking for.

Try to get the info from the trace...

1. RUN this Script to get the path of your trace file

SELECT * from ::fn_Trace_GETINFO(0)

2. Replace the following .trc with your TRACE...

/* Add the following scripts into your job step*/

DECLARE

@id char(8),

@filename varchar(50),

@cmd varchar(2000)

SET @id=convert(char(8),getdate(),112)

SET @filename='My FILEPATH Myfilename_'+@id+'.txt'

SET @cmd= 'bcp "MY QUERY" queryout '+@filename+ '-T -c'

--print @cmd

EXEC xp_cmdshell @cmd

GO

I've had this once and not figured out why.

Things you might want to check: Job enabled? Job schedule enabled? Job schedule starting time and ending time; windows time service, task...

I assume that it will automatically move the data to new partition.

To make sure it is really the case, you can run the following before and after your splitting operation...

You need to Split the range...twice.

1. add 1 new filegroups

2. add a file to the filegroup

3. Alter your partition scheme to include the added new filegroup with...

It seems that you didn't install the Database Engine for Default instance; but you installed a default instance Reporting service.

Go to your SQL Server Configuration Manager, and click...

PLAN A:

1. (DB Level) delete his account from the users in those THREE Databases that you have problem with

2. ...

Now Litespeed has Logshipping wizard.

Doing logshipping with Litespeed is super fast!