Viewing 15 posts - 5,371 through 5,385 (of 9,244 total)
why not implement a log shipping configuration, this would be very easy to setup and maintain
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 6, 2012 at 8:37 am
NT Password reset is free, use that instead 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 6, 2012 at 8:35 am
you may setup a mirror session using an IP address, this is detailed here.
This may be useful too.
You'll need to set up a 2nd clustered IP for the 2nd nic.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 6, 2012 at 8:27 am
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
Viewing 15 posts - 5,371 through 5,385 (of 9,244 total)