Move sql 2005 ee db to new server without disk access?

Is there any reasonably simple way to install the mdf and ldf files for a sq
l
server 2005 ee database on a server where one does not have access to the da
ta
folder of the sql server? IE using the ee management studio from a workstati
on?On Feb 12, 12:19 pm, "ms" <m...@.ms.ms> wrote:[vbcol=seagreen]
> Is there any reasonably simple way to install the mdf and ldf files for a
sql
> server 2005 ee database on a server where one does not have access to the
data
> folder of the sql server? IE using the ee management studio from a workstation?[/v
bcol]
Does the SQL Server service account have access to the new location?
You could try using xp_cmdshell to execute OS commands to copy the mdf/
ldf files. Detach the DB, copy with xp_cmdshell, the reattach.|||On 12/02/2007 "Tracy McKibben" <tracy.mckibben@.gmail.com> wrote:
>On Feb 12, 12:19 pm, "ms" <m...@.ms.ms> wrote:
data[vbcol=seagreen]
workstation?[vbcol=seagreen]
>Does the SQL Server service account have access to the new location?
>You could try using xp_cmdshell to execute OS commands to copy the mdf/
>ldf files. Detach the DB, copy with xp_cmdshell, the reattach.
>
Thanks Tracey, that might be possible, I'll check.

Move sql 2005 ee db to new server without disk access?

Is there any reasonably simple way to install the mdf and ldf files for a sql
server 2005 ee database on a server where one does not have access to the data
folder of the sql server? IE using the ee management studio from a workstation?
On Feb 12, 12:19 pm, "ms" <m...@.ms.ms> wrote:
> Is there any reasonably simple way to install the mdf and ldf files for a sql
> server 2005 ee database on a server where one does not have access to the data
> folder of the sql server? IE using the ee management studio from a workstation?
Does the SQL Server service account have access to the new location?
You could try using xp_cmdshell to execute OS commands to copy the mdf/
ldf files. Detach the DB, copy with xp_cmdshell, the reattach.
|||On 12/02/2007 "Tracy McKibben" <tracy.mckibben@.gmail.com> wrote:[vbcol=seagreen]
>On Feb 12, 12:19 pm, "ms" <m...@.ms.ms> wrote:
data[vbcol=seagreen]
workstation?
>Does the SQL Server service account have access to the new location?
>You could try using xp_cmdshell to execute OS commands to copy the mdf/
>ldf files. Detach the DB, copy with xp_cmdshell, the reattach.
>
Thanks Tracey, that might be possible, I'll check.

Move sql 2005 ee db to new server without disk access?

Is there any reasonably simple way to install the mdf and ldf files for a sql
server 2005 ee database on a server where one does not have access to the data
folder of the sql server? IE using the ee management studio from a workstation?On Feb 12, 12:19 pm, "ms" <m...@.ms.ms> wrote:
> Is there any reasonably simple way to install the mdf and ldf files for a sql
> server 2005 ee database on a server where one does not have access to the data
> folder of the sql server? IE using the ee management studio from a workstation?
Does the SQL Server service account have access to the new location?
You could try using xp_cmdshell to execute OS commands to copy the mdf/
ldf files. Detach the DB, copy with xp_cmdshell, the reattach.|||On 12/02/2007 "Tracy McKibben" <tracy.mckibben@.gmail.com> wrote:
>On Feb 12, 12:19 pm, "ms" <m...@.ms.ms> wrote:
>> Is there any reasonably simple way to install the mdf and ldf files for a sql
>> server 2005 ee database on a server where one does not have access to the
data
>> folder of the sql server? IE using the ee management studio from a
workstation?
>Does the SQL Server service account have access to the new location?
>You could try using xp_cmdshell to execute OS commands to copy the mdf/
>ldf files. Detach the DB, copy with xp_cmdshell, the reattach.
>
Thanks Tracey, that might be possible, I'll check.

move db Win2000 SQL2000sp2 to Server 2003 sp3a

On my current install of Win 2000 Sql Server sp2 I tried to install sp3a. A
fter repeated attempts the server did not update. I got no errors and it lo
oked like it had installed on the default database but every time I check th
e version, I was on sp2. S
o now I have a new server with Server 2003 installed and will be moving my d
atabases over there. So I have installed Sql Server 2000 sp2. I will then
be installing sp3a. Will there be any problems with restoring the master, t
emp, and all over databases
from Win 2000 sp2 server TO Server 2003 sp3a server?
Thanks for any guidance you can provide.I would have thought doing this would be a bad idea, as the restored master,
temp, msdb db's etc would be a different version to most of the server.
You are probably better off trying to update it after restoring your dbs.
Cheers,
James Goodman MCSE, MCDBA
http://www.angelfire.com/sports/f1pictures|||Can not really do that because Server 2003 needs to have Sql Server 2000 sp3
a installed.

move db Win2000 SQL2000sp2 to Server 2003 sp3a

On my current install of Win 2000 Sql Server sp2 I tried to install sp3a. After repeated attempts the server did not update. I got no errors and it looked like it had installed on the default database but every time I check the version, I was on sp2. So now I have a new server with Server 2003 installed and will be moving my databases over there. So I have installed Sql Server 2000 sp2. I will then be installing sp3a. Will there be any problems with restoring the master, temp, and all over databases from Win 2000 sp2 server TO Server 2003 sp3a server?
Thanks for any guidance you can provide.I would have thought doing this would be a bad idea, as the restored master,
temp, msdb db's etc would be a different version to most of the server.
You are probably better off trying to update it after restoring your dbs.
Cheers,
James Goodman MCSE, MCDBA
http://www.angelfire.com/sports/f1pictures|||Can not really do that because Server 2003 needs to have Sql Server 2000 sp3a installed.

Ms Reporting Services install

Where can I find the Reporting Service setup ?
Is it linked to a particular version of SQLServer 2000 (Standard...)
On the CD ?SQL Server 2000 Reporting Services is not a part of a SQL installation, it comes on different CD. It also comes in different edditions (Standard, Advanced, Development...).|||HI ,

To have it function properly ,you will need visual studio.net 2003

MS Reporting Services

I want to install reporting services. Where can I get a copy? Thanks.for SQL Server 2000

othellomy@.yahoo.com wrote:

Quote:

Originally Posted by

I want to install reporting services. Where can I get a copy? Thanks.

|||Forget it. I tried to install it after downloading. It asks for too
many things (IIS, ASP net, .net blah blah blah) and at the end asks for
service pack 3. I am not going to install Microsoft Software after this
experience (any software). Enough.

othellomy@.yahoo.com wrote:

Quote:

Originally Posted by

for SQL Server 2000
>
othellomy@.yahoo.com wrote:

Quote:

Originally Posted by

I want to install reporting services. Where can I get a copy? Thanks.

|||On 16 Jan 2007 01:16:36 -0800, othellomy@.yahoo.com wrote:

Quote:

Originally Posted by

>Forget it. I tried to install it after downloading. It asks for too
>many things (IIS, ASP net, .net blah blah blah) and at the end asks for
>service pack 3. I am not going to install Microsoft Software after this
>experience (any software). Enough.
>
>othellomy@.yahoo.com wrote:

Quote:

Originally Posted by

>for SQL Server 2000
>>
>othellomy@.yahoo.com wrote:

Quote:

Originally Posted by

I want to install reporting services. Where can I get a copy? Thanks.

Yes, it uses IIS as the presentation layer. Why would you write a new
one when a good one already exists?