Automatically Restores All database ".BAK" Files

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Lester Policarpio » Automatically Restores All database...

72 posts, Page 1 of 8

1 2 3 4 5 »»»

Automatically Restores All database ".BAK" Files

Rate Topic

Display Mode

Topic Options

Author

Message

Lester Policarpio

Posted Sunday, September 23, 2007 9:29 PM

Old Hand

Group: General Forum Members
Last Login: Tuesday, November 20, 2012 6:45 PM
Points: 398, Visits: 2,405

Comments posted to this topic are about the item Automatically Restores All database ".BAK" Files

"-=Still Learning=-"

Lester Policarpio

Post #401814

Travis Baseflug-281032

Posted Thursday, January 03, 2008 9:30 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, January 07, 2013 3:52 PM
Points: 5, Visits: 93

I only changed the path and the execution of the sproc renders the following error:

Msg 536, Level 16, State 5, Procedure usp_restore_db, Line 58
Invalid length parameter passed to the SUBSTRING function.

which appears to be at line: print @db

Post #438449

Sreejithsql

Posted Thursday, January 24, 2008 3:24 PM

Right there with Babe

Group: General Forum Members
Last Login: Saturday, August 25, 2012 9:48 PM
Points: 777, Visits: 134

hi
thx for ur information.highly appreciatable.

thx
sreejith
MCAD

Post #447230

steven.simister

Posted Sunday, February 10, 2008 4:08 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, October 13, 2008 6:41 AM
Points: 1, Visits: 3

Does this script have to be run within Query Analyser?

Post #453636

Lester Policarpio

Posted Sunday, February 10, 2008 6:42 PM

Old Hand

Group: General Forum Members
Last Login: Tuesday, November 20, 2012 6:45 PM
Points: 398, Visits: 2,405

YEs this script is intended to be executed in Query Analyzer

"-=Still Learning=-"

Lester Policarpio

Post #453707

gtossa

Posted Monday, March 03, 2008 9:47 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, September 06, 2010 1:23 AM
Points: 30, Visits: 163

I replaced the path/directory as addvised.
Running this script in query analyzer got this error:

Msg 213, Level 16, State 7, Line 1
Insert Error: Column name or number of supplied values does not match table definition.
Msg 3013, Level 16, State 1, Line 1
RESTORE FILELIST is terminating abnormally.

Please help!
GT

Post #463246

Lester Policarpio

Posted Monday, March 03, 2008 10:33 PM

Old Hand

Group: General Forum Members
Last Login: Tuesday, November 20, 2012 6:45 PM
Points: 398, Visits: 2,405

Does your backup filename with this kind of format??

DBName_db_YYYYMMDDHHMM.BAK??

"-=Still Learning=-"

Lester Policarpio

Post #463567

lars.kohsel

Posted Friday, March 14, 2008 8:57 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, April 30, 2009 11:18 PM
Points: 1, Visits: 8

Hi

Would it be possible to alter the script so the filename format could be specified in the script ?

regards
Lars Kohsel

Post #469454

Lester Policarpio

Posted Monday, March 17, 2008 6:34 PM

Old Hand

Group: General Forum Members
Last Login: Tuesday, November 20, 2012 6:45 PM
Points: 398, Visits: 2,405

Yes it can be but part of the script will need to be reconstructed

"-=Still Learning=-"

Lester Policarpio

Post #470588

Cory E.

Posted Friday, May 09, 2008 10:51 AM

Say Hey Kid

Group: General Forum Members
Last Login: Wednesday, January 11, 2012 2:47 PM
Points: 681, Visits: 10,845

in your script you had

- Not tested for multiple ndfs (currently working for this 1)

listed as a limitation - have you progressed with this at all?

-- Cory

Post #498089

« Prev Topic | Next Topic »

72 posts, Page 1 of 8

1 2 3 4 5 »»»

Permissions