Viewing 15 posts - 4,501 through 4,515 (of 9,241 total)
Can you post the table definitions for the tables you are deleting from?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 4, 2012 at 5:46 am
sql-lover (12/3/2012)
-We are using cross over cable for heartbeat
As i said a segregated network
sql-lover (12/3/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 4, 2012 at 1:49 am
sqlfriends (12/3/2012)
Can I use dynamic port for the named instance,
When I install the named instance, and check the tcp\ip port, it defaults to blank, with dynamic port set to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2012 at 11:54 pm
Oops good catch Lynn I didn't spot that port number there
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2012 at 11:47 pm
sqlfriends (12/3/2012)
Do I have to configure the named instance to use diffrent port than 1433 because the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2012 at 4:32 pm
sql-lover (12/3/2012)
My bad, we all know 3 is what we need ... 🙂
No, not necessarily. It all depends on your network infrastructure and your redundancy requirements.
sql-lover (12/3/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2012 at 4:29 pm
The wmi comsole is pretty good here. The problem with xp_fixeddrives is it cant return mounted volume details. Use something along the lines of
wmic volume get capacity, "free space", name
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2012 at 1:47 pm
sql-lover (12/3/2012)
I'm having a hard time to convince IT team that we don't need so many NICs in a dedicated SQL cluster. Besides SAN, I usually use two NICs only,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2012 at 1:39 pm
It's now WSFC and it is indeed part of the Windows 2008 server Enterprise and Datacenter editions.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2012 at 1:36 pm
Ratheesh.K.Nair (12/3/2012)
Perry how can we achieve that? If did ,it is having high chance for corrupting the backup right.
Not at all, I've never had an issue with the backup converter
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2012 at 11:45 am
HildaJ (12/3/2012)
I need to restored the master db file from one of my red gate backup files. I'd like to know the required steps to do this.thank you.
The easiest...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2012 at 8:36 am
ravi@sql (12/3/2012)
ya maxsize is given for autogrowth
What are the size details for the log currently?
Do you have any long running transactions?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2012 at 6:03 am
sql_Reporter (12/1/2012)
Hey probably a very common question but can you Replication between SQL 08 r2 enterprise & standard editions ?Thanks
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2012 at 6:01 am
ravi@sql (12/3/2012)
recovery_model_desclog_reuse_wait_descSIMPLE NOTHING
What size is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2012 at 5:50 am
if your database is using the full or bulk logged recovery model take a transaction log backup using the following
BACKUP LOG [MYDB] TO DISK = 'some drive\some path\mydb.trn'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2012 at 5:48 am
Viewing 15 posts - 4,501 through 4,515 (of 9,241 total)