if you do that you will lose point in time recovery and may as well put the database in simple mode.

(truncate_only is deprecated by the way)

do you need point in...

for tempdb (only) initial size shows the file size at create time, it does not reflect autogrowths. (a manual growth via alter database would be reflected as this would change...

you need to be truncating the log, that is removing the committed data. A shrink will not do this, and will likely have no effect if there is active data...

don't completely empty them as they are used by the gui to create restore histories if you use them to do restores. they can be useful in a disaster situation...

you can connect using the virtual name, so you don't need to know which node is active. If you do know which node is active you can connect by that...

plus the shrink will cause heavy fragmentation so there will be more for the rebuild\reorg to do.

The SQLAgent files are the errorlogs for SQLAgent. Do not delete the .OUT file as that is the current one. there should be no more than 6 cycles of these...

A free tool such as 7-zip may be able to compress a file that size, not sure.

Unless you can do SAN replication between the data centres and then attach the database files at cutover time you are looking at copying over the full backup and restoring,...

the error message implies the service has not been started in single user mode. Have you got the right instance?

post exactly what you have done.

see http://msdn.microsoft.com/en-us/library/ms180965(v=sql.100).aspx

check any maintenance plans as well if you have them.

I too was hoping this was a humour question worth lots of easy points..............

especially as its a bank holiday here.

the file format is the same for 32bit and 64bit so you can copy from one to the other.

Is the new machine name going to be the same? I always...

[quote-0Msg 3201, Level 16, State 2, Line 2

Cannot open backup device 'C:\Test\CHxxx_backup_2013_05_20_190005_1282827.bak'. Operating system error 3(The system cannot find the path specified.).

Msg 3013, Level 16, State 1, Line 2

RESTORE DATABASE...

EdVassie (5/20/2013)

---

It is supported, but as a guy called Paul once said 'All things are possible, but not all things are advisable'.

There are no data integrity or performance reasons for...