Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Copy/Refresh a database in the night Expand / Collapse
Author
Message
Posted Saturday, November 14, 2009 11:16 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 8:35 AM
Points: 143, Visits: 447
Comments posted to this topic are about the item Copy/Refresh a database in the night
Post #819033
Posted Friday, March 12, 2010 2:45 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, October 22, 2013 9:36 AM
Points: 20, Visits: 561
Exactly what I was looking for, so thank you for posting the article. (http://www.sqlservercentral.com/scripts/backup+restore+log+shipping/68673/)

Quick question - Is it common for most DBAs to have different passwords for accounts in the development or test environments?
Post #882150
Posted Tuesday, March 23, 2010 8:16 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, March 24, 2013 6:56 PM
Points: 6, Visits: 42
hi,

Thanks for your script.

Is that this script is works on single machine? Where can I pass the parameter if the DB's are sitting in differnt physical servers?

And one more thing to confirm, the script is doing backup the whole db from source system and restore into destignation system?

Post #888650
Posted Wednesday, June 16, 2010 10:27 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 8:35 AM
Points: 27, Visits: 454
This is based on one serve host. If you want to run this script between server A and server B (and your backup files could be on either one or network somewhere) You have to use linkserver and UNC path to specify A and B. If you spend several minutes, you could figure it out.

Madhu, This is a teaching script. Modify refactor for your own needs (publish back to us after). If you have a custom need, I will be happy to construct a contract business deal with you. At that point, we can write for you anything you desire.


Jason
http://dbace.us
Post #938396
Posted Wednesday, June 16, 2010 10:39 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: 2 days ago @ 11:24 AM
Points: 32,781, Visits: 14,942
I have never had the same passwords in production as test/dev






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #938400
Posted Friday, July 16, 2010 5:23 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, January 27, 2014 2:40 AM
Points: 95, Visits: 150
We have a slightly more complicated scenario...

Our production database is backed up up using a 3rd party system which does not appear in the msdb tables, on top of that the log files are backed up every 15 minutes.

Is it possible to use this approach (but introducing a SQL backup to the steps) to backup and restore the database without the backup truncating the logs?

The database is unfortunately SQL 2000 but running in SQL 7 compatibility mode.

Thanks...
Post #953763
Posted Thursday, July 29, 2010 6:08 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, March 17, 2014 6:29 AM
Points: 1,005, Visits: 142
Really liked the concept, but I ran into one issue. The object backupmediafamily.physical_device_name is nvarchar(260) so I changed @filename to nvarchar(260).

Thanks for the clear and concise article(s).

Larry
Post #960637
Posted Thursday, September 30, 2010 8:30 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 8:35 AM
Points: 27, Visits: 454
GRussell31 (7/16/2010)
We have a slightly more complicated scenario...

Our production database is backed up up using a 3rd party system which does not appear in the msdb tables, on top of that the log files are backed up every 15 minutes.

Is it possible to use this approach (but introducing a SQL backup to the steps) to backup and restore the database without the backup truncating the logs?

The database is unfortunately SQL 2000 but running in SQL 7 compatibility mode.

Thanks...


Where do they store backup info? You just use the same concept and change code to accommodate the scenario. The script operates entirely on backup only. Nothing to do with [backup truncating the logs?]


Jason
http://dbace.us
Post #996375
Posted Friday, October 01, 2010 2:27 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, January 27, 2014 2:40 AM
Points: 95, Visits: 150
Hi jswong05,

My understanding is that when a backup is performed it will truncate the transaction logs (and I couldn't find a way to stop this), as trancating the logs will mean that the 3rd party system which backs them up every fifteen minutes would be missing some information.

Hope that helps explain things?

jswong05 (9/30/2010)
GRussell31 (7/16/2010)
We have a slightly more complicated scenario...

Our production database is backed up up using a 3rd party system which does not appear in the msdb tables, on top of that the log files are backed up every 15 minutes.

Is it possible to use this approach (but introducing a SQL backup to the steps) to backup and restore the database without the backup truncating the logs?

The database is unfortunately SQL 2000 but running in SQL 7 compatibility mode.

Thanks...


Where do they store backup info? You just use the same concept and change code to accommodate the scenario. The script operates entirely on backup only. Nothing to do with [backup truncating the logs?]
Post #996499
Posted Monday, October 04, 2010 2:23 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 8:35 AM
Points: 27, Visits: 454
GRussell31 (10/1/2010)
Hi jswong05,

My understanding is that when a backup is performed it will truncate the transaction logs (and I couldn't find a way to stop this), as trancating the logs will mean that the 3rd party system which backs them up every fifteen minutes would be missing some information.

Hope that helps explain things?



It does not stop you from using this script as long as your backup files can be worked with RESTORe command; if not, that is your pain of using 3rd party.


Jason
http://dbace.us
Post #997872
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse