really started to fear the worst here 🙁

Event log brings up:

FCB::Open: Operating system error 2(error not found) occurred while creating or opening file 'Y:\DATA\mastlog.ldf -c -T3607'. Diagnose and correct...

reg keys:

-dZ:\DATA\master.mdf

-eZ:\LOG\ERRORLOG

-lY\DATA\masterlog.ldf -c -T3607

looks right but again I query the traceflag location?

Looking at SQL Error logs i get the following if it sheds light to you wise poeple out there!

Am i running the traceflag right? it seems like its pointing it...

yeah,

to start i didn't copy it over (Didn't think i had to be honest with tempdb :X) Ive copied it over now (mdf and ldf) same result.. /cry

When i run

SQLCMD -q"Alter database tempdb modify file (name = tempdev, filename = 'Y:\SQL\tempdb.mdf')"

about 10 seconds later i get an error saying:

could not open a connection to sql...

Hi SQLRNNR,

Thanks for the quick reply!

Id tried that command already. im looking at a long list of white text saying that each of those db have

error 17207, severity 16,...

Hi prvmine,

Yeah figured there would be some more pro ones out there..

Trying to use it as a learning process though so going to try and keep my eyes off...

hey,

thanks for the links, will get my reading on 🙂

S

Hi guys thanks for the replies!

I need to be able on request list if an update or delete has been found to be incorrect:

Name of person who made change,

Time...

hi John,

sqlcmd -S Servername -U newUser -P P@55w0rd

i read on thread that this only works for SQL accounts and not Windows? but im sure i used if for the...

hi Dave,

Thanks for the quick reply! feared that might be the answer..

thank you for the help.

ps

good luck with the meeting tonight. I will be trying to...

well it looks like we are running ft on all of our sql instances on the cluster and its not being used by any of them.

So im thinking ill...

Morning Jared!

Thanks for the links... im really loath to start using the registry as its a cluster .. Was hoping there would be a nice t-sql way.. I shall...

thanks jared.

seem to find myself moving data around all the time at the moment form 1 drive to another.. (so far no major problems!) but this is the first...

Hi jared,

So when i created the cluster i had to use some temp storage, now that i have the real storage for the server i have to move it...