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 Chriss Miller 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
Joined
Nov 13, 2001
Messages
11
Location
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 Question
Create view using two databases
Replies
4
Views
584
Chris Miller
Chris Miller
Niki_S
  • Locked
  • Question Question
Add two databases for connection between sql and foxpro
Replies
1
Views
305
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question Question
I have created 2 feed tables which
Replies
8
Views
356
Cpreston
Cpreston
davism
  • Locked
  • Question Question
1 SP on a different DB to used for multiple databases
Replies
3
Views
300
gmmastros
gmmastros
BeeTrees
  • Locked
  • Question Question
How to list all the databases/Schema/tablenames used in SSRS Reprts' datasets.
Replies
2
Views
232
simian336
simian336

Part and Inventory Search

Sponsor

Back
Top