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 @ 7:46 AM
Points: 6,619, Visits: 14,185
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
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 12:24 PM
Points: 968, Visits: 973
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 17, 2014 8:09 AM
Points: 115, Visits: 512
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 @ 7:46 AM
Points: 6,619, Visits: 14,185
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: Wednesday, November 12, 2014 3:14 AM
Points: 405, Visits: 1,138
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: Yesterday @ 10:18 AM
Points: 5,886, Visits: 13,041
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: Friday, September 5, 2014 2:00 PM
Points: 2,160, Visits: 2,191
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: Yesterday @ 4:18 PM
Points: 17,947, Visits: 15,940
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 @ 7:46 AM
Points: 6,619, Visits: 14,185
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