Mulit MDF Files Seperately Restore On SQL Server 2000

Hi there,
I have a question about backup restore. I have setup a database with 5 MDF
file located in different drive.
testdb_data1.MDF
testdb_data2.MDF (in USB drive)
testdb_data3.MDF
testdb_data4.MDF
testdb_data5.MDF
If the MDF file in USB drive fail (say I unplug it and replace with a new
USB drive), is that possible to restore this MDF file only in order to
recover the whole database? I have tried to backup all the MDF files but
fail to restore in this case.
Could anyone give me some hints on this question? Thanks in advance.
KennethAre you backup up the database files from Windows or using SQL Servers BACKUP command?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Black" <hoodworld@.hotmail.com> wrote in message news:uTvjY90yHHA.484@.TK2MSFTNGP06.phx.gbl...
> Hi there,
> I have a question about backup restore. I have setup a database with 5 MDF
> file located in different drive.
> testdb_data1.MDF
> testdb_data2.MDF (in USB drive)
> testdb_data3.MDF
> testdb_data4.MDF
> testdb_data5.MDF
> If the MDF file in USB drive fail (say I unplug it and replace with a new
> USB drive), is that possible to restore this MDF file only in order to
> recover the whole database? I have tried to backup all the MDF files but
> fail to restore in this case.
> Could anyone give me some hints on this question? Thanks in advance.
> Kenneth
>|||And are they in same file group? On which version of sql?
"Tibor Karaszi" wrote:
> Are you backup up the database files from Windows or using SQL Servers BACKUP command?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Black" <hoodworld@.hotmail.com> wrote in message news:uTvjY90yHHA.484@.TK2MSFTNGP06.phx.gbl...
> > Hi there,
> >
> > I have a question about backup restore. I have setup a database with 5 MDF
> > file located in different drive.
> >
> > testdb_data1.MDF
> > testdb_data2.MDF (in USB drive)
> > testdb_data3.MDF
> > testdb_data4.MDF
> > testdb_data5.MDF
> >
> > If the MDF file in USB drive fail (say I unplug it and replace with a new
> > USB drive), is that possible to restore this MDF file only in order to
> > recover the whole database? I have tried to backup all the MDF files but
> > fail to restore in this case.
> >
> > Could anyone give me some hints on this question? Thanks in advance.
> >
> > Kenneth
> >
> >|||In sql2k, you can restore single file with sql backup/restore. But need to do
log restores to keep data integrity.
"Tibor Karaszi" wrote:
> Are you backup up the database files from Windows or using SQL Servers BACKUP command?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Black" <hoodworld@.hotmail.com> wrote in message news:uTvjY90yHHA.484@.TK2MSFTNGP06.phx.gbl...
> > Hi there,
> >
> > I have a question about backup restore. I have setup a database with 5 MDF
> > file located in different drive.
> >
> > testdb_data1.MDF
> > testdb_data2.MDF (in USB drive)
> > testdb_data3.MDF
> > testdb_data4.MDF
> > testdb_data5.MDF
> >
> > If the MDF file in USB drive fail (say I unplug it and replace with a new
> > USB drive), is that possible to restore this MDF file only in order to
> > recover the whole database? I have tried to backup all the MDF files but
> > fail to restore in this case.
> >
> > Could anyone give me some hints on this question? Thanks in advance.
> >
> > Kenneth
> >
> >

Mulit MDF Files Seperately Restore On SQL Server 2000

Hi there,
I have a question about backup restore. I have setup a database with 5 MDF
file located in different drive.
testdb_data1.MDF
testdb_data2.MDF (in USB drive)
testdb_data3.MDF
testdb_data4.MDF
testdb_data5.MDF
If the MDF file in USB drive fail (say I unplug it and replace with a new
USB drive), is that possible to restore this MDF file only in order to
recover the whole database? I have tried to backup all the MDF files but
fail to restore in this case.
Could anyone give me some hints on this question? Thanks in advance.
Kenneth
Are you backup up the database files from Windows or using SQL Servers BACKUP command?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Black" <hoodworld@.hotmail.com> wrote in message news:uTvjY90yHHA.484@.TK2MSFTNGP06.phx.gbl...
> Hi there,
> I have a question about backup restore. I have setup a database with 5 MDF
> file located in different drive.
> testdb_data1.MDF
> testdb_data2.MDF (in USB drive)
> testdb_data3.MDF
> testdb_data4.MDF
> testdb_data5.MDF
> If the MDF file in USB drive fail (say I unplug it and replace with a new
> USB drive), is that possible to restore this MDF file only in order to
> recover the whole database? I have tried to backup all the MDF files but
> fail to restore in this case.
> Could anyone give me some hints on this question? Thanks in advance.
> Kenneth
>
|||And are they in same file group? On which version of sql?
"Tibor Karaszi" wrote:
[vbcol=seagreen]
> Are you backup up the database files from Windows or using SQL Servers BACKUP command?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Black" <hoodworld@.hotmail.com> wrote in message news:uTvjY90yHHA.484@.TK2MSFTNGP06.phx.gbl...
|||In sql2k, you can restore single file with sql backup/restore. But need to do
log restores to keep data integrity.
"Tibor Karaszi" wrote:
[vbcol=seagreen]
> Are you backup up the database files from Windows or using SQL Servers BACKUP command?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Black" <hoodworld@.hotmail.com> wrote in message news:uTvjY90yHHA.484@.TK2MSFTNGP06.phx.gbl...
sql

Mulit MDF Files Seperately Restore On SQL Server 2000

Hi there,
I have a question about backup restore. I have setup a database with 5 MDF
file located in different drive.
testdb_data1.MDF
testdb_data2.MDF (in USB drive)
testdb_data3.MDF
testdb_data4.MDF
testdb_data5.MDF
If the MDF file in USB drive fail (say I unplug it and replace with a new
USB drive), is that possible to restore this MDF file only in order to
recover the whole database? I have tried to backup all the MDF files but
fail to restore in this case.
Could anyone give me some hints on this question? Thanks in advance.
KennethAre you backup up the database files from Windows or using SQL Servers BACKU
P command?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Black" <hoodworld@.hotmail.com> wrote in message news:uTvjY90yHHA.484@.TK2MSFTNGP06.phx.gbl..
.
> Hi there,
> I have a question about backup restore. I have setup a database with 5 MDF
> file located in different drive.
> testdb_data1.MDF
> testdb_data2.MDF (in USB drive)
> testdb_data3.MDF
> testdb_data4.MDF
> testdb_data5.MDF
> If the MDF file in USB drive fail (say I unplug it and replace with a new
> USB drive), is that possible to restore this MDF file only in order to
> recover the whole database? I have tried to backup all the MDF files but
> fail to restore in this case.
> Could anyone give me some hints on this question? Thanks in advance.
> Kenneth
>|||And are they in same file group? On which version of sql?
"Tibor Karaszi" wrote:
[vbcol=seagreen]
> Are you backup up the database files from Windows or using SQL Servers BAC
KUP command?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Black" <hoodworld@.hotmail.com> wrote in message news:uTvjY90yHHA.484@.TK2M
SFTNGP06.phx.gbl...|||In sql2k, you can restore single file with sql backup/restore. But need to d
o
log restores to keep data integrity.
"Tibor Karaszi" wrote:
[vbcol=seagreen]
> Are you backup up the database files from Windows or using SQL Servers BAC
KUP command?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Black" <hoodworld@.hotmail.com> wrote in message news:uTvjY90yHHA.484@.TK2M
SFTNGP06.phx.gbl...

msx-tsx restore...

hi
SQLServer 2000 sp3 having master-target relationship. I want to change the
master server to another system.how can i replace this master server without
affecting target relations? any help , appreciated.
BOL says:
Each target server reports to only one master server. You must defect a
target server from one master before you can enlist it into a different one.
"kpxus" <kpxus@.discussions.microsoft.com> wrote in message
news:36E6CC5D-5EA3-474D-927E-0E7A29FFABE0@.microsoft.com...
> hi
> SQLServer 2000 sp3 having master-target relationship. I want to change the
> master server to another system.how can i replace this master server
without
> affecting target relations? any help , appreciated.
|||Instead of defect the target and re enlist, is there any way to restore
the master and msdb on other system and continue the msx-tsx relationship?
Quentin Ran wrote:
> BOL says:
> Each target server reports to only one master server. You must defect a
> target server from one master before you can enlist it into a different one.
> "kpxus" <kpxus@.discussions.microsoft.com> wrote in message
> news:36E6CC5D-5EA3-474D-927E-0E7A29FFABE0@.microsoft.com...
>
> without
>
>

msx-tsx restore...

hi
SQLServer 2000 sp3 having master-target relationship. I want to change the
master server to another system.how can i replace this master server without
affecting target relations? any help , appreciated.BOL says:
Each target server reports to only one master server. You must defect a
target server from one master before you can enlist it into a different one.
"kpxus" <kpxus@.discussions.microsoft.com> wrote in message
news:36E6CC5D-5EA3-474D-927E-0E7A29FFABE0@.microsoft.com...
> hi
> SQLServer 2000 sp3 having master-target relationship. I want to change the
> master server to another system.how can i replace this master server
without
> affecting target relations? any help , appreciated.|||Instead of defect the target and re enlist, is there any way to restore
the master and msdb on other system and continue the msx-tsx relationship?
Quentin Ran wrote:
> BOL says:
> Each target server reports to only one master server. You must defect a
> target server from one master before you can enlist it into a different on
e.
> "kpxus" <kpxus@.discussions.microsoft.com> wrote in message
> news:36E6CC5D-5EA3-474D-927E-0E7A29FFABE0@.microsoft.com...
>
> without
>
>
>sql

msx-tsx restore...

hi
SQLServer 2000 sp3 having master-target relationship. I want to change the
master server to another system.how can i replace this master server without
affecting target relations? any help , appreciated.BOL says:
Each target server reports to only one master server. You must defect a
target server from one master before you can enlist it into a different one.
"kpxus" <kpxus@.discussions.microsoft.com> wrote in message
news:36E6CC5D-5EA3-474D-927E-0E7A29FFABE0@.microsoft.com...
> hi
> SQLServer 2000 sp3 having master-target relationship. I want to change the
> master server to another system.how can i replace this master server
without
> affecting target relations? any help , appreciated.|||Instead of defect the target and re enlist, is there any way to restore
the master and msdb on other system and continue the msx-tsx relationship?
Quentin Ran wrote:
> BOL says:
> Each target server reports to only one master server. You must defect a
> target server from one master before you can enlist it into a different one.
> "kpxus" <kpxus@.discussions.microsoft.com> wrote in message
> news:36E6CC5D-5EA3-474D-927E-0E7A29FFABE0@.microsoft.com...
>>hi
>>SQLServer 2000 sp3 having master-target relationship. I want to change the
>>master server to another system.how can i replace this master server
> without
>>affecting target relations? any help , appreciated.
>
>