Search results for query: *

how do i do that?

hello is there a storedproc that will output the login names and the associated users for each database? thx

Hello I am not clear about when the log truncation happens. If i do a backup log, does the log truncate automatically or, does it require a switch? right now, i did a dbcc loginfo which shows some 230 vlf's -only one of them is active. I then did backup log and rechecked with dbcc loginfo - no...

Hello just getting familiar with a few tsql commands i did exec sp_helpdb northwind and i see the "top" result reports db size of 3.63 MB while the "bottom result" says northwind size - 2688 KB northwind_log size - 1024 KB i don't see how the two agree???

Hello I am new to admin of sql. will be responsible for backups etc. I am trying out a script from a FAQ. and it requires me to run sp_foreachdb with a created stored proc: CREATE procedure usp_BackupDatabase @DatabaseName varchar(100) as declare @date varchar(10) declare @BackupPath...

Hello I followed one of the FAQ's and executed this in a sql agent scheduled job CREATE procedure usp_BackupDatabase @DatabaseName varchar(100) as declare @date varchar(10) declare @BackupPath varchar(255) declare @BackupFile varchar(300) set @BackupPath = 'c:\temp\' set @date =...

hello I will be responsible for backups/recovery for our new DB/app running on sql 2000. Now, what i need to know is 1)In enterprise mgr (EM) when i right click the db name and do "backup DB", what default options are used. What I mean is that when I look at setting up a maint plan, there are...

hello How can i keep track of logoff time in exchange. When i go to mailboxes i see last access time but i need to know the time when users logout thx

Hello i am trying to clear up a bunch of wmi related event viewer errors. I've been able to use wmidiag.vbs to get a determination that WMI is working correctly. However, i now see event id 9097 mad monitoring thread unable to connect to WMI re: exch system attendant. So i see i need to...

hello i was just checking out search folders in OL2003 i enabled the "old mail" search folder (for "older than 1 month") and i see items in it dating back to 2002 now, where exactly is this info coming from? i ask since in my inbox i only have 60 items but this search folder shows 600+ items

hello i've been using aofo with exchange (and getting - mailboxes not snappable, backing up directly from source) so in readinf thru some tech docs i see that veritas does not recommen use of aofo with exch. they say "use the agent instead" so, if i uncheck aofo will the agent be used...

hello all has been fine since february when i first installed my 2003 ad + exch 03 (on member server) the last few days i've been getting repeating errors (on top of the browser service terminating) referring to message tracking log this particular error refers to...

got this one in my event viewer "eventsystem sub system is suppressing duplicate event log entries for a duration of 86400 secs...." i've googled it, kb etc does anyone have an idea ?

hello i am not a programmer however out of curiosity (stemming from event viewer errors in one of my servers) i would like to know what functionality netapi32.dll provides i did a search and i can't find a list of the functions can someone point me in the direction?

I rebooted my w2003 sp1 DC, checked event viewer and saw this error "...faulting application svchost.exe version...faulting module netapi32.dll..." since the reboot i have had no reports of any kind re: access to that server or it's data etc. I am concerned however since i am not clear on what...

hello just rebooted my win2003 server sp1 and obtained this error in event viewer this server is a dedicated mail exch03 server the error says "faulting module netapi32.dll" i tested email etc - all seem to be ok should i be concerned?

Hi How would i go about re-printing an old job log say from a few months ago? Are they all saved somewhere? thx

Hello I'm checking my job reports and it seems, this message always appears for the mailboxes/public folders. It then continues to say "attempting to back up directly from the source volume" and apparently the data is backed up (i see the reported size of data and folders backed up and they...

I just want to get the info on installed agents (exchange - which is installed on a remote server etc) thx

Hello I'm reading the admin manual and don't quite understand what it is that i am backing up when i include the shadow copy components (service state/system state etc) Is it required to back these up for recovery purposes? thanks