"Fabrice" wrote:

> Hello,
>
> A question about backup and restore. I'm not an export of sql server.
> I have installed sql server 2005 on windows 2003 R2.
> On my server i have two partitions. C: and D:
> Mon named instance is installed on D:
>
> What I nedd to be ready in case of disaster. For the moment I do this :
>
> 1/ Backup of my user database with sql agent.
> 2/ Backup of the system database with sql agent.
> 3/ Backup Of the system : All the files on C: and All the folder On D:
> (without the database and log).
> 4/ Ido two cold backup two times per year. I stop all the Sql server
> services and backup all directory on C and D with the database and log.
>
> I'm not sure of the procedure.
>
> Can you help me to define the best way or procedure to know what I must
> backup to be ensure to be abble to restore my server from scratch.
>
> Thanks for your help
> fabrice
>
>
>

"Jelle" wrote:

> Hi Fabrice,
>
> These are very broad questions and as I am learning, it all depends on many
> factors.  However, hear are some sites that may help you get started.
>
> Always include this site in your search for information - Microsoft Books
> On-line
> http://msdn.microsoft.com/en-us/library/bb545450.aspx
>
> Backing Up and Restoring Databases in SQL Server
> http://msdn.microsoft.com/en-us/library/ms187048(SQL.90).aspx
>
> Backup Windows Server 2003
> http://www.gafvert.info/BackupWindowsServer2003.htm
>
> Free on-line videos - Watch or Download: "SQL Server Backups Demystified"
> and "Understanding Backup Options"
> http://www.sqlservervideos.com/browse/skill/#Conceptual
>
> This last site is very helpful for beginners in SQL Server.
>
> Regards,
>
> Jelle
>
>
> "Fabrice" wrote:
>
> > Hello,
> >
> > A question about backup and restore. I'm not an export of sql server.
> > I have installed sql server 2005 on windows 2003 R2.
> > On my server i have two partitions. C: and D:
> > Mon named instance is installed on D:
> >
> > What I nedd to be ready in case of disaster. For the moment I do this :
> >
> > 1/ Backup of my user database with sql agent.
> > 2/ Backup of the system database with sql agent.
> > 3/ Backup Of the system : All the files on C: and All the folder On D:
> > (without the database and log).
> > 4/ Ido two cold backup two times per year. I stop all the Sql server
> > services and backup all directory on C and D with the database and log.
> >
> > I'm not sure of the procedure.
> >
> > Can you help me to define the best way or procedure to know what I must
> > backup to be ensure to be abble to restore my server from scratch.
> >
> > Thanks for your help
> > fabrice
> >
> >
> >

"babai" wrote:

> Fabrice,
>
> Regarding Backup strategies, you need to decide few factors:
> a) What kind of business it supports.
> b) How much of data loss can one let go...
> c) Based on some of the above facts you need to select the recovery Model
> and then design the Backup strategy..
>
> Sharing below few of the Disaster recovery article i would usuallly
> recommend. Lemme knw if you need anything...
>
> • 325257 Support WebCast: SQL Server 2000 Database Recovery: Backup and  
> Restore http://support.microsoft.com/?id=325257 
> • Designing a Backup and Restore Strategy, 
> http://msdn2.microsoft.com/en-us/library/Aa173660(SQL.80).aspxus/adminsql/ad_bkprst_63eh.asp
> • 829024 INFO: Microsoft SQL Server 2000 Operations Guide
> http://support.microsoft.com/?id=829024
> •307775 INF: Disaster Recovery Articles for Microsoft SQL Server
> http://support.microsoft.com/?id=307775
> •321836 HOW TO: Retrieve a Table or Rows from Database or Transaction Log
> Backups
> http://support.microsoft.com/?id=321836
>
> Regards
> Pranab
>
>
>
> "Jelle" wrote:
>
> > Hi Fabrice,
> >
> > These are very broad questions and as I am learning, it all depends on many
> > factors.  However, hear are some sites that may help you get started.
> >
> > Always include this site in your search for information - Microsoft Books
> > On-line
> > http://msdn.microsoft.com/en-us/library/bb545450.aspx
> >
> > Backing Up and Restoring Databases in SQL Server
> > http://msdn.microsoft.com/en-us/library/ms187048(SQL.90).aspx
> >
> > Backup Windows Server 2003
> > http://www.gafvert.info/BackupWindowsServer2003.htm
> >
> > Free on-line videos - Watch or Download: "SQL Server Backups Demystified"
> > and "Understanding Backup Options"
> > http://www.sqlservervideos.com/browse/skill/#Conceptual
> >
> > This last site is very helpful for beginners in SQL Server.
> >
> > Regards,
> >
> > Jelle
> >
> >
> > "Fabrice" wrote:
> >
> > > Hello,
> > >
> > > A question about backup and restore. I'm not an export of sql server.
> > > I have installed sql server 2005 on windows 2003 R2.
> > > On my server i have two partitions. C: and D:
> > > Mon named instance is installed on D:
> > >
> > > What I nedd to be ready in case of disaster. For the moment I do this :
> > >
> > > 1/ Backup of my user database with sql agent.
> > > 2/ Backup of the system database with sql agent.
> > > 3/ Backup Of the system : All the files on C: and All the folder On D:
> > > (without the database and log).
> > > 4/ Ido two cold backup two times per year. I stop all the Sql server
> > > services and backup all directory on C and D with the database and log.
> > >
> > > I'm not sure of the procedure.
> > >
> > > Can you help me to define the best way or procedure to know what I must
> > > backup to be ensure to be abble to restore my server from scratch.
> > >
> > > Thanks for your help
> > > fabrice
> > >
> > >
> > >

"Jelle" wrote:

> Hi Babai,
>
> I found this information to be a good resource.  Thank you.
>
> Note:  Could not connect to:
>
> • Designing a Backup and Restore Strategy, 
> http://msdn2.microsoft.com/en-us/library/Aa173660(SQL.80).aspxus/adminsql/ad_bkprst_63eh.asp
>
> Regards,
>
> Jelle
>
>
> "babai" wrote:
>
> > Fabrice,
> >
> > Regarding Backup strategies, you need to decide few factors:
> > a) What kind of business it supports.
> > b) How much of data loss can one let go...
> > c) Based on some of the above facts you need to select the recovery Model
> > and then design the Backup strategy..
> >
> > Sharing below few of the Disaster recovery article i would usuallly
> > recommend. Lemme knw if you need anything...
> >
> > • 325257 Support WebCast: SQL Server 2000 Database Recovery: Backup and  
> > Restore http://support.microsoft.com/?id=325257 
> > • Designing a Backup and Restore Strategy, 
> > http://msdn2.microsoft.com/en-us/library/Aa173660(SQL.80).aspxus/adminsql/ad_bkprst_63eh.asp
> > • 829024 INFO: Microsoft SQL Server 2000 Operations Guide
> > http://support.microsoft.com/?id=829024
> > •307775 INF: Disaster Recovery Articles for Microsoft SQL Server
> > http://support.microsoft.com/?id=307775
> > •321836 HOW TO: Retrieve a Table or Rows from Database or Transaction Log
> > Backups
> > http://support.microsoft.com/?id=321836
> >
> > Regards
> > Pranab
> >
> >
> >
> > "Jelle" wrote:
> >
> > > Hi Fabrice,
> > >
> > > These are very broad questions and as I am learning, it all depends on many
> > > factors.  However, hear are some sites that may help you get started.
> > >
> > > Always include this site in your search for information - Microsoft Books
> > > On-line
> > > http://msdn.microsoft.com/en-us/library/bb545450.aspx
> > >
> > > Backing Up and Restoring Databases in SQL Server
> > > http://msdn.microsoft.com/en-us/library/ms187048(SQL.90).aspx
> > >
> > > Backup Windows Server 2003
> > > http://www.gafvert.info/BackupWindowsServer2003.htm
> > >
> > > Free on-line videos - Watch or Download: "SQL Server Backups Demystified"
> > > and "Understanding Backup Options"
> > > http://www.sqlservervideos.com/browse/skill/#Conceptual
> > >
> > > This last site is very helpful for beginners in SQL Server.
> > >
> > > Regards,
> > >
> > > Jelle
> > >
> > >
> > > "Fabrice" wrote:
> > >
> > > > Hello,
> > > >
> > > > A question about backup and restore. I'm not an export of sql server.
> > > > I have installed sql server 2005 on windows 2003 R2.
> > > > On my server i have two partitions. C: and D:
> > > > Mon named instance is installed on D:
> > > >
> > > > What I nedd to be ready in case of disaster. For the moment I do this :
> > > >
> > > > 1/ Backup of my user database with sql agent.
> > > > 2/ Backup of the system database with sql agent.
> > > > 3/ Backup Of the system : All the files on C: and All the folder On D:
> > > > (without the database and log).
> > > > 4/ Ido two cold backup two times per year. I stop all the Sql server
> > > > services and backup all directory on C and D with the database and log.
> > > >
> > > > I'm not sure of the procedure.
> > > >
> > > > Can you help me to define the best way or procedure to know what I must
> > > > backup to be ensure to be abble to restore my server from scratch.
> > > >
> > > > Thanks for your help
> > > > fabrice
> > > >
> > > >
> > > >