Re: Automating SQL Service start and shut down
From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 06/16/04
- Next message: Pratap Lingam: "RAID 5 Implementation"
- Previous message: anonymous_at_discussions.microsoft.com: "Re: Automating SQL Service start and shut down"
- In reply to: anonymous_at_discussions.microsoft.com: "Re: Automating SQL Service start and shut down"
- Next in thread: Hari Prasad: "Re: Automating SQL Service start and shut down"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 16 Jun 2004 06:22:31 -0500
Resist the temptation to shut down the SQL Server service so that you can backup the mdf and ldf files. Just because you have these does not necessarily mean that you will be able to recover these. Most of the time it will probably work as you expect, but I would hate to be in your shoes if it does not work.
The best option would be using the Transact-SQL BACKUP command.
You mention that you have to backup the whole server....do you have other [data] files on the server (not SQL Server files?). If so, it makes sense to back them up. If not, you have to make the decision as to what you should back up.
Whatever option you choose, make sure that you know how to restore/recover your data and your databases. Grab a tape, restore the files to a different server, and try to get the files restored. Can you get your system up and running again?
You may find these links helpful:
INF: Disaster Recovery Articles for Microsoft SQL Server
http://www.support.microsoft.com/?id=307775
INF: Moving SQL Server databases to a new location with Detach/Attach
http://www.support.microsoft.com/?id=224071
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://www.support.microsoft.com/?id=314546
INF: Using the WITH MOVE Option with the RESTORE Statement
http://support.microsoft.com/?id=221465
PRB: User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://www.support.microsoft.com/?id=246133
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://www.support.microsoft.com/?id=274188
How to Resolve Permission Issues When a Database Is Moved Between SQL Servers
http://www.support.microsoft.com/?id=240872
SAMPLE: Mapsids.exe Helps Map SIDs Between User and Master Databases When Database Is Moved
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
-- Keith <anonymous@discussions.microsoft.com> wrote in message news:1cdd901c4538a$d28e7440$a601280a@phx.gbl... > I didn't make myself very clear, sorry. > > I need to backup the whole server, unattended late at > night. I didn't know how to schedule to turn off/on SQL > to ensure that the DBs were backed up along with the rest > of the server. If the service is running then the DBs are > skipped. > > Many thanks for the feedback/advice. Its an approach I > wasn't aware of. :-) > > >-----Original Message----- > >Why not just issue a Transact-SQL BACKUP command to > backup the databases to disk? You can come along with > your backup software and backup the backup files. This > is the best method, as "backups" taken of the database > and log files without performing sp_detach_db are not > guaranteed to be re-attachable. You can create jobs > within SQL Server that backup your databases to disk on a > particular schedule. > > > >Another benefit of the T-SQL BACKUP command is that the > server (and databases) remain available throughout the > process. You do not experience any downtime. > > > > > > > >-- > >Keith > > > > > >"GW" <Graham.Wilcox@en-dc.co.uk> wrote in message > news:1c82601c452f4$4462ccc0$a301280a@phx.gbl... > >> Can anybody advise me on how to schedule the SQL > service > >> to close before a backup is run and restart afterwards? > >> > >> Many thanks > >. > >
- Next message: Pratap Lingam: "RAID 5 Implementation"
- Previous message: anonymous_at_discussions.microsoft.com: "Re: Automating SQL Service start and shut down"
- In reply to: anonymous_at_discussions.microsoft.com: "Re: Automating SQL Service start and shut down"
- Next in thread: Hari Prasad: "Re: Automating SQL Service start and shut down"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
