look into transactional replication.

the table will have to have a primary key.

as this is a one off task you can script out all the jobs using SSMS.

select jobs in the left hand pane. select F7 and you will see the jobs...

dba.zahid (4/13/2012)

---

i think instead of switching recovery mode, you could simply set up another job that will shrink you database once you take the transaction log backup after the index...

If you are sure the file is there in the location you installed SQL to it might be worth checking permissions, the error could be misleading.

You could run process monitor...

is SSIS installed on this computer?

I can confirm you need the log backup restored as well.

Full instructions are here, although MS instructions on this are confusing as hell. Just the encryption key restore should do you

you need to restore the encryption key from the SSRS instance you copied the RS database from

you are getting into database as guest user then, this is one of the users listed below. This shows...

you must be a member of a windows group that has SQL access.

select * from sys.database_principals or exec sp_helpuser

thats what sp_help_revlogin does for sql authenticated ids, it scripts them out and maintains the sid and password

Perry Whittle (4/7/2012)

---

The backups...

avg_fragmentation_in_percent = 0 means you have no fragmentation so that would not change after a rebuild.

an avg_page_Space_Used_in_Percent = 0 says the pages are empty.

I would suggest there is not enough...

BTW just check you don't have any user defined error messages. Check the sysmessages tables for error nos above 50000

set quoted_identifier off

select 'exec sp_addmessage ' +convert(varchar(10),error) +"," +convert(char(2),severity) +"," +"'"+description...

They won't be set.

I don't have a script to reverse engineer them as I don't change that many of them (you should not need to), I use a script if...