| Author |
Topic |
|
BlackReefDesigns
Starting Member
27 Posts |
 Posted - 2009-01-07 : 00:29:51
|
| Hello -I reviewed the "Sticky" post at the top of this forum, but I did not find anything that could help me in my specific situation.Basically, I am Web Designer, not even a Web Programmer, hehe.A Client contacted me and told me that he wants to move a website I designed for him to a new server, since the hosting company he was with at the time went sour. I purchased a GoDaddy.com shared account, only to find out that I couldn't use any backup SQL files that came from any other hosting company besides GoDaddy.com. The GoDaddy.com support told me my only solution was to purchase a virtual server plan, and there won't be any database restrictions.So we purchased a Windows Virtual Server plan and I set it up, which I had never done before. I then contacted the old hosting company and requested a SQL Backup. They sent it in a ".backup" format.I have had one hell of a time trying to get this backup Database restored on the new virtual server. The new server uses Plesk for a CP as well. We installed SQL 2005 on the server side, and then created a new SQL Database.However, while trying to use the built-in Plesk 'restore' feature, I keep getting this error:"Error: Unable to creste database user: Some fields are empty or contain an improper value. Database user name is invalid. Only latin letters are allowed in the database user name 'login'."The Hosting Support company basically said I am "on my own" since this is a Virtual Server and they don't offer support.Also, the ONLY information I have on the ".backup" format is this E-mail I received from the Old Hosting company:"We use the MS SQL Studio Management package; and have simple tools such as "incremental" or "full" backups only. -- Support ran you a "full" backup. "What do you guys recommend I do? I can access the new server remotely but I don't know what to do once I log in.I THINK all these issues stem from the ".backup" format. Shouldn't SQL Backups be in a different format?Any help would be GREATLY appreciated - I have been working on setting up this server and moving everything over for over a week now!Thank you-Joe |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-01-07 : 02:26:08
|
| To restore a database, you use RESTORE DATABASE command. I don't have a clue what Plesk is or what "CP" is. Do those even work with SQL Server?Here's an example command to run in Management Studio:RESTORE DATABASE db1FROM DISK = 'E:\Backup\db1.bak'WITH REPLACE, MOVE 'db1_data' TO 'E:\MSSQL\db1.mdf', MOVE 'db1_log' TO 'E:\MSSQL\db1.ldf', STATSIt doesn't matter what extension the old hosting company used. If they used the full backup option in Management Studio, then it's a valid SQL Server backup. I think it's just Plesk giving you issues. Use the SQL Server client tools, such as Management Studio.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
BlackReefDesigns
Starting Member
27 Posts |
Posted - 2009-01-07 : 02:40:12
|
| Sweet! I happen to have SQL Server Management installed on my PC! This is good news, and I figured that the CP would be giving me issues, but I didn't know any better since this is literally my first week of learning all this SQL stuff. The more I learn, the less I am intimidated by it though.ANYWAYS, the example you gave me - is it just an example, or could I really put my database backup name in there and run it? Also, where in Management Studio would I put place the command? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
BlackReefDesigns
Starting Member
27 Posts |
Posted - 2009-01-07 : 14:55:35
|
Oh, I inquired about more information about the backup file the old hosting company made, here is what he said:"I named the file ".backup" for clarity purposes. Microsoft MS SQL normally wants to name it "something.bak"MS SQL 2005 is what we use as well - make sure you apply all the patches / service packs / etc... as we are on the latest versions security wise from Microsoft." |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
BlackReefDesigns
Starting Member
27 Posts |
Posted - 2009-01-07 : 15:06:11
|
| Should I use the Management Studio through Remote Desktop, or just use it through Windows XP? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
Moving SQL Database to new Virtual Server - Help