Moving the ReportServer database

I want to move the ReportServer database .mdf and .ldf files from the default directory to another drive (E:)

The ReportServer service is started, but when I run a sp_help_db from SQL Server management studio the ReportServer database is not listed. When I tried to detach it using sp_detach_db , the command reported succes but I'm wondering how this worked when the database is not in the sysdatabases table.

I haven't tried moving the ReportServerTempdb but I imagine that this would be ok, because this is in sysdatabases.

I can't seem to find anything in BOL about moving just the ReportServer database itself , anyone else come across this?

Thanks!

sp_helpdb will only return databases you have access to, so that may be part of it...also won't return databases that are offline and some other things, so not sure if that might be what you are seeing....

As for moving the database files, the RS catalog DB and RSTempDB's are just like any other user database, you can move the data files wherever you like, so long as SQL Server can see them. Note that the ReportServer service does not necessarily have to be running in order to see/move/modify/etc. the RS databases in SQL Server. The ReportServer service is simply a consumer of the SQL Server services to provide data storage in the RS and RSTempDB databases, that's all.

HTH,

|||

Thanks.

I'm using the sa login, so I would expect to be able to see it. There is nothing in sys.master_files for the ReportServer database and it does not show up in the list of databases in the management studio.

I haven't actually configured Reporting Services yet, only installed it. Is it possible that the database is not listed or attached until reporting services is up and running?

Cheers

Moving the ASPNETDB.MDF file to another computer

Hi all!

I have some problems with asp.net windows authentication.
Asp made the file ASPNETDB.MDF. But I dont have SQL Server on the machine where the application will be deployed...
So I have to move this file to another server, but I couldnt find any information about ASPNETDB.MDF connection string or somenthing like this.
Is it possible to move this file or I have to make the authentication on my own, with my own database? I hope there is a solution to this problem!
Many thanks! Regards!

Certainly there is The connection string can be found somewhere, check this article:

http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx

Moving SQL 2000 to different Drive

Hello All,
Please help. I have installed my SQL on an old powervault and needed to move
it to a new CX300. The mdf files are installed on F:\Microsoft SQL
Server\MSSQL\Data and the ldf files on G:\Microsoft SQL Server\MSSQL\Data
drive. I stopped all SQL services and copied data to new H and I drives, then
shutdown F and G drives. I renamed H and I to F and G and reboot. My problem
is that after the sever rebooted the SQL services won't start. I got an
error: the system cannot find the path specified. Any idea?
Thanks.
Put everything back to where you had it. Then read about sp_detach/
sp_attach in BOL.
"David" <David@.discussions.microsoft.com> wrote in message
news:015636D7-EAB9-40D4-8F4F-BC8F3C7668D8@.microsoft.com...
> Hello All,
> Please help. I have installed my SQL on an old powervault and needed to
move
> it to a new CX300. The mdf files are installed on F:\Microsoft SQL
> Server\MSSQL\Data and the ldf files on G:\Microsoft SQL Server\MSSQL\Data
> drive. I stopped all SQL services and copied data to new H and I drives,
then
> shutdown F and G drives. I renamed H and I to F and G and reboot. My
problem
> is that after the sever rebooted the SQL services won't start. I got an
> error: the system cannot find the path specified. Any idea?
> Thanks.
|||Hi David,
(1) Use sp_detach_db
(2) Copy .mdf and .ldf files to the new drive
(3) Use sp_attach_db by specifying the new location
Thanks
GYK
|||Thanks for Reply,
Do I have to deal with any SQL installation files on the old F and G drives?
For example the bin folder also installed on F drive.
Thanks.
"ChrisR" wrote:

> Put everything back to where you had it. Then read about sp_detach/
> sp_attach in BOL.
>
> "David" <David@.discussions.microsoft.com> wrote in message
> news:015636D7-EAB9-40D4-8F4F-BC8F3C7668D8@.microsoft.com...
> move
> then
> problem
>
>
|||Chris,
Where did you install SQL Server? If on the old drives, you'll need to
reinstall it on the new drives.
Ron
Ron Talmage
SQL Server MVP
"David" <David@.discussions.microsoft.com> wrote in message
news:B89C0CF2-C9DA-4EEB-9D68-DBCBDA49A6FD@.microsoft.com...
> Thanks for Reply,
> Do I have to deal with any SQL installation files on the old F and G
drives?[vbcol=seagreen]
> For example the bin folder also installed on F drive.
> Thanks.
> "ChrisR" wrote:
to[vbcol=seagreen]
Server\MSSQL\Data[vbcol=seagreen]
drives,[vbcol=seagreen]
an[vbcol=seagreen]

Moving SQL 2000 to different Drive

Hello All,
Please help. I have installed my SQL on an old powervault and needed to move
it to a new CX300. The mdf files are installed on F:\Microsoft SQL
Server\MSSQL\Data and the ldf files on G:\Microsoft SQL Server\MSSQL\Data
drive. I stopped all SQL services and copied data to new H and I drives, then
shutdown F and G drives. I renamed H and I to F and G and reboot. My problem
is that after the sever rebooted the SQL services won't start. I got an
error: the system cannot find the path specified. Any idea?
Thanks.Put everything back to where you had it. Then read about sp_detach/
sp_attach in BOL.
"David" <David@.discussions.microsoft.com> wrote in message
news:015636D7-EAB9-40D4-8F4F-BC8F3C7668D8@.microsoft.com...
> Hello All,
> Please help. I have installed my SQL on an old powervault and needed to
move
> it to a new CX300. The mdf files are installed on F:\Microsoft SQL
> Server\MSSQL\Data and the ldf files on G:\Microsoft SQL Server\MSSQL\Data
> drive. I stopped all SQL services and copied data to new H and I drives,
then
> shutdown F and G drives. I renamed H and I to F and G and reboot. My
problem
> is that after the sever rebooted the SQL services won't start. I got an
> error: the system cannot find the path specified. Any idea?
> Thanks.|||Hi David,
(1) Use sp_detach_db
(2) Copy .mdf and .ldf files to the new drive
(3) Use sp_attach_db by specifying the new location
--
Thanks
GYK|||Thanks for Reply,
Do I have to deal with any SQL installation files on the old F and G drives?
For example the bin folder also installed on F drive.
Thanks.
"ChrisR" wrote:
> Put everything back to where you had it. Then read about sp_detach/
> sp_attach in BOL.
>
> "David" <David@.discussions.microsoft.com> wrote in message
> news:015636D7-EAB9-40D4-8F4F-BC8F3C7668D8@.microsoft.com...
> > Hello All,
> >
> > Please help. I have installed my SQL on an old powervault and needed to
> move
> > it to a new CX300. The mdf files are installed on F:\Microsoft SQL
> > Server\MSSQL\Data and the ldf files on G:\Microsoft SQL Server\MSSQL\Data
> > drive. I stopped all SQL services and copied data to new H and I drives,
> then
> > shutdown F and G drives. I renamed H and I to F and G and reboot. My
> problem
> > is that after the sever rebooted the SQL services won't start. I got an
> > error: the system cannot find the path specified. Any idea?
> >
> > Thanks.
>
>|||Chris,
Where did you install SQL Server? If on the old drives, you'll need to
reinstall it on the new drives.
Ron
--
Ron Talmage
SQL Server MVP
"David" <David@.discussions.microsoft.com> wrote in message
news:B89C0CF2-C9DA-4EEB-9D68-DBCBDA49A6FD@.microsoft.com...
> Thanks for Reply,
> Do I have to deal with any SQL installation files on the old F and G
drives?
> For example the bin folder also installed on F drive.
> Thanks.
> "ChrisR" wrote:
> > Put everything back to where you had it. Then read about sp_detach/
> > sp_attach in BOL.
> >
> >
> > "David" <David@.discussions.microsoft.com> wrote in message
> > news:015636D7-EAB9-40D4-8F4F-BC8F3C7668D8@.microsoft.com...
> > > Hello All,
> > >
> > > Please help. I have installed my SQL on an old powervault and needed
to
> > move
> > > it to a new CX300. The mdf files are installed on F:\Microsoft SQL
> > > Server\MSSQL\Data and the ldf files on G:\Microsoft SQL
Server\MSSQL\Data
> > > drive. I stopped all SQL services and copied data to new H and I
drives,
> > then
> > > shutdown F and G drives. I renamed H and I to F and G and reboot. My
> > problem
> > > is that after the sever rebooted the SQL services won't start. I got
an
> > > error: the system cannot find the path specified. Any idea?
> > >
> > > Thanks.
> >
> >
> >

Moving SQL 2000 to different Drive

Hello All,
Please help. I have installed my SQL on an old powervault and needed to move
it to a new CX300. The mdf files are installed on F:\Microsoft SQL
Server\MSSQL\Data and the ldf files on G:\Microsoft SQL Server\MSSQL\Data
drive. I stopped all SQL services and copied data to new H and I drives, the
n
shutdown F and G drives. I renamed H and I to F and G and reboot. My problem
is that after the sever rebooted the SQL services won't start. I got an
error: the system cannot find the path specified. Any idea?
Thanks.Put everything back to where you had it. Then read about sp_detach/
sp_attach in BOL.
"David" <David@.discussions.microsoft.com> wrote in message
news:015636D7-EAB9-40D4-8F4F-BC8F3C7668D8@.microsoft.com...
> Hello All,
> Please help. I have installed my SQL on an old powervault and needed to
move
> it to a new CX300. The mdf files are installed on F:\Microsoft SQL
> Server\MSSQL\Data and the ldf files on G:\Microsoft SQL Server\MSSQL\Data
> drive. I stopped all SQL services and copied data to new H and I drives,
then
> shutdown F and G drives. I renamed H and I to F and G and reboot. My
problem
> is that after the sever rebooted the SQL services won't start. I got an
> error: the system cannot find the path specified. Any idea?
> Thanks.|||Hi David,
(1) Use sp_detach_db
(2) Copy .mdf and .ldf files to the new drive
(3) Use sp_attach_db by specifying the new location
Thanks
GYK|||Thanks for Reply,
Do I have to deal with any SQL installation files on the old F and G drives?
For example the bin folder also installed on F drive.
Thanks.
"ChrisR" wrote:

> Put everything back to where you had it. Then read about sp_detach/
> sp_attach in BOL.
>
> "David" <David@.discussions.microsoft.com> wrote in message
> news:015636D7-EAB9-40D4-8F4F-BC8F3C7668D8@.microsoft.com...
> move
> then
> problem
>
>|||Chris,
Where did you install SQL Server? If on the old drives, you'll need to
reinstall it on the new drives.
Ron
--
Ron Talmage
SQL Server MVP
"David" <David@.discussions.microsoft.com> wrote in message
news:B89C0CF2-C9DA-4EEB-9D68-DBCBDA49A6FD@.microsoft.com...
> Thanks for Reply,
> Do I have to deal with any SQL installation files on the old F and G
drives?[vbcol=seagreen]
> For example the bin folder also installed on F drive.
> Thanks.
> "ChrisR" wrote:
>
to[vbcol=seagreen]
Server\MSSQL\Data[vbcol=seagreen]
drives,[vbcol=seagreen]
an[vbcol=seagreen]

Moving production server to new box

I'm moving my prod server to a new box. Is the plan below
workable ?
I install the new server at the same SP level as the old
server.
I copy the mdf and ldf files to the new location.
I over write the mdf and ldf files for master with the old
servers copy.
I restart the server.
Since the directory structure is different, I assume that
master will come up but other db's will be suspect.
I update sysdatbases to point to the correct path for the
user databases.
I restart the server.
Is this too simplistic 'Please read this article, and do not move or overwrite MDF/LDF files with
the server shut down!:
http://support.microsoft.com/?kbid=224071
"Jack A" <anonymous@.discussions.microsoft.com> wrote in message
news:1411901c41370$84d51b00$a301280a@.phx
.gbl...
> I'm moving my prod server to a new box. Is the plan below
> workable ?
> I install the new server at the same SP level as the old
> server.
> I copy the mdf and ldf files to the new location.
> I over write the mdf and ldf files for master with the old
> servers copy.
> I restart the server.
> Since the directory structure is different, I assume that
> master will come up but other db's will be suspect.
> I update sysdatbases to point to the correct path for the
> user databases.
> I restart the server.
> Is this too simplistic '
>|||A silly question but why not just use the Copy Database Wizard ?
http://msdn.microsoft.com/library/d...>
wiz_0z50.asp
J
-- Jack A wrote: --
I'm moving my prod server to a new box. Is the plan below
workable ?
I install the new server at the same SP level as the old
server.
I copy the mdf and ldf files to the new location.
I over write the mdf and ldf files for master with the old
servers copy.
I restart the server.
Since the directory structure is different, I assume that
master will come up but other db's will be suspect.
I update sysdatbases to point to the correct path for the
user databases.
I restart the server.
Is this too simplistic '|||Can i use this to move from a Sql 7 to Sql 2000. How do I
start the wizard. Cant find it anywhere in the interface.
>--Original Message--
>A silly question but why not just use the Copy Database
Wizard ?
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/adminsql/ad_onmigwiz_0z50.asp
>J
> -- Jack A wrote: --
> I'm moving my prod server to a new box. Is the plan
below
> workable ?
> I install the new server at the same SP level as the
old
> server.
> I copy the mdf and ldf files to the new location.
> I over write the mdf and ldf files for master with
the old
> servers copy.
> I restart the server.
> Since the directory structure is different, I assume
that
> master will come up but other db's will be suspect.
> I update sysdatbases to point to the correct path
for the
> user databases.
> I restart the server.
> Is this too simplistic '
>
>.
>|||The problem is if you have different path for the system databases. Move mas
ter and when you then start SQL
Server, it will look for model and tempdb in the *old* path, which might not
exists and SQL Server will not
start if it can't find these databases...
Moving SQL Server Databases
http://www.support.microsoft.com/?id=224071
Moving Databases between Servers
http://www.support.microsoft.com/?id=314546
Using WITH MOVE in a Restore to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Mapping Logins & SIDs after a Restore
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
How to Resolve Permission Issues When a Database Is Moved Between SQL Server
s
http://www.support.microsoft.com/?id=240872
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
Disaster Recovery Articles for SQL Server
http://www.support.microsoft.com/?id=307775
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Jack A" <anonymous@.discussions.microsoft.com> wrote in message
news:1411901c41370$84d51b00$a301280a@.phx
.gbl...
> I'm moving my prod server to a new box. Is the plan below
> workable ?
> I install the new server at the same SP level as the old
> server.
> I copy the mdf and ldf files to the new location.
> I over write the mdf and ldf files for master with the old
> servers copy.
> I restart the server.
> Since the directory structure is different, I assume that
> master will come up but other db's will be suspect.
> I update sysdatbases to point to the correct path for the
> user databases.
> I restart the server.
> Is this too simplistic '
>|||HI
SQL 2000 Enterprise Manager: click 'Run a Wizard' button (or tools menu - Wi
zards...). Expand 'Management' and select 'Copy Database Wizard'.
Select a Source Server: Your old SQL 7.0 server. ...
-- Jack A wrote: --
Can i use this to move from a Sql 7 to Sql 2000. How do I
start the wizard. Cant find it anywhere in the interface.
>--Original Message--
>A silly question but why not just use the Copy Database
Wizard ?
url=/library/en-us/adminsql/ad_onmigwiz_0z50.asp
below
> workable ?
old
> server.
> I over write the mdf and ldf files for master with
the old
> servers copy.
> I restart the server.
> Since the directory structure is different, I assume
that
> master will come up but other db's will be suspect.
> I update sysdatbases to point to the correct path
for the
> user databases.
> I restart the server.
>

moving mdf files

hi all,
could someone help me out on this question? i have a database made up of 3
.mdf files. the files are all on the same drive of a raid 10 so we need to
move them to different drives, as it is obvious that we are not taking
advantage of the hardware. how do i move the mdf files? what is the best
possible way since the db is relativly big and the time frame we have to
make this movement is small?
thanks in advance.
hector quintanillai am sorry for answering my own post, but i didn't see this part while
reading BoL:
If the database you are moving has additional data or log files, specify all
of them in a comma-delimited list in the sp_attach_db stored procedure. The
sp_detach_db procedure does not change no matter how many files the database
contains because it does not list them.
thanks and sorry!
"hector quintanilla" <hquintanilla@.cyberworksNOSPAM.com.mx> wrote in message
news:erashzznDHA.2652@.TK2MSFTNGP09.phx.gbl...
> hi all,
> could someone help me out on this question? i have a database made up of
3
> .mdf files. the files are all on the same drive of a raid 10 so we need
to
> move them to different drives, as it is obvious that we are not taking
> advantage of the hardware. how do i move the mdf files? what is the best
> possible way since the db is relativly big and the time frame we have to
> make this movement is small?
> thanks in advance.
> hector quintanilla
>|||Hi Hector.
Nothing to be sorry about!
If it's ok to take the database offline during the move, then using
sp_detach_db etc is an ok approach. There's a limit of 16 files with that
approach, but you're no-where near that.
There are also other options to do this online if needed, although they may
be slower & it sounds like you're probably ok with going offline anway.
Regards,
Greg Linwood
SQL Server MVP
"hector quintanilla" <hquintanilla@.cyberworksNOSPAM.com.mx> wrote in message
news:uCpbs9znDHA.2064@.TK2MSFTNGP11.phx.gbl...
> i am sorry for answering my own post, but i didn't see this part while
> reading BoL:
> If the database you are moving has additional data or log files, specify
all
> of them in a comma-delimited list in the sp_attach_db stored procedure.
The
> sp_detach_db procedure does not change no matter how many files the
database
> contains because it does not list them.
> thanks and sorry!
> "hector quintanilla" <hquintanilla@.cyberworksNOSPAM.com.mx> wrote in
message
> news:erashzznDHA.2652@.TK2MSFTNGP09.phx.gbl...
> > hi all,
> >
> > could someone help me out on this question? i have a database made up
of
> 3
> > .mdf files. the files are all on the same drive of a raid 10 so we need
> to
> > move them to different drives, as it is obvious that we are not taking
> > advantage of the hardware. how do i move the mdf files? what is the
best
> > possible way since the db is relativly big and the time frame we have to
> > make this movement is small?
> >
> > thanks in advance.
> >
> > hector quintanilla
> >
> >
>|||greg,
thanks for the reply. could you be more specific about the way to do this
change online? maybe a url? it may be ok to do it online, but it will
depend on the clients need.
thanks in advance
hector quintanilla
"Greg Linwood" <g_linwoodremovethisbeforeemailingme@.hotmail.com> wrote in
message news:urSI0F0nDHA.2772@.TK2MSFTNGP10.phx.gbl...
> Hi Hector.
> Nothing to be sorry about!
> If it's ok to take the database offline during the move, then using
> sp_detach_db etc is an ok approach. There's a limit of 16 files with that
> approach, but you're no-where near that.
> There are also other options to do this online if needed, although they
may
> be slower & it sounds like you're probably ok with going offline anway.
> Regards,
> Greg Linwood
> SQL Server MVP
> "hector quintanilla" <hquintanilla@.cyberworksNOSPAM.com.mx> wrote in
message
> news:uCpbs9znDHA.2064@.TK2MSFTNGP11.phx.gbl...
> > i am sorry for answering my own post, but i didn't see this part while
> > reading BoL:
> >
> > If the database you are moving has additional data or log files, specify
> all
> > of them in a comma-delimited list in the sp_attach_db stored procedure.
> The
> > sp_detach_db procedure does not change no matter how many files the
> database
> > contains because it does not list them.
> >
> > thanks and sorry!
> >
> > "hector quintanilla" <hquintanilla@.cyberworksNOSPAM.com.mx> wrote in
> message
> > news:erashzznDHA.2652@.TK2MSFTNGP09.phx.gbl...
> > > hi all,
> > >
> > > could someone help me out on this question? i have a database made up
> of
> > 3
> > > .mdf files. the files are all on the same drive of a raid 10 so we
need
> > to
> > > move them to different drives, as it is obvious that we are not taking
> > > advantage of the hardware. how do i move the mdf files? what is the
> best
> > > possible way since the db is relativly big and the time frame we have
to
> > > make this movement is small?
> > >
> > > thanks in advance.
> > >
> > > hector quintanilla
> > >
> > >
> >
> >
>|||It can be done a few ways - depending on requirements / size etc.
If the database is not a VLDBMS (ie huge) you may be able to simply create a
new file on the target volume / drive, start a transaction & take the steps
to move the object/s from the old file over there. This may even be as
simple as begin transaction, rename existing objects (tables, stored procs
etc), create new object/s (tables, stored proc on old file) on new file,
select into, index maintenance, drop old table, commit transaction. Then if
all objects are off the old file successfully, drop the file & delete it
from the file system.
If you have many tables, it may be worth investing time in building DTS
packages that perform the work in parallel. Basically, if you don't have an
online need, it's usually not worth going through all this as there's
analysis, planning & preparation that isn't worth it if you don't really
need to do it online.
I was mainly pointing out that there are online options which may be worth
looking into but only if you know you need to. sp_detach_db is certainly
going to be an offline operation.
I don't have a specific urls unfortunately, although I'm hoping someone else
who read the thread may know of one.. Perhaps post a new thread in case
others ignore this now it's been responded to.
Regards,
Greg Linwood
SQL Server MVP
"hector quintanilla" <hquintanilla@.cyberworksNOSPAM.com.mx> wrote in message
news:edTfCa0nDHA.1676@.TK2MSFTNGP09.phx.gbl...
> greg,
> thanks for the reply. could you be more specific about the way to do this
> change online? maybe a url? it may be ok to do it online, but it will
> depend on the clients need.
> thanks in advance
> hector quintanilla
> "Greg Linwood" <g_linwoodremovethisbeforeemailingme@.hotmail.com> wrote in
> message news:urSI0F0nDHA.2772@.TK2MSFTNGP10.phx.gbl...
> > Hi Hector.
> >
> > Nothing to be sorry about!
> >
> > If it's ok to take the database offline during the move, then using
> > sp_detach_db etc is an ok approach. There's a limit of 16 files with
that
> > approach, but you're no-where near that.
> >
> > There are also other options to do this online if needed, although they
> may
> > be slower & it sounds like you're probably ok with going offline anway.
> >
> > Regards,
> > Greg Linwood
> > SQL Server MVP
> >
> > "hector quintanilla" <hquintanilla@.cyberworksNOSPAM.com.mx> wrote in
> message
> > news:uCpbs9znDHA.2064@.TK2MSFTNGP11.phx.gbl...
> > > i am sorry for answering my own post, but i didn't see this part while
> > > reading BoL:
> > >
> > > If the database you are moving has additional data or log files,
specify
> > all
> > > of them in a comma-delimited list in the sp_attach_db stored
procedure.
> > The
> > > sp_detach_db procedure does not change no matter how many files the
> > database
> > > contains because it does not list them.
> > >
> > > thanks and sorry!
> > >
> > > "hector quintanilla" <hquintanilla@.cyberworksNOSPAM.com.mx> wrote in
> > message
> > > news:erashzznDHA.2652@.TK2MSFTNGP09.phx.gbl...
> > > > hi all,
> > > >
> > > > could someone help me out on this question? i have a database made
up
> > of
> > > 3
> > > > .mdf files. the files are all on the same drive of a raid 10 so we
> need
> > > to
> > > > move them to different drives, as it is obvious that we are not
taking
> > > > advantage of the hardware. how do i move the mdf files? what is
the
> > best
> > > > possible way since the db is relativly big and the time frame we
have
> to
> > > > make this movement is small?
> > > >
> > > > thanks in advance.
> > > >
> > > > hector quintanilla
> > > >
> > > >
> > >
> > >
> >
> >
>

Moving mdf & ldf files to another server

I am running SQL Server 7 (SP4) on Windows 2000 Server
(SP3). I am trying to implement a DR solution for my SQL 7
servers. I have a tool (Legato's Replistor) that will
replicate the Data directory to my DR server which has the
same version of SQL running. I have replaced the entire
Data directory with that from the other server. Can I get
these databases loaded doing this?
When I tried starting SQL it started OK but my main DB was
in suspect mode. I tried to detach and attach the database
but I got a corrupt log file message (9003).
Any help would be greatly appreciated.
Thanks,
Brian Lough
IT Manager
Canpar TransportBrian,
You don't want anything accessingthe sql files while it is running. Andeven
if you did get the files to copy to another server they would not be
consistant and could not be trusted. You might want to look into Log
Shipping instead.
--
Andrew J. Kelly SQL MVP
"Brian Lough" <blough@.canpar.com> wrote in message
news:002c01c3b503$02b101f0$a301280a@.phx.gbl...
> I am running SQL Server 7 (SP4) on Windows 2000 Server
> (SP3). I am trying to implement a DR solution for my SQL 7
> servers. I have a tool (Legato's Replistor) that will
> replicate the Data directory to my DR server which has the
> same version of SQL running. I have replaced the entire
> Data directory with that from the other server. Can I get
> these databases loaded doing this?
> When I tried starting SQL it started OK but my main DB was
> in suspect mode. I tried to detach and attach the database
> but I got a corrupt log file message (9003).
> Any help would be greatly appreciated.
> Thanks,
> Brian Lough
> IT Manager
> Canpar Transport
>

moving master db to another location

Hi ,
My master's .mdf & .ldf file is currently in D:\ drive and if i want it to
be changed to E:\ drive how can i do that ?
i am not able to detach it nor change the file name from EM ..
appreciate ur advise
tks & rdgs
Message posted via http://www.droptable.comHi,
http://www.databasejournal.com/feat...cle.php/3379901
HTH, jens Suessmeyer.
http://www.sqlserver2005.de
--|||Hi
http://support.microsoft.com/defaul...kb;en-us;224071
"maxzsim via droptable.com" <u14644@.uwe> wrote in message
news:60f711ff30917@.uwe...
> Hi ,
> My master's .mdf & .ldf file is currently in D:\ drive and if i want it to
> be changed to E:\ drive how can i do that ?
> i am not able to detach it nor change the file name from EM ..
> appreciate ur advise
> tks & rdgs
> --
> Message posted via http://www.droptable.com|||... and for SQL Server 2005 there is a section 'Moving System Databases' on
BOL.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/72bb62ee-9602-4f71-be51-c466
c1670878.htm
Ben Nevarez, MCDBA, OCP
Database Administrator
"maxzsim via droptable.com" wrote:

> Hi ,
> My master's .mdf & .ldf file is currently in D:\ drive and if i want it t
o
> be changed to E:\ drive how can i do that ?
> i am not able to detach it nor change the file name from EM ..
> appreciate ur advise
> tks & rdgs
> --
> Message posted via http://www.droptable.com
>|||Oops, I just notice that the original post says 'EM' so I guess it is not
SQL Server 2005 :-)
Ben Nevarez, MCDBA, OCP
Database Administrator
"Ben Nevarez" wrote:
[vbcol=seagreen]
> ... and for SQL Server 2005 there is a section 'Moving System Databases' o
n
> BOL.
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/72bb62ee-9602-4f71-be51-c4
66c1670878.htm
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "maxzsim via droptable.com" wrote:
>|||Hi ,
I was trying to move both msdb & model using the following steps :
1. addede the parameter -T3608
2a. use master
go
sp_detach_db 'msdb'
go
2b. use master
go
sp_detach_db 'model'
go
3. stop & restart SQL SERVER
4. i could not restart the SQL SERVER Service from the SQL Server Service
Manager as it keeps restarting & stopping by itself
any way i can get it to work now ?
tks & rdgs
Uri Dimant wrote:[vbcol=seagreen]
>Hi
>http://support.microsoft.com/defaul...kb;en-us;224071
>
>[quoted text clipped - 6 lines]
Message posted via http://www.droptable.com|||Hi ,
I got the 18502 error (looked into past posting seems no solution)
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 5/29/2006
Time: 6:11:53 PM
User: N/A
Computer: ALTIRISSERVER
Description:
18052 :
Error: 823, Severity: 24, State: 2.
and
from the SQL Error Log i got the followings :
2006-05-29 18:11:51.41 server Microsoft SQL Server 2000 - 8.00.760 (Inte
l
X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
2006-05-29 18:11:51.42 server Copyright (C) 1988-2002 Microsoft
Corporation.
2006-05-29 18:11:51.42 server All rights reserved.
2006-05-29 18:11:51.42 server Server Process ID is 2268.
2006-05-29 18:11:51.42 server Logging SQL Server messages in file 'd:\ms
sqlserver\MSSQL\log\ERRORLOG'.
2006-05-29 18:11:51.42 server SQL Server is starting at priority class
'high'(2 CPUs detected).
2006-05-29 18:11:51.44 server Performance monitor shared memory setup
failed: -1
2006-05-29 18:11:51.53 server SQL Server configured for thread mode
processing.
2006-05-29 18:11:51.53 server Using dynamic lock allocation. [2500] L
ock
Blocks, [5000] Lock Owner Blocks.
2006-05-29 18:11:51.57 server Attempting to initialize Distributed
Transaction Coordinator.
2006-05-29 18:11:52.60 spid4 Starting up database 'master'.
2006-05-29 18:11:53.85 spid4 Error: 823, Severity: 24, State: 2.
2006-05-29 18:11:53.85 spid4 Cannot recover the master database. Exiting
.
Any solutions besidess re-install ?
tks & rdgs
maxzsim wrote:[vbcol=seagreen]
>Hi ,
> I was trying to move both msdb & model using the following steps :
>1. addede the parameter -T3608
>2a. use master
> go
> sp_detach_db 'msdb'
> go
>2b. use master
> go
> sp_detach_db 'model'
> go
>3. stop & restart SQL SERVER
>4. i could not restart the SQL SERVER Service from the SQL Server Service
>Manager as it keeps restarting & stopping by itself
>any way i can get it to work now ?
>tks & rdgs
>
>[quoted text clipped - 4 lines]
Message posted via http://www.droptable.com|||Hi ,
further info :
I have checked the registery for the Master db the path is as per the
startup parameters before i moved the 'model' and 'msdb' database
really appreciate all advise
tks & rdgs
maxzsim wrote:[vbcol=seagreen]
>Hi ,
> I got the 18502 error (looked into past posting seems no solution)
>Event Type: Error
>Event Source: MSSQLSERVER
>Event Category: (2)
>Event ID: 17055
>Date: 5/29/2006
>Time: 6:11:53 PM
>User: N/A
>Computer: ALTIRISSERVER
>Description:
>18052 :
>Error: 823, Severity: 24, State: 2.
>and
>from the SQL Error Log i got the followings :
>2006-05-29 18:11:51.41 server Microsoft SQL Server 2000 - 8.00.760 (Int
el
>X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
>2006-05-29 18:11:51.42 server Copyright (C) 1988-2002 Microsoft
>Corporation.
>2006-05-29 18:11:51.42 server All rights reserved.
>2006-05-29 18:11:51.42 server Server Process ID is 2268.
>2006-05-29 18:11:51.42 server Logging SQL Server messages in file 'd:\ms
>sqlserver\MSSQL\log\ERRORLOG'.
>2006-05-29 18:11:51.42 server SQL Server is starting at priority class
>'high'(2 CPUs detected).
>2006-05-29 18:11:51.44 server Performance monitor shared memory setup
>failed: -1
>2006-05-29 18:11:51.53 server SQL Server configured for thread mode
>processing.
>2006-05-29 18:11:51.53 server Using dynamic lock allocation. [2500]
Lock
>Blocks, [5000] Lock Owner Blocks.
>2006-05-29 18:11:51.57 server Attempting to initialize Distributed
>Transaction Coordinator.
>2006-05-29 18:11:52.60 spid4 Starting up database 'master'.
>2006-05-29 18:11:53.85 spid4 Error: 823, Severity: 24, State: 2.
>2006-05-29 18:11:53.85 spid4 Cannot recover the master database. Exitin
g.
>Any solutions besidess re-install ?
>tks & rdgs
>
>[quoted text clipped - 24 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200605/1

moving master db to another location

Hi ,
My master's .mdf & .ldf file is currently in D:\ drive and if i want it to
be changed to E:\ drive how can i do that ?
i am not able to detach it nor change the file name from EM ..
appreciate ur advise
tks & rdgs
--
Message posted via http://www.sqlmonster.comHi,
http://www.databasejournal.com/features/mssql/article.php/3379901
HTH, jens Suessmeyer.
--
http://www.sqlserver2005.de
--|||Hi
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
"maxzsim via SQLMonster.com" <u14644@.uwe> wrote in message
news:60f711ff30917@.uwe...
> Hi ,
> My master's .mdf & .ldf file is currently in D:\ drive and if i want it to
> be changed to E:\ drive how can i do that ?
> i am not able to detach it nor change the file name from EM ..
> appreciate ur advise
> tks & rdgs
> --
> Message posted via http://www.sqlmonster.com|||... and for SQL Server 2005 there is a section 'Moving System Databases' on
BOL.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/72bb62ee-9602-4f71-be51-c466c1670878.htm
Ben Nevarez, MCDBA, OCP
Database Administrator
"maxzsim via SQLMonster.com" wrote:
> Hi ,
> My master's .mdf & .ldf file is currently in D:\ drive and if i want it to
> be changed to E:\ drive how can i do that ?
> i am not able to detach it nor change the file name from EM ..
> appreciate ur advise
> tks & rdgs
> --
> Message posted via http://www.sqlmonster.com
>|||Oops, I just notice that the original post says 'EM' so I guess it is not
SQL Server 2005 :-)
Ben Nevarez, MCDBA, OCP
Database Administrator
"Ben Nevarez" wrote:
> ... and for SQL Server 2005 there is a section 'Moving System Databases' on
> BOL.
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/72bb62ee-9602-4f71-be51-c466c1670878.htm
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "maxzsim via SQLMonster.com" wrote:
> > Hi ,
> >
> > My master's .mdf & .ldf file is currently in D:\ drive and if i want it to
> > be changed to E:\ drive how can i do that ?
> >
> > i am not able to detach it nor change the file name from EM ..
> >
> > appreciate ur advise
> >
> > tks & rdgs
> >
> > --
> > Message posted via http://www.sqlmonster.com
> >|||Hi ,
I was trying to move both msdb & model using the following steps :
1. addede the parameter -T3608
2a. use master
go
sp_detach_db 'msdb'
go
2b. use master
go
sp_detach_db 'model'
go
3. stop & restart SQL SERVER
4. i could not restart the SQL SERVER Service from the SQL Server Service
Manager as it keeps restarting & stopping by itself
any way i can get it to work now ?
tks & rdgs
Uri Dimant wrote:
>Hi
>http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
>> Hi ,
>[quoted text clipped - 6 lines]
>> tks & rdgs
--
Message posted via http://www.sqlmonster.com|||Hi ,
I got the 18502 error (looked into past posting seems no solution)
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 5/29/2006
Time: 6:11:53 PM
User: N/A
Computer: ALTIRISSERVER
Description:
18052 :
Error: 823, Severity: 24, State: 2.
and
from the SQL Error Log i got the followings :
2006-05-29 18:11:51.41 server Microsoft SQL Server 2000 - 8.00.760 (Intel
X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
2006-05-29 18:11:51.42 server Copyright (C) 1988-2002 Microsoft
Corporation.
2006-05-29 18:11:51.42 server All rights reserved.
2006-05-29 18:11:51.42 server Server Process ID is 2268.
2006-05-29 18:11:51.42 server Logging SQL Server messages in file 'd:\ms
sqlserver\MSSQL\log\ERRORLOG'.
2006-05-29 18:11:51.42 server SQL Server is starting at priority class
'high'(2 CPUs detected).
2006-05-29 18:11:51.44 server Performance monitor shared memory setup
failed: -1
2006-05-29 18:11:51.53 server SQL Server configured for thread mode
processing.
2006-05-29 18:11:51.53 server Using dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks.
2006-05-29 18:11:51.57 server Attempting to initialize Distributed
Transaction Coordinator.
2006-05-29 18:11:52.60 spid4 Starting up database 'master'.
2006-05-29 18:11:53.85 spid4 Error: 823, Severity: 24, State: 2.
2006-05-29 18:11:53.85 spid4 Cannot recover the master database. Exiting.
Any solutions besidess re-install ?
tks & rdgs
maxzsim wrote:
>Hi ,
> I was trying to move both msdb & model using the following steps :
>1. addede the parameter -T3608
>2a. use master
> go
> sp_detach_db 'msdb'
> go
>2b. use master
> go
> sp_detach_db 'model'
> go
>3. stop & restart SQL SERVER
>4. i could not restart the SQL SERVER Service from the SQL Server Service
>Manager as it keeps restarting & stopping by itself
>any way i can get it to work now ?
>tks & rdgs
>>Hi
>>http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
>[quoted text clipped - 4 lines]
>> tks & rdgs
--
Message posted via http://www.sqlmonster.com|||Hi ,
further info :
I have checked the registery for the Master db the path is as per the
startup parameters before i moved the 'model' and 'msdb' database
really appreciate all advise
tks & rdgs
maxzsim wrote:
>Hi ,
> I got the 18502 error (looked into past posting seems no solution)
>Event Type: Error
>Event Source: MSSQLSERVER
>Event Category: (2)
>Event ID: 17055
>Date: 5/29/2006
>Time: 6:11:53 PM
>User: N/A
>Computer: ALTIRISSERVER
>Description:
>18052 :
>Error: 823, Severity: 24, State: 2.
>and
>from the SQL Error Log i got the followings :
>2006-05-29 18:11:51.41 server Microsoft SQL Server 2000 - 8.00.760 (Intel
>X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
>2006-05-29 18:11:51.42 server Copyright (C) 1988-2002 Microsoft
>Corporation.
>2006-05-29 18:11:51.42 server All rights reserved.
>2006-05-29 18:11:51.42 server Server Process ID is 2268.
>2006-05-29 18:11:51.42 server Logging SQL Server messages in file 'd:\ms
>sqlserver\MSSQL\log\ERRORLOG'.
>2006-05-29 18:11:51.42 server SQL Server is starting at priority class
>'high'(2 CPUs detected).
>2006-05-29 18:11:51.44 server Performance monitor shared memory setup
>failed: -1
>2006-05-29 18:11:51.53 server SQL Server configured for thread mode
>processing.
>2006-05-29 18:11:51.53 server Using dynamic lock allocation. [2500] Lock
>Blocks, [5000] Lock Owner Blocks.
>2006-05-29 18:11:51.57 server Attempting to initialize Distributed
>Transaction Coordinator.
>2006-05-29 18:11:52.60 spid4 Starting up database 'master'.
>2006-05-29 18:11:53.85 spid4 Error: 823, Severity: 24, State: 2.
>2006-05-29 18:11:53.85 spid4 Cannot recover the master database. Exiting.
>Any solutions besidess re-install ?
>tks & rdgs
>>Hi ,
>[quoted text clipped - 24 lines]
>> tks & rdgs
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200605/1