Viewing 15 posts - 5,371 through 5,385 (of 9,241 total)
ksrikanth77 (7/5/2012)
Let me explain me the scenario
I have created SQL Server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 5, 2012 at 3:49 pm
kevinsql7 (7/5/2012)
For SQL Server 2008 R2 SP 1, I have found the following exe on http://www.microsoft.com/en-us/download/details.aspx?id=26727:SQLServer2008R2SP1-KB2528583-x64-ENU.exe
Use this file
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 5, 2012 at 3:46 pm
You're generally stuck with 2 options mentioned.
Option1
Detach or offline database (generally almost instantaneous)
Copy files (takes time)
Reattach files (generally almost instantaneous)
Option2
Take compressed backup (can take time)
Copy compressed back (usually quick)
Restore backup...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 5, 2012 at 2:01 pm
AAKR (7/5/2012)
Example:
I am having a XXX database in ABC server, I want to move this database...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 5, 2012 at 10:26 am
thomasrichardson2000 (7/5/2012)
sorry there is no second one ,it returns no rows
Check to make sure you supplied the correct database name.
If still no rows then as Brandie says, the LS secondary...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 5, 2012 at 9:44 am
marks_262 (7/5/2012)
I am looking for some scripts or a tool (preferably...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 5, 2012 at 6:07 am
Please execute the following and return the results
against primary
exec sp_help_log_shipping_primary_database @database = 'yourdb'
against secondary
exec sp_help_log_shipping_secondary_database @secondary_database = 'yourdb'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 5, 2012 at 6:05 am
yes but data is moved to a filegroup, not an individual file. If that group only contains 1 file then fine otherwise it'll be spread across all files in the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 3, 2012 at 11:44 am
dan-572483 (7/3/2012)
Just curious, what are the specs on your laptop & VMs? I've thought about clustering VMs on my home computer for self-training purposes, but I'm concerned about...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 3, 2012 at 11:41 am
i'm currently working on a script to pull database permissions and connection grants, etc from a user database, it's not complete but here's the bones of it
SET NOCOUNT ON
DECLARE...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 3, 2012 at 11:28 am
Firstly, this statement from the ask sql server central site is incorrect
TRUNCATE TABLE statements cannot be used for tables involved in replication or log shipping
Log shipping does not replicate atb...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 3, 2012 at 7:04 am
sure, as i said you only want to be creating multiple files per filegroup from the outset to ensure the fill is equal, (hence sames sizes and growth rates). If...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 3, 2012 at 6:56 am
From reading your post it sounds very much like you require AlwaysOn in SQL Server 2012, are you not able to make the upgrade and utilise the newer technology?
Aside that...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 3, 2012 at 2:47 am
Since essentially all tables\indexes in SQL Server 2005 on are partitioned, to get down to the partition sizes you'll need to join sys.indexes, sys.partitions and sys.allocation_units.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 2, 2012 at 12:02 pm
my guide, linked by Mohammed, shows you all you need to know
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 2, 2012 at 11:51 am
Viewing 15 posts - 5,371 through 5,385 (of 9,241 total)