Restoring Backup From SQL 2000 To SQL 2005 But Login Name Is Missing
Mar 29, 2007
Hi all,
I'm having a problem restoring backup from 2000 to 2005. The actual
restore process went ok. However, the database user of the restored
database is missing a Login Name. I've made sure that the Login Name
is created in 2005. Also tried deleting the user, but couldn't the
user is db owner. Is there any way that I can assign a Login Name for
this database user or maybe drop this user and assign another one?
Regards,
Gerd
View 2 Replies
ADVERTISEMENT
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
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 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
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
View Related
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
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
Jun 2, 2008
i'm trying to set up one of the asp.net website starter kits and part of the process is to backup the sql express db and then import it into the sql 2005 at the web hosting account. it's not working and i'm wondering if there's any difference between the backups they make. the sql express makes a file with a .bak extension and the sql 2005 at the host makes a file with a .sqlbak extension. i was assuming that was just a naming thing and not a structural thing but the host's tech support has said:
"This sort of thing happens when the database being imported is not properly formatted. You can try downloading and using sql express from microsoft to see if you can do it manually, but most likely you will need to save your database again properly set for import to an mssql server rather than however you did."
all i had done was rename the .bak file from express to .sqlbak as that was the choice for backup files.
i will note that it also failed importing the .mdf, which works fine locally with the site but i did make some changes to it from the original that came with the starter kit.
should a backup file made with sql express (using sql management studio express, by right clicking on the file and choosing tasks > backup) normally be importable by sql 2005?
or, i suppose, does it make sense that a db that works fine locally with sql express (within a visual web developer express project anyway) would actually be "formatted" in a way that would cause it to fail to import into sql 2005?
thanks much for any assistance.
View 3 Replies
View Related
Oct 24, 2006
I am currently having a problem with restoring a backup made on SQL 2000 XP machine onto a Windows server 2003 machine with SQL Express 2005. I am getting the following error
"System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'C:Program FilesAvidian TechnologiesProphetavidian.mdf'. (Microsoft.SqlServer.Express.Smo)"
I'm not sure what is going on becuase I have no issues installing the backup on my XP Pro machine that has SQL Express 2005 Dev edition. So what I did was restore the backup on to SQL Express 2005 on my dev machine and backup again. Unfortunately when I took the newly created backup and tried again to restore the database on to my window server 2003 machine it failed again. Exact same message was displayed.
Any suggestions or help would be greatful.
Thanks,
Rodney
View 1 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
Jun 20, 2007
Hello,
I'm having an issue with stored procedures after restoring a db from 2000 -> 2005.
If any stored procedures isnt owned by dbo (eg tomsqluser.updateItems rather than dbo.updateItems) then it just wont work and Studio Management Server doesnt give the permission to change it to dbo.
Is there any way around this after restoring?
View 10 Replies
View Related
Nov 11, 2007
hi there,
I've got a problem while restoring a DB from sql server 2005 to sql server 2000 I always got an error message 3169.
Please I want if it's possible to make it, it urgent.
Thanks in advance
View 1 Replies
View Related
Oct 16, 2007
Hi Guys,
I have two servers at my site out of which one is our production server (on SQL 2000) and the other being a reporting server (SQL 2005). Now the question i have are the following..
Q1) Can i restore an hourly differential backup of my SQL 2000 to SQL 2005?
Q2) If yes, are there any specific way i need to go about it other than the conventional Restore with NoRecovery option?
Q3) If the answer is no to Q1, then is there any 3rd party software that does this(restoring differentials from 2000 to 2005)?
I had tried this once some time back and at that time it failed to keep the database in a state(norecovery) where in it would accept timely differential db restoration.
Appreciate your help
sk
View 5 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
Jan 11, 2007
Hi all,
We are experiencing major performance issues after restoring SQL Server 2000 db into newly setup hardware environment. The application is faster on another environemnt running on Windows 2000 server with SQL Server 2000.
We have replicated exact same hardware setup, but only fifference is we are running latest version windows server (2003) and latest version of SQL Server (2005). So far we have troubleshooted the bottleneck to be one of the trigger that is inserting data into a table in one of the stored procedures. The same SP takes 9 mins to execute whereas on our env it takes around one hour. If I disable the trigger it executes in 2 minutes.
After restoring, we have executed
exec sp_updatestats
DBCC UPDATEUSAGE
DBCC DBREINDEX all tables
Set Compatibility level to SQL SERVER 2005 (90).
Now we are installing latest Service Pack for both OS and SQL Server.
Any ideas?
Your help is appreciated.
View 1 Replies
View Related
Apr 27, 2007
Hello,
Is it possible to restore a SQL 2000 backup with Binary Order collation to a new SQL 2005 installation with Dictionary order, case-insensitive. Is this something I can do during the restore process or would I need to change it after?
Thanks in advance,
Buster
View 3 Replies
View Related
Sep 4, 2006
Hello,
I tried to restore a database which I backuped from MS SQL 2000 to SQL Express 2005 but it always failed with the following error message. What could be the problem?
Restore failed for Server 'SERVSQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)
Additional information
System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'gtp' database.
(Microsoft.SqlServer.Express.Smo)
Thanks
View 23 Replies
View Related
Nov 8, 2007
Hi All,
I was trying to restore MSDE 2000 database to SQL 20005 EE and I got stuck with the following error:
System.Data.SqlClient.SqlError: RESTORE detected an error on page (xxxx:xxxxxx) in database 'testdb' as read from the backup set.
Do you think some pages are corrupt from the db or the backup set?
Has anybody come across this? Any ideas to resolve this error?
Thanks,
Siva.
View 4 Replies
View Related
Mar 30, 2007
We have a set of databases some are fully read-only others have read-only file groups, is there any way to restore backups of these taken on an MSDE 2000 to an SQL Express 2005 instance?
When doing the inplace upgrade we change these to read-write before the upgrade and set them back after the upgrade.
These databases are used in the field by customers althought the controlled upgrade requires a backup before (and blocks if it fails) and tries a backup after if the post upgrade backup fails (due to disk space) we might need to recover from this odd situation.
The only solution I have is install MSDE some place restore to this then do the controlled upgrade again, any other ideas?
View 2 Replies
View Related
Sep 18, 2006
Hi all.
I don't know if this is the right forum to post this question, but here it goes.
We have restored into sql 2005 the database backups made in sql 2000. We connect with trusted connection and application roles, and when trying to execute a transaction to another database (with the guest user), we get a permission error.
Does anyone know if, apart from restoring the databases, we should do something else to get the guest user working the same way as with sql 2000 in the restored databases?
Thanks in advance for your help.
View 1 Replies
View Related
Jul 19, 2007
I am attempting to move some SQL 2000 databases to SQL 2005. My main production database does not seem to want to move. When I use the SQL 2005 GUI the .bak backup file is marked 'Incomplete'. When I attempt to restore the backup file I get a 'RESTORE detected an error on page (0:0) in database' message. I saw a thread in the SQL Express forum suggesting trying to restore from the T-SQL level to get the GUI out of the picture and I get the same 'error on page (0:0)' message. However when I take the same file and use SQL 2000 Enterprise Manager it restores with no problems.
Any ideas?
Thanks
Mike Mattix
View 8 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 27, 2005
Hisql server 2005. Is there any way to restore from a backup if the originaldb has been deleted? I have created a blank db and have tried to restoreinto it but it says the db is not the same.ThanksRegards
View 1 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
Apr 23, 2008
Hello,
I would like to ask you if there is better to recreate database structure on 2005 from 2000 and move data or to just load
2000 backup.
Currently I loaded the backup, but I am wondering if there might be slightly better performance on 2005 when recreating structure on 2005 to loading 2000 backup?
Does loading 2000 backup create 2005 binary structure?
Thanks for help in advance
View 5 Replies
View Related
Sep 6, 2007
Good day ,
Does anyone know how to moe / copy database users from sql server 2000 to sql server 2005. I ave been successful will everything except this in my migration. I can copy the database users themselves but not the users under the security section.
Please help
View 4 Replies
View Related
Nov 3, 2014
I scheduled automatic backup process but its only showing backup of the only one .sql file in the backup folder. Other created .sql files are not backed up. Why is it so?
View 5 Replies
View Related
Jan 18, 2008
I'm attempting to write a script that I can execute accross 30 servers that will create a domain login and subsequently grant access to said account on all databases per server. The only problem that I'm running into is trying to dymanically create the login. Example source is below.
declare @sql varchar(1000)
declare @loginname varchar(50)
select @loginname = 'DOMAINaccountname'
set @sql = 'if not exists (select * from master.dbo.syslogins where name = N' + char(39) + 'DOMAINaccountname' + char(39) + ')' + char(10) + char(13)
set @sql = @sql + 'begin ' + char(10) + char(13)
set @sql = @sql + char(9) + 'exec master.dbo.sp_grantlogin ' + quotename(@loginname)
print @sql
exec (@sql)
Here is the generated output and the error. Any suggestions would be appreciated.
if not exists (select * from master.dbo.syslogins where name = N'DOMAINaccountname')
begin
exec master.dbo.sp_grantlogin [DOMAINaccountname]
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near 'DOMAINaccountname'.
View 4 Replies
View Related
Mar 21, 2007
As I said in the subject I've a problem trying to restore a backup of a previous db created in sql 2000 server
When I try to do it I recive the following message:
____________________________________________________________________________________
System.Data.SqlClient.SqlError: Il set di backup include il backup di un database diverso dal database 'musica2007' esistente. (Microsoft.SqlServer.Express.Smo)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476
------------------------------
Program Location:
in Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQueryWithMessage(StringCollection queries, ServerMessageEventHandler dbccMessageHandler, Boolean errorsAsMessages)
in Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSql(Server server, StringCollection queries)
in Microsoft.SqlServer.Management.Smo.Restore.SqlRestore(Server srv)
____________________________________________________________________________________
What should I do? What's the probem? I've already tried to look for the solution in other messages but I didn't find anything..... Thanks for help,,, by Luke
View 1 Replies
View Related
Dec 10, 2007
Hi,Good morning to All,
I have SQL Server 2005 installed on my system. Recently I have formatted by computer. But I couldn't take backup of my data. Big loss.
For this, I've googled also. but I couldn't get clear information.
I want like the following:I could able to backup entire the Database either into my pen-drive, or some other media.And, latter I could able to put the Data back into my system.
Can anyone please tell how to take backup of my Data, and Restore also.
Thanks in advance,Ashok kumar.
View 1 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
