Viewing 15 posts - 3,136 through 3,150 (of 9,253 total)
sqldriver (7/29/2014)
Hello,Has anyone ever done a live physical to virtual conversion?
Yes, more than i care to remember :crazy:
sqldriver (7/29/2014)
July 29, 2014 at 9:27 am
if you're looking in explorer on the node where the disk is not online you won't see it.
July 29, 2014 at 6:25 am
Marios Philippopoulos (7/29/2014)
You need to:(1) Evict the standalone node from the WSFC cluster
(2) Install the sql on that node
(3) Add the node back to the cluster.
Be very careful here, when...
July 29, 2014 at 6:17 am
Chowdary's (7/28/2014)
I executed the Script against the DB , i got the following
SpaceUsedMbs, SizeMBs, GrowthAllowed, MaxGrowthSize,Growth and FreeMBs result.But from this result ...
July 28, 2014 at 7:45 am
Chowdary's (7/28/2014)
On 24th my Mdf size was 10GB,when i checked now the Mdf size was increased suddenly to 30GB.
First ascertain whether the file has free space or filled with data.
If...
July 28, 2014 at 6:26 am
Paul Morris-1011726 (7/25/2014)
Very cool, I will do this off hours just because i am paranoid. Let you know how it goes. Thanks for the help!
no need to be paranoid, just...
July 25, 2014 at 9:52 am
Once you restored the database as a new name i would also then change the logical filenames as shown below (and based on my example)
ALTER DATABASE [bob] MODIFY FILE (NAME...
July 25, 2014 at 7:16 am
I have an example here which should help.
I have a Litespeed database called Litespeedlocal which i have a backup of, I want to restore it as bob.
The logical filenames...
July 25, 2014 at 7:12 am
Paul Morris-1011726 (7/25/2014)
So it should look like this?
RESTORE DATABASE TEST FROM DISK = 'E:\<path>\FULL.BAK'
WITH REPLACE, RECOVERY,
MOVE 'PROD' TO 'E:\<path>\TEST.MDF',
MOVE 'PROD_log' TO 'E:\<path>\TEST_log.LDF';
Do i need the RECOVERY?
You don't need REPLACE since...
July 25, 2014 at 6:58 am
Paul Morris-1011726 (7/25/2014)
And i can do this during business hours without affecting the Prod DB?
Should be perfectly safe as long as you set the move clauses correctly. The logical name...
July 25, 2014 at 6:50 am
MikaS (7/22/2014)
it's not something you automatically need (after SQL Server 2005, which did require it for cluster installation).
Whilst it's not actually required for 2008 onwards, the installer still bitches and...
July 25, 2014 at 3:04 am
SQLSACT (7/22/2014)
I am required to set up a multi-instance SQL/Windows Cluster.
Windows 2012 Ent/SQL 2012 Ent
There will be 12 instances across 4 nodes.
Which considerations do I need to take for...
July 25, 2014 at 3:03 am
chengchong36 (7/9/2014)
July 25, 2014 at 2:58 am
This is why you are getting the error
RESTORE DATABASE TEST FROM DISK = 'E:\<path>\FULL.BAK'
WITH REPLACE, RECOVERY,
MOVE 'PROD' TO 'E:\<path>\TEST.MDF';
You've only specified a move for the primary data file, you need...
July 25, 2014 at 2:56 am
Viewing 15 posts - 3,136 through 3,150 (of 9,253 total)