Can you please post the error and also confirm the access to folder that you are backing up. It’s always recommended to use windows authentication service accounts.
Dr.Sql
Good Luck.
You approach is right but I would suggest to pre-allocate the required space to primary group and this should help your merge quicker. Also verify that the second file groups are in primary group or diff files? If it’s different file groups then you need to move the object to the primary...
It’s all depends on how critical your data is and how much Swiss cheese holes let your security team allows in your firewall. The safe bet is your third option and SQL Server has a new version to accommodate that is SQL Server Web edition. Web tier directly connects to SQL Server web edition and...
As DBA we have been debating with our developers whether we should be using CLR Stored procedures or SQL Server Stored procedures. Is there any have any experience with it or suggest the Pros and Cons.
Thanks in advance.
Dr.Sql
Good Luck.
SQLBill's recommendations are the right approach. I would also suggest running the profiler, filter duration > 10 Sec to start with and take the query that taking the longest start running through Index tuning advisor. Also profiler would let you capture trace for a period and you run it...
Few more questions :)
You verified the fragmentation for all tables used in the query?
How much data you are querying as output?
Does it have lot of joins?
Can you check the buffer cache and disk io?
Is your prod and dev using same type of disk in tiers?
I would still explore running a...
I meant there are sveral way you can decide your re-index jobs and its available on-line.
What we have decided to deploy in an environment that has more than 200 instances is that
Re-Index Sun 1.00 AM
Update Stats: Thur 1.00 AM
Re-Index Configuration variables:
-- Less than 30% Fragmenation...
The rule of thump for pagefile is 1.5 of the total memory and reccomned to leave 512 on C:\ for OS and reamining can be distrubuted on other drives. That ebing said I would suggest compare the the db and table fragmentation you can use DBCC SHOWCONTIG and look for SCAN DENSITY. Here is a good...
Re-index and Rebuild is recommended based on fragmentation level and there are several scripts but I won’t suggest running shrink as part of it. If the db and log file grown to a size during the maintenance jobs then leave the size intact, constant file growth and shrink can cause disk...
Is this first occurnace?
Then you should explore if anyone else running any long running queries that uses tempdb also suggest to look into maintenance?
Any recent schema changes?
Is there any un-expected grwoth to DB?
Monitor for next week for same window also if needed run some trace.
Good...
As John stated a lot depends on your email communication relay and its pretty relaible. I have custom alerts configured for business crtical app to send direct emails rather than using our monitoring tool and it has been more relaible than exteranl tools.
Good luck
Dr.Sql
Good Luck.
Yes, there is an "in place" upgrade but I would suggest only if you were upgrading DB Engine, else I would suggest a complete re-install. In 2008 there is no longer required IIS for SSRS and SSIS needs to re-deployed to 2008, and I haven’t worked on SSAS but assume you might have to make some...
Please share your thoughts about why you would choose mirroring over log-shipping in SQL Server 2008.
Quick responses are greatly apppreciated.
Thanks
Dr.Sql
Good Luck.
At this time it will be trial and error option and here is an article that talks in details about your error...
http://www.sqlservercentral.com/articles/65804/
Corruption in the Metadata
Msg 3853, Level 16, State 1, Line 1 Attribute (object_id=181575685) of row...
Good reccomendation.. We also use same Red-Gate SQL Compare.
On a flip side I would suggest to off-load the work to developers by selling to your manaagemnt as deploymnet best practice is that development should provide you a set of scripts that includes roll-back as part of change management...
Did you run the SQL Server 2005 upgrade avisor against SQL 2000 database prior to the move else I would suggest to running that and analyse the report.
You can obtain the copy
http://www.microsoft.com/downloads/details.aspx?familyid=1470E86B-7E05-4322-A677-95AB44F12D75&displaylang=en...
Both SQL 2000 Enterprise Manager 2005 Studio can be installed on same system and 2005 Management studio is bakcward compatable. Make sure configure the locations to seprate folders during installs.
Thanks
Dr.Sql
Good Luck.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.