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 |
|
bayman
Starting Member
4 Posts |
 Posted - 2007-10-05 : 07:26:55
|
| hi all,i want take backup of sql 2005 64-bit database using a third party backup software. we have done the following things.1 production server which is 24x7 is doing log shiipping to another publishing server which is 24x7 ........the 2 nd server database is in read-only mode due to log shipping .....i want to take database backup from the secondary server. is it possible????thanks. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-05 : 23:46:32
|
| Did you ever try it? |
 |
|
|
bayman
Starting Member
4 Posts |
Posted - 2007-10-06 : 06:27:14
|
| yup .....giving error..... |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-06 : 07:43:07
|
| And the error message is? |
|
|
|
bayman
Starting Member
4 Posts |
Posted - 2007-10-06 : 14:28:22
|
| database backup/restore error in retrospect..... |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-06 : 14:52:26
|
| So you are using Retrospect to make the backups?My advice would be to have SQL Server backup to a file, and then let Retrospect (or whatever) backup that file.Kristen |
|
|
|
bayman
Starting Member
4 Posts |
Posted - 2007-10-06 : 14:58:41
|
| cant do a file backup ..coz the database is in read-only mode.....due to log shipping.....any idea abt it...???? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-06 : 19:46:39
|
| Not file backup. Try backup db with sql statement 'backup database', then use your tool to backup db backup file. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-07 : 01:57:45
|
"cant do a file backup ..coz the database is in read-only mode.....due to log shipping....."Sorry, you misunderstood me.As rmiao say.To clarify:You make a backup using SQL Server tools.That creates a file - with a filename like MyDatabaseName_yymmdd_hhmmss.BAK - and you backup THAT file using your 3rd party software.I don't doubt that Retrospect is very good, but this forum has had lots of posts over the years along the lines of "I'm use XYZ program to backup my database and now I cannot restore from my backup""I'm use XYZ program to backup my database and it doesn't work now that Service Pack NNN is out""I'm use XYZ program to backup my database ... I have some problems with my database ..."and my advice would be never to use 3rd party software to backup the database directly, let SQL Server backup to a file, then have the 3rd party software backup that file.I'll add to my list:"My 3rd party software can't backup a log-shipping database"  Kristen |
|
|
|
|
|
|
sql 2005 64 bit backup