A simple backup need help! - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

A simple backup need help!

Author

Topic

sixpack
Starting Member

6 Posts

Posted - 2006-04-03 : 17:16:23

My hosting company just "upgraded" to mylittleadmin for SQL, we can no longer connect and manage using enterprise manager or local other tools. I need the ability to connect locally, so I'm changing hosting company. The problem is I need an updated backup to transfer to the new server, even tech-support can't figure out this new "upgraded" system. The only help they offered was try the "dump" command, but that only give me a Incorrect syntax near '20' error. This is what I tried using the online Query Analyser:
dump dbname
dump 20twenty

Any and all help highly appreciated....
Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-04-03 : 17:34:07

What is mylittleadmin? Is the dbms still SQL Server?

Tara Kizer
aka tduggan

sixpack
Starting Member

6 Posts

Posted - 2006-04-03 : 17:38:18

It's a new online interface for SQL, there's more info here:
http://mylittletools.net/scripts/en/mla_sql/default.asp

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-04-03 : 17:43:14

I would think Enterprise Manager and Query Analyzer tools would still work regardless. Are you getting an error when using these tools?

According to the link that you sent, mylittleadmin has a backup database wizard. I'd suggest using that to backup your database. Hopefully, it outputs the backup as a SQL Server backup.

Tara Kizer
aka tduggan

sixpack
Starting Member

6 Posts

Posted - 2006-04-03 : 17:47:49

I tried that, tech support could'nt tell where the file is saved...so I can't find it..:(

sixpack
Starting Member

6 Posts

Posted - 2006-04-03 : 17:50:16

The tools will not work anymore, that is why they oppt for the change better security...I'm told.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-04-03 : 17:51:50

Have the hosting company run BACKUP DATABASE in Query Analyzer from the database server as that tool will still work locally. Have them copy the file to you.

Tara Kizer
aka tduggan

sixpack
Starting Member

6 Posts

Posted - 2006-04-03 : 17:55:58

Ok thanks I'll try that..

sixpack
Starting Member

6 Posts

Posted - 2006-04-03 : 18:42:12

Ok tk.. I got the file, the files extension is .bak, how do I import?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-04-03 : 18:47:57

You can restore the .bak file using RESTORE DATABASE command in Query Analyzer. Check out RESTORE DATABASE in SQL Server Books Online for details. If you have specific questions about the command, feel free to ask. Here is an example of the command:

RESTORE DATABASE DBNameGoesHere
FROM DISK = 'E:\MSSQL\Backup\SomeBackupFile.BAK'
WITH REPLACE

You'll need to use the MOVE option in the WITH part if your drives and folders are different than the original.

Tara Kizer
aka tduggan

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources