restoring database procedure - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

restoring database procedure

Author

Topic

mwagz
Starting Member

4 Posts

Posted - 2007-01-03 : 01:58:20

I have some databse files one is 18gb databse primary file the rest r log files.I want to migrate it to a newly created databse on another SQL server...
Whats the procedure for it?

sponguru_dba
Yak Posting Veteran

93 Posts

Posted - 2007-01-03 : 02:07:37

Hi

That means you have .mdf and .ldf files and you say "migration" please mention the version
from which are version you want to migrate to which version

SreenivasaRao
Bangalore,INDIA

mwagz
Starting Member

4 Posts

Posted - 2007-01-03 : 02:53:52

I have tried to attach the mdf to the new database but i keeo getting an error :
Couldnt find row in sysindexes for database ID15, index ID1,Run DBCC ChECKTABLE on sysindexes.

I'm using MS SQL Server 2000 enterprise edition

Kristen
Test

22859 Posts

Posted - 2007-01-03 : 03:48:20

I recommend that you Backup from the old server and Restore to the new server.

See:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Move%20database,Moving%20to%20a%20new%20sql%20server,Fix%20Orphaned%20Users

and see also the Backup and Restore links near the Move Database links highlighted.

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources