DB2008 (4/24/2009)

---

IS this virtual Server to Virtual server move or physical server to Physical server move. If it is physical to physical move i would suggest not going for it...

Another reason for doing it this way, I have many maintenance plans, jobs PLUS LOG SHIPPING running on the existing sql box. New box will have same network name...

Our new product has the business logic on servers separate from the sql server 2005 database. Virtually no use of stored procedures. Not my design. C# .NET...

While I'm not sure this belongs on SQLServerCentral.com, in the United States anyway, I fear corporations and private capitalists more than I do my government. So let's...

This article indicates Instant File Initialization is only for data files.

http://www.microsoft.com/technet/prodtechnol/sql/2005/physdbstor.mspx

Instant File Initialization

SQL Server 2005 added support for the Windows instant file initialization feature. By default, when a file is...

Oh, of course. I made my comment before the coffee was ready, sorry.

Multiple log files: I thought the recommendation was one log file per cpu, for performance?

Last night was a classic case. I'm a data analyst ( DBA without the title I guess ) who generally is given the job of making sure...

Some companies don't have a DBA on purpose. It's called Agile Development. Some experienced developers who are trying to follow agile development want to retain all control over...

Those are great articles, thanks. Since I only need to audit a handful of employees ( everyone else would be using the GUI front end or it would be...

I was thinking triggers were tied to specific fields in specific tables. With a large relational database, hundreds of tables, if a user makes a change to one field...

From my earlier post:"Tlog is doing nothing as far as I can see -- apparently that's because there is no full backup and thus no possibility of tlog backups....

The database being loaded was created with a script ( identical to production ) and then some basic config info was loaded. It is in full recovery on...

So back to my original question, the t log file is not being used as far as I can see even though we're in full recovery. The data file...

I want to mimick our production environment where regular t log backups and log shipping occur, because ultimately that's where the real load will occur. I plan...