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

Using Disparate File Paths in SQL Server Database Mirroring Expand / Collapse
Author
Message
Posted Monday, February 28, 2011 10:29 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:16 PM
Points: 7,565, Visits: 15,574
Comments posted to this topic are about the item Using Disparate File Paths in SQL Server Database Mirroring

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1070983
Posted Monday, February 28, 2011 10:30 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 27, 2015 7:27 AM
Points: 1,034, Visits: 1,060
Excellent tip to "trick" SQL into thinking we did a full backup/restore of the DB to be able to move the new database file.

Cheers,
Steve
Post #1070984
Posted Tuesday, March 1, 2011 2:13 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Monday, November 24, 2014 2:50 AM
Points: 116, Visits: 513
nice article. one question?

in your backup TLog statement did you mean to say....

BACKUP DATABASE AdventureWorks TO DISK = '\\hanode1\backup\AdventureWorks_createnewfile.trn' WITH INIT

?
Post #1071040
Posted Tuesday, March 1, 2011 2:16 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:16 PM
Points: 7,565, Visits: 15,574
dibbydibby (3/1/2011)
nice article. one question?

in your backup TLog statement did you mean to say....

BACKUP DATABASE AdventureWorks TO DISK = '\\hanode1\backup\AdventureWorks_createnewfile.trn' WITH INIT

?

Hi
well spotted, no the backup and the restore statement should read

BACKUP LOG
RESTORE LOG

Regards
Perry


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1071042
Posted Tuesday, March 1, 2011 2:32 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, February 9, 2015 8:07 AM
Points: 405, Visits: 1,141
good article and good tip for addining files without the need to do a full backup and restore.

_____________________________________________________________________________
MCITP: Business Intelligence Developer (2005)
Post #1071054
Posted Tuesday, March 1, 2011 2:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 28, 2014 7:10 AM
Points: 8, Visits: 71
Hi Perry,

Another good article, thanks for the tip!

Cheers

John
Post #1071056
Posted Tuesday, March 1, 2011 11:06 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:12 AM
Points: 5,986, Visits: 13,251
nice article Perry and very useful info.

I think the lesson to take away though is to set your live and failover servers up with exactly the same drive\directory structures in the first place.


---------------------------------------------------------------------

Post #1071431
Posted Tuesday, March 1, 2011 1:17 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, June 30, 2015 9:47 AM
Points: 2,160, Visits: 2,204
Thank you very much for the article, it is good to learn about the pitfalls before actually falling into them.
Post #1071543
Posted Tuesday, March 1, 2011 2:02 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 2:53 PM
Points: 19,184, Visits: 17,495
Nice article Perry. Thanks



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1071575
Posted Tuesday, March 1, 2011 7:44 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:16 PM
Points: 7,565, Visits: 15,574
Guys

Thank you very much for all your kind replies I'm glad you find it useful

george sibbald (3/1/2011)
I think the lesson to take away though is to set your live and failover servers up with exactly the same drive\directory structures in the first place.

George I couldn't agree more, although sometimes you may inherit a system and will have to roll with it. This is especially for these types of systems


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1071695
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse