Home > Archive > MS SQL Server > August 2005 > SQL server









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author SQL server
Dafne

2005-08-31, 8:23 pm

I need help,
I can someone please let me know how can I save a file from the sql to
another drive or directory.
Brian Lawton

2005-08-31, 8:23 pm

Assuming that you mean how to move a database file from one drive to
another, you can use sp_detach_db/sp_attach_db or you can backup you
database and when restoring it, redirect the files to a new location.

--
--Brian
(Please reply to the newsgroups only.)


"Dafne" <sasha203@msn.com(donotspam)> wrote in message
news:4611FCA9-D1E7-4842-810E- 8352AEBC0991@microso
ft.com...
>I need help,
> I can someone please let me know how can I save a file from the sql to
> another drive or directory.



Dafne

2005-08-31, 8:23 pm

Thank you brian I will tried to do it tomorrow in school
--
Sincerely,
Dafne


"Brian Lawton" wrote:

> Assuming that you mean how to move a database file from one drive to
> another, you can use sp_detach_db/sp_attach_db or you can backup you
> database and when restoring it, redirect the files to a new location.
>
> --
> --Brian
> (Please reply to the newsgroups only.)
>
>
> "Dafne" <sasha203@msn.com(donotspam)> wrote in message
> news:4611FCA9-D1E7-4842-810E- 8352AEBC0991@microso
ft.com...
>
>
>

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com