Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Problem in BACKUP job

 
   Database Forums (Home) -> Replication RSS
Next:  How does it work -- with triggers/  
Author Message
SouRa

External


Since: Mar 01, 2005
Posts: 12



(Msg. 1) Posted: Fri Sep 09, 2005 9:48 pm
Post subject: Problem in BACKUP job
Archived from groups: microsoft>public>sqlserver>replication (more info?)

Hi,

I am using a job to take daily backup.

BACKUP DATABASE databasenameTO DISK=N'path'
WITH INIT,NOUNLOAD,NAME=N'name',
NOSKIP,STATS=10,NOFORMAT

and it was working fine.
When I tried to restore the backup, I couldn't restore it, the backup was
uncompleted(I know this only when i tried to restore it). But in Enterprise
manager Last Run Status shows 'Succeeded'.

Is there any option to check whether the backup is in good condition or to
check the integrity of the backup immediately after the completion of
backup(through query without restoring the backup).

Thanks,
Soura

 >> Stay informed about: Problem in BACKUP job 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
why is the SQL backup filesize so big - Hi, We have an database which is about the file size of 730MB, this db is set configure with publisher and will always push data to our backup server database. When we backup this db, the database backup filesize is actually 85GB (full backup from SQL)...

Backup - 2000 - I've got a distibutor server, 1 publishing server and 3 subscribing servers all on SS 2000 SP4 with transactional immediate replication. What I want to know is this: 1) what is the "best practices way" to back up the distributor and 2) if ...

Initialize from backup files. - Hi, I have both my server at different location with around 4GB of database and network is poor. I am trying this feature of SQl 2005 replication which allows initial snapshot from backup. I could do it with pubs db but couldn't understand some..

Backup and restore of publisher - We use SQL Server 2000 with merge replication with 500 users. We are moving the server and need to temporarily move the database to a different server while the server is moved. Is there a way to backup and restore the server (publisher) without..

Off Site Backup Server - We are in the process of setting up an Off Site backup Server. Our production Server is currently Window Servers 2003 with TS, and we will be using DFS to duplicate the data on the other Server. Both Servers will be running GoldMine and SQL Server..
   Database Forums (Home) -> Replication All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]