Geek Answers Handbook

Where is the SQL Server Agent and do I need it?

I want to upgrade db to 2005 using 2008 Sql Server Mgt Studio to do this and get a warning at the end. Questions:

  • I no longer have a drive for SQL Server 2008; Do I need to install or run an agent? If I can’t install the agent, will the upgrade to 2008 work?
  • If the agent is most likely installed but not running, where is it? I saw another SO post saying it was a login option, but I don't see it anywhere.

Aside, my only real motivation to worry is that the datetime type has become a problem. What did people do when they needed a date earlier than in the 18th century before the date, and the date and time2 came?

Warning from Database Copy Wizard

SQL Server Agent is not running on the destination server. If the SQL Server Agent is not running on the destination server, the Copy Database Wizard will not work properly. Do you want to continue?

+5
source share
2 answers

try:

start-> run->services.msc

find the sql server agent and check if it is running

+11
source

What did people do when they needed a date earlier than in the 18th century before the date, and the date and time2 came?

SQL Server (, , ). , # (.NET) "01/01/0001", long, db BIGINT / . , , :

var dt = DateTime.Now.ToBinary();

, :)

:

var dt1 = DateTime.FromBinary(dt);
+4

More articles:


All Articles