Posts Tagged by MSSQL2000

MSSQL Resources

13-Jun-2007 Posted by Sonia Hamilton under , , ,
No Comments

Web Sites

(more…)

log shipping hints

25-Aug-2006 Posted by Sonia Hamilton under
No Comments

select * from msdb..log_shipping_databases
select * from msdb..log_shipping_plans
select * from msdb..log_shipping_primaries
select * from msdb..log_shipping_secondaries
sp_get_log_shipping_monitor_info

sp_delete_log_shipping_secondary
sp_delete_log_shipping_primary
sp_delete_log_shipping_database

exercise – move system databases

24-Aug-2006 Posted by Sonia Hamilton under , ,
No Comments

In this exerise, you are required to move two of the system databases (master and model) to c:data. Here are some web pages that may help:

Steps:

  1. move master
    • change the startup properties for the server, to point to a different location for master
    • stop the server using Administrative Tools, Services
    • manually move master’s database files using Windows Explorer to c:data
    • start the server using Administrative Tools, Services
    • in Enterprise Manager, check the properties of the master database, to ensure that master is running from the new location (more…)

howto move sql server system databases

22-Aug-2006 Posted by Sonia Hamilton under
1 Comment

Here’s a couple of links on how to move the MS SQL Server system databases:

In a nutshell:

  • for master, change startup parameters in Server Properties, stop SQL Server, move files, start SQL Server
  • for other system databases, restart SQL Server using Trace Flag 3608 (-T3608 startup param), use sp_detach_db and sp_attach_db, restart without Trace Flag
  • if SQL Server won’t start because of an error in the startup settings, the settings can be edited here:
 HKLM/SOFTWARE/Microsoft/MSSQLServer/MSSQLServerParameters

multiserver jobs exercise

14-Dec-2005 Posted by Sonia Hamilton under ,
No Comments

Exercise

  1. Have a second instance of SQL Server running, either by:
    • installing a second instance of SQL Server
    • starting up a second Virtual PC
  2. If using Virtual PC’s, check that you have network connectivity between both VPC’s:
Next Page »