| Author |
Topic |
|
jyoti
Starting Member
6 Posts |
 Posted - 2010-01-15 : 12:59:19
|
| Hi,I installed Sqlserver 2008 standard edition recently. In management studio under the server name I can see Management folder but there is no Maintenance folder showing up. I have to create a maintenance plan to have a automatic backup of the database.Could anyone please let me know how to rectify this issue.Thanks in advance.Jyoti |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-01-15 : 16:57:33
|
| Agree 100% |
 |
|
|
jyoti
Starting Member
6 Posts |
Posted - 2010-01-15 : 17:40:20
|
| Thanks Tkizer.Actually I cant even see sql profiler and so many other things are missing.So I want to know if i need to install any service pack or addon to get the missing features. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-01-16 : 03:09:00
|
| jvoti - if you go into SSMS , under Tools , one of the options will be SQL Server Profiler-Jack Vamvas--------------------http://www.ITjobfeed.com |
|
|
|
jyoti
Starting Member
6 Posts |
Posted - 2010-01-18 : 10:41:13
|
| Under Tools I cannot see any profiler.Even it is not showing in Program files.Does it makes any difference if the sql server is installed on 64 bit processor? |
|
|
|
jyoti
Starting Member
6 Posts |
Posted - 2010-01-18 : 10:42:13
|
| Tkizer I have sysadmin role on the sqlserver. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-01-19 : 10:44:27
|
| Also check in C:\Program Files\Microsoft SQL Server\90\Tools\Binn\PROFILER90Jack Vamvas--------------------http://www.ITjobfeed.com |
|
|
|
jyoti
Starting Member
6 Posts |
Posted - 2010-01-19 : 11:11:55
|
| Hi jackv,There is no folder by name-Tools inside 90 folder. Folder Shared is present instead.Regards |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-01-19 : 11:37:47
|
| Jackv showed default path to SQL 2005 profiler. This is default path to 2008 Profiler:C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\PROFILER.EXE |
|
|
|
jyoti
Starting Member
6 Posts |
Posted - 2010-01-26 : 17:47:18
|
| No i couldnot find profiler.exe anywhere on the system.So does that mean that my sqlserver is not properly installed?Thanks |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-01-26 : 20:13:07
|
| it means the tools weren't. but you don't need anything other than SSMS to create a maint plan -- which i wouldn't use anyway.should just create a job to do your backups |
|
|
|
|
Automatic Backup of Database