Viewing 15 posts - 31 through 45 (of 1,068 total)
Reports are supposed to be read (SELECT) operation. Have you investigated why they are causing blocking?
Have you created indexes on the report server?
February 15, 2013 at 1:58 am
You can initialize a subscription with a backup.
BOL:
Initializing a subscription with a backup
A backup contains an entire database; therefore each subscription database will contain a complete copy of the publication...
February 14, 2013 at 4:13 am
Must read "How to become an Exceptional DBA" by Brad McGehee
February 14, 2013 at 3:03 am
The message in the SQL Server log might not be related the database status.
Is the database Log-Shipped (Secondary Server)?
Following command is used to bring the database online:
RESTORE DATABASE <dbname> WITH...
February 7, 2013 at 7:46 am
-- Edited ---
To move the system database (master and tempdb), SQL Server service needs to be stopped.
Only for user databases and msdb, taking the database offline is enough.
January 17, 2013 at 3:46 am
Is the drive size same in Prod and Dev servers?
Please read the BOL section about moving system and user database files.
January 17, 2013 at 3:25 am
dwilliscp (1/16/2013)
January 17, 2013 at 2:03 am
Where is the old data? Was it deleted? Was it moved to some other database or server before deleting?
Restore the old backup as dbname_old. Then get the data from this...
January 17, 2013 at 12:02 am
Monitor blocking
Monitor free space in the data, log and disks. Increase the DB, Log file size when required to avoid auto-growth
Alerts for job, log shipping, replication, etc.
Monitor log file...
January 16, 2013 at 11:58 pm
Bhuvnesh (1/16/2013)
Suresh B. (1/16/2013)
However, the filegroup can be different from that of the corresponding tables or other corresponding indexes.What does it mean ?
It means table and index can be...
January 16, 2013 at 5:27 am
No. It's not possible.
Not only in the same database, objects should be in the same filegroup.
BOL:
Source and target tables must share the same filegroup. The source and the target table...
January 16, 2013 at 5:13 am
You can try BCP. It has options to inset rows in batches.
BCP is known to be faster than other methods.
December 11, 2012 at 2:28 am
While upgrading replicated instances, order matters.
Upgrade should be done in the following order:
1) Distributor
2) Subscriber
3) Publisher
December 4, 2012 at 1:35 am
jjolk (11/21/2012)
Did I set something up wrong during my install?
Yes.
While installing you need to select Replication component.
You can run setup program again and add replication component to an existing...
November 28, 2012 at 10:44 pm
Viewing 15 posts - 31 through 45 (of 1,068 total)