Viewing 15 posts - 841 through 855 (of 1,179 total)
If database is not production. You can also use backup and restore with move option.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 25, 2009 at 2:06 am
If I am not worng the txt file which you are talking about is the log files of the jobs. Now you can set the retention period for this history...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 21, 2009 at 4:56 am
yes Ratheesh,
When every you set up a replication it will create the jobs automatically which is called depend on the type of replication you are setting up. e.g. for Logreader...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 17, 2009 at 5:52 am
I guess tempdb needs more diskspace.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 17, 2009 at 4:47 am
what is the database size?
What is the database recovery model?
Howmuch freespace is there in database as well as on disk?
what is the size of tempdb?
Looks like this is a space...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 17, 2009 at 1:14 am
If I am not wrong in India at present you can ask around 20% more on the currnet salary.
But still Depend on Company, requirement, roles & responsibilities etc....
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 17, 2009 at 12:58 am
If your environment is very huge and company can afford you can use MOM, redgate etc. third party tool to monitor your daily activity as well as much more other...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 17, 2009 at 12:03 am
You can also think about SSIS.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 16, 2009 at 1:18 am
First of all if it's not production you can run reindexing on the database.
Than run checktable command if you still have errors you can use repair option to fix the...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 16, 2009 at 1:08 am
That was the reason I have used "might". 😉
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 16, 2009 at 12:51 am
But you might have data loss as log file is missing.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 15, 2009 at 3:28 am
You have not mention which sql server enterprise edition are you installing.... 2000,2005, or 2008?
You are getting correct error "Hardware compatability".
sql 2005 EE do not support winxp refer link below:
http://msdn.microsoft.com/en-us/library/ms143506(SQL.90).aspx
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 15, 2009 at 3:04 am
Try to start sql server into minimal mode and then fix the issue.
Moveing Model database is very simple.
First of all stop sql server agent
Second, Detach and attach (after copying mdf...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 15, 2009 at 1:32 am
I have parse the query in the query analyzer and got the following error:
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near 'SETS'.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 15, 2009 at 1:13 am
Check FAST BCP...
http://www.informit.com/library/content.aspx?b=STY_Sql_Server_7&seqNum=108
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 14, 2009 at 5:56 am
Viewing 15 posts - 841 through 855 (of 1,179 total)