Restoring SQL 7.0 Backup On SQL 2000 Server
Oct 9, 2002
Hi Gurus,
I am new to SQL server and I need your advise on the following .
1. We have two SQL 7.0 Databases at a distant location and we want to move those databases to our location.
2. we plan to take the SQL backup of the databases in tape ( 4Gb and 2 Gb in size) , bring them here, restore them to SQL 2000 server.
- Is this possible , DO SQL 7.0 backups are restored on SQL 2000 without any problems ?.
Also, we plan to take log backups of the DBs at the source after the initial full backups and apply them at the target SQL 2K databases till we cut over to the Target Databases.
Ehat would be the best method of doing this? All your suggestions , pointers to real life scenarios like this, solutions are welcome.
Please let me know if you need any more informations , before suggesting any solution.
Thanks in advance
-Jay
View 3 Replies
ADVERTISEMENT
Jul 20, 2005
Hello,Recently I've tried to restore backup made on SQL Server 6.5.Unfortunately, the only version of SQL Server I currently possess is SQLServer 2000. I have access only to that backup, because I've made it afew years ago, and the main db file doesn't exist any more ;( I would begrateful if you could help me a little ;)RegardsR.Kruk
View 2 Replies
View Related
Dec 7, 2006
When I try to restore my SQL Server 2000 backup file to a newly installed copy of SQL Server 2005 Express using Studio Express, I get the following error:
The backup set holds a backup of a database other than the existing 'UpperBridge' database. (Microsoft.sqlservfer.Express.smo)
The backup is made from an SQL Server 2000 database called 'UpperBridge'
I am trying to restore to a database called 'UpperBridge' which I created under 'New databases' in Studio Express.
Any help very much appreciated.
View 1 Replies
View Related
Jul 26, 2002
Hello all
Help me if there is any way I can restore a backup taken on SQL server 6.5 to SQL server 2000.
The file is in .DAT format.
Regards
Farrukh
View 2 Replies
View Related
Sep 11, 2006
Hi,I am working in a sql server 2000 environment but my customer uses sql server 7. Is it possible to use backup and restore to transfer the database or should I set up a sql server 7 for development?The database only contains tables and views...ThanksKoen
View 1 Replies
View Related
Nov 13, 2006
I did a backup of a SQL2000 database (named Winstis) using the 2005 management studio. I then created a blank database on my 2005 instance (named Winstis). I then tried to do a database restore to the new 2005 database. I got an error:
System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'Winstis' database. (Microsoft.SqlServer.Smo)
I even tried the option to Overwrite Existing database and I got a different error:
System.Data.SqlClient.SqlError: The operating system returned the error '32(The process cannot access the file because it is being used by another process.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'D:Program FilesMicrosoft SQL ServerMSSQLData est.ldf'. (Microsoft.SqlServer.Smo)
Also the 2005 instance database is on C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataWinstis_Data.mdf
and the 2000 instance is on
D:Program FilesMicrosoft SQL ServerMSSQLDataWinstis_Data.mdf
How can I accomplish getting the database from 2000 to 2005 with all tables, store procedures, and functions?
View 2 Replies
View Related
Mar 29, 2007
Hi all,I'm having a problem restoring backup from 2000 to 2005. The actualrestore process went ok. However, the database user of the restoreddatabase is missing a Login Name. I've made sure that the Login Nameis created in 2005. Also tried deleting the user, but couldn't theuser is db owner. Is there any way that I can assign a Login Name forthis database user or maybe drop this user and assign another one?Regards,Gerd
View 2 Replies
View Related
Feb 26, 2007
Hi,
I have a database that is in the SQL Server 2000 compatability mode on my SQL 2005 server. I am trying to restore a backup of this database on my SQL Server 2000 database on another server and keep getting strange messages. First trying Red-Gate and then plain SQL Server with no luck.
It seems as I remember that the 7.0 and 2000 compatibility issue between backups did not arise when the compatibility mode was set to 7.0.
Is this "planned" behavior or an "undocumented feature"??? Anyone else have success doing this?
Thanks,
John Campbell
View 3 Replies
View Related
Sep 6, 2007
I want to read certain data from the backup file of MS SQL 2000 without restoring the database backup file. Based on the data selected I will manage the further functionality such as restoration of the backup file.
Is it possible to read some data from MS SQL 2000 backup file without restoring? If yes then please let me know how?
View 8 Replies
View Related
May 12, 1999
I want to create a database that is identical to one I currently have for testing purposes. I took a backup and tried to restore it to
another server to actually create the database. It wouldn't work, then I created the database on that server and gave it the exact
name and file layout (dbid was different) and tried to restore the backup to the newly created database. Still would not restore.
I am using SQL 7 for backkup and restore. The backup device backs up to disk on the servers. What I am doing wrong?
View 4 Replies
View Related
May 1, 2008
I'm trying to restore databases to a backup server from a production server. This is the message I received. I'm fairly new to this. I haven't touched SQL Server in over a year and wasn't very proficient back then either. Any help would be greatly appreciated!
TITLE: Microsoft SQL Server Management Studio
------------------------------
Restore failed for Server 'ULTIPROBAK'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'HRMS_GLOBALDATA' database. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
-Jeff
View 2 Replies
View Related
Dec 25, 1999
Hi,
I have used the backup tool in MS Access 2000.ADP many times
To make a nice backup of my adp Projects server objects(tables & data) that
I have in my MS SQL Sever 7.0 dBase. and then have successfully restored them back to the same computer that I have backed them up to. .
But now I need to transfer server SQL 7.0 DAT backup files over to two other types of computer setups..
I need to transfer these files and import or restore them onto another
computer that has MS Access 2000 and SQL 7.0 on a NT Server 4.0 platform and
also to a computer that has MS Access 2000 and MSDE on a win98 platform..
Have tried many different things but cannot seem to find a way to transfer or restore the SQL 7.0 DAT files to a different named dbase NT server with SQL 7.0 or to a win98 client with a named dbase on a MSDE file. the ADP client portion is just a simple file transfer but these SQL Server 7.0 DAT backup files... argh!
I am completely stumped even after trying many things and consulting the SQL
server manual.
Christopher James
View 1 Replies
View Related
Nov 21, 2015
I am restoring a backup of sql server 2005 which I inherited on to sql server 2012 and is in a recovery pending state and the reason why is, this is a backup from a different domain and does not have the logins from the legacy domain, looks like its some access issue as its not being able to find the necessary login on sql server 2012.
View 4 Replies
View Related
Oct 3, 2007
Hi,
I have a sql server 2000 backup and I want to restore it into a Sql Server 2005 database.
I did the restore on the usual way. All the database tables were created, but the data didn't get restored.
Pls help!
Thanks!
View 7 Replies
View Related
Jul 20, 2005
I am doing a complete backup on a sql 7 db and then doing a completerestore (with overwrite existing db) on a sql 2000 server. This is nowour hot standby server. I have the process automated and it worksgreat. The only problem I have now is the logins dont work.I have tried running EXEC sp_change_users_login 'Report', and thelogins appear.However, when I run EXEC sp_helplogins 'joe', the results are empty.So, I am guessing all I need is a sp that will re-associate my loginswith the correct db and grant the appropriate permissions.If anyone has any ideas that would be great.I have also considered doing a log ship instead of a full backup andrestore. Does anyone have any suggections or good examples of how tomake that happen?Thanx
View 1 Replies
View Related
Mar 25, 2008
Hi,
Is there any option to restore a specific object from a full database backup file?
View 3 Replies
View Related
Mar 5, 2007
Alright, here's the deal. I'm testing some backup/restore strategies, and hitting a (slight) sticking point.
We've got collections of database and log backups created by the usual maintenance plans on a 2000 Enterprise machine. I'm trying to run through a restore onto a new 2005 machine (Developer Edition on my test workstation) using the collection of .bak and .trn files copied from the 2000 server. When I try to restore to a new database on 2005 via SSMS, and select all the .bak and .trn files for the restore, I get the ol' "The volume on device '[trimmed]' is not part of a multiple family media set. BACKUP WITH FORMAT can be used to form a new media set." error.
I'm assuming this just means that SQL Server can't verify that these log backups are in fact part of a functional "set", even if they aren't part of a traditional backup media set. Is there any way to tell SSMS, "It's okay man, just restore the database from these files, in this order - trust me," or is the only solution restoring every individual log file one at a time? (Which seems to work fine, though is a tremendous pain with any more than a few log backups.) Seems like there ought to be a good one-shot method to restore a bunch of backups to a different server, and I'm just not finding it.
View 4 Replies
View Related
Dec 12, 2014
With all the new functionality, can 2014 now restore a single table from a standard backup without using any third party tools? I have looked, but can't see this listed as a feature (though that doesn't mean it's not there, maybe I've just missed it).
View 6 Replies
View Related
Sep 8, 2015
I got full backup on daily schedule its taking more space on Drive because each file has more than 25GB.I am using SLQ server 2008R2 so I'm looking to take the backup with compression instead of uncompressed Backup. What are the impacts of compressed backup. Is there any problems with compressed backup while restoring the backup file.
View 8 Replies
View Related
Dec 28, 2007
Windows 2003 backup utility uses the shadow copy option that allows it to copy open files.
Therefore, can I use this utility to backup the .mdf and .ldf files for my SQL 2000 database?
I can then attach the .mdf files if I need to restore the database to another server.
Can anyone tell me if this is safe? I've tried it and it worked but I'm worried there maybe some lurking danger in using this approach.
View 4 Replies
View Related
Mar 12, 2007
I would like to know if it is possible to make a backup of a database in a SQL Server 2005 server and restoring it in a SQL Server 2000 server.
Thanks a lot in advanced.
View 5 Replies
View Related
Jul 23, 2005
Dear All,Do anyone know where I can find some useful documentation or anydocumentationabout restoring database to the point in time (using logs).SQL Server 2000 on Win 2000Thanks for all,M&M
View 1 Replies
View Related
Jul 26, 2006
I need to ensure users can submit SQL queries (readonly) to a database whilst transaction logs are restored (at 15 minutes intervals.)
Is this possible?
View 5 Replies
View Related
Jul 20, 2005
I'm trying to rebuild from a meltdown. I'm using disk backup files. Icould have sworn that I had SQL Server 2000 SP3 installed on the oldmachine, but maybe not.With SP3 installed, I get a message along the lines that the restorecan't be done because the backup was created using server version134218262 and this server is version 134218488.I've searched the documentation and can't find any reference to thoseversion numbers.In any case, I thought SQL Server 2000 could restore backups createdon any SP level to any SP level.Any ideas?--Regards.Richard.
View 4 Replies
View Related
Jun 1, 2008
moving to a new sql server box because of a problem with the SAN its connected to.
started my named instance in single user mode and restored master. sqlserve.exe -c -m -s ovops
now the instance won't start. tried starting it with the -t3608 switch.. won't start!!
Its because my drive configuration is different on the new server than it was on the old server, I cannot start the instance because it is expecting model, msdb, temdb and all of the user databases on drives that don't exist?? what can I do?????
View 4 Replies
View Related
Nov 21, 2007
Hey guys
We currenlty have SQL Server 2000 installed inhouse for testing. A client has given us a backup of their 2005 database and i'm wondering if the restore will work into 2000, or any issues i should be aware of. Should i just install msde locally on my machine and restore the database?
thanks
View 2 Replies
View Related
Feb 28, 2008
Hi There
Can U help me?
Have a MDF file from SQL7 and I attempt to attach the databse to sql 2000.
However, keep getting this error when Accessing the database.
Cannot Open Database 'dbname' from version 524. Upgrade database to latest version.
Is there a work-around to solve this problem
Thanks in advance
View 4 Replies
View Related
Nov 29, 2001
I want to know how people are backup up their win2k system and SQL 2000 server. If you want a run backup once a night and first backup win2k file system and then run backup using sql agent will that work?
Thanks.
View 2 Replies
View Related
Sep 3, 2014
I did tried the encryption on server "A" for database "AdventureWorks2012". Then I tried to restore to server "B". There was the certificate issue, and I thought "of course : it's encrypted ! Let's deactivate it". So here I go "ALTER DATABASE AdventureWorks2012 SET ENCYRPTION OFF".I look at sys.databases : not encrypted.I backup using no encryption, I verify using msdb.dbo.backupset : not encrypted.
I move my backup to my other server where encryption was never configured (so no certificate, nothing...), and I have the error :
Msg 33111, Level 16, State 3, Line 1
Cannot find server certificate with thumbprint '0xFA130E58C999C4919B8975999C83A75A403B11D8'.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
View 6 Replies
View Related
Aug 25, 2000
HI everybody,
I have a problem in restoring a backup. In the restore command there is one option called <file> = 'file_number'. Where do we get this 'file_number'?.
tks in advance
Srini
View 4 Replies
View Related
Oct 11, 2001
Hi Everyone, I was prototyping a DB and made a backup of all the files in the data directory of sql server, thinking that I would be able to restore the system from another installation when I made it to the US. I have the cd with the archives on and a full backup of the DB I want but I have no idea how to get sql server to initialise it.
Any ideas???
Steve
View 2 Replies
View Related
Jul 24, 2004
Guys, i've 1.6 GB of backup size and it takes 1 hour for this backup to get restored over a SCSII 10,000 rpm.
Is it normal. How can i make the restore faster.
It takes only 5-10 mins to take the backup however.
I am restoring the full backup, no differential or log file.
Howdy!
View 13 Replies
View Related
Dec 8, 2004
I Have a full database backup of the database aaa ON a server xxxx. I want to restore the same back upto as a database aaa ON another server yyyy.For to achieve this do I need to make the database aaa ON server xxxx.
How can I do that.Please help me in this issue.
Thanks.
View 1 Replies
View Related
