Restore to Multiple Files?

I am in the process of configuring a new laptop. It has two hard drives and
I want to restore several of my large databases to files on both hard
drives, even though the original dbs on my old laptop are single-file.
Anyone know a secret that will allow you to restore a single-file database
to spread it's data over two files during the restore'
--
TheSQLGuru
President
Indicium Resources, Inc.Hi
I'm affraid you cannot do that. As SQL Server needs to restore/attach the
same number of files as you created db.
"TheSQLGuru" <kgboles@.earthlink.net> wrote in message
news:%23mNKpyH9HHA.4180@.TK2MSFTNGP05.phx.gbl...
>I am in the process of configuring a new laptop. It has two hard drives
>and I want to restore several of my large databases to files on both hard
>drives, even though the original dbs on my old laptop are single-file.
>Anyone know a secret that will allow you to restore a single-file database
>to spread it's data over two files during the restore'
> --
> TheSQLGuru
> President
> Indicium Resources, Inc.
>
>|||I didn't think it could be done either, but I have found quite a number of
things that fall into that category on this forum so I thought I would ask
anyway!! :-)
--
TheSQLGuru
President
Indicium Resources, Inc.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uqQ5U8H9HHA.1484@.TK2MSFTNGP06.phx.gbl...
> Hi
> I'm affraid you cannot do that. As SQL Server needs to restore/attach the
> same number of files as you created db.
> "TheSQLGuru" <kgboles@.earthlink.net> wrote in message
> news:%23mNKpyH9HHA.4180@.TK2MSFTNGP05.phx.gbl...
>>I am in the process of configuring a new laptop. It has two hard drives
>>and I want to restore several of my large databases to files on both hard
>>drives, even though the original dbs on my old laptop are single-file.
>>Anyone know a secret that will allow you to restore a single-file database
>>to spread it's data over two files during the restore'
>> --
>> TheSQLGuru
>> President
>> Indicium Resources, Inc.
>>
>|||You are probably better off placing the log files on one drive and the data
on the other.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"TheSQLGuru" <kgboles@.earthlink.net> wrote in message
news:%23mNKpyH9HHA.4180@.TK2MSFTNGP05.phx.gbl...
>I am in the process of configuring a new laptop. It has two hard drives
>and I want to restore several of my large databases to files on both hard
>drives, even though the original dbs on my old laptop are single-file.
>Anyone know a secret that will allow you to restore a single-file database
>to spread it's data over two files during the restore'
> --
> TheSQLGuru
> President
> Indicium Resources, Inc.
>
>|||That will be done for my 'standard' databases. I have a few very large ones
I use for analyzing trace files and also one large test db for a client and
for those the read-throughput is key to optimal perforance thus the desire
to spread the data across both drives.
--
TheSQLGuru
President
Indicium Resources, Inc.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:uTTCReJ9HHA.5456@.TK2MSFTNGP05.phx.gbl...
> You are probably better off placing the log files on one drive and the
> data on the other.
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "TheSQLGuru" <kgboles@.earthlink.net> wrote in message
> news:%23mNKpyH9HHA.4180@.TK2MSFTNGP05.phx.gbl...
>>I am in the process of configuring a new laptop. It has two hard drives
>>and I want to restore several of my large databases to files on both hard
>>drives, even though the original dbs on my old laptop are single-file.
>>Anyone know a secret that will allow you to restore a single-file database
>>to spread it's data over two files during the restore'
>> --
>> TheSQLGuru
>> President
>> Indicium Resources, Inc.
>>
>sql

Restore the database

I have abackup of an SQL Server database named "UserData.bak" now i wantRestore this backup to my SQL Server.

pls tell me whole process.

Can i also restore it to MS-Access, if possible pls do let me know.

Thanks

Open the SQL Enterprise Manager. Select Import Data and this will start the wizard just read and follow. It must be simple.

|||

ravipahuja1:

Open the SQL Enterprise Manager. Select Import Data and this will start the wizard just read and follow. It must be simple.

I am using SQLEXPRESS 2005 server. then what's the process

|||

You must first download the sql express management studio and then use the standard restore process. Download SQL Express management studio herehttp://msdn.microsoft.com/vstudio/express/sql/

|||

richardsoeteman.net:

You must first download the sql express management studio and then use the standard restore process. Download SQL Express management studio herehttp://msdn.microsoft.com/vstudio/express/sql/

Yaa i have but pls tell the process.

|||

Hi sawan.singh,

I've reproduced the process in Sql Server 2005, and i think the process should be similiar for Sql Express Management Studio(or almost the same). So, just give you some advices and you can take as a reference.

1.Open your Sql Express Mangement Studio and right click your database that you need to restore;

2.From the pop-up menue, clickTasks--> Restore--> Databases, this should open a restoration wizard;

3.In the wizard window, select your backup file in the "Specify the source and location of backup sets to restore" section and click OK;

4. After a few minutes (depends on how large your database is) a message box will pop up and say,"restore succeed"

BTW, you can also refer to this link in msdn:http://msdn2.microsoft.com/en-us/library/ms177429.aspx

Hope my suggestion helps

sql

RESTORE Terminated abnormally

Dear all,
How can I restore from a SQL backup file but only the data part? When I
restore my backup file in SQL 2000 Server, the restore process stops and
said "TErminating abnormally" I am wondering the problem can be the
transaction log part in the backup file. So, is it possible to restore only
the data part?
Thanks,
ACAllen
CREATE DATABASE mywind
GO
ALTER DATABASE mywind ADD FILEGROUP new_customers
ALTER DATABASE mywind ADD FILEGROUP sales
GO
ALTER DATABASE mywind ADD FILE
(NAME='mywind_data_1',
FILENAME='d:\mw.dat1')
TO FILEGROUP new_customers
ALTER DATABASE mywind
ADD FILE
(NAME='mywind_data_2',
FILENAME='d:\mw.dat2')
TO FILEGROUP sales
BACKUP DATABASE mywind
TO DISK ='d:\mywind.dmp'
WITH INIT
GO
USE mywind
GO
CREATE TABLE t1 (id int) ON new_customers
CREATE TABLE t2 (id int) ON sales
GO
BACKUP LOG mywind TO DISK='d:\mywind.dmp'
WITH NOINIT
RESTORE FILELISTONLY FROM DISK='d:\mywind.dmp'
GO
RESTORE HEADERONLY FROM DISK='d:\mywind.dmp'
GO
RESTORE DATABASE mywind_part
FILEGROUP = 'sales'
FROM DISK='d:\mywind.dmp'
WITH FILE=1,NORECOVERY,PARTIAL,
MOVE 'mywind' TO 'd:\mw2.pri',
MOVE 'mywind_log' TO 'd:\mw2.log',
MOVE 'mywind_data_2' TO 'd:\mw2.dat2'
GO
RESTORE LOG mywind_part
FROM DISK = 'g:\mywind.dmp'
WITH FILE = 2,RECOVERY
GO
Notice that t2 is accessible after the partial restore operation.
SELECT COUNT(*) FROM mywind_part..t2
Here is the result:
--
0
Notice that t1 is not accessible after the partial restore operation.
SELECT COUNT(*) FROM mywind_part..t1
Here is the resulting message:
The query processor is unable to produce a plan because
the table 'mywind_part..t1' is marked OFFLINE.
"Allen Cheng" <acheng@.hk.eclipsecomputing.com> wrote in message
news:bf5q4d$6g0$1@.hfc.pacific.net.hk...
> Dear all,
> How can I restore from a SQL backup file but only the data part? When I
> restore my backup file in SQL 2000 Server, the restore process stops and
> said "TErminating abnormally" I am wondering the problem can be the
> transaction log part in the backup file. So, is it possible to restore
only
> the data part?
> Thanks,
> AC
>|||Let me give you another option:
sp_attach_single_file_db
All you need is the path to the mdf file.
You can always browse to the mdf file through Windows Explorer and then drag
and drop the file into an open START / RUN dialog box to get the full path
to the mdf easily.
"Allen Cheng" <acheng@.hk.eclipsecomputing.com> wrote in message
news:bf5q4d$6g0$1@.hfc.pacific.net.hk...
> Dear all,
> How can I restore from a SQL backup file but only the data part? When I
> restore my backup file in SQL 2000 Server, the restore process stops and
> said "TErminating abnormally" I am wondering the problem can be the
> transaction log part in the backup file. So, is it possible to restore
only
> the data part?
> Thanks,
> AC
>

Restore Question

I am trying the restore process.
Here is the test case that i am performing:
1) Full backup Nwind Databse at 5pm
2) Add some tables and after that did transaction log backup at 5.10pm
Try to initiate failure by renaming the .mdf.
Restored full with NORECOVERY followed by trans log with RECOVER. it worked.
My question is, after 5.10pm, i did changes without saving and renamed the
..mdf again. I wanted to try A Point in Time backup. After i renamed the .mdf,
i cant perform trans log backup using the BACKUP LOG statement(it gives error
that the database is not online. But, hey, i just renamed the .mdf and the
..ldy is perfectly alright). From my understanding, the changes,after 5.10pm,
are recorded in trans log and if i can save that, i can get all the data
back. So, how do i do that?Or did i overlook sth?
TIA
"How to restore to the point of failure (Transact-SQL)"
http://msdn.microsoft.com/library/en...asp?frame=true
Cristian Lefter, SQL Server MVP
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:0F275721-28D6-4FB1-94BB-C407DD114D92@.microsoft.com...
>I am trying the restore process.
> Here is the test case that i am performing:
> 1) Full backup Nwind Databse at 5pm
> 2) Add some tables and after that did transaction log backup at 5.10pm
> Try to initiate failure by renaming the .mdf.
> Restored full with NORECOVERY followed by trans log with RECOVER. it
> worked.
> My question is, after 5.10pm, i did changes without saving and renamed the
> .mdf again. I wanted to try A Point in Time backup. After i renamed the
> .mdf,
> i cant perform trans log backup using the BACKUP LOG statement(it gives
> error
> that the database is not online. But, hey, i just renamed the .mdf and the
> .ldy is perfectly alright). From my understanding, the changes,after
> 5.10pm,
> are recorded in trans log and if i can save that, i can get all the data
> back. So, how do i do that?Or did i overlook sth?
> TIA
|||Rupart
You can only restore from a backup of the transaction log. You can not
restore direct from the transaction log.
In a real situation where you are going to have to either go to your DR
solution (If you have one) or do a restore, it's always a good idea to see if
you can perform a final transaction log backup before proceding. In your
case, renaming the .mdf, you won't be able to, but sometimes you can. This
will allow you to get as up to date as possible. In your scenario there is no
way for you to restore the database to any point after 5:10pm.
Regards
John
"Cristian Lefter" wrote:

> "How to restore to the point of failure (Transact-SQL)"
> http://msdn.microsoft.com/library/en...asp?frame=true
> Cristian Lefter, SQL Server MVP
> "rupart" <rupart@.discussions.microsoft.com> wrote in message
> news:0F275721-28D6-4FB1-94BB-C407DD114D92@.microsoft.com...
>
>
|||> After i renamed the .mdf,
> i cant perform trans log backup using the BACKUP LOG
This is what the NO_TRUNCATE option for the BAKUP LOG command is for. It will allow you do exactly
that. You might want to check out:
http://www.karaszi.com/SQLServer/inf...eral_times.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:0F275721-28D6-4FB1-94BB-C407DD114D92@.microsoft.com...
>I am trying the restore process.
> Here is the test case that i am performing:
> 1) Full backup Nwind Databse at 5pm
> 2) Add some tables and after that did transaction log backup at 5.10pm
> Try to initiate failure by renaming the .mdf.
> Restored full with NORECOVERY followed by trans log with RECOVER. it worked.
> My question is, after 5.10pm, i did changes without saving and renamed the
> .mdf again. I wanted to try A Point in Time backup. After i renamed the .mdf,
> i cant perform trans log backup using the BACKUP LOG statement(it gives error
> that the database is not online. But, hey, i just renamed the .mdf and the
> .ldy is perfectly alright). From my understanding, the changes,after 5.10pm,
> are recorded in trans log and if i can save that, i can get all the data
> back. So, how do i do that?Or did i overlook sth?
> TIA
|||cool..
thx guys..let me check it out
"Cristian Lefter" wrote:

> "How to restore to the point of failure (Transact-SQL)"
> http://msdn.microsoft.com/library/en...asp?frame=true
> Cristian Lefter, SQL Server MVP
> "rupart" <rupart@.discussions.microsoft.com> wrote in message
> news:0F275721-28D6-4FB1-94BB-C407DD114D92@.microsoft.com...
>
>

Restore Question

I am trying the restore process.
Here is the test case that i am performing:
1) Full backup Nwind Databse at 5pm
2) Add some tables and after that did transaction log backup at 5.10pm
Try to initiate failure by renaming the .mdf.
Restored full with NORECOVERY followed by trans log with RECOVER. it worked.
My question is, after 5.10pm, i did changes without saving and renamed the
.mdf again. I wanted to try A Point in Time backup. After i renamed the .mdf,
i cant perform trans log backup using the BACKUP LOG statement(it gives error
that the database is not online. But, hey, i just renamed the .mdf and the
.ldy is perfectly alright). From my understanding, the changes,after 5.10pm,
are recorded in trans log and if i can save that, i can get all the data
back. So, how do i do that?Or did i overlook sth?
TIA"How to restore to the point of failure (Transact-SQL)"
http://msdn.microsoft.com/library/en-us/howtosql/ht_7_backpc_5a61.asp?frame=true
Cristian Lefter, SQL Server MVP
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:0F275721-28D6-4FB1-94BB-C407DD114D92@.microsoft.com...
>I am trying the restore process.
> Here is the test case that i am performing:
> 1) Full backup Nwind Databse at 5pm
> 2) Add some tables and after that did transaction log backup at 5.10pm
> Try to initiate failure by renaming the .mdf.
> Restored full with NORECOVERY followed by trans log with RECOVER. it
> worked.
> My question is, after 5.10pm, i did changes without saving and renamed the
> .mdf again. I wanted to try A Point in Time backup. After i renamed the
> .mdf,
> i cant perform trans log backup using the BACKUP LOG statement(it gives
> error
> that the database is not online. But, hey, i just renamed the .mdf and the
> .ldy is perfectly alright). From my understanding, the changes,after
> 5.10pm,
> are recorded in trans log and if i can save that, i can get all the data
> back. So, how do i do that?Or did i overlook sth?
> TIA|||Rupart
You can only restore from a backup of the transaction log. You can not
restore direct from the transaction log.
In a real situation where you are going to have to either go to your DR
solution (If you have one) or do a restore, it's always a good idea to see if
you can perform a final transaction log backup before proceding. In your
case, renaming the .mdf, you won't be able to, but sometimes you can. This
will allow you to get as up to date as possible. In your scenario there is no
way for you to restore the database to any point after 5:10pm.
Regards
John
"Cristian Lefter" wrote:
> "How to restore to the point of failure (Transact-SQL)"
> http://msdn.microsoft.com/library/en-us/howtosql/ht_7_backpc_5a61.asp?frame=true
> Cristian Lefter, SQL Server MVP
> "rupart" <rupart@.discussions.microsoft.com> wrote in message
> news:0F275721-28D6-4FB1-94BB-C407DD114D92@.microsoft.com...
> >I am trying the restore process.
> > Here is the test case that i am performing:
> > 1) Full backup Nwind Databse at 5pm
> > 2) Add some tables and after that did transaction log backup at 5.10pm
> > Try to initiate failure by renaming the .mdf.
> > Restored full with NORECOVERY followed by trans log with RECOVER. it
> > worked.
> >
> > My question is, after 5.10pm, i did changes without saving and renamed the
> > .mdf again. I wanted to try A Point in Time backup. After i renamed the
> > .mdf,
> > i cant perform trans log backup using the BACKUP LOG statement(it gives
> > error
> > that the database is not online. But, hey, i just renamed the .mdf and the
> > .ldy is perfectly alright). From my understanding, the changes,after
> > 5.10pm,
> > are recorded in trans log and if i can save that, i can get all the data
> > back. So, how do i do that?Or did i overlook sth?
> >
> > TIA
>
>|||> After i renamed the .mdf,
> i cant perform trans log backup using the BACKUP LOG
This is what the NO_TRUNCATE option for the BAKUP LOG command is for. It will allow you do exactly
that. You might want to check out:
http://www.karaszi.com/SQLServer/info_restore_log_several_times.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:0F275721-28D6-4FB1-94BB-C407DD114D92@.microsoft.com...
>I am trying the restore process.
> Here is the test case that i am performing:
> 1) Full backup Nwind Databse at 5pm
> 2) Add some tables and after that did transaction log backup at 5.10pm
> Try to initiate failure by renaming the .mdf.
> Restored full with NORECOVERY followed by trans log with RECOVER. it worked.
> My question is, after 5.10pm, i did changes without saving and renamed the
> .mdf again. I wanted to try A Point in Time backup. After i renamed the .mdf,
> i cant perform trans log backup using the BACKUP LOG statement(it gives error
> that the database is not online. But, hey, i just renamed the .mdf and the
> .ldy is perfectly alright). From my understanding, the changes,after 5.10pm,
> are recorded in trans log and if i can save that, i can get all the data
> back. So, how do i do that?Or did i overlook sth?
> TIA|||cool..
thx guys..let me check it out
"Cristian Lefter" wrote:
> "How to restore to the point of failure (Transact-SQL)"
> http://msdn.microsoft.com/library/en-us/howtosql/ht_7_backpc_5a61.asp?frame=true
> Cristian Lefter, SQL Server MVP
> "rupart" <rupart@.discussions.microsoft.com> wrote in message
> news:0F275721-28D6-4FB1-94BB-C407DD114D92@.microsoft.com...
> >I am trying the restore process.
> > Here is the test case that i am performing:
> > 1) Full backup Nwind Databse at 5pm
> > 2) Add some tables and after that did transaction log backup at 5.10pm
> > Try to initiate failure by renaming the .mdf.
> > Restored full with NORECOVERY followed by trans log with RECOVER. it
> > worked.
> >
> > My question is, after 5.10pm, i did changes without saving and renamed the
> > .mdf again. I wanted to try A Point in Time backup. After i renamed the
> > .mdf,
> > i cant perform trans log backup using the BACKUP LOG statement(it gives
> > error
> > that the database is not online. But, hey, i just renamed the .mdf and the
> > .ldy is perfectly alright). From my understanding, the changes,after
> > 5.10pm,
> > are recorded in trans log and if i can save that, i can get all the data
> > back. So, how do i do that?Or did i overlook sth?
> >
> > TIA
>
>

Restore Question

I am trying the restore process.
Here is the test case that i am performing:
1) Full backup Nwind Databse at 5pm
2) Add some tables and after that did transaction log backup at 5.10pm
Try to initiate failure by renaming the .mdf.
Restored full with NORECOVERY followed by trans log with RECOVER. it worked.
My question is, after 5.10pm, i did changes without saving and renamed the
.mdf again. I wanted to try A Point in Time backup. After i renamed the .md
f,
i cant perform trans log backup using the BACKUP LOG statement(it gives erro
r
that the database is not online. But, hey, i just renamed the .mdf and the
.ldy is perfectly alright). From my understanding, the changes,after 5.10pm
,
are recorded in trans log and if i can save that, i can get all the data
back. So, how do i do that?Or did i overlook sth?
TIA"How to restore to the point of failure (Transact-SQL)"
[url]http://msdn.microsoft.com/library/en-us/howtosql/ht_7_backpc_5a61.asp?frame=true[/
url]
Cristian Lefter, SQL Server MVP
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:0F275721-28D6-4FB1-94BB-C407DD114D92@.microsoft.com...
>I am trying the restore process.
> Here is the test case that i am performing:
> 1) Full backup Nwind Databse at 5pm
> 2) Add some tables and after that did transaction log backup at 5.10pm
> Try to initiate failure by renaming the .mdf.
> Restored full with NORECOVERY followed by trans log with RECOVER. it
> worked.
> My question is, after 5.10pm, i did changes without saving and renamed the
> .mdf again. I wanted to try A Point in Time backup. After i renamed the
> .mdf,
> i cant perform trans log backup using the BACKUP LOG statement(it gives
> error
> that the database is not online. But, hey, i just renamed the .mdf and the
> .ldy is perfectly alright). From my understanding, the changes,after
> 5.10pm,
> are recorded in trans log and if i can save that, i can get all the data
> back. So, how do i do that?Or did i overlook sth?
> TIA|||Rupart
You can only restore from a backup of the transaction log. You can not
restore direct from the transaction log.
In a real situation where you are going to have to either go to your DR
solution (If you have one) or do a restore, it's always a good idea to see i
f
you can perform a final transaction log backup before proceding. In your
case, renaming the .mdf, you won't be able to, but sometimes you can. This
will allow you to get as up to date as possible. In your scenario there is n
o
way for you to restore the database to any point after 5:10pm.
Regards
John
"Cristian Lefter" wrote:

> "How to restore to the point of failure (Transact-SQL)"
> http://msdn.microsoft.com/library/e...me=true

> Cristian Lefter, SQL Server MVP
> "rupart" <rupart@.discussions.microsoft.com> wrote in message
> news:0F275721-28D6-4FB1-94BB-C407DD114D92@.microsoft.com...
>
>|||> After i renamed the .mdf,
> i cant perform trans log backup using the BACKUP LOG
This is what the NO_TRUNCATE option for the BAKUP LOG command is for. It wil
l allow you do exactly
that. You might want to check out:
http://www.karaszi.com/SQLServer/in...veral_times.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:0F275721-28D6-4FB1-94BB-C407DD114D92@.microsoft.com...
>I am trying the restore process.
> Here is the test case that i am performing:
> 1) Full backup Nwind Databse at 5pm
> 2) Add some tables and after that did transaction log backup at 5.10pm
> Try to initiate failure by renaming the .mdf.
> Restored full with NORECOVERY followed by trans log with RECOVER. it worke
d.
> My question is, after 5.10pm, i did changes without saving and renamed the
> .mdf again. I wanted to try A Point in Time backup. After i renamed the .m
df,
> i cant perform trans log backup using the BACKUP LOG statement(it gives er
ror
> that the database is not online. But, hey, i just renamed the .mdf and the
> .ldy is perfectly alright). From my understanding, the changes,after 5.10p
m,
> are recorded in trans log and if i can save that, i can get all the data
> back. So, how do i do that?Or did i overlook sth?
> TIA|||cool..
thx guys..let me check it out
"Cristian Lefter" wrote:

> "How to restore to the point of failure (Transact-SQL)"
> http://msdn.microsoft.com/library/e...me=true

> Cristian Lefter, SQL Server MVP
> "rupart" <rupart@.discussions.microsoft.com> wrote in message
> news:0F275721-28D6-4FB1-94BB-C407DD114D92@.microsoft.com...
>
>

Restore process is hung up

I really could use help ASAP -

I started a restore process about 20 hours ago of a very SMALL database. It apparently is hung up because it is still in the "restoring" state. How can I stop the restore process? I need to get this database back up, even if it is to the state prior to attempting a restore. I can't do anything with it now because it keeps saying the database is in the middle of a restore. ANYONE? I can't find any way to kill the process or anything.

Any help would be GREATLY appreciated!

You can probably issue a RESTORE WITH RECOVERY to get in out of the restoring state. i.e.,

RESTORE DATABASE <dbname> WITH RECOVERY

|||Thanks. What I ended up doing was creating a new database and doing a restore to it and it worked fine. Then just deleted the one that was hung up.|||When it happens again then best you can check the event viewer logs for any issues on hardware.

Restore Master Problem

We are in the process of upgrading our servers. We tried to Restore Master
Database from SQL 2000 SP3 on Win NT to a new test machine that has SQL 2000
SP3 on WIN 2003 Server SP1. The restore says its successful but the service
doesn't start after restoring. I am using local system account on both the
machines.
Also I have tried to restore Master from SQL 2000 SP3 on WIN 2000 Prof SP4
to the same machine (SQL 2000 sp3 on WIN 2003 server sp1) but ran into the
same problem.
I would really appreciate if you could give me some suggestions.on the original server do you have anything unusual like
- tempdb in ram
- max server memory greater than what is available on new server.
- additional tempdb on drive which does not exist etc . .
- what errors do you get in error log?
- did sql start with -m option?
- if all fails you may have to try -f option - see BOL for more details
HTH
"Pradip" wrote:
> We are in the process of upgrading our servers. We tried to Restore Master
> Database from SQL 2000 SP3 on Win NT to a new test machine that has SQL 2000
> SP3 on WIN 2003 Server SP1. The restore says its successful but the service
> doesn't start after restoring. I am using local system account on both the
> machines.
> Also I have tried to restore Master from SQL 2000 SP3 on WIN 2000 Prof SP4
> to the same machine (SQL 2000 sp3 on WIN 2003 server sp1) but ran into the
> same problem.
> I would really appreciate if you could give me some suggestions.|||1. Start SQL from the console ( command prompt) ie sqlservr.exe -m
2. Then do the restore from the database backup.
3. thern Ctrl-C the console, and restart SQL Serve..
What error messages are you getting?
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Pradip" <Pradip@.discussions.microsoft.com> wrote in message
news:C4E333AA-055D-4EDC-8271-9DF88AF68B9C@.microsoft.com...
> We are in the process of upgrading our servers. We tried to Restore Master
> Database from SQL 2000 SP3 on Win NT to a new test machine that has SQL
2000
> SP3 on WIN 2003 Server SP1. The restore says its successful but the
service
> doesn't start after restoring. I am using local system account on both the
> machines.
> Also I have tried to restore Master from SQL 2000 SP3 on WIN 2000 Prof SP4
> to the same machine (SQL 2000 sp3 on WIN 2003 server sp1) but ran into the
> same problem.
> I would really appreciate if you could give me some suggestions.

Restore Master Problem

We are in the process of upgrading our servers. We tried to Restore Master
Database from SQL 2000 SP3 on Win NT to a new test machine that has SQL 2000
SP3 on WIN 2003 Server SP1. The restore says its successful but the service
doesn't start after restoring. I am using local system account on both the
machines.
Also I have tried to restore Master from SQL 2000 SP3 on WIN 2000 Prof SP4
to the same machine (SQL 2000 sp3 on WIN 2003 server sp1) but ran into the
same problem.
I would really appreciate if you could give me some suggestions.on the original server do you have anything unusual like
- tempdb in ram
- max server memory greater than what is available on new server.
- additional tempdb on drive which does not exist etc . .
- what errors do you get in error log?
- did sql start with -m option?
- if all fails you may have to try -f option - see BOL for more details
HTH
"Pradip" wrote:

> We are in the process of upgrading our servers. We tried to Restore Master
> Database from SQL 2000 SP3 on Win NT to a new test machine that has SQL 20
00
> SP3 on WIN 2003 Server SP1. The restore says its successful but the servic
e
> doesn't start after restoring. I am using local system account on both the
> machines.
> Also I have tried to restore Master from SQL 2000 SP3 on WIN 2000 Prof SP4
> to the same machine (SQL 2000 sp3 on WIN 2003 server sp1) but ran into the
> same problem.
> I would really appreciate if you could give me some suggestions.|||1. Start SQL from the console ( command prompt) ie sqlservr.exe -m
2. Then do the restore from the database backup.
3. thern Ctrl-C the console, and restart SQL Serve..
What error messages are you getting?
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Pradip" <Pradip@.discussions.microsoft.com> wrote in message
news:C4E333AA-055D-4EDC-8271-9DF88AF68B9C@.microsoft.com...
> We are in the process of upgrading our servers. We tried to Restore Master
> Database from SQL 2000 SP3 on Win NT to a new test machine that has SQL
2000
> SP3 on WIN 2003 Server SP1. The restore says its successful but the
service
> doesn't start after restoring. I am using local system account on both the
> machines.
> Also I have tried to restore Master from SQL 2000 SP3 on WIN 2000 Prof SP4
> to the same machine (SQL 2000 sp3 on WIN 2003 server sp1) but ran into the
> same problem.
> I would really appreciate if you could give me some suggestions.

Restore Master Problem

We are in the process of upgrading our servers. We tried to Restore Master
Database from SQL 2000 SP3 on Win NT to a new test machine that has SQL 2000
SP3 on WIN 2003 Server SP1. The restore says its successful but the service
doesn't start after restoring. I am using local system account on both the
machines.
Also I have tried to restore Master from SQL 2000 SP3 on WIN 2000 Prof SP4
to the same machine (SQL 2000 sp3 on WIN 2003 server sp1) but ran into the
same problem.
I would really appreciate if you could give me some suggestions.
on the original server do you have anything unusual like
- tempdb in ram
- max server memory greater than what is available on new server.
- additional tempdb on drive which does not exist etc . .
- what errors do you get in error log?
- did sql start with -m option?
- if all fails you may have to try -f option - see BOL for more details
HTH
"Pradip" wrote:

> We are in the process of upgrading our servers. We tried to Restore Master
> Database from SQL 2000 SP3 on Win NT to a new test machine that has SQL 2000
> SP3 on WIN 2003 Server SP1. The restore says its successful but the service
> doesn't start after restoring. I am using local system account on both the
> machines.
> Also I have tried to restore Master from SQL 2000 SP3 on WIN 2000 Prof SP4
> to the same machine (SQL 2000 sp3 on WIN 2003 server sp1) but ran into the
> same problem.
> I would really appreciate if you could give me some suggestions.
|||1. Start SQL from the console ( command prompt) ie sqlservr.exe -m
2. Then do the restore from the database backup.
3. thern Ctrl-C the console, and restart SQL Serve..
What error messages are you getting?
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Pradip" <Pradip@.discussions.microsoft.com> wrote in message
news:C4E333AA-055D-4EDC-8271-9DF88AF68B9C@.microsoft.com...
> We are in the process of upgrading our servers. We tried to Restore Master
> Database from SQL 2000 SP3 on Win NT to a new test machine that has SQL
2000
> SP3 on WIN 2003 Server SP1. The restore says its successful but the
service
> doesn't start after restoring. I am using local system account on both the
> machines.
> Also I have tried to restore Master from SQL 2000 SP3 on WIN 2000 Prof SP4
> to the same machine (SQL 2000 sp3 on WIN 2003 server sp1) but ran into the
> same problem.
> I would really appreciate if you could give me some suggestions.