File was on the same machine as sql server and if I put scrip into vbs file on the server it works fine but from job on the same server...

i checked that first but account that runs task is local admin on server

With restoring master database you restored logins from different domain and lost all logins from domain server is in so you can not log in this way. Only solution is...

If you have functions or stored procedures in master you can script them and then create on new server. Master is system database and i doubt that you can successfully...

Your commands look like you have sql server 2005 and i have sql2000. My commands are

select * from ::fn_trace_getinfo(3)

312

32W:\trace\STBTrace

331

34NULL

351

I run server side trace with script and it is making files...

i read your topic once again and i am not sure what do you want. You can restore or detach attach user database, restore msdb and if you want to...

I meant that we restored msdb to transfer our jobs from one server to another and we restored each user database to new server or detached user databases from old...

Do you have backup of original master database? If you have restore that database and try to log in with some account from that domain. This is the first time...

Animal Magic (10/28/2009)

---

irena.bulatovic (10/28/2009)

---

when you copy file you are accessing remote location with credentials you are logged in with and when you use cmdshell you are accessing remote location with...

when you copy file you are accessing remote location with credentials you are logged in with and when you use cmdshell you are accessing remote location with account that is...

declare @logid as int

declare @backup_file as varchar(200)

declare @komanda as varchar(200)

--Select media_set_id of last backup

set @logid=(select max(media_set_id) from

backupmediafamily

where physical_device_name like

'Your backup device name%')

--Select exact backup device name if...

Of course it is. Server is working for some time now and at the beginning it was ok but as the time passes and our db is getting bigger performances...

I don't understand what i will get with adding more disks because i have enough free space but disks are busy all the time as i understand utilization of 98%

Of course i have log backup every 5 min and datafile disks are

install 60GB capacity 39GB free

datafile1 200GB 92GB free

datafile2 150 GB ...

No it is only sql server. I have

one lun for installation files where msdb, master and one tempdb file is,

two luns for two data files

one for one transaction log...