Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 310 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
trouble with logins after restore
trennert
Member Posts: 22
We are on Navision Attain 3.01B, on SQL Server 2000.
I try to be prepared for a restauration of our production database (8 GO, 200 user in windows login). So we will work with a complete backup plus tansactions logs. This should run without problem.
But after some testing I wonder what should be the procedure to get all the user connexions in the new database.
I try to be prepared for a restauration of our production database (8 GO, 200 user in windows login). So we will work with a complete backup plus tansactions logs. This should run without problem.
But after some testing I wonder what should be the procedure to get all the user connexions in the new database.
0
Comments
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
I saw that it is necessary to start sql server in single user mode to restore the master database.
Then when restoring the master database in the enterprise manager in the end there is an error because it can't connect to the sql server
I restarted the whole server - allways the same. I can't start sql server. I can't connect to sql server.
I read that the sqlservr command is also to stop the sql server running - perhaps I need to tell him to stop single user mode but I can't see how to do this.
it would be nice to know how to get the connexions only because restoring on a system that has not the same disk structure seems to cause sql not to start again.
Any hints ?