This is my first thread and first of all let me ask you to pardon my ignorance as regards SQL Server. I have been using Ms Access all this time and now we have moved on...........Hence the post.
I have an existing SQL Server db on one of my machine's local disk (C:\), (that system would be taken away), I need to port that whole database to the local drive (C:\ or D:\) of my laptop. Along with the data, I need to transfer all jobs, Stored Procedures, and the linked server.
Both Servers are 2008R2, I have sa access on both.
How best do I do this ?