Viewing 15 posts - 16 through 30 (of 35 total)
I'm not totally familliar yet with 2010, I know there are some settings under Session Management Settings which may be worth a look. The other thing I've used to limit...
October 3, 2011 at 9:49 am
Depending on the size of your database and the speed of your server, it may take some time for DBCC CHECKDB to finish. Hopefully you have a database backup around....
October 3, 2011 at 9:25 am
Please don't double post. See my other response on cascading inserts.
October 3, 2011 at 9:21 am
If I understand you correctly, I believe what you may want to have a look at is cascading inserts:
http://www.dba-sql-server.com/sql_server_tips/t_super_sql_423_cascade.htm
October 3, 2011 at 9:19 am
The nice thing about the import export wizard is you can save your job as an SSIS package for future work if you would need this to be a repeateable...
October 3, 2011 at 6:53 am
I'm a bit confused by your question. Installing windows updates on the secondary server and rebooting it should not cause mirroring to break. It should only briefly pause it. What...
October 2, 2011 at 7:47 am
See if the disk where your error logs are stored is out of space. If not, try running sp_cycle_errorlog.
October 2, 2011 at 7:42 am
Which version of Windows?
October 2, 2011 at 7:32 am
Check your windows firewall to make sure that TCP 1433, 1434 and UDP 1434 are enabled. The Default port that SQL Server communicates on is TCP 1433. For sql browser...
October 2, 2011 at 7:18 am
What type of IO disk subsystem do you have? If it's SAN then your SAN Administrator might be able to assist you with valuable metrics while running SQLIO or sample...
October 2, 2011 at 7:09 am
I would recommend that if you have a lot of tables, and if you have a lot of data in those tables, consider transactional replication instead of snapshot. Snapshot replication...
September 30, 2011 at 8:38 pm
Basically unless you absolutly need to reclaim space on the disk, I'm of the opinion you should not ever shrink the data files on a database.
September 30, 2011 at 8:04 pm
Depending on how much data you have, I would try the import export wizard as it is the easiest way. So in SSMS, right click on the database, go...
September 30, 2011 at 6:16 pm
Transaction log backups are incremental. Lets say you take a full backup at 8:00AM, and then transaction logs at 9:00AM, 9:30AM, and 10:00AM. At 10:25AM your sql server catches on...
September 2, 2010 at 6:29 am
Viewing 15 posts - 16 through 30 (of 35 total)