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!

Localisation bug?

Can you tell me if this is a bug?
My browser language (Internet Explorer version 6) is set to English (United
Kingdom) [en-gb].
I have 2 reports based on the AdventureWorks2000 database.
The first report is:
SELECT PurchaseOrderID, EmployeeID, OrderDate
FROM PurchaseOrderHeader
WHERE EmployeeID = @.EmployeeID
ORDER BY OrderDate DESC
The second report is:
SELECT PurchaseOrderID, EmployeeID, OrderDate
FROM PurchaseOrderHeader
WHERE EmployeeID = @.EmployeeID AND OrderDate = @.OrderDate
I have created an ACTION link (using "Jump to Report") from the first report
to the second report which sets the parameters(@.EmployeeID & @.OrderDate)
accordingly. (ie. @.EmployeeID = Fields!EmployeeID.Value; @.OrderDate = Fields!OrderDate.Value. @.EmployeeID is type integer; @.OrderDate is type
DateTime).
Everything works as expected unless I perform the following steps:
1. Run the Report1 (deployed version) [report displays succesfully]
2. Click on the action link to jump to Report2 [report displays succesfully]
3. Click the "refresh" toolbar button (not Internet Explorer Refresh)
[ERROR!!]
The Error is:
Reporting Services Error
---
The value provided for the report parameter 'OrderDate' is not valid for
its type. (rsReportParameterTypeMismatch) Get Online Help
---
Notes:
--
1. If I run Report2 independantly, the refresh button works.
2. Everything works from VS.Net "preview" tab. It is only when deployed
that the error occurs.
3. If I set my Internet Explorer language to English(United States) [en-us]
then the error goes away!
Is this a bug?
Cheers,
JoeI've found a workaround (on this newsgroup) for this bug but it's not ideal:
Instead of using the 'Jump to Report' action you can use the 'Jump to URL'
action and specify the language setting there as follows:
=Globals!ReportServerUrl & "?/Development1/PODetail&EmployeeID=" &
Parameters!EmployeeID.Value & "&OrderDate=" & Fields!OrderDate.Value &
"&rs:ParameterLanguage=en-GB"
... and hey presto it works!
"Joe" wrote:
> Can you tell me if this is a bug?
> My browser language (Internet Explorer version 6) is set to English (United
> Kingdom) [en-gb].
> I have 2 reports based on the AdventureWorks2000 database.
> The first report is:
> SELECT PurchaseOrderID, EmployeeID, OrderDate
> FROM PurchaseOrderHeader
> WHERE EmployeeID = @.EmployeeID
> ORDER BY OrderDate DESC
> The second report is:
> SELECT PurchaseOrderID, EmployeeID, OrderDate
> FROM PurchaseOrderHeader
> WHERE EmployeeID = @.EmployeeID AND OrderDate = @.OrderDate
> I have created an ACTION link (using "Jump to Report") from the first report
> to the second report which sets the parameters(@.EmployeeID & @.OrderDate)
> accordingly. (ie. @.EmployeeID = Fields!EmployeeID.Value; @.OrderDate => Fields!OrderDate.Value. @.EmployeeID is type integer; @.OrderDate is type
> DateTime).
>
> Everything works as expected unless I perform the following steps:
> 1. Run the Report1 (deployed version) [report displays succesfully]
> 2. Click on the action link to jump to Report2 [report displays succesfully]
> 3. Click the "refresh" toolbar button (not Internet Explorer Refresh)
> [ERROR!!]
>
> The Error is:
> Reporting Services Error
> ---
> The value provided for the report parameter 'OrderDate' is not valid for
> its type. (rsReportParameterTypeMismatch) Get Online Help
> ---
>
> Notes:
> --
> 1. If I run Report2 independantly, the refresh button works.
> 2. Everything works from VS.Net "preview" tab. It is only when deployed
> that the error occurs.
> 3. If I set my Internet Explorer language to English(United States) [en-us]
> then the error goes away!
>
> Is this a bug?
>
> Cheers,
> Joe
>