Viewing 15 posts - 6,076 through 6,090 (of 8,416 total)
ashish.kuriyal (2/19/2010)
Paul,Downtime will be there if you want the database files to be copied properly.
No. There is absolutely no need to copy database files (*.mdf, *.ndf, *.ldf)
Log...
February 19, 2010 at 3:18 am
mattfitz (2/18/2010)
February 19, 2010 at 3:16 am
jshailendra (2/19/2010)
Paul..can you give some link to read on this?..I am not aware of this..need to gain more knowledge on this concept.
Sure. Books Online: Database Mirroring and Database Snapshots
February 19, 2010 at 3:06 am
ashish.kuriyal (2/19/2010)
1) take primary database offline.
2) Detach it.
3) Copy file(data and log) to new location.
4) Bring your main database online to...
February 19, 2010 at 3:01 am
jshailendra (2/19/2010)
Not sure how you guys suggesting mirroring...as per my understanding mirrored DB is not accessible (till failover) .....how that can be used for reporting?
If you read back, you'll see...
February 19, 2010 at 2:57 am
GT-897544 (2/18/2010)
February 19, 2010 at 2:55 am
Dave Ballantyne (2/19/2010)
...even if you can guarantee that on small tables with a clustered index will always return in order.
There is no guarantee of that - it's just very difficult...
February 19, 2010 at 2:48 am
GT-897544 (2/18/2010)
And i also feel i should keep away from this Blog, as when ever i replied to question looks like other DBA's are not happy.
I wouldn't take too...
February 18, 2010 at 6:48 pm
Ninja's_RGR'us (2/18/2010)
Who am I to decide that for you?Why do you think I was only / still talking to you?
It seemed that way to me.
And...it was a rhetorical question.
February 18, 2010 at 6:44 pm
Books Online - SET IDENTITY_INSERT
February 18, 2010 at 6:22 pm
Before I have gone to bed actually!
Night all. I might post again this afternoon if there's anything left worth saying by then.
February 18, 2010 at 10:28 am
I really really have to get some sleep.
Anyone up for helping out here
If not, cool, I'll take another look this afternoon.
Paul
February 18, 2010 at 10:19 am
Dan Guzman - Not the MVP (2/18/2010)
February 18, 2010 at 10:17 am
george sibbald (2/18/2010)
I'm sure you do Paul, its hard to get the full meaning across with only the writtem word. I felt it needed expanding for the Ops benefit.
Oh ok....
February 18, 2010 at 10:08 am
Viewing 15 posts - 6,076 through 6,090 (of 8,416 total)