rslinct (6/9/2009)

---

Primary system will have 5 databases. Of those 5, three will get "mirrored" to form a secondary level.

Of thos 3 in the secondary level, two will be read...

The complete syntax of BACKUP DATABASE with examples can be found at

http://msdn.microsoft.com/en-us/library/ms186865.aspx

and that of RESTORE DATABASE can be found at

http://msdn.microsoft.com/en-us/library/ms186858.aspx

1. You'll require .NET framenwork to be installed http://www.microsoft.com/downloads/details.aspx?familyid=79BC3B77-E02C-4AD3-AACF-A7633F706BA5&displaylang=en

2. Install SQL Server 2005

Installing Visual Studio is not a pre-requisite for Sql Server 2005.

We cannot restore master directly from one build of sql...

On X64 bit systems, AWE settings are ignored(it's used in 32 bit systems to allow sql server to use more than 4 GB of memory). What you need to do...

rslinct (6/8/2009)

---

I will have both a read only database and a read / write database. I have to provide access for various reasons, some just to generate reports from...

ChandraMohan Nandula (6/8/2009)

---

Pradeep,

Please dont misguide the user. And the link you had posted is for sql server 2008. Please check the link before posting it. This...

Use DDL Trigger.

Refer http://msdn.microsoft.com/en-us/library/ms175941.aspx

you should update statistics of your tables on a weekly basis (off-peak hour) which improves performance of your queries.

Refer these links:

http://msdn.microsoft.com/en-us/library/ms187348.aspx

http://www.sqlskills.com/blogs/Kimberly/post/Auto-update-statistics-and-auto-create-statistics-should-you-leave-them-on-andor-turn-them-on.aspx

rslinct (6/8/2009)

---

I am trying to create a "mirrored" database on the same server to allow external access. I want to keep my primary database free of external access and...

Rick Todd (6/8/2009)

---

If we move our TempDB to an iSCSI solution we can greatly improve the performance of one of our vendor's apps. We don't have a lot of options...

Multiple logs will not have an impact on performance as only one...

It's possible to move master database.

Refer BOL

http://msdn.microsoft.com/en-us/library/ms345408.aspx

Best place to start is Books Online (BOL).

You can start from here:

http://msdn.microsoft.com/en-us/library/ms187103(SQL.90).aspx

I hope you replaced the 'loginname' with actual orphaned ID(a user id for...