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

Give me free advice !!! (mirroring , Replication) ? Expand / Collapse
Author
Message
Posted Tuesday, July 23, 2013 10:33 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 25, 2013 12:33 AM
Points: 2, Visits: 7
Hi there
I wanna give a online backup from my SQL server 2008 and i don't know how to do it !!!
I want design a king of back up which when my main sql server goes down with changing ip address in client apps
they work with out any delay and lost data !
can anyone help me in this case ?

I've done a lot of search on the net and i got 2 solution which is cool for me but none of them are useful because
my SQL DB has file-stream and mirroring doesn't support it !!!
and as far as i know replication works like this !
1 - publisher
2 - subscriber

which subscriber is read only ? and when my publisher (main SQL server goes done the subscriber won't work )is it correct ?

any suggestion ?
Post #1476868
Posted Wednesday, July 24, 2013 2:09 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 12:15 PM
Points: 43,017, Visits: 36,179
s.kianpoor (7/23/2013)
which subscriber is read only ?


Incorrect.

and when my publisher (main SQL server goes done the subscriber won't work )


Incorrect.

As for suggestions, maybe a lot more reading...



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1476914
Posted Wednesday, July 24, 2013 5:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 25, 2013 12:33 AM
Points: 2, Visits: 7
tnx for help
u tell me !
i have one sql server with filestream and i want take realtime backup on another server !

how can i do this ?
Post #1477012
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse