Re: Move SQL databases?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Nick Hill (nick_at_mailboxisinvalid.net)
Date: 02/23/05 

Date: Wed, 23 Feb 2005 08:30:30 -0000

OK thank you David

I will read it again more carefully!

Regards
Nick

"David Copeland [MSFT]" <davidcop@online.microsoft.com> wrote in message
news:OcitPaDGFHA.3596@TK2MSFTNGP12.phx.gbl...
> Nick,
>
> Actually it does.. it should discuss using the sp_detach_db and
> sp_attach_db commands from OSQL.
> Page 12 begins discussing moving the SharePoint databases
> Page 14 beings dicussing moving the SBSMonitoring database.
>
> --
>
> Hope that helps,
> David Copeland
> Microsoft Small Business Server Support
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> Newsgroups:
> SBS v4.x : microsoft.public.backoffice.smallbiz
> SBS 2000: microsoft.public.backoffice.smallbiz2000
> SBS 2003: microsoft.public.windows.server.sbs
>
>
> "Nick Hill" <nick@mailboxisinvalid.net> wrote in message
> news:cvd13f$4hj$1$8300dec7@news.demon.co.uk...
>> Thanks David
>>
>> I checked the whotepaper but it does not cover SQL databases.
>>
>> Regards
>> Nick
>>
>>
>> "David Copeland [MSFT]" <davidcop@online.microsoft.com> wrote in message
>> news:OjT7fUQFFHA.3416@TK2MSFTNGP09.phx.gbl...
>>> Nick,
>>>
>>> Might want to check out the following whitepaper which discusses the
>>> steps James outlined and more..
>>>
>>> http://www.microsoft.com/windowsserver2003/sbs/techinfo/productdoc/default.mspx
>>>
>>> Moving Data Folders for Windows Small Business Server 2003
>>>
>>> Follow these instructions to move one or all of the Windows Small
>>> Business Server 2003 data folders.
>>>
>>>
>>> --
>>>
>>> Hope that helps,
>>> David Copeland
>>> Microsoft Small Business Server Support
>>>
>>> This posting is provided "AS IS" with no warranties, and confers no
>>> rights.
>>>
>>> Newsgroups:
>>> SBS v4.x : microsoft.public.backoffice.smallbiz
>>> SBS 2000: microsoft.public.backoffice.smallbiz2000
>>> SBS 2003: microsoft.public.windows.server.sbs
>>>
>>>
>>> "Nick Hill" <nick@mailboxisinvalid.net> wrote in message
>>> news:cv1suv$dep$1$8300dec7@news.demon.co.uk...
>>>> Hi
>>>>
>>>> I have a customer who is upgrading from SBS2000 to SBS2003. They have
>>>> several SQL databases & as I'm not experienced with SQL, I suggested
>>>> that they use a specialist to transfer the databases. The customer
>>>> however has asked if I can transfer the databases just by using backup
>>>> & restore.
>>>>
>>>> The new SBS2003 will be built on a new server & data transferred across
>>>> from the old server. Is there some way that I can easily move the
>>>> current SQL databases?
>>>>
>>>> Regards
>>>> Nick
>>>>
>>>
>>>
>>
>>
>
>

Relevant Pages