Viewing 15 posts - 4,951 through 4,965 (of 9,241 total)
mcopa (9/24/2012)
Can I use the Copy Database wizard?
if you use the detach\attach method no you can't.
If you use the object method trnasfer it might work as it reads the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 24, 2012 at 12:11 pm
Jason Marshall (9/24/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 24, 2012 at 8:52 am
if it were me i would separate SSRS and SSIS to one box and put SSAS on its own
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 24, 2012 at 8:49 am
braju (9/24/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 24, 2012 at 7:55 am
saidapurs (9/24/2012)
Hi Gila/Perry,Thanks for your response even i observed required less down time for this...
Thanks & Regards
Satish
No problem, the main thing is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 24, 2012 at 6:59 am
look closely at the cost threshold parameter and also check for rogue queries and tune them 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 24, 2012 at 6:55 am
You could certainly consolidate the database engine instances to one box, whether or not you have a box that's capable of providing the level of performance you'll require from the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 24, 2012 at 6:42 am
runal_jagtap (9/24/2012)
then Move the files manually from C Drive to the new location & then start the DB..
I always copy the files then remove the originals when the database starts...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 24, 2012 at 6:31 am
saidapurs (9/24/2012)
could you tell me what is the difference on Detach/attach process and above process.....??Thanks & Regards
Satish Saidapur
Detach removes the database from the system. Offli9ning the database keeps it attached...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 24, 2012 at 6:28 am
saidapurs (9/24/2012)
I observed the files are not moved particular path, currently Data & log files are in 'C' drive itself.....
When i executed below query get...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 24, 2012 at 5:56 am
Andrew Pruski (9/18/2012)
Quest - LiteSpeed
Idera - SQL Safe Backup v 7.2
If anyone is currently using any of the products, could you let me know what your...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 23, 2012 at 1:35 pm
braju (9/21/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 23, 2012 at 1:25 pm
One further question,
When you set the details on the restore tab did you edit the restore options and enter different paths for the target\secondary data and log files?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 22, 2012 at 2:15 pm
Get back to basics, firstly the agent service account on the primary doesn't need any access to the copy location on the secondary server. It doesn't know about it and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 22, 2012 at 10:50 am
Consult with your vm admin, if memory ballooning becomes a problem you may have to uninstall the balloon driver from the vmware tools but simply having the admin reserve resources...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 22, 2012 at 2:36 am
Viewing 15 posts - 4,951 through 4,965 (of 9,241 total)