Networker

Re: [Networker] Microsoft SQL Database

2006-09-21 13:09:44
Subject: Re: [Networker] Microsoft SQL Database
From: Stan Horwitz <stan AT TEMPLE DOT EDU>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Thu, 21 Sep 2006 12:58:33 -0400
On Sep 21, 2006, at 12:08 PM — 9/21/06, Stella Hays wrote:

First, I have been backing up a window's server that runs Microsoft SQL databases. The disk that the databases were on was deleted. We are not able to find all the .ldf and .mdf files. Are we not backing up all these files? The databases are not being stopped. So I would guess the files are open. I did not receive any mail saying "The process cannot access the file because it is being used by another process". This happen when the file is open, correct? The server that is performing the backup is running
Solairs 9 with Legato 7.2.

Second, is there a report I can run that can show me what is being backed
up?  Is this in a log file somewhere?

If you are backing up a live database without the optional SQL module, your backups are probably useless. You need to either shut down your database to back it up, dump the data first, or use NSR's optional SQL module.

To sign off this list, send email to listserv AT listserv.temple DOT edu and type 
"signoff networker" in the
body of the email. Please write to networker-request AT listserv.temple DOT edu 
if you have any problems
wit this list. You can access the archives at 
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER

<Prev in Thread] Current Thread [Next in Thread>