Viewing 15 posts - 5,221 through 5,235 (of 9,244 total)
I'm assuming this is a new share you have created for the backups is it?
\\IPaddress\share
The backup will run under the sql server agent, is this service using a pass through...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 8, 2012 at 6:19 am
didi77 (8/7/2012)
Why did it lost the sequence when I made a manualy backup log?
Because the log backup went to a location outside of the log shipping backup folder??
Can you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 8, 2012 at 3:39 am
Firstly, are these questions related to firewall configuration for a SQL server instance?
alanspeckman (8/7/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 8, 2012 at 12:17 am
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
Viewing 15 posts - 5,221 through 5,235 (of 9,244 total)