| Author |
restore db from device in sql2005
|
|
|
| Need to restore the db from network location.
After I click restore from device. The select path box is grayed out. I
could not type the network path.
(I know i could restore it in query analyzer by using restore code.)
Any ideas?
Thanks
| |
| Tibor Karaszi 2006-10-24, 6:38 pm |
| Did you press the ... button to the right of that text box?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
"mecn" <mecn2002@yahoo.com> wrote in message news:ud2imO78GHA.4224@TK2MSFTNGP02.phx.gbl...
> Need to restore the db from network location.
> After I click restore from device. The select path box is grayed out. I
> could not type the network path.
> (I know i could restore it in query analyzer by using restore code.)
> Any ideas?
>
> Thanks
>
>
| |
|
| I did, Just let you select local divers only
"Tibor Karaszi" <tibor_please.no. email_karaszi@hotmai
l.nomail.com> wrote in
message news:%23mgSe1B9GHA.3916@TK2MSFTNGP04.phx.gbl...[color=darkred]
> Did you press the ... button to the right of that text box?
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www. solidqualitylearning
.com/
>
>
> "mecn" <mecn2002@yahoo.com> wrote in message
> news:ud2imO78GHA.4224@TK2MSFTNGP02.phx.gbl...
| |
| Tracy McKibben 2006-10-24, 6:38 pm |
| mecn wrote:
> I did, Just let you select local divers only
>
Correct, you can't point/click to a network path, but you can TYPE the
path into the filename field on that same window...
--
Tracy McKibben
MCDBA
http://www.realsqlguy.com
| |
|
| The problem is I could not. The box is grayed out.
"Tracy McKibben" <tracy@realsqlguy.com> wrote in message
news:4538D8BB.7050509@realsqlguy.com...
> mecn wrote:
>
> Correct, you can't point/click to a network path, but you can TYPE the
> path into the filename field on that same window...
>
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
| |
|
| I couldn't type. Is it sort of permission issue?
Thanks
"Tracy McKibben" <tracy@realsqlguy.com> wrote in message
news:4538D8BB.7050509@realsqlguy.com...
> mecn wrote:
>
> Correct, you can't point/click to a network path, but you can TYPE the
> path into the filename field on that same window...
>
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
| |
|
| sorry. you are saying that I could type the network path in to the file name
box?
i.e. \\network\servover\d
ir\abc.bak?
Thanks
"Tracy McKibben" <tracy@realsqlguy.com> wrote in message
news:4538D8BB.7050509@realsqlguy.com...
> mecn wrote:
>
> Correct, you can't point/click to a network path, but you can TYPE the
> path into the filename field on that same window...
>
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
| |
|
| I don't think taht you could type the path and file name into filename box.
Filename box is only for file name like abc.bak. right?!
"Tracy McKibben" <tracy@realsqlguy.com> wrote in message
news:4538D8BB.7050509@realsqlguy.com...
> mecn wrote:
>
> Correct, you can't point/click to a network path, but you can TYPE the
> path into the filename field on that same window...
>
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
| |
|
| I am sorry, you are right!!!! I could type the network path into file name
box and it works----------------THANK YOU VERY MUCH!!!@!!
"Tracy McKibben" <tracy@realsqlguy.com> wrote in message
news:4538D8BB.7050509@realsqlguy.com...
> mecn wrote:
>
> Correct, you can't point/click to a network path, but you can TYPE the
> path into the filename field on that same window...
>
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
| |
| Tracy McKibben 2006-10-24, 6:38 pm |
| mecn wrote:
> I am sorry, you are right!!!! I could type the network path into file name
> box and it works----------------THANK YOU VERY MUCH!!!@!!
>
Great... Now that you've accomplished that, can you explain why this
was easier than just issuing the RESTORE DATABASE command in a query window?
--
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|
|
|
|