if you get to the database log still you can backup the tail of the log, see here

then its a case of restoring to the secondary with recovery

don't use shrink database, use shrinkfile through TSQL. do you want to shrink the data file or the log file?

WARNING, after shrinking the file is likely to grow again unless...

🙂

with R2 it works in standard as well

You have SQL2008R2 so you get database backup compression with the product

run commands

sp_configure 'backup compression',1

reconfigure

to enable it.

the just set up a maintenance plan to do your backups, it can...

A full backup contains enough of the transaction log so the database can be made consistent on restore. The way the question is worded transaction 4 commits before the end...

just be aware you will need a license for the SSRS instance if its on its own server.

my 2 pence worth, tempdb apart, don't bother separating system database data and log files, as you have seen yourself they are lightly used databases so there is no performance...

lets play guess the error........:-)

which message actually concerns you saggy?

MSDE is tuned for up to 8 concurrent queries, you are exceeding that, you would need to upgrade to a higher edition.

If the old MSRS10.MSSQLSERVER directory still exists, move it out of the way. If your problem was around encryption make sure you have the encryption keys available and as recreating...

surprised its even explicitly mentioned, the SQL service account will always have sysadmin rights, in the case of SQL2008 via the service SID NTAUTHORITY\MSSQLSERVER

I don't have anything like this setup so I cannot give any cast iron guarantees. However I know of no shared resources for RS instances so I don't see any...

Do you have the database engine installed as well? If so through add and remove programs select mssqlserver to uninstall then later on you get the option as to which...

duplicate post - replies to http://www.sqlservercentral.com/Forums/Topic1327682-1549-1.aspx please