Maintenance plans are not available in the Express Edition - which also does not have SQL Server Agent.

You have two options:

1) Upgrade to an edition that supports maintenance plans and...

Are your users logging into that machine - or are they logging into their own machines and trying to connect? If they are logging into their own machines, are...

sqlbuddy123 (7/20/2010)

---

Hi

Try to switch to Bulk Logged recovery model and take frequent Transaction Log backups. This would do minimal Logging and truncate the TL.

...

To be able to use SQL Server functionality in a normal powershell session, you have to include the powershell provider for SQL Server.

http://msdn.microsoft.com/en-us/library/cc281962.aspx

sushantkumar1984 (7/16/2010)

---

@ jeffrey...

But my database restores starts from 10%, 20% , 30% ...then it stops in between....

it is not that it doesnt start...but after sometime it throws error.

The article...

This might be the issue you are running into: http://support.microsoft.com/kb/843515

Read Paul Randall's blog on this subject.

http://www.sqlskills.com/BLOGS/PAUL/category/Indexes-From-Every-Angle.aspx#p4

Basically, he made them up...

You can use the backup_set_id column in the backupset table in msdb. There are scripts available that can be used to generate the restore script for you.

Search this site...

You do not need to cycle SQL Server for this change. Changing memory is dynamic and the additional memory will be immediately available.

The only time you need to cycle...

This is a network issue - there is something that is causing that system to lose connection with the network or that other system.

Copy the backup files local and restore...

If the size of the database is small (< 4GB), and there are not a lot of users of the system, you can probably get this done by installing SQL...

Thanks - at least that clears up whether or not that is set correctly. Now, I wouldn't set min...

Okay - I'll ask this again what are the exact values you used to set max memory. To clarify my concern is that a lot of people have set...

And if you really want to get into the higher paying jobs - you need to know the business that you support.

DBA + Operations (system admin, SAN, etc...) + Healthcare...

Because the clustered index is the table - and the table has a text column. If the index was a non-clustered index, you could rebuild it online because it...