Re: sql server 2000 restore



Hi Wendy,
You can usually find what you need in SQL Server books
online but SQLServerCentral.com has a lot of different
backup and restore scripts available to meet a lot of
different needs. It's a good site for finding useful
scripts.
General link: www.sqlservercentral.com
Backup and restore scripts:
http://www.sqlservercentral.com/Scripts/listscripts.asp?categorynm=Backup%20/%20Restore&categoryid=8

-Sue

On Tue, 6 Dec 2005 12:21:02 -0800, Wendy Elizabeth
<WendyElizabeth@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>For a small company, I need to come up with backup and restore procedures for
>a sql server 2000 database. This company will not consider using sql server
>2005 until the end of 2006.
> Thus I am wondering if you can give me a script and/or point to me to a
>url that that I can use as an example to setup backup and restore procedures
>for a sql server 2000 database?
>
>Thanks!

.



Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... with volume Shadow Copy error 800423f4. ... You back up data from a volume that contains a Microsoft SQL Server ... The recovery model of the SQL Server database is configured to use an ... It just ensures backup will continue without reporting the error. ...
    (microsoft.public.windows.server.sbs)
  • Re: Start SQLServerAgent job Synchronously
    ... Wayne Snyder, MCDBA, SQL Server MVP ... > call and the caller resumes processing as soon as the call is made. ... > I have a set of SQLServerAgent jobs, each of which runs a BACKUP DATABASE ...
    (microsoft.public.sqlserver.server)
  • Re: Start SQLServerAgent job Synchronously
    ... Wayne Snyder, MCDBA, SQL Server MVP ... > call and the caller resumes processing as soon as the call is made. ... > I have a set of SQLServerAgent jobs, each of which runs a BACKUP DATABASE ...
    (microsoft.public.sqlserver.programming)
  • Re: "Best Practices" way to distribute MSDE
    ... > Restore a users's selected backup. ... for dayly house-keeping I do usually provide scripted job for database ... that file copy operation (not SQL Server backup!) can be performed.. ... my personala advice is to perform dayly house-keeping actions ...
    (microsoft.public.sqlserver.msde)
  • Re: NT Backup Causes Server to Hang
    ... Thanks for using the SBS newsgroup. ... You back up data from a volume that contains a Microsoft SQL Server ... The recovery model of the SQL Server database is configured to use an ... It just ensures backup will continue without reporting the error. ...
    (microsoft.public.windows.server.sbs)

Loading