Location of the Audit Log

This should be an easy one: when I turn on the Audit Log, what directory and
what is the log called? Can I send the log to a drive other than the drive
I have my data files on?SQL Server auditing is sent to the NT Event logs.
Is this what you are asking?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||I need the name of the file SQL Server creates. I am looking in that config
folder and ther is at least 14 NT files in this thing!|||Errorlogs are sent to the drive specified by this registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\MSSQLServer\Parameters
SQLArg1
Hope this helps.
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||got it! Thanks for all your help!

Location of Report Files on Server

Does anyone know which directory contains the report (.rdl) files on the SQL
Server Reporting Services server? I'd like to access these files on the
server.
Thank you.There are no rdl files on the server. The process of deploying causes the
rdl to be stored in the database. If you need to retrieve the rdl that was
deployed you can do to report manager, click on the report, properties, edit
and give it a file name to put the rdl into.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Brian P" <BrianP@.discussions.microsoft.com> wrote in message
news:606DD94C-C004-4E30-BD72-DDBB0056C908@.microsoft.com...
> Does anyone know which directory contains the report (.rdl) files on the
> SQL
> Server Reporting Services server? I'd like to access these files on the
> server.
> Thank you.|||Bruce,
Understood. Thanks for the reply.
Brian
"Bruce L-C [MVP]" wrote:
> There are no rdl files on the server. The process of deploying causes the
> rdl to be stored in the database. If you need to retrieve the rdl that was
> deployed you can do to report manager, click on the report, properties, edit
> and give it a file name to put the rdl into.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Brian P" <BrianP@.discussions.microsoft.com> wrote in message
> news:606DD94C-C004-4E30-BD72-DDBB0056C908@.microsoft.com...
> > Does anyone know which directory contains the report (.rdl) files on the
> > SQL
> > Server Reporting Services server? I'd like to access these files on the
> > server.
> >
> > Thank you.
>
>

Locate backup file - can't see other drives

In MS SQL 2005 when you select "Restore Database" and click "From
Device", you get a directory explorer where you can select a backup
file. In that explorer window ("Locate Backup File") I can't see any
other drives than the one where my MS SQL Server is installed.
Is it just my system or is this by design?
Thanks for any ideas!
It could be that your SQL Server is clustered and you're seeing only the
disks on which SQL Server has a dependency.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"lanfear" <v_koski@.hotmail.com> wrote in message
news:1183726609.006262.23360@.q75g2000hsh.googlegro ups.com...
In MS SQL 2005 when you select "Restore Database" and click "From
Device", you get a directory explorer where you can select a backup
file. In that explorer window ("Locate Backup File") I can't see any
other drives than the one where my MS SQL Server is installed.
Is it just my system or is this by design?
Thanks for any ideas!
|||Hi
"lanfear" wrote:

> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!
>
Normally the dialog would default to a location and you could browse from
there depending on your permissions to see the directories. You could try
typing the path in yourself. With a cluster you would only see the drives
that have been tagged as cluster resources.
John
|||Are the other drives in question local? I
Anthony E. Castro - MCDBA
"lanfear" wrote:

> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!
>
|||Wow, bullseye! It's a two node cluster where only the E drive is in
the resource group. I suppose there isn't a way to have other drives
displayed when it's a clustered service.
Thanks a lot for the fast reply, now I don't have to scratch my head
anymore. Thanks John & Anthony aswell.
/lf
On Jul 6, 3:23 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> It could be that your SQL Server is clustered and you're seeing only the
> disks on which SQL Server has a dependency.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> "lanfear" <v_ko...@.hotmail.com> wrote in message
> news:1183726609.006262.23360@.q75g2000hsh.googlegro ups.com...
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!
|||Just got back from vacation - sorry for the late follow-up. I don't think
there is a way to get that in SSMS.
That said, I'm concerned that there is only one disk dependency - drive E: -
for your clustered instance. Typically, you have one disk for data and
another for logs.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"lanfear" <v_koski@.hotmail.com> wrote in message
news:1183732767.641961.258190@.q75g2000hsh.googlegr oups.com...
Wow, bullseye! It's a two node cluster where only the E drive is in
the resource group. I suppose there isn't a way to have other drives
displayed when it's a clustered service.
Thanks a lot for the fast reply, now I don't have to scratch my head
anymore. Thanks John & Anthony aswell.
/lf
On Jul 6, 3:23 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> It could be that your SQL Server is clustered and you're seeing only the
> disks on which SQL Server has a dependency.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> "lanfear" <v_ko...@.hotmail.com> wrote in message
> news:1183726609.006262.23360@.q75g2000hsh.googlegro ups.com...
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!

Locate backup file - can't see other drives

In MS SQL 2005 when you select "Restore Database" and click "From
Device", you get a directory explorer where you can select a backup
file. In that explorer window ("Locate Backup File") I can't see any
other drives than the one where my MS SQL Server is installed.
Is it just my system or is this by design?
Thanks for any ideas!It could be that your SQL Server is clustered and you're seeing only the
disks on which SQL Server has a dependency.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"lanfear" <v_koski@.hotmail.com> wrote in message
news:1183726609.006262.23360@.q75g2000hsh.googlegroups.com...
In MS SQL 2005 when you select "Restore Database" and click "From
Device", you get a directory explorer where you can select a backup
file. In that explorer window ("Locate Backup File") I can't see any
other drives than the one where my MS SQL Server is installed.
Is it just my system or is this by design?
Thanks for any ideas!|||Hi
"lanfear" wrote:

> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!
>
Normally the dialog would default to a location and you could browse from
there depending on your permissions to see the directories. You could try
typing the path in yourself. With a cluster you would only see the drives
that have been tagged as cluster resources.
John|||Are the other drives in question local? I
--
Anthony E. Castro - MCDBA
"lanfear" wrote:

> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!
>|||Wow, bullseye! It's a two node cluster where only the E drive is in
the resource group. I suppose there isn't a way to have other drives
displayed when it's a clustered service.
Thanks a lot for the fast reply, now I don't have to scratch my head
anymore. Thanks John & Anthony aswell.
/lf
On Jul 6, 3:23 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> It could be that your SQL Server is clustered and you're seeing only the
> disks on which SQL Server has a dependency.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> "lanfear" <v_ko...@.hotmail.com> wrote in message
> news:1183726609.006262.23360@.q75g2000hsh.googlegroups.com...
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!|||Just got back from vacation - sorry for the late follow-up. I don't think
there is a way to get that in SSMS.
That said, I'm concerned that there is only one disk dependency - drive E: -
for your clustered instance. Typically, you have one disk for data and
another for logs.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"lanfear" <v_koski@.hotmail.com> wrote in message
news:1183732767.641961.258190@.q75g2000hsh.googlegroups.com...
Wow, bullseye! It's a two node cluster where only the E drive is in
the resource group. I suppose there isn't a way to have other drives
displayed when it's a clustered service.
Thanks a lot for the fast reply, now I don't have to scratch my head
anymore. Thanks John & Anthony aswell.
/lf
On Jul 6, 3:23 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> It could be that your SQL Server is clustered and you're seeing only the
> disks on which SQL Server has a dependency.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> "lanfear" <v_ko...@.hotmail.com> wrote in message
> news:1183726609.006262.23360@.q75g2000hsh.googlegroups.com...
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!

Locate backup file - can't see other drives

In MS SQL 2005 when you select "Restore Database" and click "From
Device", you get a directory explorer where you can select a backup
file. In that explorer window ("Locate Backup File") I can't see any
other drives than the one where my MS SQL Server is installed.
Is it just my system or is this by design?
Thanks for any ideas!It could be that your SQL Server is clustered and you're seeing only the
disks on which SQL Server has a dependency.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"lanfear" <v_koski@.hotmail.com> wrote in message
news:1183726609.006262.23360@.q75g2000hsh.googlegroups.com...
In MS SQL 2005 when you select "Restore Database" and click "From
Device", you get a directory explorer where you can select a backup
file. In that explorer window ("Locate Backup File") I can't see any
other drives than the one where my MS SQL Server is installed.
Is it just my system or is this by design?
Thanks for any ideas!|||Hi
"lanfear" wrote:
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!
>
Normally the dialog would default to a location and you could browse from
there depending on your permissions to see the directories. You could try
typing the path in yourself. With a cluster you would only see the drives
that have been tagged as cluster resources.
John|||Are the other drives in question local? I
--
Anthony E. Castro - MCDBA
"lanfear" wrote:
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!
>|||Wow, bullseye! :) It's a two node cluster where only the E drive is in
the resource group. I suppose there isn't a way to have other drives
displayed when it's a clustered service.
Thanks a lot for the fast reply, now I don't have to scratch my head
anymore. Thanks John & Anthony aswell.
/lf
On Jul 6, 3:23 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> It could be that your SQL Server is clustered and you're seeing only the
> disks on which SQL Server has a dependency.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> "lanfear" <v_ko...@.hotmail.com> wrote in message
> news:1183726609.006262.23360@.q75g2000hsh.googlegroups.com...
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!|||Just got back from vacation - sorry for the late follow-up. I don't think
there is a way to get that in SSMS.
That said, I'm concerned that there is only one disk dependency - drive E: -
for your clustered instance. Typically, you have one disk for data and
another for logs.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"lanfear" <v_koski@.hotmail.com> wrote in message
news:1183732767.641961.258190@.q75g2000hsh.googlegroups.com...
Wow, bullseye! :) It's a two node cluster where only the E drive is in
the resource group. I suppose there isn't a way to have other drives
displayed when it's a clustered service.
Thanks a lot for the fast reply, now I don't have to scratch my head
anymore. Thanks John & Anthony aswell.
/lf
On Jul 6, 3:23 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> It could be that your SQL Server is clustered and you're seeing only the
> disks on which SQL Server has a dependency.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> "lanfear" <v_ko...@.hotmail.com> wrote in message
> news:1183726609.006262.23360@.q75g2000hsh.googlegroups.com...
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!

Local SQL Server Connection times out during network outage

Hi,
we just upgraded to active directory from nt 4 domain.
In our HQ office we have 2 SQL servers for various
applications. We have a DNS/DC/GC server located at this
location and a DNS/DC/GC server located at a remote site.
During the last couple months after the upgrade we have
had a couple network outages. During these times sql
access to these local servers within the local office has
been so slow that it times out our applications and the
local users cannot use their local sql servers. Any
ideas on what is happening?
Sounds like the clients were trying to resolve the local server name in DNS
or WINS, that were unreachable perhaps. With SQL 2000 you can connect with
Shared Memory, which never needs to go out on the network. So, essentially
local connections are just that , local.
I would check to see if Shared Memory is enabled on the machine, and if
there were an local aliases used. If there is an alias specifying TCP for
example, then the client would attempt to use TCP, which could be a problem
under those conditions.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Local SQL Server Connection times out during network outage

Hi,
we just upgraded to active directory from nt 4 domain.
In our HQ office we have 2 SQL servers for various
applications. We have a DNS/DC/GC server located at this
location and a DNS/DC/GC server located at a remote site.
During the last couple months after the upgrade we have
had a couple network outages. During these times sql
access to these local servers within the local office has
been so slow that it times out our applications and the
local users cannot use their local sql servers. Any
ideas on what is happening?Sounds like the clients were trying to resolve the local server name in DNS
or WINS, that were unreachable perhaps. With SQL 2000 you can connect with
Shared Memory, which never needs to go out on the network. So, essentially
local connections are just that , local.
I would check to see if Shared Memory is enabled on the machine, and if
there were an local aliases used. If there is an alias specifying TCP for
example, then the client would attempt to use TCP, which could be a problem
under those conditions.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.