| Author |
Restoring a database in sql 2005
|
|
|
| hi,
I have question for restoring a database in sql 2005. After I clicked
restore from device. I need to restore a db from \\abc\backup\dd.bak.
a Network location. I need to type it the path myself. Sql 2005 doesn't have
option for me to type my own path for restoring file. Maybe I don't know
how?
Any ideas.
Thanks.
| |
| Tracy McKibben 2006-10-24, 6:38 pm |
| mecn wrote:
> hi,
>
> I have question for restoring a database in sql 2005. After I clicked
> restore from device. I need to restore a db from \\abc\backup\dd.bak.
> a Network location. I need to type it the path myself. Sql 2005 doesn't have
> option for me to type my own path for restoring file. Maybe I don't know
> how?
>
> Any ideas.
>
> Thanks.
>
>
If all else fails, use the RESTORE DATABASE command...
--
Tracy McKibben
MCDBA
http://www.realsqlguy.com
| |
|
| Hi,
It might be because the Service account you use to start SQL Server
with does not have access to that network location.
You can use "net use" statements to configure access for the same.
But if you are sure your SQL has access to that network location then
try using the Restore command from Query Analyzer.
KArt
mecn wrote:
> hi,
>
> I have question for restoring a database in sql 2005. After I clicked
> restore from device. I need to restore a db from \\abc\backup\dd.bak.
> a Network location. I need to type it the path myself. Sql 2005 doesn't have
> option for me to type my own path for restoring file. Maybe I don't know
> how?
>
> Any ideas.
>
> Thanks.
| |
| soonyu 2006-10-24, 6:38 pm |
| make sure sql agent service not logon as Local system account if you want
restore from network location as well. Use domain user account instead.
Cheers,
"mecn" wrote:
> hi,
>
> I have question for restoring a database in sql 2005. After I clicked
> restore from device. I need to restore a db from \\abc\backup\dd.bak.
> a Network location. I need to type it the path myself. Sql 2005 doesn't have
> option for me to type my own path for restoring file. Maybe I don't know
> how?
>
> Any ideas.
>
> Thanks.
>
>
>
| |
| Tibor Karaszi 2006-10-24, 6:38 pm |
| It isn't Agent doing the reading of the files. It is SQL Server service account that need
permissions in the share.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
"soonyu" <soonyu@discussions.microsoft.com> wrote in message
news:B453C314-10ED-4BA4-8B28- DEA14125A5EF@microso
ft.com...[color=darkred]
> make sure sql agent service not logon as Local system account if you want
> restore from network location as well. Use domain user account instead.
>
> Cheers,
>
> "mecn" wrote:
>
| |
|
| Thanks everyone for help.
Sql agent service (same as other services) running under windows acct.
When I do the restore from device, the select path box is grayed out. Don't
know why?
Thanks
"mecn" <mecn2002@yahoo.com> wrote in message
news:eVMNQ8u8GHA.4808@TK2MSFTNGP03.phx.gbl...
> hi,
>
> I have question for restoring a database in sql 2005. After I clicked
> restore from device. I need to restore a db from \\abc\backup\dd.bak.
> a Network location. I need to type it the path myself. Sql 2005 doesn't
> have option for me to type my own path for restoring file. Maybe I don't
> know how?
>
> Any ideas.
>
> Thanks.
>
|
|
|
|