Viewing 15 posts - 61 through 75 (of 266 total)
Run DBCC SQLPERF(LOGSPACE) It will show you how much of you log is actually free space. It's likely that most of it is unused so the backup size will be...
October 11, 2018 at 3:03 am
Take a log backup as soon as you can then schedule regular log backups. Or if log backups aren't needed put the database in simple recovery.
You should also...
October 11, 2018 at 2:32 am
First of all what size is the ldf file and also the mdf file?
What recovery model is your database using? If it's full, how often are you backing your...
October 11, 2018 at 1:47 am
I believe SQL Server Driver is an older version of the driver. As you are able to connect using using the Native Client can you just continue to use it?
October 9, 2018 at 5:20 am
What error messages are you getting when you try to connect?
Thanks
October 9, 2018 at 4:14 am
The log will have grown to 9gb for a reason, maybe a large transaction running or possibly it was in full recovery but the log backups were not being taken....
October 8, 2018 at 7:34 am
I have SQL Server 2008 Express edition installed on server. It has two database....
September 24, 2018 at 5:36 am
Are your statistics up to date? Also I'm assuming that no-one was playing around with the indexes.
Thanks
August 30, 2018 at 6:28 am
August 23, 2018 at 1:45 am
Is there any reason you're not able to use the other solutions that have been posted? They are pretty simple to implement.
Thanks
August 20, 2018 at 5:57 am
August 17, 2018 at 4:44 am
August 17, 2018 at 1:26 am
You are right, standard and developer editions would not behave differently to each other.
What errors were returned on Developer?
Thanks
August 15, 2018 at 8:22 am
Not as far as I'm aware unless you have auditing on your database to pickup such changes.
Thanks
August 15, 2018 at 7:59 am
In Management Studio right click on your database then Tasks --> Generate Scripts. Post back if you have any problems.
Thanks
August 13, 2018 at 1:25 am
Viewing 15 posts - 61 through 75 (of 266 total)