March 9, 2011 at 9:11 pm
HELLO TO ALL
I WOULD LIKE TO ASK IF EVER THERE IS A FUNCTION OR FEATURES IN SQLSERVER 2008 FOR REPLICATING THE MDF AND LDF, I KNOW THAT THERE IS A REPLICATION FOR ARTICLES ONLY, BUT I WANT TO KNOW IF THERE IS, OR IS THERE A WAY TO REPLICATE THAT TWO FILES..SAMPLES,REFERENCES AND IDEAS I HIGHLY APPRECIATED TO IT.
THANKS
March 9, 2011 at 10:30 pm
I can only think of running it on Mirrored Drives, which I would never recommend for performance.
SQL replication/mirroring will as you said replicate the changes to the databases.
Because the mdf and ldf files are locked for use during operation, I doubt you will find a "tool" that would be able to do this task...why btw?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 9, 2011 at 10:53 pm
There's SAN replication, but that requires 2 SANs, typically mid-upper range.
Why are you asking?
p.s. Please don't post in all caps. It's the online equivalent of shouting at people
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 9, 2011 at 11:44 pm
oh i'm sorry for the upper case i've written not my intention or any negative approach, anyway just to think if there is a tool in sql2008 to replicate mdf and ldf coz where having a problem if in the next month will going to add another tables and that table should be replicated to other db, as mention above comment that using replication mirroring is not applicable due to one of the services should be stop or locked, that's is true coz where in prod db and prod db should not be interrupted,..anyway thanks a lot guys.
March 10, 2011 at 12:58 am
jolan.mahinay (3/9/2011)
anyway just to think if there is a tool in sql2008 to replicate mdf and ldf coz where having a problem if in the next month will going to add another tables and that table should be replicated to other db
Why don't you explain what it is you're trying to do and then we can suggest options for doing so?
as mention above comment that using replication mirroring is not applicable due to one of the services should be stop or locked,
There's no such thing as 'replication mirroring'
In replication (transactional) both databases are online and available. In mirroring the mirror database is recovering, but the service is still running (not stopped, not locked)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 10, 2011 at 3:52 am
Hi,
There no native option/feature available in SQL server to do this. The Most important thing is that what is your requirement? Why you want to maintain 2nd copy of database files. Further SQL Server has verity of Replication to maintain copy of database.
Thanks
Ram
MSSQL DBA
March 10, 2011 at 10:08 pm
read my recent post then suggest if you have an option of what trying to ask.
March 10, 2011 at 10:12 pm
we only have 1 simple requirements, we only need to replicate the main db in real time to second db without any manual copying for the mdf and ldf..thanks
March 11, 2011 at 4:51 am
Transactional replication
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 13, 2011 at 10:05 pm
thanks gila but the problem is if we have an additional tables and the replication is already set then we have to reinitialize again the replication to capture the newly created tables..
March 14, 2011 at 2:29 pm
jolan.mahinay (3/13/2011)
thanks gila but the problem is if we have an additional tables and the replication is already set then we have to reinitialize again the replication to capture the newly created tables..
So, you guys are using a huge publication including all the articles?:cool:
March 14, 2011 at 2:53 pm
jolan.mahinay (3/13/2011)
thanks gila but the problem is if we have an additional tables and the replication is already set then we have to reinitialize again the replication to capture the newly created tables..
You shouldn't have to reinitialise. Add the new article sure, snapshot it (which should just snapshot the new articles), but not reinit the entire thing.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 14, 2011 at 11:00 pm
where in the sqlserver 2008 can i find a properties/features for snapshotting the a new article?
March 14, 2011 at 11:50 pm
thanks gila i already found it..
March 15, 2011 at 2:48 am
Hi,
There is option to copy .mdf, .ldf files even your database is online. The technology is VSS (Volume Shadow Copy) SQL Writer service coordinate with windows VSS service and provide copy of the SQL Database files. But it can interrupt your regular backup plan.
I know a program called Hobocopy.exe it provides database files backup using Windows VSS Service.
Ram
MSSQL DBA
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply