Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Operating Systems & Databases

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 2nd January 2013, 08:57
niralibaan niralibaan is offline
Member
 
Join Date: Feb 2010
Posts: 52
niralibaan is on a distinguished road
Baan: LN 6.1 - DB: SQL - OS: Windows
Restore differential backup in SQL Server 2005
Baan: ERP LN 6.1 FP2
DB: SQL Server 2005
OS: Windows XP
C/S: Server

Hi,
Can anyone pls tell me how to restore differential backup in SQL server 2005?
I have to take full backup weekly and differential backup daily from SQL Server.
I want to know if my database gets down and I want to restore differential backup then should I directly restore it or first I have to restore full backup in SQL server?

Regards,
Nirali
Reply With Quote
  #2  
Old 10th August 2013, 19:47
Darioo Darioo is offline
Newbie
 
Join Date: Mar 2011
Posts: 1
Darioo is on a distinguished road
Baan: FP7 - DB: MS SQL SERV 2008 - OS: MS WIN SERV 2008
Hi,
If you want to restore a backup differential, you must first restore the full backup and the last differential backup.

If you do this in Management Studio, it automatically selects the required full-copy and play both.

Regards,
Darioo
Reply With Quote
Sponsored Links
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
New Install - SQL Server 2005 Sort Order RickMorris Operating Systems & Databases 3 14th January 2009 19:56
Database Configuration Error in SQL Server 2005 keyuser.tdtt Tools Administration & Installation 1 15th July 2008 21:21
LN on SQL Server 2005 tritonbaan Operating Systems & Databases 0 7th August 2006 15:21
SQL Server 7.0 SP4 + BaanERP compatiblity Jabran Tools Administration & Installation 1 4th October 2004 12:49
Decision Manager & SQL Server 7.0 BisBoy Open World, Portal & Decision Manager 0 10th July 2003 14:11


All times are GMT +2. The time now is 23:23.


©2001-2017 - Baanboard.com - Baanforums.com