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 12345»»»

Automatically Restores All database ".BAK" Files Expand / Collapse
Author
Message
Posted Sunday, September 23, 2007 9:29 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 12:14 AM
Points: 398, Visits: 2,427
Comments posted to this topic are about the item Automatically Restores All database ".BAK" Files

"-=Still Learning=-"

Lester Policarpio

Post #401814
Posted Thursday, January 3, 2008 9:30 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 16, 2014 10:18 AM
Points: 5, Visits: 122
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
Posted Thursday, January 24, 2008 3:24 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight 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
Posted Sunday, February 10, 2008 4:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Sunday, February 10, 2008 6:42 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 12:14 AM
Points: 398, Visits: 2,427
YEs this script is intended to be executed in Query Analyzer

"-=Still Learning=-"

Lester Policarpio

Post #453707
Posted Monday, March 3, 2008 9:47 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, September 6, 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
Posted Monday, March 3, 2008 10:33 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 12:14 AM
Points: 398, Visits: 2,427
Does your backup filename with this kind of format??

DBName_db_YYYYMMDDHHMM.BAK??


"-=Still Learning=-"

Lester Policarpio

Post #463567
Posted Friday, March 14, 2008 8:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Monday, March 17, 2008 6:34 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 12:14 AM
Points: 398, Visits: 2,427
Yes it can be but part of the script will need to be reconstructed

"-=Still Learning=-"

Lester Policarpio

Post #470588
Posted Friday, May 9, 2008 10:51 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay 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 »

Add to briefcase 12345»»»

Permissions Expand / Collapse