A LOT of companies are going to be in the mixed versions of SQL Server boat. I know of many myself.

I think going forward over the next 10 years...

Yep. I am in this boat. We have 7 dbs still in SQL 2000, 5 of which will be moved to 2008R2 next week. We still have a...

Depending on how complex or simple your tables are..... You might be able to simply script out the tables and then use the import/export GUI to move the data.

I don't want db users... just want logins and the server roles.

I found this to do the trick

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/5486ec6b-ee6f-47fb-b1e0-61ba731ad970/migration-of-sql-server-roles-from-one-server-to-another-server-for-all-users-sqlserver-2008-?forum=transactsql

I hope this fixes the issue. This SQL Server is only about 3 months old... has 7 under 10 gig dbs on it and this one is 100gig MDF...

Ended up opening a ticket with Microsoft Support on this case as the CHECKDB utility would not run on this one specific db twice.... There is a Windows patch...

You really need to schedule your integrity checks once a day before you do a backup. That way you know if there is corruption in the db BEFORE a...

Never thought of that... I have never created a db snapshot... In doing more research there maybe a Windows 2008 hotfix for this.

That 'can' hold some share locks... if there are heavily updated rows that are attempting to happen as you have an open query to the data there could be some...

As far as a very strong team in the NL the Cardinals appear to be the strongest. Their one weakness last year was SS and they plugged that hole......

I guess it depends on when you say you have Mgt Studio open... are you just connected or did you have an open query or something?

I know if you 'design'...

When we did this I used the Import/Export wizard. You have to install the DB2 client on the server and config the dbs but... it works great.

It depends..... are they simply spinning up an AIX or Linux server, installing one DB2 instance and moving all of the different SQL Server dbs to it that...

JoshDBGuy (3/26/2014)

---

Yes, the logfile is still being used, it just truncates when a database event occurs. What are your autogrowth settings? If they are 1 MB, then by the time...

Wrong. The transaction log is critical to the database.

When you are in SIMPLE mode as transactions enter the database they are in the trans log FIRST... once they are...