Monday, May 27, 2013

[MS SQL Server] Database Documention Tool

[MS SQL Server] Database Documention Tool

Database Documention Tool

Posted: 26 May 2013 10:54 PM PDT

Hi All,Can any one guide me to find what is the best sql server database documentation tool? I have searched in Google and used some of it and I need your guidance.I hope I will not be disappointed.Thanks in advance

failure:restore master database in sql server 2008r2...

Posted: 26 May 2013 04:44 PM PDT

Hi,I hope you are doing good. Iam facing one problem with Restoration master Database in Sql server 2008r2(named instance) enterprise edition.Actual problem with backup/restore in same named instance.but its not happening restoration.iam following these steps:backup of master Database and restore the same named instance with single user mode using sqlcmd utility.(stopped the services also)command:restore database master from disk='.....' with replacegoits not happens restoration and it will shows the Error single_user mode"how to connect:sqlserver.exe...Please kindly give me your valuable help or suggestions.Thanks&Regards,

Where do views and indexed views reside? In memory or tempdb?

Posted: 26 May 2013 01:00 PM PDT

Do materialized views and indexed views exist in tempdb or the buffer, correct? They could be in the buffer if the view were small, right?I think they usually reside in tempdb. Can someone tell me exactly where they live?

Moving SQL Server 2008 R2 to new Server Hardware

Posted: 26 May 2013 04:27 PM PDT

Hi All,I'm tasked with moving an existing SQL Server 2008 R2 environment to a new server. The current server is attached to a SAN. The SAN is staying the same...it's going to be detached and attached to the new Server. All system databases are on the M drive (the san). So...all that will be changing is the server. I've come up with the following plan...just wanted to check with you all if this is correct:1. Create new server and ensure SQL and Patch are same level as existing server.2. Detach SAN and reattach to new server3. Ensure new server can see SAN drives4. Switch off old server. Change server name on new server to the name of the old server5. Change startup parameters for MASTER db and point to M drive6. Alter MSDB database and also point to M drive7. Configure TEMPDB (split into multiple files)This seems straight forward...but I'm not too sureThanksDenesh
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog