Viewing 15 posts - 16 through 30 (of 859 total)
rew-370421 (12/17/2009)
Regarding the actual Hard Drive space. Yes, it has 9.57 GB of FREE space. I also looked at TempDB and it has 1053MB Space...
December 18, 2009 at 4:32 am
2009-12-15 19:27:19 - ! [165] ODBC Error: 0, An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused...
December 17, 2009 at 1:01 am
Krishna Potlakayala (11/4/2009)
rambilla4 (11/3/2009)
From the link http://msdn.microsoft.com/en-us/library/ms178117%28SQL.90%29.aspx
Changing Roles Between Primary and Secondary Servers
After you have failed over to a secondary server, you can configure your secondary database to...
November 4, 2009 at 11:21 pm
rambilla4 (11/3/2009)
From the link http://msdn.microsoft.com/en-us/library/ms178117%28SQL.90%29.aspx
Changing Roles Between Primary and Secondary Servers
After you have failed over to a secondary server, you can configure your secondary database to act as...
November 4, 2009 at 11:18 pm
shusta (11/3/2009)
I8. Select “Mixed Mode” and enter a NEW sa password for my new instance, when ready I click Next.
Mixed mode?? Not a best practice. That is the only concern...
November 4, 2009 at 12:33 am
parthi-1705 (11/3/2009)
Reason for suspect databases in ms sql ,
There could be a lot. Please introduce ourselves to your situation and do not generalize it. If you want to know in...
November 4, 2009 at 12:19 am
y.koteswarrao-652921 (11/3/2009)
Hi,Iam a junior DBA, how to migrate changes made in the development environment to production environment.
Regards
Koteswarrao
You can use Backup-Restore method which is the easier one for not VLDB though....
November 3, 2009 at 11:14 pm
gmamata7 (11/3/2009)
Before this you would have to tell us what other jobs scheduled on the server? Re-index, re-org etc..
On sunday, first rebuild indexes maintenance plan job runs (for all...
November 3, 2009 at 11:05 pm
ramuvanparti (11/3/2009)
try this command on the server where you are shipping the log that is target server
use master
restore database databasename with recovery
it might bring your restoring state db in online.
i...
November 3, 2009 at 3:45 am
Mamta,
Before that I am curious to know why your log is growing, is your Recovery model Full while re-indexing? and also how many indexes have u got and are you...
November 3, 2009 at 2:59 am
gmamata7 (11/3/2009)
I'm running Update stats Maintenance task job weekly and its taking 1 hr 15 mins and I'm not sure whether Update stats job required to run on production instance....
November 3, 2009 at 2:49 am
gmamata7 (11/3/2009)
When the database is in restoring state, it means the databases is not online/unavailable- Hence not accessible. so, it would not be possible to take a backup of that...
November 3, 2009 at 2:44 am
gmamata7 (11/3/2009)
thanks Krishna,My question is: Is there any way to take the backup of a database, which is in restoring mode?
When the database is in restoring state, it means the...
November 3, 2009 at 1:22 am
charipg (11/2/2009)
what should i do for access database properties.
What privileges have you got on the server?
November 3, 2009 at 12:21 am
john jin (11/2/2009)
By right even you delete 800,000 records shouldn't cause problems.It's not about 2G or 4G memory in your machine,
Can you please post that query?
Mamta,
Adding to this. How are...
November 3, 2009 at 12:13 am
Viewing 15 posts - 16 through 30 (of 859 total)