Viewing 15 posts - 3,136 through 3,150 (of 9,244 total)
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 25, 2014 at 3:03 am
chengchong36 (7/9/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 25, 2014 at 2:56 am
smtzac (7/23/2014)
-- Switch to your database
USE ngmetadata;
GO
-- Check VLF Count for current database
DBCC LogInfo;
-- Check individual File Sizes and space available for current database
SELECT name AS [File Name]...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 24, 2014 at 4:14 am
vsamantha35 (7/23/2014)
On a cluster, we have 2 networks i.e private network and public network.
Private network is used for cluster communication(LooksAlive and IsAlive checks) and Public network is used for client...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 24, 2014 at 4:04 am
don't ever delete the TUF file, this will require a re initialisation of the LS plan
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 24, 2014 at 4:02 am
Jeff Moden (7/21/2014)
Perry Whittle (7/21/2014)
Steve Jones - SSC Editor (7/21/2014)
GilaMonster (7/16/2014)
Steve Jones - SSC Editor (7/16/2014)
Yes. I believe you can use copy only, which avoids this
Full backups do not break...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2014 at 4:12 pm
Steve Jones - SSC Editor (7/21/2014)
GilaMonster (7/16/2014)
Steve Jones - SSC Editor (7/16/2014)
Yes. I believe you can use copy only, which avoids this
Full backups do not break the log chain. Copy...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 21, 2014 at 2:23 pm
Viewing 15 posts - 3,136 through 3,150 (of 9,244 total)