Viewing 15 posts - 286 through 300 (of 608 total)
You may need to shrink msdb after a large cleanup.
Are you able to restore via the GUI now?
September 11, 2013 at 7:04 am
pradeep.mohan (9/10/2013)
backupfile - 44095724backupfilegroup - 22047863
restorefile - 974
restorefilegroup - 487
restorehistory - 487
backupmediafamily - 22047869
There is your problem. You have LOADS of backup history. The GUI is trying to...
September 10, 2013 at 7:19 am
What do these queries return?
SELECT COUNT(1) FROM msdb.dbo.backupfile;
SELECT COUNT(1) FROM msdb.dbo.backupfilegroup;
SELECT COUNT(1) FROM msdb.dbo.restorefile;
SELECT COUNT(1) FROM msdb.dbo.restorefilegroup;
SELECT COUNT(1) FROM msdb.dbo.restorehistory;
SELECT COUNT(1) FROM msdb.dbo.backupmediafamily;
September 10, 2013 at 6:47 am
Are you running SSMS locally or on the server?
September 10, 2013 at 5:26 am
This sounds like a job for the Geometry data type and spatial functions. The following query works for your example.
IF OBJECT_ID ('dbo.SpatialTable') IS NOT NULL
DROP TABLE dbo.SpatialTable;
GO
CREATE TABLE SpatialTable
...
September 10, 2013 at 5:13 am
If your end time is in the next day you will need to add a day to your date parameter.
WHERE MyDate BETWEEN CAST(@date + StartTime) AND CAST(DATEADD(DAY, 1, @date) +...
September 9, 2013 at 7:34 am
The BCP utility has a batch parameter that allows you to specify the number of records to group in a transaction. If something happens during the BCP process, only the...
September 9, 2013 at 7:01 am
http://en.wikipedia.org/wiki/Project_plan
A project plan, according to the Project Management Body of Knowledge, is: "...a formal, approved document used to guide both project execution and project control.
A project plan requires a project....
September 5, 2013 at 3:05 am
beejug1983 (9/4/2013)
Hi All,Please explain; what exactly happens internally in SQL Server when we take database full backup.
Thanks in advance.
Paul Randal wrote an excellent article on the subject.
http://technet.microsoft.com/en-us/magazine/2009.07.sqlbackup.aspx
September 4, 2013 at 3:29 am
Hany Helmy (9/3/2013)
"Transactions Durable: After the database engine acknowledges that a transaction has been committed, its changes are persistent in the...
September 4, 2013 at 12:39 am
Dennis Post (9/3/2013)
I haven't been able to REPLACE the CHAR(0) nor have I been able to detect it with:Thanks for brainstorming with me on this!! 🙂
You're welcome.
The reason you cannot...
September 3, 2013 at 5:35 am
Dennis Post (9/3/2013)
Hi Sean,Welcome to the party.
Your query returns 0's. Testing for > 0 returns no rows.
This mean the last char is a NULL ??
Yes the last character is a...
September 3, 2013 at 5:23 am
Your data type is CHAR(24) but the string is 23 characters long. If the last character is a TAB or NUL then it will fail. Does this query return 9...
September 3, 2013 at 4:02 am
Oracle has Label Security Policy. You will need to ask an Oracle forum for help.
September 2, 2013 at 8:04 am
Excuse the type in the image, the comment should read -- Hit Ctrl+7
September 2, 2013 at 7:36 am
Viewing 15 posts - 286 through 300 (of 608 total)