August 3, 2012 at 11:22 am
I have restored a copy of msdb from another server. Can i point my ssms to view the metadata from this msdb?
August 3, 2012 at 11:49 am
You should be able to view just about anything in there. I would assume you named it something different than msdb? Is this more of a "is it possible" type of question or are you actually having problems?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 3, 2012 at 1:28 pm
Sean Lange (8/3/2012)
You should be able to view just about anything in there. I would assume you named it something different than msdb? Is this more of a "is it possible" type of question or are you actually having problems?
The database is restored with different name. Yes , i wanted to know if it is possible, if it is then it would make my life much much easy.
August 3, 2012 at 1:33 pm
sqldba_newbie (8/3/2012)
Sean Lange (8/3/2012)
You should be able to view just about anything in there. I would assume you named it something different than msdb? Is this more of a "is it possible" type of question or are you actually having problems?The database is restored with different name. Yes , i wanted to know if it is possible, if it is then it would make my life much much easy.
Sure just make the name whatever you want during restore. It is then just a typical user database.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 3, 2012 at 1:35 pm
Sean Lange (8/3/2012)
sqldba_newbie (8/3/2012)
Sean Lange (8/3/2012)
You should be able to view just about anything in there. I would assume you named it something different than msdb? Is this more of a "is it possible" type of question or are you actually having problems?The database is restored with different name. Yes , i wanted to know if it is possible, if it is then it would make my life much much easy.
Sure just make the name whatever you want during restore. It is then just a typical user database.
Hmmm...i dont think we are on same page. If i restore msdb from serverA to serverB, on serverB would i be able to use GUI of job activity monitor to view the job history from serverA as msdb is restored. If not is there a way such that i can add this msdb so that it displays the data on serverB
August 3, 2012 at 1:50 pm
sqldba_newbie (8/3/2012)
Sean Lange (8/3/2012)
sqldba_newbie (8/3/2012)
Sean Lange (8/3/2012)
You should be able to view just about anything in there. I would assume you named it something different than msdb? Is this more of a "is it possible" type of question or are you actually having problems?The database is restored with different name. Yes , i wanted to know if it is possible, if it is then it would make my life much much easy.
Sure just make the name whatever you want during restore. It is then just a typical user database.
Hmmm...i dont think we are on same page. If i restore msdb from serverA to serverB, on serverB would i be able to use GUI of job activity monitor to view the job history from serverA as msdb is restored. If not is there a way such that i can add this msdb so that it displays the data on serverB
Well you didn't mention anything about job activity monitor. You asked about metadata. The job history table and everything else would still be there. I don't think there is a way to have job activity monitor pick which database to use.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply