Viewing 15 posts - 166 through 180 (of 469 total)
I dont think you need to restore system databases to make a copy of production. Because Dev and Prod are completely different instances.
Dev and prod need to match with their...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 19, 2009 at 8:39 am
Did you say you restored the dev server system databases with the backup from production system databases?
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 19, 2009 at 8:26 am
You would need to do this then, won't affect anything else unless you have any jobs that use the old server name. If so you need to updated them with...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 19, 2009 at 8:09 am
You can do so by changing the name of your server from windows OS. Then restart SQL server. Your new name should reflect when you run select @@servername again.
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 19, 2009 at 8:00 am
Steve asked you to check if the fill factor is a small value like 40 or 50 % if so please make it 80 or 90% that means all the...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 17, 2009 at 2:03 pm
Decrease the Autogrow from100MB to say 10% or a smaller size in MB. Also allocate a larger file size to begin with that way the transaction will not have ...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 17, 2009 at 1:10 pm
You can try these books if you want.
http://cid-1cc1edb3daa9b8aa.profile.live.com/Lists/cns!1CC1EDB3DAA9B8AA!203/
They are what they are...:P
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 17, 2009 at 12:51 pm
Scott,
In the properties tab you say it is displaying 100MB growth restricted to 2,097,152. I think that is the maximum space available on the drive.
Unlimited filegrowth is only in the...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 17, 2009 at 12:38 pm
Even though you are the owner of the job but the process that kicks of the job is SQLAgent service. I think it is not able to access that folder...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 12, 2009 at 12:30 pm
Do you have backup files older than 2 days in that directory?
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 12, 2009 at 12:24 pm
If the linked server is on ServerA then the security should be set as 'Be made using this security context ', here specify the login and password that exists on...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 12, 2009 at 11:37 am
As for the link for SQL 2005 Clustering, there is a good article by Richard Lu, you can refer it in the below link
http://www.sqlservercentral.com/articles/Clustering/62327/
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 12, 2009 at 11:22 am
You can manage a cluster through Cluster Administrator only. This is available when you install MSCS ( Microsoft Clustering Services) on the windows server. This will enable you to list...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 12, 2009 at 11:20 am
Right click on the server and go to properties. Click on the Connections tab on left and there the first option is to set the max allowed connections.
The default is...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 12, 2009 at 11:14 am
Make sure the account specified in the linked server has required credentials to access the database on server B
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 12, 2009 at 11:11 am
Viewing 15 posts - 166 through 180 (of 469 total)