How Can I Restore A SQL 2005 Database On My SQL 2000?
Aug 4, 2007
My customer has SQL Server 2005. I have SQL Server 2000 on my laptop (on XP Pro). I believe I have an empty database the same as theirs, but I need to restore their data. They sent me a normal SQL Backup, but my laptop threw a fit and cannot work with it.
They are now trying to export the database to Microsoft Access and send me that, but I won't get that until next week now. However is there a better and easier solution for those of us with insufficient experience of this, please?
Many thanks,
Caspar
View 3 Replies
ADVERTISEMENT
Aug 13, 2006
Hello,
If I have a SQL 2005 database set to SQL 2000 Compatiblity can I create a backup on SQL 2005 that can be restore on SQL 2000.
Michael
View 1 Replies
View Related
Oct 22, 2007
I am maintaining a .net 1.0 asp.net web application that accesses a SQL server 2000 database. I need to backup the database and then restore it on a laptop. Currently it resides on a server. The problem is that on the server they are using sql server 2005. If I backup using 2005 and then try and restore this database using SQL server 2000 or 2005 on the laptop, I get an error message. "Too many backup devices specified for backup or restore; only 64 are allowed. RESTORE DATABASE is terminating abnormally.
What can I do to restore the database? Must it be backed up with SQL server 2000 and then restored with SQL Server 2005?
Please help!
View 1 Replies
View Related
Jul 15, 2006
I'm trying to see the differences between Backup/Restore and Attach/Detach. I backup and detach a database from SQL Server 2000 SP3 and then attach and restore it to SQL Server 2005 SP1.
The differences I noticed are:
1. The restored database has a much larger initial size (database size is same) for data and log.
2. The attached database has a last backup date
3. If the backup is restored over a database, the restored database is showing owned by the database owner of the database restored over but syslogins and sysusers do not match.
I don't understand why #1 happens.
Are there any other differences between Backup/Restore and Attach/Detach?
Thanks,
Peter
View 2 Replies
View Related
Dec 27, 2007
Hi All
I have Computer is setuped SQL Server 2000 and SQL server 2005 when I restore SQL Server 2005 it's OK but when it's not OK when I restore in SQL Server 2000. The Error as follows:
Please help me to solve this problem. Thanks
View 1 Replies
View Related
Oct 17, 2006
Hi All
This is a very urgent requirement of my client having 200 stores and one Head office. the HO has just installed SQL-Server 2005, The HO sends small backups of the data related to stock transfer which needs to be restored at stores. It was working find when both the HO and stores were SQL-Server 2000. but the process has come to a dead halt as the HO has SQL-Server 2005. It is not possible to convert the stores immediately. please help me out.
Thanks
Raoshan
View 3 Replies
View Related
Jul 15, 2007
I have a file backup database SQL Server 2000
I want to restore it to SQL Server 2005.
But it failed.
I try :
Database ( right-click) - Restore Database - From Device - Specify Backup Add
Locate Backup File. I must choose File of Type is All File so that i can find file backup from SQL 2000, if i choose File of Type is *.bak,*.trn so i cannot find that file.
And then i choose OK all. But it failed. The error is below :
Restore failed for Server 'DHBK-734D0C3663'. (Microsoft.SqlServer.Smo)
------------------------------
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: Directory lookup for the file "C:Program FilesMicrosoft SQL ServerMSSQLdataqlsach_Data.MDF" failed with the operating system error 3(The system cannot find the path specified.). (Microsoft.SqlServer.Smo)
Program Location:
at Microsoft.SqlServer.Management.Smo.Restore.SqlRestore(Server srv)
at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreDatabaseOptions.RunRestore()
===================================
System.Data.SqlClient.SqlError: Directory lookup for the file "C:Program FilesMicrosoft SQL ServerMSSQLdataqlsach_Data.MDF" failed with the operating system error 3(The system cannot find the path specified.). (Microsoft.SqlServer.Smo)
Program Location:
at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQueryWithMessage(StringCollection queries, ServerMessageEventHandler dbccMessageHandler, Boolean errorsAsMessages)
at Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSql(Server server, StringCollection queries)
at Microsoft.SqlServer.Management.Smo.Restore.SqlRestore(Server srv)
View 11 Replies
View Related
May 28, 2007
Dear experts, I've a backup in sql server 2005. how can i restore that in 2000? and is it possible to do the same from 2000 to 2005?
Vinod
Even you learn 1%, Learn it with 100% confidence.
View 2 Replies
View Related
Nov 22, 2006
Hi,I have an old 2000 bak file for a db that I would now like restoredonto sql server 2005. I keep erroring out though, this is what I'mdoing:Went to Restore Database in sql 2005, selected the db I want itrestored to, and File (say c: empxyz.bak)Checked the restore checkbox, went to options checked Overwrite theexisting database.Do I need to do anything else, maybe in the Restore the database filesas section? As those path are listed as:C:Program FilesMicrosoft SQL ServerMSSQLdataxyz.mdfC:Program FilesMicrosoft SQL ServerMSSQLdataxyz_log.ldfIf I just run it without updating those mdf and ldf paths, I keepgetting an error:Exclusive Access could not be obtained because the database is in use.Thanks.
View 2 Replies
View Related
Jan 2, 2006
Hello,
I'm tring to restor a DB from sql 2005 (which is located on my local computer) into sql 2000 (which is located on the server) and I am getting this type of message:
TITLE: Microsoft SQL Server Management Studio
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
ADDITIONAL INFORMATION:
Too many backup devices specified for backup or restore; only 64 are allowed.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3205)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.0818&EvtSrc=MSSQLServer&EvtID=3205&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Why? and how to restore SQL 2005 DB to SQL 2000?
View 49 Replies
View Related
Jun 10, 2008
Friends -
Is it possible to restore user databases in SQL Server 2005 with user database backup copy of SQL Server 2000.
Please advise on this.
Cheers:)
VSH
View 11 Replies
View Related
Feb 15, 2007
Hi All
I have a problem in transferring a 2005 backed up database to SQL Server 2000 SP3.
i got an error message, crux of it is
"too many backup devices specified only 64 allowed"
the i browsed MICROSOFT help, downloaded SQL 2000 SP4 - mentioned as a fix for the above error.
Now get a message,crux of it is
"current version of Database in 611 and destination version is 536"
Is there a solution????
should i download any other patches or
Should i tweak the SQL 2005 backup process???
ASAP Plz
View 1 Replies
View Related
May 26, 2006
Does anyone know if this works to where the data is viewable/usable?
I have an application that takes datasets out of the SQL database. We decommisioned our old SQL 2000 SP4 machine and brought in a SQL 2005 Server. What we did was backed up the old database and then restored it on the new Server.
Now the application does not see the old datasets but will collect new ones that are viewable. We can import older datasets but we have nearly 27 GB of data, which our DBA can see the old tables in Enterprise Manager but our applciation can't see it.
I'm thinking it might be a schema issue or the way that 2005 translate the odler 2000 SP4 database. Does anyone know, or have they run a back up on a older 2000 Server and then restored it to a 2005?
Thank you.
David
View 4 Replies
View Related
Nov 14, 2006
While ago my SBS 2003 which had SQL 2000 crashed so I had to rebuild everything and this time I used SBS 2003 R2. My SQL 2000 databases were backed up under Veritas 10 and now I'm trying to restore them under SQL 2005. Is this possible?
Please advice.
Thanks,
Mike
View 4 Replies
View Related
Jul 9, 2007
I need to restore a backup of database taken from SQL 2005 in SQLServer 2000.
I tried to restore from backup file; It says "Error 3205: Too many backup devices specified for backup or restore; Only 64 are allowed" .
I tried to attach mdf file, it too failed.
Can anyone help me in the procedure to restore 2005 backup in 2000?
View 4 Replies
View Related
Nov 14, 2006
While ago my SBS 2003 which had SQL 2000 crashed so I had to rebuild everything and this time I used SBS 2003 R2. My SQL 2000 databases were backed up under Veritas 10 and now I'm trying to restore them under SQL 2005. Is this possible?
Please advice.
Thanks,
Mike
View 1 Replies
View Related
Feb 9, 2007
hi there
i've made a backup from a MS SQL Server 2005 database and i tried to restore this database to a MS SQL Server 2000. Unfortunately, I got following error
The backed-up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrad this database.
what can i do ? is it possible to restore the MS SQL Server 2005 DB on a MS SQL Server 2000 ?
Philipp
View 4 Replies
View Related
Nov 1, 2007
Hi
I need to restore a SQL 2005 DB to SQL 2000.
What is the best method to do this?
Thanks in advance.
View 6 Replies
View Related
Oct 11, 2000
Hi everyone,
Can you let me know, how to restore a database backup of sql 2000 into sql 7.0. If it is explain me the process of it.
Thanks
Jagannath
View 1 Replies
View Related
Oct 30, 2007
I have a database backup from Server Express 2005 that I want to restore to SQL Server 2000. I keep getting an error message saying it was created a newer version and wont work. Is there a workaround to this.
Thanks.
View 7 Replies
View Related
Nov 29, 2001
Hi,
Any one know how to restore a SQL 2000 backup on to a server which has SQL 7.0??
Thanks,
Naveen
View 1 Replies
View Related
Aug 9, 2007
Sorry for basic question, But i dont know more about SQL Server,
During Last weak , i have bought a new server with Plesk 7.6 that SQL Server 2000 Express is installed on it, I want to know how can i restore databases that comes from other servers, for example restore a SQL Server 2000 Express backup file on this server? is there any special software?
Another question is about changing Collation of a database how can i change collation of databases that i make with SQL Server 2000 Express?
View 1 Replies
View Related
Jul 21, 2007
Is there any need to re-apply SP4 to sql server 2000 if a user database has been restored to it from a non-service packed sql 2000 server.
We inadvertantly did this after a flood and later realised that the log shipped server at the other site was not not service packed.
Does service pack 4 update user databases in any way?
We have not had any major issues with this but I need to rule this out when considering performance issues and so on that have been raised since the recovery.
Any help would be appreciated.
View 3 Replies
View Related
Jul 20, 2005
Help,I have a database that has a data file of 2GB and a log file of 31GB.In enterprise manager, when I choose shrink it says there is 30GB ofunused space. When I shrink the database, it does not shrink,(however it says it has completed).I've done a complete backup, tried shrink again, no dice. I thenbacked up the database (which the backup was 1.9GB), deleted thedatabase and made a new database with 2,048MB for the data and samefor the log file.When I restore, the log file jumps up to 31GB again. When I check thespace when I use the shrink, it again says I have 30GB of unusedspace.How on earth do I get this file to shrink?I've been able to shrink other databases, but not this one.TIARob
View 1 Replies
View Related
Sep 11, 2007
Hello,
I am attempting to restore the database from within VB.NET application I am making the following 3 calls:
RESTORE FileListOnly FROM DISK = 'C:MyDatabase.dat'
USE Master RESTORE DATABASE MyDatabase FROM DISK = 'C:MyDatabase.dat' WITH NORECOVERY, MOVE 'MyDatabase' TO 'C:Program FilesMicrosoft SQL ServerMSSQLDataMyDatabase.mdf', MOVE 'MyDatabase_log' TO 'C:Program FilesMicrosoft SQL ServerMSSQLDataLDFMyDatabase.ldf', REPLACE
RESTORE DATABASE MyDatabase FROM DISK = 'C:MyDatabase.dat'
using SMO. This logic works fine with small *.dat files, however when using *.dat file of about 4Gb I get an error on the 3d restore database call:
ExecuteNonQuery failed for Database 'master'.
An exception occurred while executing a Transact-SQL statement or batch.
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Operator aborted backup or restore. See the error messages returned to the console for more details.
ExecuteNonQuery failed for Database 'master'.
An exception occurred while executing a Transact-SQL statement or batch.
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Operator aborted backup or restore. See the error messages returned to the console for more details.
The same program/logic also works fine when I use MS SQL 2005 and it runs fine from MS SQL 2005 Query Analyzer for both 2005 and 2000 databases. There seem to be only problem with MS SQL 2000 from within VB.NET. Anybody has any idea? I'd appreciate any response. Thanks
Eugene
View 6 Replies
View Related
Jul 20, 2005
Yesterday I received a response to my CI/CS Collation problem and therecommendation was to try and restore a CI Collation database to a CSCollation database. After creating a blank CS database a full restore(Force restore over existing database) does change the Collation toCI. I'm unsure as to how I can restore without changing theCollation. Any suggestions?
View 2 Replies
View Related
Jul 27, 2006
In SQL 2000, When I restore a database backup called "A" as "B" the datafile name and log file will change automatically with the new restored database name , whereas in SQL 2005 the datafile name and log file name remains with backup database name.
Will this issue be addressed in next release of service pack.
View 4 Replies
View Related
Oct 10, 2007
Currently I receive the following error when executing script within a DTS package in SQL 2005 (it seems to be working in SQL 2000):
Processed 27008 pages for database 'Marketing', file 'Marketing_Data' on file 5.
Processed 1 pages for database 'Marketing', file 'Marketing_Log' on file 5.
BACKUP DATABASE successfully processed 27009 pages in 15.043 seconds (14.708 MB/sec).
(5 row(s) affected)
Msg 213, Level 16, State 7, Line 1
Insert Error: Column name or number of supplied values does not match table definition.
Msg 3013, Level 16, State 1, Line 1
RESTORE FILELIST is terminating abnormally.
The code I am using is:
-- the original database (use 'SET @DB = NULL' to disable backup)
DECLARE @DB varchar(200)
SET @DB = 'Marketing'
-- the backup filename
DECLARE @BackupFile varchar(2000)
SET @BackupFile = 'C:SQL2005 dbsMarketing.dat'
-- the new database name
DECLARE @TestDB2 varchar(200)
SET @TestDB2 = datename(month, dateadd(month, -1, getdate())) + convert(varchar(20), year(getdate())) + 'Inst1'
-- the new database files without .mdf/.ldf
DECLARE @RestoreFile varchar(2000)
SET @RestoreFile = 'C:SQL2005 dbs' + @TestDB2
DECLARE @RestoreLog varchar (2000)
SET @RestoreLog = 'C:SQL2005 dbs' + @TestDB2
-- ****************************************************************
-- no change below this line
-- ****************************************************************
DECLARE @query varchar(2000)
DECLARE @DataFile varchar(2000)
SET @DataFile = @RestoreFile + '.mdf'
DECLARE @LogFile varchar(2000)
SET @LogFile = @RestoreLog + '.ldf'
IF @DB IS NOT NULL
BEGIN
SET @query = 'BACKUP DATABASE ' + @DB + ' TO DISK = ' + QUOTENAME(@BackupFile, '''')
EXEC (@query)
END
-- RESTORE FILELISTONLY FROM DISK = 'C: empackup.dat'
-- RESTORE HEADERONLY FROM DISK = 'C: empackup.dat'
-- RESTORE LABELONLY FROM DISK = 'C: empackup.dat'
-- RESTORE VERIFYONLY FROM DISK = 'C: empackup.dat'
IF EXISTS(SELECT * FROM sysdatabases WHERE name = @TestDB2)
BEGIN
SET @query = 'DROP DATABASE ' + @TestDB2
EXEC (@query)
END
RESTORE HEADERONLY FROM DISK = @BackupFile
DECLARE @File int
SET @File = @@ROWCOUNT
DECLARE @Data varchar(500)
DECLARE @Log varchar(500)
SET @query = 'RESTORE FILELISTONLY FROM DISK = ' + QUOTENAME(@BackupFile , '''')
CREATE TABLE #restoretemp
(
LogicalName varchar(500),
PhysicalName varchar(500),
type varchar(10),
FilegroupName varchar(200),
size int,
maxsize bigint
)
INSERT #restoretemp EXEC (@query)
SELECT @Data = LogicalName FROM #restoretemp WHERE type = 'D'
SELECT @Log = LogicalName FROM #restoretemp WHERE type = 'L'
PRINT @Data
PRINT @Log
TRUNCATE TABLE #restoretemp
DROP TABLE #restoretemp
IF @File > 0
BEGIN
SET @query = 'RESTORE DATABASE ' + @TestDB2 + ' FROM DISK = ' + QUOTENAME(@BackupFile, '''') +
' WITH MOVE ' + QUOTENAME(@Data, '''') + ' TO ' + QUOTENAME(@DataFile, '''') + ', MOVE ' +
QUOTENAME(@Log, '''') + ' TO ' + QUOTENAME(@LogFile, '''') + ', FILE = ' + CONVERT(varchar, @File)
EXEC (@query)
END
View 1 Replies
View Related
Nov 1, 2007
can we restore (migrate) database from MS SQLserver 2005 to MS SQLserver 2000
Pls reply.
View 2 Replies
View Related
Jul 23, 2005
The following failed in EM (or whatever it is called now managementstudio I think) and I scripted it out and ran it in a query window toget more info. This works fine in SQL 2000 but not in 2005. I also triedto 'create' the database first then ran this command below but with the'force restore over existing database' checked on but this failed alsowhich is odd as well. Any ideas. This is my very first play with 2005 soit is not off to a great start although to be fair, i seem to have gorlucky on the install as it all went OK. BTW, is there a more approriatenewsgroup for this query?ThanksRESTORE DATABASE [bob] FROM DISK = N'C:BigFujiCopiesBob.bak' WITHFILE = 1,MOVE N'bob_Data' TO N'c:Program FilesMicrosoft SQLServerMSSQLDataob_Data.MDF',MOVE N'bob_Log' TO N'c:Program FilesMicrosoft SQLServerMSSQLDataob_Log.LDF',NOUNLOAD, STATS = 10GOMsg 5122, Level 16, State 1, Line 1Directory lookup for the file "c:Program FilesMicrosoft SQLServerMSSQLDataob_Data.MDF"failed with the operating system error 3(error not found).Msg 3156, Level 16, State 3, Line 1File 'bob_Data' cannot be restored to 'c:Program FilesMicrosoft SQLServerMSSQLDataob_Data.MDF'.Use WITH MOVE to identify a valid location for the file.Msg 5122, Level 16, State 1, Line 1Directory lookup for the file "c:Program FilesMicrosoft SQLServerMSSQLDataob_Log.LDF" failed with the operating system error3(error not found).Msg 3156, Level 16, State 3, Line 1File 'bob_Log' cannot be restored to 'c:Program FilesMicrosoft SQLServerMSSQLDataob_Log.LDF'. Use WITH MOVE to identify a validlocation for the file.Msg 3119, Level 16, State 1, Line 1Problems were identified while planning for the RESTORE statement.Previous messages provide details.Msg 3013, Level 16, State 1, Line 1RESTORE DATABASE is terminating abnormally.*** Sent via Developersdex http://www.developersdex.com ***
View 2 Replies
View Related
Nov 18, 2007
Hi experts,
I had a database in sql server 2005 under instance name 'rohitcvman'. I took its backup. The computer is formatted and sql server 2005 is installed again with instance name 'rtamrakarcvmanager'. When I try to restore it, it ends up with the following message (copied from message box).
TITLE: Microsoft SQL Server Management Studio
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
ADDITIONAL INFORMATION:
Too many backup devices specified for backup or restore; only 64 are allowed.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3205)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.0194&EvtSrc=MSSQLServer&EvtID=3205&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
I also have its 'MDF' and 'LDF' file. When I try to attach it, I get the following message:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Attach database failed for Server 'rtamrakar'. (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=Attach+database+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Could not find row in sysindexes for database ID 15, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
Could not open new database 'CVManager'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=602&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
I have not tried to restore/attach in the same instance name from which it was backed up. Is it compulsory to have same instance name to attach/restore?
Can any one help me?
Thank you.
View 13 Replies
View Related
Jan 31, 2008
I am using SQL server 2005 9.00.3042 . When I go to databases restore, restore to Northwind, from device
I select backup device and select SDLT. The actual backup device is LTO3.
The error is an exception occurred while executing a Transact-SQL statement of batch
Timeout expired. The timeout period elapsed prior to completion or the server is not responding.
I checked and we have no firewall turned on this server
I tried on another SQL 2005 9.00.3042 server - this one has an SDLT drive and the error is similar
Restore headeronly is terminating abnormally
View 2 Replies
View Related
Oct 30, 2007
Is there a way to grant rights to a user to be able to restore a specific database on a server, without being able to muck around with other databases on the server?
View 1 Replies
View Related
