Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Which databases.....

Status
Not open for further replies.
JOHN94

JOHN94

Technical User
Nov 13, 2001
11
0
0
FR
hello

once the master is rebuilt after the codepage had been changed , which databases will i have to restor ??? (master ? ; pubs ? ; msdb ? ; Northwind ?)

thanks !
 
Sort by date Sort by votes
You will have to restore any custom tables and sprocs to the master.

You will also have to restore the msdb if you have any jobs or maintenance plans set up.


Other databases are optional according to your needs.
 
Upvote 0 Downvote
thanks.

And will i have to script roles , and users ... ?
and how ??
will i have to execute script on all the tables ??
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Niki_S
  • Locked
  • Question
Create view using two databases
Replies
4
Views
80
Chris Miller
Chris Miller
Niki_S
  • Locked
  • Question
Add two databases for connection between sql and foxpro
Replies
1
Views
50
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question
I have created 2 feed tables which 1
Replies
8
Views
61
Cpreston
Cpreston
davism
  • Locked
  • Question
1 SP on a different DB to used for multiple databases
Replies
3
Views
48
gmmastros
gmmastros
BeeTrees
  • Locked
  • Question
How to list all the databases/Schema/tablenames used in SSRS Reprts' datasets.
Replies
2
Views
21
simian336
simian336

Part and Inventory Search

Sponsor

Back
Top