How to restore bak file in sql server 2000

Verify your account to enable IT peers to see that you are a professional. Are you running Q. View this "Best Answer" in the replies below ».

I am actually using the SA account. So it has full access. This works for us, it may totally botch your system, so use with care. If error occurs please execute following command it will convert database in multi user. Well no luck with that either. But in this restoration I have copied the backup file back to the server to do this restore.

I think I figured it out. After some testing and looking at the backups that were created by the previous person. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums.

Sign in to vote. I backup the database from SQL From Management Suit, I try to restore database but I can not see network drive from there even though SQL serveris running under network account. I could see network drive from SQL or at least I can type path to find backup file.

However I can not do this.. My Q is: 1. If not, what is the best practice to upgrade this database into SQL ? Eventually porduction server will be scrup and install SQL and then restore DBs into production machine Thx in advance Jay. Thursday, December 8, PM. Okay since this forum has failed to answer the question, here's the process in SSMS. Tuesday, July 11, AM. We support restoring from network paths. You need to ensure the sql service has access to the path. The GUI would also need access to the network path.

You might try using an explicit UNC rather than drive letters. We automatically upgrade the system tables as part of the restore or attach. Monday, December 12, PM. Steve Schmidt Thanks for the post here. I get the following error. Sunday, February 12, PM. Your procedure is correct.

Hope that helps. Monday, February 13, PM. I have 2 databases. After some research, I saw that the best approach is making a. I tried some youtube tutorial videos but without results. If you only have. This is not a recommended method for restores, but may be what you need. Or, there are several posts out there about attaching a database without a transaction log file.

One random choice:. If your SQL Server If the file has been corrupted, of course, then there is little to be done. And it has been so long since I used it that I do not remember all the problems and limitations. If you need a full version of SQL Server , then I would suggest that you talk to other SQL Server users in the area and find one who still has retained an original install disk. Sign up to join this community. Connect and share knowledge within a single location that is structured and easy to search.

I'm facing a huge problem. I'm trying to restore a database to a newer version of SQL server. I have been told that it is possible to go upwards - to newer versions - but never backwards. SQL Server cannot process this media family. The backup file can be corrupted, or it can be from newer version of SQL Server. Try getting fresh backup and restoring it.

And double check the target instance name. Maybe by accident you're trying to restore not in intended instance. It happens How are we doing? Please help us improve Stack Overflow. Take our short survey.