Viewing 3 posts - 46 through 48 (of 48 total)
Greetings,
The best solution is to use the copy database wizard (right click on the database, task, copy database).
Do that for each database, so you'll have moved the data, jobs,...
MBA
MCSE, MCDBA, MCSD, MCITP, IBM DB2 Expert, I-Net+, CIW
Proud member of the NRA
-Anti-gun laws prevent law abiding citizens to buy guns and defend themselves against bad guys who do not care about the law and get their gun illegally.
- Democracy is 2 wolves and one sheep talking about their next dinner. Freedom is 2 wolves and one armed sheep with a .357 magnum talking about their next dinner.
October 5, 2007 at 7:47 am
Greetings,
It depends how your instance is setup and the operating system.
I suggest you give more details or read up on AWE. 🙂
Best way to check is right-click on the instance...
MBA
MCSE, MCDBA, MCSD, MCITP, IBM DB2 Expert, I-Net+, CIW
Proud member of the NRA
-Anti-gun laws prevent law abiding citizens to buy guns and defend themselves against bad guys who do not care about the law and get their gun illegally.
- Democracy is 2 wolves and one sheep talking about their next dinner. Freedom is 2 wolves and one armed sheep with a .357 magnum talking about their next dinner.
October 5, 2007 at 7:41 am
Greetings,
This is normal behaviour when a rollback operation is going on. Even if you shut down and restart SQL Server service, it will pick up where it was left (and...
MBA
MCSE, MCDBA, MCSD, MCITP, IBM DB2 Expert, I-Net+, CIW
Proud member of the NRA
-Anti-gun laws prevent law abiding citizens to buy guns and defend themselves against bad guys who do not care about the law and get their gun illegally.
- Democracy is 2 wolves and one sheep talking about their next dinner. Freedom is 2 wolves and one armed sheep with a .357 magnum talking about their next dinner.
October 5, 2007 at 7:24 am
Viewing 3 posts - 46 through 48 (of 48 total)