I am working on same scenario you have explained and so far i found two best options

- Backup / Restore

- Transactional Replication

But for now i am going...

Can you post that script if you have modified for Orphaned Users please?

Nice and very useful stored procedure. would like to make sure few things

- i have backup sotred on network location or shared drive so this proc works inthis situation...

Hi Josep

this is the best script ever found ,i was looking for fromlong time. just few concersn like to make sure with you if you don't mind.

-...

Hi ,

Replying on your Post Sentance

"I always overwrite, but I use a new file name for each file, which has the date in the file name. This allows...

Sorry My bad ...i am new here so

Thanks for letting me know

I tried SSIS Job and worked fine to me..

Thanks for kind suggetion.

Hi Paul

I like your suggetion can you tell me in details which command should use to setup for this

thanks

My Scenario is pretty much same as you replied.

We are appending now last TB Backup because my manager want to keep old backup file untill new backup completed.

but how...

Follow this link hope it would be helpful to you

http://sqlblog.com/blogs/aaron_bertrand/archive/2011/01/14/sql-server-v-next-denali-additional-states-for-error-18456.aspx.

after i read your post i created sql login on my local server and iw as getting error...

Try this Way

USE db_name

GO

ALTER DATABASE db_Name SET SINGLE_USER WITH ROLLBACK AFTER 10 SECONDS -- you chagne value of Seconds

GO

Use master

Go

RESTORE DATABASE [db_name]

FROM DISK =...

for Historical Restore Operations

Would Suggest

Transaction Log Backup - every 15 min or 30 min.

Differential backup -Every night

FUll backup - once in a week .

system backup - once in week or you...

ya thats true i just figured out ..Thank for your kind reply.

Thanks for info ya i am trying to look in default trace file .but i dont have access to go there . but thanx for help