In order to shrink the data files, you must be member of SYSADMIN server role , or DBOWNER database role.

Regds,
Shrikant Patil
MCDBA

-----Original Message-----
From: murali prasad k [mailto:mssqldba-ezmlmshield-x6820811.[Email address protected]
Sent: Monday, May 31, 2004 7:56 AM
To: LazyDBA.com Discussion
Subject: unable to shrink log file

 
hi,
my problem is regarding shrinking of log file on the main server(MS SQL 200) to which 50000 records will be added every day. previously we had a user say xx which has all the properties of sysadmin.. with this user i was able to shrink log file using dbcc shrink log file command,, but now the properties has been changed for that user by somebody,, now if i try to shrink log file its giving error msg like to shrink a log file the user need to member of sysadmin.. from sql enterprise manager also i am unable to do it...when i right click on database shrinkdatabase option in invisible.
so can anyone guide me to solve this problem thanks, regards murali.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website : http://www.LazyDBA.com To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]


MS Sql Server LazyDBA home page