Viewing 15 posts - 5,221 through 5,235 (of 9,241 total)
soccer (8/7/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 8, 2012 at 12:02 am
Cough cough!!
Perry Whittle (8/7/2012)
Execute the modify statements first, take the db offline and then copy the files to the new location(s).Once the db is online remove the old files.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 7, 2012 at 11:55 pm
Angelindiego (8/7/2012)
ALTER DATABASE MyDB SET OFFLINE;
GO
-- Physically move the file to a new location.
-- In...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 7, 2012 at 3:21 pm
@robert sure, no problem
@Hernan shared storage is never good for performance, using multiple logical drives you'll get logical separation but that's as far as it goes
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 7, 2012 at 3:16 pm
Sqlism (8/7/2012)
why there are two ports 1433 and 1434 for SQL Server.
whts the purpose of two?
how are they different?
I came to know 1433 is for TCP\IP
1434 for UDP what...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 7, 2012 at 3:01 pm
Robert Davis (8/7/2012)
Perry Whittle (8/7/2012)
Hernán Rojas (8/6/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 7, 2012 at 2:47 pm
sqlfriends (8/7/2012)
Thanks, I see it has a tcp/ip port of 1433.But how can I know this port is opened through firewall?
get your firerwall admin to check the rules 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 7, 2012 at 2:37 pm
granny (8/7/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 7, 2012 at 2:35 pm
did you understand this?
Hernán Rojas (8/6/2012)
should I have the primary filegroup with 8 datafiles or could be better to have two filegroups with 4 files each??
Perry Whittle (8/7/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 7, 2012 at 2:28 pm
Hernán Rojas (8/7/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 7, 2012 at 2:23 pm
n00bDBA (8/7/2012)
Trying to work with log shipping. Primary server is backup log files but the secondary isn't copying them to the secondary server. The failed job in secondary (LSCopy..)...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 7, 2012 at 2:14 pm
For SQL Server 2000 you need to use the client network utility to check the port number. You could also use the netstat command to identify which port the SQL...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 7, 2012 at 2:07 pm
Hernán Rojas (8/7/2012)
a. One LUN for database...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 7, 2012 at 1:59 pm
you're using SQL Server 2000?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 7, 2012 at 1:57 pm
Hernán Rojas (8/6/2012)
But, the "tempdb database" is the datafiles and the log file, Is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 7, 2012 at 1:51 pm
Viewing 15 posts - 5,221 through 5,235 (of 9,241 total)