basically it is scenario based exam,

but will there be simulation questions too?

if yes then how many questions will be there for simulation & how many for objective?

anyone know the solution?

this means ur copy job is failing, isn't it?

can u please give the error.so that we can provide u the exact solution

do the foll checks first

1.Try to open that file on 193.169.122.111.

2.check the rights on the file HARD_COPY.csv.

3.Try to access that file from ur sql machine.

hey gail,

i was looking for this point only

if i put .ndf file to new filegrp & restricts .mdf file then what will happen?

new data will go in .ndf or new...

thanx a lot

does it require downtime?

as Shawn Melton said

1. check for free space on drive where tempdb is stored

&

2. Try to truncate log of tempdb only if no users are using tempdb database.

3. also...

Try registering foll. files in the foll. path

C:\Program Files\Microsoft SQL Server\80\Tools\Binn\DTSPkg.dll

C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTS.dll

then try to open the dts package.

link is related to 32 vs 64 bit.

In my case both the versions of OS are 32 bit only

i have already posted the table structure (ServerDrivestatus).

in proc. ServerDrivestatus & #drive are the tables used.

#drive structure is in proc only

what r other table structures u want?

Table

---------------

create table ServerDrivestatus

( servername varchar(150),drive varchar(10),totalMB float ,

FreeMB float,PercentFreeMB float, FreeSpaceDate smalldatetime)

SP

----------

create PROCEDURE sp_cloverdiskspace

AS

SET NOCOUNT ON ...

Thanx for the reply guys,thanx a lot!!!

Hii steve ,

in second video how to configure those nodes?

basically i want to configure clustering using VMWare on my test machine i installed...

Jeffrey Williams-493691 (11/24/2009)

They are not stored in the file system - maintenance plans are stored in MSDB. ...

great article .

Thanx a lot.