Viewing 15 posts - 436 through 450 (of 712 total)
Lynn Pettis (8/21/2012)
durai nagarajan (8/21/2012)
with full...
August 22, 2012 at 3:16 am
Can you tell me what is wrong with the current setup?
what type of data available explain more clearly and what level of data loss is acceptable.
if the data is sensitive...
August 22, 2012 at 3:10 am
consider the number of DB and data loss acceptability before planning this.
defenitely go for better backup plan with or without maintanence plan.
take full back up daily if you have enough...
August 22, 2012 at 2:52 am
we have done on certain tables by moving the old data say year or more to another db and changed only reports to take data from that location.
monthly job will...
August 22, 2012 at 2:05 am
lynn,
My company is asking for the Tlog retention period in tapes which is happening daily.
we have TLOg backup every hour and full backup once in a day.
what is your suggestion?...
August 21, 2012 at 7:11 am
In that case he has not scheduled Tlog backup from 6:00PM to 10:00PM which in turn might leave him in data loss incase of disaster.
with full backup and next day...
August 21, 2012 at 7:03 am
deos your script has constant file name like the name of your 300+ mb file and it has
"WITH NOFORMAT, NOINIT" option?
then it is updating the backup on same file.
August 21, 2012 at 3:40 am
Lynn Pettis (8/17/2012)
August 21, 2012 at 3:33 am
i dont know much about ssis, still
"svcintersql" user's IE temp folder is the one you have specified that means, it is using default IE temp folder, might be the...
August 21, 2012 at 3:23 am
I manually created a new folder on the server named "S:\SQL\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DRI_KY193_DATA\" and added sa full access to it in permissions.
SA is a sql user how did you configured...
August 21, 2012 at 3:15 am
A simple option disable the user which applciation uses and enable it once the activity completes.
other option is change the sql port and restart the sql service and who ever...
August 21, 2012 at 3:04 am
what is the table size (total records) and no of tables affected by ntext in the statistics update?
read the link below might help..
http://geekswithblogs.net/johnsPerfBlog/archive/2008/04/16/ntext-vs-nvarcharmax-in-sql-2005.aspx
August 20, 2012 at 8:24 am
is "named pipes" enabled in sql configuration manager
August 20, 2012 at 5:58 am
Brilliant query guys , i am poor .. good learning
August 20, 2012 at 5:12 am
it is my miss , how about this.
set nocount on
CREATE TABLE #Test
(ID int NOT NULL IDENTITY(1,1) Primary key,
TranID int NOT NULL,
OriginCode varchar(5) NOT NULL,
DestinationCode varchar(5) NOT...
August 20, 2012 at 4:41 am
Viewing 15 posts - 436 through 450 (of 712 total)