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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-03-17 : 08:14:32
|
| tspoon writes "Hi, I'm new to SQL Server, and don't want to bore you with the long details of how I came from being an accountant a few weeks ago to now be managing 20 odd SQL 7 databases with limited knowledge, but 'that's life'. However I've been left with the task to move a database from one server to the another.I thought the best way I'd do this was to take a backup and restore the backup to the destination server (simple enough, eh)Well, my backup just hangs, for no apparent reason. The Database is up and running. I'm trying to do this via Enterprise Mgr.I then attempted to execute the backup using the maint plans and the backup wizard - (after reading a few articles on here) and on all three occassions the backups will just hang. There is sufficient disk space on the relevant device and both servers are on the same network. The dialogue box remains opened, stating 'Backup in progress'Do you have any reasons for this happening?Would it be better to take an import and export the dump?Other things that I could checkThanks for your help" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-03-17 : 08:22:33
|
| I'd recommend doing the backup through Query Analyzer:BACKUP DATABASE myDB TO DISK='myDB.bak' WITH INIT, STATS=5You should change 'myDB.bak' to the drive and path where you want to put your backup file(s). The INIT keyword will overwrite any existing backup files with that name. STATS will give you progress messages as the backup proceeds, and will notify you when it is completed or if there is some kind of error.You can find more information in Books Online under "BACKUP DATABASE". |
 |
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-03-17 : 10:28:24
|
| Even with stats, you may have to be patient depending on how big the database is. How do you know that it is hanging? Can you see disk activity (or increased activity) on the backup volume during the backup? |
|
|
|
|
|
|
SQL Server 7.0 Backup Hangs