restroing a table to a db from a network drive

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 2000 Forums

SQL Server Administration (2000)

restroing a table to a db from a network drive

Author

Topic

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2007-03-12 : 04:33:17

i have a table that was backup on 1 server and i want to put it on another table under db called DB1.
the problem that on the new server i dont have enough space so i want to put this table on a netwrok drive.
i have defined a netrwork drive for \\server1\db as "P:\"
but when i want to make a restore the sql server dosent see the P drive, and when trying to restore it with relative path : "\\server1\db " it dsoent work either!
any idea?
thnaks in advance
peleg

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

Kristen
Test

22859 Posts

Posted - 2007-03-12 : 08:28:36

Script it from the "other server" and then transfer the data with DTS?

Kristen

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2007-03-12 : 09:21:05

script it?
which "other server do u mean"?
the first server and the second server have no network connection between them.
and the P drive is just a HD on a server on the netwrok withought SQL Machine on it
Peleg

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

Kristen
Test

22859 Posts

Posted - 2007-03-12 : 11:13:22

"script it?"

Use "Generate SQL Script" on the "Source" server to generate the DDL for the table. Run that on the "Target" server to create the table.

"no network connection"

BCP out the data on the Source server (using Native format) and BCP the data in on the Target server's new [empty] table.

You are going to have to do most of this to get the Table out of the backup file and into the Target database anyway.

Kristen

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2007-03-13 : 04:19:33

hi all
i have found this [url]http://www.extremeexperts.com/SQL/Articles/DBCCTraceFlags.aspx[/url]
one of the options says that whne u canhge the trace flag you can run a backup from network drive
i hope it will help some 1 and me too:)
peleg

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources