do a run as when you open your dos session, and use the same account as what the sql agent account is, and try that

change your job to say

cscript.exe D:\xyz\Scripts\DB_Trans_Log_Ship.vbs

and let me know if that works

if you type cscript in a dos prompt, you can see the parameters for it.

Which EMC product are you referring to, there are many

sqlcool (9/25/2009)

---

Hi there

i am using the following way to inoke a .bat file which internally invokes .vbs file but it dosent seem to work

Type :- CmdExec

Run as :- SQL...

kiranmca24 (9/25/2009)

---

1. I need to shrink my database file. what is the maximum size of database file(i.e mdf).my mdf file size is 978 mb.so can i shrink my database...

Bit disappointed to be honest, expected more detail and in more depth. nothing pointed out really made me think about the subject in question. Just another rehash of arguments about...

PhilM99 (9/24/2009)

---

Thanks to Silverfox and ALZDBA for the quick replies!

OK, if I do this am I on the right track?:

1) Manually:

Set recovery model to Full

Do a...

rajeshreddydba (9/24/2009)

---

I am running a existing job it is failing .bcz the profile name is not valid and error number is 14607,

can u help it out brifefly telling the...

Third party tools are normally used, Object level restores are not supported in sql server yet.

this link might help.

http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-setup/8970/Error-when-installing-KB948109

if you are using a domain account for the sql server service, you can try changing it to local system and restart the service then try the...

Looking at your post again, Would i be correct in thinking that you have 1 database there with 2 log files?

if that is the case, that might explain your problem,...

Dean Jones-454305 (9/24/2009)

---

Hi Guys,

I have a bit of a problem here, I have stopped the SQL service on server A, copied the mdf files and ldf files across to server...

One of the commands that you can run is

dbcc showcontig

this reports on fragmentation at table level

you ideally want

Scan Density [Best Count:Actual Count] to be closer to 100% as possible

Scan...

Hard to say, How often do you test the backups that are done and do practise restores, to test the DR scenario.

ramuvanparti (9/24/2009)

---

suppose i have db name test and there no objects in this db now whenever user of this database will create a object that should in either of these...