I have a MS SQL database backup from a client and would like to use this to create the database on my local machine.
I have been advised to do this by using restore database in enterprise manager.
I am lost though as I really dont know much about MS SQL - sorry people but can anyone tell me how to do this?Sure (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_20h1.asp).
-PatP|||I think they had the database on their D:/ drive and I only have a C: drive
That is whats causing the problem I think.
Any suggestions on how to get round this?
Thanks
Paul|||When restoring in EM, click on Options tab and change the path for every device there.|||and buy a copy of this book...
Inside SQL Server 2000 By Kalen Delaney (http://www.bestwebbuys.com/Inside_Microsoft_SQL_Server_2000-ISBN_0735609985.html?isrc=b-search)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment