Viewing 15 posts - 451 through 465 (of 1,069 total)
Kevin, your plan sounds good.
I recommend installing at least two instaces for pactising replication, mirroring, etc.
Reference book: The Real MCTS SQL Server 2008 Exam 70-432 Prep Kit: Database Implementation...
August 9, 2011 at 5:33 am
srinath.vanama (8/9/2011)
... if Log size is huge simply shrink log files.
I don't agree with this advice.
August 9, 2011 at 5:24 am
No. Pull subscription does not setup distributor at subscriber. Distribution Agent runs at subscriber instead of at distributor.
Your problem is related to security. Make sure that distribution agent has access...
August 9, 2011 at 4:59 am
rlong 55506 (8/1/2011)
Basically I'm looking to get another skillset under my belt. I have worked on ACCESS db's in the past, but I want to take it to the "next...
August 9, 2011 at 4:48 am
naresh.talla (8/9/2011)
200 gb
You cannot restore a 200GB database, if free drive space is only 100GB.
August 9, 2011 at 4:10 am
When I try to open Test.xls as mentioned in Sumata's solution, I get error "The file you are trying to open, 'Test.xls', is in different format than specified by the...
August 9, 2011 at 4:07 am
Check the free drive space. It looks like on the other server there is less free drive space than the size of the database file.
August 9, 2011 at 2:47 am
I think they cannot be compared.
Locking is an action taken by SQL Server engine to protect data integrity. For example when a row is being UPDATEd it is locked by...
August 9, 2011 at 2:41 am
guptaprashant1982-1107326 (8/8/2011)
how to Create Execl File From msdb.dbo.sp_send_dbmail and mail it
Some of the options are:
1) SSRS subscription
2) CLR
3) Attach query result as a .CSV file
4) Export/SSIS
August 9, 2011 at 2:22 am
The reason is in the subscriber, rows are updated/deleted one-by-one using primary key.
For example:
If you delete 100 rows in the publisher using a single DELETE statement, in the subscriber 100...
August 5, 2011 at 2:59 am
I recommend querying sys.databases and sys.master_files
August 1, 2011 at 2:18 am
forsqlserver (7/29/2011)
Suresh can u explore how to set deadlock_prority
Sorry, I don't have any additional information than what is mentioned in BOL.
Hope others will share their experience with this.
July 29, 2011 at 1:05 am
sudhir.tvs (7/28/2011)
HiCan we run partial check db command on any database?
No.
But as an alternative you can run DBCC CHECKFILEGROUP, DBCC CHECKALLOC,...
July 28, 2011 at 11:46 pm
forsqlserver (7/28/2011)
Can I kill any one of deadlocked process?
You cant kill. But you can SET DEADLOCK_PRIORITY.
July 28, 2011 at 10:48 pm
Not sure about the cause. But this my bring it online.
restore database model with recovery
July 28, 2011 at 1:57 am
Viewing 15 posts - 451 through 465 (of 1,069 total)