Not sure what you mean by root databases but a SQL Server
backup is an online operation so no databases will be
offline. While restoring a database, the database being
restored is not accessible.
How are you trying to copy the databases - what steps are
you using? When you say it won't copy, do you have some
specific error numbers and error messages that come up?
Backup and restore is a relatively easy way to get a copy of
a database to another location.
-Sue
On 17 Jul 2006 10:23:55 -0700, "Thanas"
[quoted text, click to view] <atsioplakis@gmail.com> wrote:
>Will a backup/restore cause the root database to go offline?
>
>The strange thing Arnie is that I know the SQL Server Express is set up
>for remote connection but for some reason it won't copy through
>Management Studio.
>
>Arnie Rowland wrote:
>> Yes. You may have to use the Surace Area Configuration Tool to enable Remote
>> Connections.
>>
>> The best way to get a copy is to Backup/Restore.
>>
>> --
>> Arnie Rowland
>> "To be successful, your heart must accompany your knowledge."
>>
>>
>>
>> "Thanas" <atsioplakis@gmail.com> wrote in message
>> news:1153152610.699659.263260@m73g2000cwd.googlegroups.com...
>> > Can SQL Server Express accept remote connections? If so how?
>> >
>> > I am trying to copy a database from our main SQL Server 2005 database
>> > to a laptop that is housing a SQL Server Express.
>> >
>> > If anyone knows of a better method on how to get a copy to a SQL Server
>> > Express that would be great.
>> >
>> > -Thanas
>> >
>> > Thanks for the help in advance.
>> >
