Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 how to change profiler Trace file to new device

Author  Topic 

vasi
Starting Member

11 Posts

Posted - 2012-06-12 : 10:51:51
Hi All,
My env is Sql server 2005.
My profiler trace file is full.I need to change to the new device.
1.May I know, how to check my profiler trace file path ?
2.Please give me the steps, how to change the trace file path to point to new device ?

Thanks
vasi

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-06-12 : 11:06:08
How did you set it up in the first place ?
Did you save it to : Save to file or Save to Table?

Normally , if I save it to Save to file - then I "enable file rollover"

Have you run out of disk space?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

vasi
Starting Member

11 Posts

Posted - 2012-06-12 : 20:56:59
Hi jackv,

1.How did you set it up in the first place ?
Did you save it to : Save to file or Save to Table?

Can you tell me the steps to view its save in file or on table ?

2.Have you run out of disk space?
yes disk space full
we like to point the othere disk , Can I know the steps plz ?


Normally , if I save it to Save to file - then I "enable file rollover"
Can I have the steps for the enable file plz ?

Thanks
Vasi
Go to Top of Page
   

- Advertisement -