moving a database to a different drive

what is the reccomended method for moving a database to a different drive on
the same computer? Just a backup and restore?
Have a look at
INF: Moving SQL Server Databases to a New Location with Detach/Attach
http://support.microsoft.com/default...;EN-US;q224071
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"djc" <noone@.nowhere.com> wrote in message
news:elhbGfwUEHA.484@.TK2MSFTNGP10.phx.gbl...
> what is the reccomended method for moving a database to a different drive
on
> the same computer? Just a backup and restore?
>
|||Thanks. I will.
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:eC3pXbxUEHA.2844@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Have a look at
> INF: Moving SQL Server Databases to a New Location with Detach/Attach
> http://support.microsoft.com/default...;EN-US;q224071
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "djc" <noone@.nowhere.com> wrote in message
> news:elhbGfwUEHA.484@.TK2MSFTNGP10.phx.gbl...
drive
> on
>

moving a database to a different drive

what is the reccomended method for moving a database to a different drive on
the same computer? Just a backup and restore?Have a look at
INF: Moving SQL Server Databases to a New Location with Detach/Attach
http://support.microsoft.com/defaul...b;EN-US;q224071
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"djc" <noone@.nowhere.com> wrote in message
news:elhbGfwUEHA.484@.TK2MSFTNGP10.phx.gbl...
> what is the reccomended method for moving a database to a different drive
on
> the same computer? Just a backup and restore?
>|||Thanks. I will.
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:eC3pXbxUEHA.2844@.TK2MSFTNGP12.phx.gbl...
> Have a look at
> INF: Moving SQL Server Databases to a New Location with Detach/Attach
> http://support.microsoft.com/defaul...b;EN-US;q224071
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "djc" <noone@.nowhere.com> wrote in message
> news:elhbGfwUEHA.484@.TK2MSFTNGP10.phx.gbl...
drive[vbcol=seagreen]
> on
>

moving a database to a different drive

what is the reccomended method for moving a database to a different drive on
the same computer? Just a backup and restore?Hi,
You could do a backup and restore using the 'WITH MOVE'
OPTION or you could (better use) detach the database, copy
the datafile to new location and attach the database files.
You can look at sp_detach_db and sp_attach_db procedures
in BOL.
hth
DeeJay
>--Original Message--
>what is the reccomended method for moving a database to a
different drive on
>the same computer? Just a backup and restore?
>
>.
>|||ok. I'll check out those procedures in Books Online. Thanks for the input.
"DeeJay Puar" <deejaypuar@.yahoo.com> wrote in message
news:1cc9b01c45309$967fde70$a101280a@.phx.gbl...
> Hi,
> You could do a backup and restore using the 'WITH MOVE'
> OPTION or you could (better use) detach the database, copy
> the datafile to new location and attach the database files.
> You can look at sp_detach_db and sp_attach_db procedures
> in BOL.
> hth
> DeeJay
> >--Original Message--
> >what is the reccomended method for moving a database to a
> different drive on
> >the same computer? Just a backup and restore?
> >
> >
> >.
> >|||Have a look at
INF: Moving SQL Server Databases to a New Location with Detach/Attach
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q224071
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"djc" <noone@.nowhere.com> wrote in message
news:elhbGfwUEHA.484@.TK2MSFTNGP10.phx.gbl...
> what is the reccomended method for moving a database to a different drive
on
> the same computer? Just a backup and restore?
>|||Thanks. I will.
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:eC3pXbxUEHA.2844@.TK2MSFTNGP12.phx.gbl...
> Have a look at
> INF: Moving SQL Server Databases to a New Location with Detach/Attach
> http://support.microsoft.com/default.aspx?scid=kb;EN-US;q224071
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "djc" <noone@.nowhere.com> wrote in message
> news:elhbGfwUEHA.484@.TK2MSFTNGP10.phx.gbl...
> > what is the reccomended method for moving a database to a different
drive
> on
> > the same computer? Just a backup and restore?
> >
> >
>|||Hi,
I will use the detatch/attatch method to move but your reply brings another
question to me. I did not see an option to restore 'WITH MOVE' in enterprise
manager GUI restore... is it only available when using TSQL? The reason I
ask is I had previously done a backup and restore to new database name and
new location in order to quickly create a 'staging' or 'testing' version of
a production database and want to be sure that was ok... meaning I wanted to
verify that I had NOT chosen the 'WITH MOVE' option... I didn't know if it
was a default option. Because, in that case, I wanted the database to be
different... not a move of the real database..
If I actually got a clear question out of that (doubtful ;) ) any info would
be appreciated... I think I'm just being overly paranoid.
"DeeJay Puar" <deejaypuar@.yahoo.com> wrote in message
news:1cc9b01c45309$967fde70$a101280a@.phx.gbl...
> Hi,
> You could do a backup and restore using the 'WITH MOVE'
> OPTION or you could (better use) detach the database, copy
> the datafile to new location and attach the database files.
> You can look at sp_detach_db and sp_attach_db procedures
> in BOL.
> hth
> DeeJay
> >--Original Message--
> >what is the reccomended method for moving a database to a
> different drive on
> >the same computer? Just a backup and restore?
> >
> >
> >.
> >|||The move option is exposed on the right-most tab, where EM specifies the physical file names. In the right
part, just type the desired file name.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"djc" <noone@.nowhere.com> wrote in message news:%23Cj8oj5UEHA.2668@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I will use the detatch/attatch method to move but your reply brings another
> question to me. I did not see an option to restore 'WITH MOVE' in enterprise
> manager GUI restore... is it only available when using TSQL? The reason I
> ask is I had previously done a backup and restore to new database name and
> new location in order to quickly create a 'staging' or 'testing' version of
> a production database and want to be sure that was ok... meaning I wanted to
> verify that I had NOT chosen the 'WITH MOVE' option... I didn't know if it
> was a default option. Because, in that case, I wanted the database to be
> different... not a move of the real database..
> If I actually got a clear question out of that (doubtful ;) ) any info would
> be appreciated... I think I'm just being overly paranoid.
>
> "DeeJay Puar" <deejaypuar@.yahoo.com> wrote in message
> news:1cc9b01c45309$967fde70$a101280a@.phx.gbl...
> > Hi,
> >
> > You could do a backup and restore using the 'WITH MOVE'
> > OPTION or you could (better use) detach the database, copy
> > the datafile to new location and attach the database files.
> >
> > You can look at sp_detach_db and sp_attach_db procedures
> > in BOL.
> >
> > hth
> >
> > DeeJay
> > >--Original Message--
> > >what is the reccomended method for moving a database to a
> > different drive on
> > >the same computer? Just a backup and restore?
> > >
> > >
> > >.
> > >
>

Move RS database to a new computer

we are aware of KB84245 Titled:
"How to move a Reporting Servides database from a computer that is running
Reporting Services to another computer".
this seems rather clear. But I have I a question.
Does this article assume the original DB is on the web server machine, and
if so would these
exact instructions apply to mvoing a database in a multi-tier arrangement.
By which I mean: in our case we have a Web Server and a Database Server.
The Web Server Hosts ReportingSservices and the Database Server hosts the
ReportingService DBs. We are moving our reportingservice DB to a different
database server.
are there additional/different instructions I should follow for a move in a
multi-tier arrangement? Are is this KB good to go for all situations?
thanks.
dlrHi Dennis,
I just successfully moved a RS database to a new server in a 2-tiered
environment, and the MS instructions worked perfectly. I backed up the 2
dbs to files, then restored them to the new db server. Then on the IIS
machine, I used rsconfig utility to reconfigure the db location/connection
info. I moved the reportserver component to a new IIS machine as well, so I
had to backup/restore the encryption keys, too - but I don't think you'll
have to do that, as you're not moving the reportserver.
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]
Dennis Redfield wrote:
> we are aware of KB84245 Titled:
> "How to move a Reporting Servides database from a computer that is
> running Reporting Services to another computer".
> this seems rather clear. But I have I a question.
> Does this article assume the original DB is on the web server
> machine, and if so would these
> exact instructions apply to mvoing a database in a multi-tier
> arrangement.
> By which I mean: in our case we have a Web Server and a Database
> Server. The Web Server Hosts ReportingSservices and the Database
> Server hosts the ReportingService DBs. We are moving our
> reportingservice DB to a different database server.
> are there additional/different instructions I should follow for a
> move in a multi-tier arrangement? Are is this KB good to go for all
> situations?
> thanks.
> dlr|||well i did have problems. I moved the RS databases to a new server (which
was a clean SQL Server install with no prior RS history). and indeed
everything seemed to work fine until I got permission errors when attempting
a snap-shot execution. The problem:
RS creates an RSExecRole in the databases it creates AND in the master
database and adds your connection user to those roles. On the databases
moved to the new server theRSExecRole move along with the restore. The
master database on the new machine is not restored from anywhere, of course,
and thus IT DOES NOT HAVE THE RSExecRole. If you are using the prinicple of
least previlge and use a RS database connection user with few intrinsic
rights you will see the permission error. Solution: manually create the
RSExecRole in "master" and manually add your connection user to this role.
Easy but not fun in a disaster recovery situation.
dlr
"Jake Marx" <msnews@.longhead.com> wrote in message
news:OPxDc7PvEHA.1452@.TK2MSFTNGP11.phx.gbl...
> Hi Dennis,
> I just successfully moved a RS database to a new server in a 2-tiered
> environment, and the MS instructions worked perfectly. I backed up the 2
> dbs to files, then restored them to the new db server. Then on the IIS
> machine, I used rsconfig utility to reconfigure the db location/connection
> info. I moved the reportserver component to a new IIS machine as well, so
I
> had to backup/restore the encryption keys, too - but I don't think you'll
> have to do that, as you're not moving the reportserver.
> --
> Regards,
> Jake Marx
> MS MVP - Excel
> www.longhead.com
> [please keep replies in the newsgroup - email address unmonitored]
>
> Dennis Redfield wrote:
> > we are aware of KB84245 Titled:
> > "How to move a Reporting Servides database from a computer that is
> > running Reporting Services to another computer".
> >
> > this seems rather clear. But I have I a question.
> >
> > Does this article assume the original DB is on the web server
> > machine, and if so would these
> > exact instructions apply to mvoing a database in a multi-tier
> > arrangement.
> >
> > By which I mean: in our case we have a Web Server and a Database
> > Server. The Web Server Hosts ReportingSservices and the Database
> > Server hosts the ReportingService DBs. We are moving our
> > reportingservice DB to a different database server.
> >
> > are there additional/different instructions I should follow for a
> > move in a multi-tier arrangement? Are is this KB good to go for all
> > situations?
> >
> > thanks.
> >
> > dlr
>

move report to other machine

Hi,
How can I move a report I developed in my computer (in Reporting Services
for SQL Server 2000) to another computer that already has SQL Server 2000
and Reporting Services installed?
Is it with Import/Export, generated scripts, ... ?
Thanks,
Nuno MachadoCopy your RDL file from your computer, to the other computer.
Go to Report Manager on the other computer, and click on the Upload File
button.
Find your RDL file where you copied it to and upload it.
Try your report.
You might have to create new datasources on the other report server. Just
copy whatever settings you have on the first one and do any adjustments you
need to do.
If you can access the other server from your computer (type in
http://whatever/reportserver ), then you don't have to copy the file, just
upload it from your web page. Or try deploying it directly through Visual
Studio, if you have the right access rights.
Kaisa M: Lindahl
"Nuno Machado" <nuno.machado@.vpconsulting.pt> wrote in message
news:er%23rSxCHGHA.1180@.TK2MSFTNGP09.phx.gbl...
> Hi,
> How can I move a report I developed in my computer (in Reporting Services
> for SQL Server 2000) to another computer that already has SQL Server 2000
> and Reporting Services installed?
> Is it with Import/Export, generated scripts, ... ?
> Thanks,
> Nuno Machado
>

Move databases between local drives ?

How can I move a database between local drives or paths on
the same computer that is running sql server?Backup the database, do a test restore.
Either
detach the database (sp_detach_db)
move the files
attach the database (sp_attach_db)
or
drop the database
restore from backup with move.|||Oops - duplicate post.